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
This dataset has the following 15 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
OBJECTID | objectid | number | Unique identifier for each tree point | 5585594 4705403 3361802 5778084 2419319 view top 100 |
DBH | dbh | number | Diameter of tree at breast height (4.5 feet off the ground) | 3 4 5 6 2 view top 100 |
TPStructure | tpstructure | text | Indicates the current physical state of the tree (stump, shaft, or entire tree intact) | Full Retired Stump Shaft Stump - Uprooted view top 100 |
TPCondition | tpcondition | text | Indicates condition of the tree based on biological health and physical structure | Good Fair Dead Excellent Poor view top 100 |
StumpDiameter | stumpdiameter | text | Diameter of exposed stump face | 0 12 3 6 5 view top 100 |
PlantingSpaceGlobalID | plantingspaceglobalid | text | Unique identifier for planting space associated with tree point | 038561B8-7CD6-4CEC-B820-41C01CD4D056 3AFD1B0E-B883-4D6A-B58F-A2D748E75A01 2CC41510-E0A6-4DA9-AD44-1DE36802EE60 D10DFA63-722C-4E14-83E4-0E82D9E695BF 992357B5-2416-459A-BA6A-D9C40ADE34EF view top 100 |
Geometry | geometry | text | Geometry for planting space in well known text | POINT (-73.8813807388734887 40.7236496944448376) POINT (-73.7488130800217760 40.7759921277298361) POINT (-73.9671519096020944 40.6955187922374719) POINT (-74.1579769883115461 40.5617429858598086) POINT (-73.9524693109144096 40.6397828016085754) view top 100 |
GlobalID | globalid | text | Unique identifier for each tree point | 0731F22C-2AF0-48E3-8B58-30E28AFFFED0 74CB936B-5C12-459E-8547-2DCAF26DBA4C 73BC156A-B9F7-4151-A0BD-EBF9EDB946A1 8575517D-9728-4347-AB18-F6711C026576 95158AE3-D063-4D95-8199-3C91DF39FDC9 view top 100 |
GenusSpecies | genusspecies | text | Tree species, includes gensus and specific epithet plus common name | Platanus x acerifolia - London planetree Gleditsia triacanthos var. inermis - Thornless honeylocust Quercus palustris - pin oak Pyrus calleryana - Callery pear Acer platanoides - Norway maple view top 100 |
CreatedDate | createddate | text | Date tree point record was created | 2016-11-02 16:59:52.0000000 2018-11-07 11:11:11.0000000 2018-04-11 11:11:11.0000000 2017-11-15 11:11:11.0000000 2018-08-01 11:11:11.0000000 view top 100 |
UpdatedDate | updateddate | text | Date tree point record was last updated | 2017-11-21 04:11:11.0000000 2024-04-16 19:33:59.0000000 2017-04-13 11:11:11.0000000 2020-05-26 15:00:00.0000000 2018-10-29 14:17:45.0000000 view top 100 |
PlantedDate | planteddate | text | Date tree was planted | 2023-05-15 04:00:00.0000000 2021-12-15 05:00:00.0000000 2021-12-13 05:00:00.0000000 2020-12-15 05:00:00.0000000 2021-12-10 05:00:00.0000000 view top 100 |
RiskRating | riskrating | text | Risk rating of the most recent risk assessment inspection | 6 7 3 5 8 view top 100 |
RiskRatingDate | riskratingdate | text | Date of most recent risk assessment inspection | 2020-01-03 00:00:00.0000000 2019-11-08 00:00:00.0000000 2017-09-13 04:00:00.0000000 2017-09-15 04:00:00.0000000 2017-03-23 04:00:00.0000000 view top 100 |
Location | location | point | {"coordinates":[-73.9671519096021,40.69551879223747],"type":"Point"} {"coordinates":[-73.88138073887349,40.72364969444484],"type":"Point"} {"coordinates":[-73.74881308002178,40.775992127729836],"type":"Point"} {"coordinates":[-73.94189242160232,40.837633665640624],"type":"Point"} {"coordinates":[-73.9647708553998,40.59477475546461],"type":"Point"} view top 100 |