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 Risk Assessments

259a-b6s7Environment16 columns
Risk Assessments are sub-components of Inspection records where Type = Level 2. Trees are inspected in accordance with Parks' Tree Risk Management program. For a given defect identified on a tree, 3 rating variables are selected to arrive at a Total Rating. Because multiple defects can be noted on a tree, multiple Risk Assessment records can be related to one Inspection. 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

A90.7 / 100

From a 500-row sample across 12 columns.

completeness91/ 25% weight
consistency71/ 20% weight
accuracy99/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Forestry Tasks0.45
    joins onglobalidobjectidworkorderglobalid
  • Tree Contract Work Details0.45
  • Forestry Tree Points0.44
    joins on:@computed_region_yeji_bk3qglobalidcreateddate+5
  • Forestry Inspections0.40
    joins on:@computed_region_yeji_bk3qglobalidcreateddate+4
  • Forestry Work Orders0.36

Sample rows

objectidradefectradefectlocationfailureimpacttargetconsequenceriskratinginspectionglobalidglobalidcreateddatefailureimpact
18958176Dead WoodBranches2.02.04.08.028420BB3-4608-4526-8590-094BEB41E444AB69151A-DEDF-47EF-B0B4-7EAEFB8A41342026-07-10T15:18:25.0004.0
18952709Poor Tree Architecture

Columns

12 queryable · 12 profiled

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

FieldTypeDescriptionNullValues
objectidinteger—0%76200981426771619435321
radefectcategorical—0%Dead WoodDecayPoor Tree Architectureof 9
radefectlocationcategorical—0%BranchesStemEntire Treeof 6
failurecategorical—0%1.02.03.0of 5

Query this from your own app

GET /api/datasets/259a-b6s7
GET /api/datasets/259a-b6s7/quality
GET /api/datasets/259a-b6s7/related
GET /api/columns?dataset=259a-b6s7
joins on:@computed_region_yeji_bk3qglobalidcreateddate+5
  • DSNY Special Waste Drop-off Sites0.36
    joins on:@computed_region_yeji_bk3qglobalid:@computed_region_f5dn_yrer+2
  • Forestry Service Requests0.35
    joins on:@computed_region_yeji_bk3qglobalidcreateddate+4
  • DSNY Litter Basket Inventory0.35
    joins on:@computed_region_yeji_bk3q:@computed_region_f5dn_yrerobjectid+2
    • Branches
    1.0
    3.0
    2.0
    6.0
    C3412E23-BFFE-47DE-892B-9DE0FBA17DC6
    6C642F00-5BD0-4043-9E65-F62E359E9F73
    2026-07-09T22:47:34.000
    4.0
    18952720Poor Tree ArchitectureStem1.02.04.07.07250E89E-BBB2-48EB-9D5E-4F693F986FD4DFBE5BF9-7E80-4AED-9378-A3E8A0F4AB7A2026-07-09T22:43:53.0003.0
    18952712DecayRoots1.02.02.05.07250E89E-BBB2-48EB-9D5E-4F693F986FD486959692-9EBA-4BE9-9D20-D7544C29BB8B2026-07-09T22:43:53.0003.0
    18952713DecayRoots1.04.02.07.0C3412E23-BFFE-47DE-892B-9DE0FBA17DC6903661CC-BE18-4C07-AA59-5D6AAC0CD7352026-07-09T22:47:34.0005.0
    18952708Dead WoodBranches1.03.02.06.0C3412E23-BFFE-47DE-892B-9DE0FBA17DC6639FFA96-15CA-4200-8226-5738D4C7B7342026-07-09T22:47:34.0004.0
    18952706DecayBranches2.02.02.06.07250E89E-BBB2-48EB-9D5E-4F693F986FD45555D696-ED81-4046-8DB2-5BD33590C8172026-07-09T22:43:53.0004.0
    18952711Root ProblemsRoot Flare1.04.02.07.0C3412E23-BFFE-47DE-892B-9DE0FBA17DC674861F59-D490-44FE-BF72-DE181C1FBF832026-07-09T22:47:34.0005.0
    18952715DecayRoot Flare2.02.02.06.07250E89E-BBB2-48EB-9D5E-4F693F986FD4ABA8B99D-960A-408E-9E98-59F2780FA5AB2026-07-09T22:43:53.0004.0
    18952710Poor Tree ArchitectureStem1.04.02.07.0C3412E23-BFFE-47DE-892B-9DE0FBA17DC671331460-4255-4984-868C-C1A677393BC22026-07-09T22:47:34.0005.0
    impacttarget
    categorical
    —
    0%
    2.01.03.0of 5
    consequencecategorical—0%2.01.03.0of 5
    riskratingcategorical—0%7.06.08.0of 13
    inspectionglobalidtext—0%FF6CB2EA-EC9E-4FCC-B57D-…F6EF761C-0AF8-4803-8F85-…E2DE494C-A70E-4EF7-A545-…
    globalidtext—0%40B27104-8483-48F6-8FA7-…B218306A-682E-466C-AFBF-…3E669523-E225-475B-88F7-…
    createddatedatetime—0%2020-01-03T00:00:00.0002019-11-08T00:00:00.0002019-10-09T00:00:00.000
    failureimpactcategorical—0%4.05.03.0of 9
    workorderglobalidtext—83%A18E38C3-9906-4B79-B27E-…43812782-6D5C-442C-B909-…73DCD46D-F9B8-41EB-B13E-…