cityofnewyork-us/forestry-tree-points-hn5i-inap
 
Readme
Updated 18 days ago
Indexed 3 hours ago

Forestry Tree Points

Record of Forestry tree points for NYC Parks & Recreation.

Tree Points and Planting Spaces form the basis of ForMS 2.0’s data inventory and are the core entities that all Service Requests, Inspections, and Work Orders are associated to. The system has built-in rules to ensure that every Tree Point has a Planting Space and each Planting Space can have no more than one active Tree Point at a given time. Locations that have had one tree removed and another tree replanted will appear in ForMS 2.0 as a single Planting Space associated with one retired Tree Point (that has a removal Work Order) and one active Tree Point.

This dataset can be joined to the Forestry Planting Spaces dataset by joining PlantingSpaceGlobalID from Forestry Tree Points to GLOBALID from Forestry Planting Spaces.

User guide: https://docs.google.com/document/d/1PVPWFi-WExkG3rvnagQDoBbqfsGzxCKNmR6n678nUeU/edit?usp=sharing

Data dictionary: https://docs.google.com/spreadsheets/d/1yMfZgcsrvx9M0b3-ZdEQ3WCk2dFxgitCWytTrJSwEAs/edit?usp=sharing

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
GlobalIDglobalidglobalidTextUnique identifier for each tree point
OBJECTIDobjectidobjectidNumberUnique identifier for each tree point
LocationlocationlocationPoint
Zip Codes:@computed_region_efsh_h5xi:@computed_region_efsh_h5xiNumber
RiskRatingDateriskratingdateriskratingdateCalendar dateDate of most recent risk assessment inspection
UpdatedDateupdateddateupdateddateCalendar dateDate tree point record was last updated
GeometrygeometrygeometryTextGeometry for planting space in well known text
City Council Districts:@computed_region_92fq_4b7q:@computed_region_92fq_4b7qNumber
StumpDiameterstumpdiameterstumpdiameterTextDiameter of exposed stump face
PlantingSpaceGlobalIDplantingspaceglobalidplantingspaceglobalidTextUnique identifier for planting space associated with tree point
RiskRatingriskratingriskratingTextRisk rating of the most recent risk assessment inspection
Location (zip)location_ziplocation_zipText
Location (city)location_citylocation_cityText
TPStructuretpstructuretpstructureTextIndicates the current physical state of the tree (stump, shaft, or entire tree intact)
TPConditiontpconditiontpconditionTextIndicates condition of the tree based on biological health and physical structure
Borough Boundaries:@computed_region_yeji_bk3q:@computed_region_yeji_bk3qNumber
GenusSpeciesgenusspeciesgenusspeciesTextTree species, includes gensus and specific epithet plus common name
DBHdbhdbhNumberDiameter of tree at breast height (4.5 feet off the ground)
Police Precincts:@computed_region_sbqj_enih:@computed_region_sbqj_enihNumber
Location (address)location_addresslocation_addressText
Community Districts:@computed_region_f5dn_yrer:@computed_region_f5dn_yrerNumber
Location (state)location_statelocation_stateText
PlantedDateplanteddateplanteddateCalendar dateDate tree was planted
CreatedDatecreateddatecreateddateCalendar dateDate tree point record was created
Upstream Metadata