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 Work Orders

bdjm-n7q4Environment56 columns
Record of Forestry work orders for NYC Parks & Recreation. Work Orders are used to record activities performed by Parks staff, contractors, other Agencies, or private entities in the case of permitted work. ForMS 2.0 requires that WOs can only be created from an Inspection, with the exception of a Debris Removal – Misc. Wood WO where the associated tree cannot always be determined. This dataset can be joined to the Forestry Planting Spaces dataset by joining PlantingSpaceGlobalID from Forestry Work Orders 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

B82.7 / 100

From a 500-row sample across 52 columns.

completeness53/ 25% weight
consistency75/ 20% weight
accuracy97/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Forestry Service Requests0.47
    joins onbblcongressionalupdateddate+29
  • Forestry Inspections0.44
    joins onplantingspaceglobalidtreepointglobalidupdateddate+10
  • Forestry Planting Spaces0.42
    joins onbblcongressionalupdateddate+28

Geography

Mappable — Socrata point column `geometry`.

Open on the map →

Sample rows

objectidwotypewostatuswopriorityboroughcodecommunityboardparknamewocategorywowoodremainssanitationzoneinspectionglobalidglobalid
31341145Tree RemovalOpen6Queens407.0Frank Golden ParkRisk MitigationNo Wood Debris4075C79F8A82F-67AA-4685-972A-BE9C961394BC1B6B171D-A1AE-4767-AC12-6D3896463491

Columns

51 queryable · 51 profiled

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

FieldTypeDescriptionNullValues
objectidintegerUnique identifier for each tree point0%93615192672874318918740
wotypetextIndicates the type of work order0%Block PruningTree RemovalTree Plant-Street Tree
wostatuscategoricalIndicates the work order status0%ClosedOpenCancelof 6
woprioritycategoricalIndicates work order priority75%897of 12

Query this from your own app

