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
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"cityofnewyork-us/forestry-tree-points-hn5i-inap\".\"forestry_tree_points\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.