cambridgema-gov/street-trees-82zb-7qc9
Icon for Socrata external plugin
 
Readme
Updated 12 days ago
Indexed 3 hours ago

Street Trees

View full metadata

https://www.cambridgema.gov/GIS/gisdatadictionary/Environmental/ENVIRONMENTAL_StreetTrees

Description

Trees and tree planting sites owned, planted or maintained by the City of Cambridge, the Massachusetts Department of Conservation and Recreation, and MIT, Harvard University and other private organizations. This layer is maintained by Cambridge Public Works. City owned and maintained trees. This layer is maintained by Cambridge Public Works and updated regularly by the City Arborist.

About Edit Dates

This data is automatically updated on a set schedule. The Socrata edit date may not reflect the actual edit dates in the data. For more details please see the update date on the full metadata page or view the edit date within the data rows.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Street NumberstreetnumbstreetnumbNumberNumber of the street address closest to the site.
CultivarcultivarcultivarTextCultivated variety of the current tree species (see Species).
LocationRelocationrelocationreText
Structural SoilstructuralstructuralTextIndicates if the tree was planted in structural soil.
Solar RatingsolarratinsolarratinNumberSolar 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.
Biochar_Adbiochar_adbiochar_adText
CommonNamecommonnamecommonnameText
TreeWellWitreewellwitreewellwiNumber
SpeciesspeciesspeciesTextCommon name of the species of the current tree.
Species ShortspeciesshospeciesshoTextGenus of the current tree species (see Species).
Plant DateplantdateplantdateCalendar dateDate that a tree was last planted at this site.
Site TypesitetypesitetypeTextDesignates 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.
Tree Well IDtreewellidtreewellidNumber
Tree WellLetreewellletreewellleNumber
ScheduledRscheduledrscheduledrNumber
TrunkstrunkstrunksNumberNumber of tree trunks (see note at Diameter about using the number of trunks to calculate an average tree diameter).
SiteRetiresiteretiresiteretireText
SiteReplansitereplansitereplanText
notesnotesnotesText
WateringRewateringrewateringreText
Order_order_order_Text
PlantingCoplantingcoplantingcoText
Census Blocks 2010:@computed_region_e4yd_rwk4:@computed_region_e4yd_rwk4NumberThis column was automatically created in order to record in what polygon from the dataset 'Census Blocks 2010' (e4yd-rwk4) the point in column 'the_geom' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
cambridge_cdd_zoning:@computed_region_swkg_bavi:@computed_region_swkg_baviNumberThis column was automatically created in order to record in what polygon from the dataset 'cambridge_cdd_zoning' (swkg-bavi) the point in column 'the_geom' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
cambridge_neighborhoods:@computed_region_rffn_qbt6:@computed_region_rffn_qbt6NumberThis column was automatically created in order to record in what polygon from the dataset 'cambridge_neighborhoods' (rffn-qbt6) the point in column 'the_geom' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
inspectrinspectrinspectrText
Bare RootbarerootbarerootTextDesignates whether the last tree was planted as a bare-root tree.
RemovalRearemovalrearemovalreaText
OwnershipownershipownershipTextDesignates the ownership of the tax parcel on which the site falls.
OffStTreePoffsttreepoffsttreepText
Tree IDtreeidtreeidText
Tree GratetreegrateatreegrateaNumberThis 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.
TreeWellCotreewellcotreewellcoTextThe type of cover, if any that is over the tree well. The two values are Tree Grate or Flexi-Pave.
GenusgenusgenusText
Cartegra_1cartegra_1cartegra_1Calendar date
PBpbpbText
Removal DateremovaldatremovaldatCalendar dateDate that a tree was last removed from this site.
Street NamestreetnamestreetnameTextName of the street for the address closest to the site.
Memorial TreememtreememtreeTextDesignates whether the current tree was planted in memoriam.
ADA CompliantadacompliaadacompliaTextDesignates whether the site is ADA compliant, for instance whether the site has the minimum required sidewalk width of 4 feet.
Abuts Open SpaceabutsopenaabutsopenaTextIndicates if the tree abuts an open space or if the tree well is the only open area around the tree.
Overhead WiresoverheadwioverheadwiNumberDesignates the presence of above-ground utility wires in the area of tree canopy growth at the site.
CartegraphcartegraphcartegraphCalendar date
creatorcreatorcreatorText
PlantingSeplantingseplantingseText
StTreePrunsttreeprunsttreeprunText
ScientificscientificscientificText
Geometrythe_geomthe_geomPointGeospatial layer geometry. The latitude and longitude data for the underlying map shapes.
DiameterdiameterdiameterNumberTree 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.
LocationlocationlocationTextDesignates 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).
Police Response Districts:@computed_region_v7jj_366k:@computed_region_v7jj_366kNumberThis column was automatically created in order to record in what polygon from the dataset 'Police Response Districts' (v7jj-366k) the point in column 'the_geom' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Exposed RootsexposedrooexposedrooTextIndicates if the root flare of the tree is visible.
Police Neighborhood Regions:@computed_region_guic_hr4a:@computed_region_guic_hr4aNumberThis column was automatically created in order to record in what polygon from the dataset 'Police Neighborhood Regions' (guic-hr4a) the point in column 'the_geom' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
TreeWellDetreewelldetreewelldeNumber
 
Preview
  • street_trees
     
Upstream Metadata