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 Inspections

4pt5-3vv4Environment30 columns
Record of Forestry inspections for NYC Parks & Recreation. Inspections are initiated by a service request or internal process and may result in a work order. Inspections are used to record field observations. ForMS 2.0 requires that Inspections can only be created from either a Tree Point or Planting Space based on the asset in question. Inspection types vary depending on the inspector’s workflow: • level 1 (limited visual) • level 2 (basic) • level 3 (advanced) • Re-inspection • Sidewalk Rating (Trees and Sidewalks Inspections) • General – Planting Space (Street Tree Planting Inspections) This dataset can be joined to the Forestry Tree Points dataset by joining TreePointGlobalID from Forestry Inspections to GLOBALID from Forestry Tree Points. 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

B83.6 / 100

From a 500-row sample across 30 columns.

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

Related datasets

  • Forestry Work Orders0.45
    joins onupdateddatecreateddatetreepointglobalid+10
  • Forestry Service Requests0.44
    joins onupdateddatecreateddatecloseddate+8
  • Forestry Tree Points0.43
    joins onupdateddatecreateddate:@computed_region_efsh_h5xi+9
  • Forestry Risk Assessments0.40

Geography

Mappable — Socrata point column `location`.

Open on the map →

Sample rows

objectidinspectiontypeinspectionstatusinspectiontpconditioninspectiontpstructuretreepointdbhtreepointglobalidplantingspaceglobalidservicerequestglobalidgeometryglobalidinspectiondate
22814879Level 2ClosedFairFull2816863D42-71CD-44E1-9303-0C5A362CF43366DB2F88-E668-41AB-9BD8-089EC86BE6C12FE4AF95-784A-4145-A9EA-A50C3497CF0CPOINT (1005341.6002085656 175104.972291857)1B48DCE4-4EC8-4A09-9A0F-005BF4A3FE0E

Columns

25 queryable · 25 profiled

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

FieldTypeDescriptionNullValues
objectidintegerUnique identifier for each inspection0%262249922819729631233042
inspectiontypecategoricalType of inspection0%Level 2Level 1General - Planting Spaceof 5
inspectionstatuscategoricalIndicates if inspection has been completed, is awaiting reinspection, or has not been completed0%ClosedReinspectionOpenof 3
inspectiontpconditioncategoricalCondition of tree at the time of inspection10%

Query this from your own app

