City owned and maintained trees. This layer is maintained by Cambridge Public Works and updated regularly by the City Arborist.
| Name |
Type Details |
Description |
| CREATOR |
type: String
width: 40
precision: 0 |
Name of the editor who created the record. |
| INSPECTR |
type: String
width: 40
precision: 0 |
Name of the tree inspector. |
| SPECIES |
type: String
width: 30
precision: 0 |
Common name of the species of the current tree. |
| DIAMETER |
type: Single
width: 4
precision: 6 |
Tree diameter in inches taken at approximately 4.5 feet above ground (DBH). If the diameter point falls on a swelling in the trunk it is customary to measure below the swelling at the point where the diameter is smallest. Note: an average diameter should be calculated for trees with multiple trunks (see the Trunks field); an online calculator for multi-stemmed trees may be found at https://www.treetec.net.au/TPZ_SRZ_DBH_calculator.php. |
| TRUNKS |
type: SmallInteger
width: 2
precision: 5 |
Number of tree trunks (see note at Diameter about using the number of trunks to calculate an average tree diameter). |
| NOTES |
type: String
width: 500
precision: 0 |
Miscellaneous notes. |
| SITETYPE |
type: String
width: 20
precision: 0 |
Designates whether the site is currently occupied by a tree (Tree) or stump (Stump), is an empty planting site (Planting Site), or has been paved over or is otherwise empty and no longer available for planting (Retired). Note: this field typically supersedes any conflicting data within the record; for example, a record designated as a “Planting Site” would indicate that any values for Diameter and Trunks were no longer valid. |
| PLANTDATE |
type: Date
width: 8
precision: 0 |
Date that a tree was last planted at this site. |
| REMOVALDATE |
type: Date
width: 8
precision: 0 |
Date that a tree was last removed from this site. |
| SPECIESSHORT |
type: String
width: 50
precision: 0 |
Genus of the current tree species (see Species). |
| TREEID |
type: String
width: 50
precision: 0 |
Unique identifier for the record. |
| OVERHEADWIRES |
type: SmallInteger
width: 2
precision: 5 |
Designates the presence of above-ground utility wires in the area of tree canopy growth at the site. |
| CULTIVAR |
type: String
width: 50
precision: 0 |
Cultivated variety of the current tree species (see Species). |
| STREETNUMBER |
type: SmallInteger
width: 2
precision: 5 |
Number of the street address closest to the site. |
| STREETNAME |
type: String
width: 40
precision: 0 |
Name of the street for the address closest to the site. |
| MEMTREE |
type: String
width: 1
precision: 0 |
Designates whether the current tree was planted in memoriam. |
| LOCATION |
type: String
width: 50
precision: 0 |
Designates whether the site is located along a street (Street Tree), beyond the back edge of a sidewalk in a front yard or other area not immediately adjacent to a street (Back of Sidewalk), in a park or other open space (Park Tree, Cemetery Tree, Golf Course), or on the grounds of a public school or other municipal building (Public School, City Building). |
| OWNERSHIP |
type: String
width: 50
precision: 0 |
Designates the ownership of the tax parcel on which the site falls. |
| ADACOMPLIANT |
type: String
width: 1
precision: 0 |
Designates whether the site is ADA compliant, for instance whether the site has the minimum required sidewalk width of 4 feet. |
| TREEGRATEACTIONREQ |
type: SmallInteger
width: 2
precision: 5 |
This field is used to record if the metal tree grate surrounding the tree needs to be reset or removed. When the tree grows, it can get girdled by the tree grate. |
| BAREROOT |
type: String
width: 3
precision: 0 |
Designates whether the last tree was planted as a bare-root tree. |
| TREEWELLCOVER |
type: String
width: 25
precision: 0 |
The type of cover, if any that is over the tree well. The two values are Tree Grate or Flexi-Pave. |
| STRUCTURALSOIL |
type: String
width: 5
precision: 0 |
Indicates if the tree was planted in structural soil. |
| TREEWELLLENGTH |
type: Double
width: 8
precision: 38 |
The length of the tree well. |
| TREEWELLWIDTH |
type: Double
width: 8
precision: 38 |
The width of the tree well. |
| ABUTSOPENAREA |
type: String
width: 5
precision: 0 |
Indicates if the tree abuts an open space or if the tree well is the only open area around the tree. |
| EXPOSEDROOTFLARE |
type: String
width: 5
precision: 0 |
Indicates if the root flare of the tree is visible. |
| TREEWELLID |
type: Integer
width: 4
precision: 10 |
|
| CREATED_USER |
type: String
width: 255
precision: 0 |
|
| CREATED_DATE |
type: Date
width: 8
precision: 0 |
|
| GENUS |
type: String
width: 55
precision: 0 |
|
| LAST_EDITED_USER |
type: String
width: 255
precision: 0 |
Initials of person making most recent edit |
| LAST_EDITED_DATE |
type: Date
width: 8
precision: 0 |
Last edit date. |
| COMMONNAME |
type: String
width: 55
precision: 0 |
|
| CARTEGRAPHRETIREDATE |
type: Date
width: 8
precision: 0 |
|
| CARTEGRAPHPLANTDATE |
type: Date
width: 8
precision: 0 |
|
| SCIENTIFICNAME |
type: String
width: 55
precision: 0 |
|
| ORDER_ |
type: String
width: 30
precision: 0 |
|
| PLANTINGCONTRACT |
type: String
width: 30
precision: 0 |
|
| WATERINGRESPONSIBILITY |
type: String
width: 25
precision: 0 |
|
| LOCATIONRETIRED |
type: String
width: 3
precision: 0 |
|
| SITEREPLANTED |
type: String
width: 3
precision: 0 |
|
| SITERETIREDREASON |
type: String
width: 255
precision: 0 |
|
| BIOCHAR_ADDED |
type: String
width: 3
precision: 0 |
|
| SOLARRATING |
type: SmallInteger
width: 2
precision: 5 |
Solar radiation rating between 1 and 5, where 1 is the lowest score and 5 is the highest (receives the most light). Pictometry 2014 DSM and DEM were used to determine tree height and measure shadows from 2014 3D buildings. SolarRating is the average of the solar radiation for both the DSM and DEM results for June, July, August, and September. |
| TREEWELLDEPTH |
type: Double
width: 8
precision: 38 |
|
| SCHEDULEDREMOVAL |
type: SmallInteger
width: 2
precision: 5 |
|
| REMOVALREASON |
type: String
width: 25
precision: 0 |
|
| PB |
type: String
width: 3
precision: 0 |
|
| PLANTINGSEASON |
type: String
width: 15
precision: 0 |
|
| STTREEPRUNINGZONE |
type: String
width: 10
precision: 0 |
|
| OFFSTTREEPRUNINGZONE |
type: String
width: 10
precision: 0 |
|