Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Forestry Tree Points

hn5i-inapEnvironment20 columns
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
View on NYC Open Data↗

Quality

B89.1 / 100

From a 500-row sample across 20 columns.

completeness86/ 25% weight
consistency68/ 20% weight
accuracy95/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Forestry Planting Spaces0.58
    joins ongeometryupdateddateobjectid+8
  • Tree Contract Work Details0.45
  • Forestry Risk Assessments0.44
    joins onriskratingobjectid:@computed_region_sbqj_enih+5
  • Forestry Inspections0.43
    joins ongeometryupdateddateobjectid+9

Geography

Mappable — Socrata point column `location`.

Open on the map →

Sample rows

objectiddbhtpstructuretpconditionplantingspaceglobalidgeometryglobalidgenusspeciescreateddateupdateddatelocation:@computed_region_efsh_h5xi
8682322RetiredExcellentE814CD37-9F53-4D79-AF86-3B454F9D29B9POINT(-73.81656874596392 40.716290654685075)2B457A4C-E0E4-4E17-81C4-A5449F51C804Acer nigrum - black maple2015-02-28 05:00:002026-01-03 13:52:0040.71629, -73.8165724670

Columns

15 queryable · 15 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
objectidintegerUnique identifier for each tree point0%13616730334735015802259
dbhintegerDiameter of tree at breast height (4.5 feet off the ground)2%346
tpstructurecategoricalIndicates the current physical state of the tree (stump, shaft, or entire tree intact)0%FullRetiredStumpof 5
tpconditioncategoricalIndicates condition of the tree based on biological health and physical structure0%GoodFairDead

Query this from your own app

GET /api/datasets/hn5i-inap
GET /api/datasets/hn5i-inap/quality
GET /api/datasets/hn5i-inap/related
GET /api/columns?dataset=hn5i-inap
Forestry Work Orders0.41
joins ongeometryupdateddateobjectid+8
  • DSNY Litter Basket Inventory0.38
    joins onobjectid:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+3
  • Electronics Drop Off Locations in NYC0.37
    joins onobjectid:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+3
  • DSNY Special Waste Drop-off Sites0.35
    joins on:@computed_region_sbqj_enih:@computed_region_yeji_bk3q:@computed_region_92fq_4b7q+3
  • 8762310RetiredGoodA644AB79-A3CB-4F7F-923B-F308E615CCD4POINT(-73.93848036135195 40.81299277914583)37195E1A-A7EE-4AA4-8389-19A0ED5C46F7Fraxinus pennsylvanica - Green ash2015-03-03 05:00:002019-09-18 13:12:5540.81299, -73.9384813095
    8802324RetiredPoor21431016-EDB8-4A0B-B122-673125800C87POINT(-73.8324418097762 40.88762504258473)6BA8E72B-1901-4EF3-ABFF-D11680AB4A9BAcer platanoides - Norway maple2015-03-03 05:00:002018-03-27 14:00:4240.88763, -73.8324411275
    8882310FullFair96FB6C55-612F-466D-9449-85A3CD2178E1POINT(-74.20903635163978 40.519577813518666)79A5DBAF-F305-4DA1-A4B1-7A8C8D085435Pyrus calleryana - Callery pear2015-03-04 05:00:002024-06-28 12:41:5540.51958, -74.2090410696
    8882410RetiredDead4796B64F-906C-4345-A4E9-5CD6133642F8POINT(-73.98032166282525 40.7429106380851)182F6647-D9C1-4A45-ADA0-9ADEFD1ECC60Gleditsia triacanthos var. inermis - Thornless honeylocust2015-03-04 05:00:002016-10-24 02:50:4340.74291, -73.9803212078
    8882519RetiredFairF31930BA-47FD-4D9F-B8A2-7A4FA4707D16POINT(-73.73589054380587 40.73590388589216)394AEC59-B91C-45AD-93FB-2996B0C09747Fraxinus americana - white ash2015-03-04 05:00:002017-04-12 09:35:5040.73590, -73.7358924336
    8922312RetiredCriticalED1D6BF0-C0E7-49BB-9A1A-85CBF8558ACDPOINT(-73.96597434089155 40.795164007783804)8717EC83-F165-495A-A1AA-1064173A681FZelkova serrata - Japanese zelkova2015-03-04 05:00:002020-01-08 16:27:0040.79516, -73.9659712422
    892258RetiredDead6AC474F7-0D16-43EC-A1F9-8C9B6C14F434POINT(-74.13088024029413 40.60672684318438)FD617E56-130C-4E43-A76D-3AF989E37A2FAcer platanoides - Norway maple2015-03-04 05:00:002017-09-11 08:51:1740.60673, -74.1308810700
    896256RetiredUnknown8E628B41-0A1D-4948-AAE3-F0B3A2A8AFE8POINT(-73.96474481232734 40.804278981082376)380AB840-F0E9-4B14-A4D6-A99B8861065ETilia cordata - littleleaf linden2015-03-04 05:00:002016-12-28 12:18:1540.80428, -73.9647412422
    8962615RetiredFairC6526419-CD64-4D8D-9288-C7967124B9B4POINT(-73.85287876894496 40.67822801614558)8A487A6B-146A-4DE4-9AEE-835492B1E348Abies alba - silver fir2015-03-04 05:00:002023-12-11 18:01:0740.67823, -73.8528824013

    Showing 12 of 18 columns. All of them are listed below.

    of 7
    stumpdiametertextDiameter of exposed stump face63%0312
    plantingspaceglobalidtextUnique identifier for planting space associated with tree point0%B8E9701B-C063-4D16-A4C6-…2CC41510-E0A6-4DA9-AD44-…132E611E-0482-4EB9-9B53-…
    geometrytextGeometry for planting space in well known text0%POINT(-73.91059749631333…POINT(-73.90509503012358…POINT(-73.97317981655793…
    globalidtextUnique identifier for each tree point0%0731F22C-2AF0-48E3-8B58-…74CB936B-5C12-459E-8547-…73BC156A-B9F7-4151-A0BD-…
    genusspeciestextTree species, includes gensus and specific epithet plus common name0%Platanus x acerifolia - …Gleditsia triacanthos va…Quercus palustris - pin …
    createddatedatetimeDate tree point record was created0%2016-11-02 16:59:522018-11-07 11:11:112018-04-11 11:11:11
    updateddatedatetimeDate tree point record was last updated17%2017-11-21 04:11:112024-04-16 19:33:592017-04-13 11:11:11
    planteddatedatetimeDate tree was planted88%2023-05-15 04:00:00.0000…2021-12-15 05:00:00.0000…2025-12-13 05:00:00.0000…
    riskratingcategoricalRisk rating of the most recent risk assessment inspection39%673of 13
    riskratingdatedatetimeDate of most recent risk assessment inspection39%2020-01-03 00:00:002019-11-08 00:00:002017-09-13 04:00:00
    locationcoordinate—0%{'coordinates': [-73.910…{'coordinates': [-73.748…{'coordinates': [-73.881…