GET /api/datasets/bdjm-n7q4
GET /api/datasets/bdjm-n7q4/quality
GET /api/datasets/bdjm-n7q4/related
GET /api/columns?dataset=bdjm-n7q4
  • Forestry Tree Points0.41
    joins onplantingspaceglobalidupdateddategeometry+8
  • Asset Management Parks System (AMPS) - Work Orders0.38
  • Food Scrap Drop-Off Locations in NYC0.36
    joins onbbl:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+6
  • Forestry Risk Assessments0.36
    joins on:@computed_region_sbqj_enihcreateddate:@computed_region_yeji_bk3q+5
  • 2005 Street Tree Census0.35
    joins onbblnta:@computed_region_sbqj_enih+10
    • 31344689
    Pruning
    Open
    6
    Bronx
    208.0
    Washington's Walk
    Risk Mitigation
    No Wood Debris
    2081B
    E07557F2-2879-4D8C-B8F9-D05E2192BD1D
    67F3F0A2-CF0E-4BDB-9325-42A1EAC73646
    31346037PruningOpen5Bronx208.0Washington's WalkRisk MitigationNo Wood Debris2081BCC7C2040-83FF-4031-BF5A-7F0EF99C9362ACA92732-002B-40B1-BF4B-297397A33917
    31296650Block PruningOpen—Bronx211.0—Block PruningNo Wood Debris2112E78F15776-6C31-4647-B828-B0031CE8E143C9981D30-07CB-40B2-8388-9F8B054ED0F4
    31296648Block PruningOpen—Bronx211.0—Block PruningNo Wood Debris2112EEB2F1E26-325B-4094-861F-C252BF7C6A94A9A616F8-0DA0-465B-B3F8-0DF505B904BE
    31183723Tree RemovalOpen8Manhattan107.0Riverside ParkRisk MitigationNo Wood Debris1075BD1BE5EFC-14FC-42CD-AE4B-81CEF028FF67FF533886-6061-4FF5-A9A4-43C271F04A88
    31296645Block PruningOpen—Bronx211.0—Block PruningNo Wood Debris2112EF99B6DF3-E603-48EE-AA6C-C968533DCD9C80F29E8A-7EFE-4DBD-AADB-C9B0B8E25F39
    31124615Tree RemovalOpen6Bronx228.0Pelham Bay ParkRisk MitigationNo Wood Debris—3D932951-F4CE-45DC-B522-78EF031358331158C8C7-BC96-41BA-B844-21C598C05E74
    31175471Hanging LimbOpen9Brooklyn318.0Marine ParkRisk MitigationUnprocessed Wood—2E73849C-8FC9-4733-AE2D-BFEE016B235912AA8BCC-2F22-4310-95F8-C8DD548D7159
    31175476Hanging LimbOpen8Brooklyn318.0Marine ParkRisk MitigationUnprocessed Wood—6E4936CE-9F62-4978-8F9A-C2B0FAE902EFF4DBB70A-EDEF-4AB6-AFA4-B2482FBB708B

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

    boroughcodecategoricalBorough the work order is in0%QueensBrooklynBronxof 5
    communityboardintegerCommunity Board the work order is in0%503.0413.0412.0
    buildingnumbertextBuilding number of the Planting Space address8%0*/
    streetnametextStreet name of the work order7%0/BROADWAY
    locationdetailstextInternal agency codes to give additional details about location16%1F1f2F
    actualfinishdatedatetimeDate of work order completion96%2024-01-01T16:10:112026-09-29T04:00:002025-06-18T04:00:00
    wocontracttextIndicates contract if work was completed using a contractor29%BP-Q17BP-Q20BP-Q18
    parknametextName of park if work order is in a park88%Pelham Bay ParkFlushing Meadows Corona …Riverside Park
    parkzonetextName of zone in park if work order is in a park95%X003-ZN01R031-ZN02X003-ZN02
    cancelreasontextReason for why the work order was cancelled93%VOID - Refer to Location…EAB Treatment Work Order…BBO
    wocategorycategoricalWork order category0%Block PruningRisk MitigationTree Plantingof 9
    sanitationassigneddatedatetime—38%2017-04-13T10:00:00.0002017-08-09T11:11:11.0002023-06-16T04:00:00.000
    sanitationremovaldatedatetime—100%2020-08-13T12:31:08.0002020-08-09T15:22:57.0002020-08-11T07:02:52.000
    sanitationupdateddatedatetime—100%2020-08-11T07:02:52.0002020-08-13T14:36:15.0002020-08-09T15:22:57.000
    wowoodremainscategoricalIndicates if work order has wood remains that need to be picked up0%No Wood DebrisAll Wood RemovedUnprocessed Woodof 6
    woequipmentcategoricalIndicates what equipment is needed to complete work93%Bucket, Loader & ChipperBucket & ChipperChipperof 12
    zipcodeintegerZipcode work order is in7%10312.010314.010306.0
    citycouncilintegerCity council district work order is in7%51.050.019.0
    statesenateintegerState senate district work order is in7%24.011.015.0
    stateassemblyintegerState assembly district work order is in7%62.064.063.0
    congressionalcategoricalCongressional district work order is in7%11.05.06.0of 15
    sanitationzonetextSanitation zone work order is in2%2031A5034D2031B
    physicalidintegerPhysicalID of CSCL line segment that the PS address is associated with23%7814519152558005
    crossstreet1textName of first cross street7%BENDBROADWAYALLEY
    crossstreet2textName of second cross street7%BENDALLEYDEAD END
    plantingspaceglobalidtextUnique identifier for planting space associated with work order100%C1FECDF7-2298-4017-98B7-…B77DA87B-6DD8-4484-936A-…80D01121-944A-45A6-B02C-…
    treepointglobalidtextUnique identifier for tree point associated with work order100%C963DB83-18CC-4E24-BF84-…BE2AF776-EE10-48E8-807D-…8EA61BBB-C933-45F4-9519-…
    inspectionglobalidtextUnique identifier for inspection associated with work order1%F9F5AC35-42EA-4D55-8F7C-…AC7FB772-A72B-41DF-810A-…E1582D5E-A14C-4002-912B-…
    globalidtextUnique identifier for each inspection0%F92190F4-93A8-4F56-A1D3-…378D460E-DFA3-4C87-B29A-…9EFC2084-F34E-4ACE-BCC9-…
    sidewalkdamagecategoricalIndicates if the sidewalk was damaged by the tree90%1.00.0of 2
    wowireconflictcategoricalIndicates if the tree is in conflict with a utility wire0%No Util Conflict PresentElectric Utility OpenAll Conflicts Resolvedof 5
    crewglobalidtextUnique identifier of crew that performed the work89%324F88D5-7630-43D8-BFF3-…A2637397-0208-4AEE-B7C7-…A294DC04-BBD0-45E1-B38C-…
    closeddatedatetimeDate the work order record was closed40%2017-04-13T10:00:00.0002017-08-09T11:11:11.0002022-06-07T04:00:00.000
    canceldatedatetimeDate work order was cancelled93%2021-07-27T00:00:00.0002018-08-02T10:20:11.0002021-12-02T12:00:00.000
    createddatedatetimeDate work order was created0%2016-07-14T17:19:00.0002024-01-01T16:10:11.0002016-07-14T17:19:24.000
    updateddatedatetimeDate work order was last updated33%2017-04-13T10:00:00.0002017-08-09T11:11:11.0002023-06-16T04:00:00.000
    woentitycategoricalIndicates if the work was completed by in-house crews, capital or expense contractors, or other groups0%ExpenseIn-HouseCapitalof 17
    projstartdatedatetimeProjected start date of work17%NaT2015-10-15 00:00:002016-03-15 00:00:00
    woprojecttextIndicates if work is associated with specific project42%Block PruningP&D - EABYSTP
    recommendedspeciestextSpecies intended for planting95%Platanus x acerifolia - …Fraxinus pennsylvanica -…Pyrus calleryana - Calle…
    latitudefloat—20%40.72691840.87501340.747262
    longitudefloat—20%-73.930808-73.828362-73.843333
    census_tractfloat—20%176134892.01
    bininteger—21%400000030000002000000
    bblinteger—21%302802001420514101204020180001
    ntatext—0%/SI01 /SI54 /
    geometrycoordinate—0%{'coordinates': [-73.973…{'coordinates': [-73.798…{'coordinates': [-73.973…