GET /api/datasets/4pt5-3vv4
GET /api/datasets/4pt5-3vv4/quality
GET /api/datasets/4pt5-3vv4/related
GET /api/columns?dataset=4pt5-3vv4
joins oncreateddate:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+4
  • Forestry Planting Spaces0.38
    joins onupdateddatecreateddate:@computed_region_efsh_h5xi+8
  • DSNY Special Waste Drop-off Sites0.36
    joins on:@computed_region_efsh_h5xi:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+3
  • Electronics Drop Off Locations in NYC0.35
    joins on:@computed_region_efsh_h5xi:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+3
  • Forestry Tasks0.35
    joins onglobalidobjectid
  • 2024-01-05T18:55:54.000
    24181205Level 2ClosedFairFull4401B362A-5B5B-4F1D-803F-D12FFEE5E95BB99B1475-30D6-4C05-979C-5213E6404204—POINT (997358.65062522888 203584.91104185581)376B6A76-DECE-42F0-AB64-01F6C8327F522024-05-20T14:35:19.000
    6622748Level 1ClosedGoodFull8EEB2D030-4C1A-404F-955F-9D9260D71FE79E690A61-7CB4-47E9-B4E3-6C91AA28083B—POINT (946926.91979189217 140263.14645852149)FB0E24FA-CD3B-4B69-B595-00ACE42481512017-11-03T10:12:22.000
    18404347Level 2ClosedFairFull16E538BED5-8DDC-4AB3-8700-3814BDB3D901DAFD8FE1-ECAE-4CC4-B429-47D1A8320DFA—POINT (994779.23312522471 189915.00500018895)4F120CBD-7768-4157-ADDF-012F0AE91B922022-08-24T04:00:00.000
    11815870Level 2ClosedDeadFull829187909-CBFB-418E-AF6C-6F5B4DA438ADB46784FF-A436-4A54-8967-CE51E36855F2273D20AB-9DCF-4256-A010-9C2D7CC652FDPOINT (984639.23437522352 192017.13208352029)DFF95D56-BCBF-4EBB-AEA4-01462799BD602020-10-07T15:01:18.000
    26326787Level 1ClosedUnknownShaft3DAA28376-3E22-433D-A901-036F36CB222E9FDA8EAE-771B-487B-970C-516258C4CBE2—POINT (1002012.6433335692 183722.1231251806)F51A171A-9E48-4C99-BF18-00DC309B0FA82025-01-13T17:31:58.000
    17369694Level 2ClosedFairFull9F9BEDCA2-2C41-444A-A9D1-EC4B304F1CE072809D6E-B16C-4598-9B89-7952A3549E34FF609C30-30ED-41DB-9DC4-C355CE05D4F4POINT (997992.57916688919 179151.5341668427)4D959AE8-9DF9-4E9D-8FA7-017E223B5E6E2022-06-02T17:48:10.000
    22600948Level 2ClosedGoodFull103B017E39-ABD9-48A9-B0E1-F217D28E2DFBFAFD8A01-347E-4A49-BB0A-DE63928F8D16—POINT (991223.37291689217 187064.74083352089)F6EE7955-62B2-49DF-B227-0058B492F4EA2023-12-13T21:22:51.000
    5544588General - Planting SpaceClosed————7716D84B-F085-412B-832B-45E338F8A69D—POINT (1047346.2195835561 222146.98354184628)9017E95D-CFEC-4F87-BA92-003EFF4FF3EF2017-01-30T09:46:24.000
    21028614Level 2ClosedFairFull129B7F2608-79E5-4666-AFAA-3F69F489CE71A46CA113-A558-45E8-8E1C-BAB3A560B92F—POINT (1021805.5233335644 262903.33875018358)A5A59F92-7308-4B62-86B8-016F5ED29FFC2023-07-12T14:29:57.000

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

    Good
    Fair
    Dead
    of 7
    inspectiontpstructurecategoricalStructure of tree at the time of inspection10%FullShaftLiability Releaseof 5
    treepointdbhtextDiameter at breast height of tree at the time of inspection14%365
    swtreeconditionratingcategoricalCondtion of tree during sidewalk inspection97%431of 16
    swlocationratingtext—97%124
    swclearanceratingtext—97%4320
    swdamageratingtext—97%534
    swdamagedflagstonesratingcategorical—97%543of 16
    swratingtotaltext—97%818076
    treepointglobalidtextUnique identifier for tree point associated with inspection11%61BA2037-7323-4FDC-8FF5-…EE8B4ED7-BBFA-4647-98C7-…374CBE69-0CAB-49EE-99BA-…
    plantingspaceglobalidtextUnique identifier for planting space associated with inspection0%F92C63E0-5A3C-4968-BAE2-…E253FB9E-0965-4FEB-B26F-…6E7BCB93-DF1E-4D90-9324-…
    servicerequestglobalidtextUnique identifier for service request associated with inspection75%35103058-D72D-401C-8D34-…1AE19668-DA14-4373-ABED-…327CFF55-8B8D-4BF9-88F9-…
    geometrytextGeometry for planting space in well known text0%POINT (991497.419583559 …POINT (1026328.013958558…POINT (998075.624166891 …
    globalidtextUnique identifier for each inspection0%3663BE72-CE63-4D62-B398-…E4BA597E-3770-4239-A1CA-…835FDC9D-4E83-484A-AE7F-…
    inspectiondatedatetimeDate inspection was performed0%2020-08-12T16:47:43.0002020-08-12T04:00:00.0002020-02-03T05:00:00.000
    closeddatedatetimeDate inspection was closed1%2024-04-16T19:34:52.0002024-12-17T20:37:22.0002020-08-12T16:47:43.000
    createddatedatetimeDate inspection was created0%2024-04-16T19:34:52.0002024-12-17T20:37:22.0002020-08-12T16:47:43.000
    updateddatedatetimeDate of last update to inspection33%2020-05-26T15:00:00.0002024-12-03T12:00:00.0002024-01-01T16:10:11.000
    parentinspectionglobalidtextUnique identifier of inspection that triggered a reinspection98%FF8D425B-247B-4D97-BDAC-…F562AD2A-4805-464D-B66C-…B7C482C6-3A2F-41C2-9539-…
    reinspectiondatedatetimeDate for when reinspection should take place98%2026-04-15T04:00:00.0002023-11-15T05:00:00.0002018-05-22T09:21:06.000
    swtotaltreescategoricalIndicates number of trees at property98%124of 5
    locationcoordinate—0%{'coordinates': [-73.973…{'coordinates': [-73.848…{'coordinates': [-73.950…