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
This dataset has the following 52 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
OBJECTID | objectid | number | Unique identifier for each tree point | 484584 484983 484984 484985 484987 view top 100 |
WOType | wotype | text | Indicates the type of work order | Block Pruning Tree Removal Tree Plant-Street Tree Pruning Stump Removal view top 100 |
WOStatus | wostatus | text | Indicates the work order status | Closed Cancel Open Pending Alternate view top 100 |
WOPriority | wopriority | text | Indicates work order priority | 8 9 7 6 1 view top 100 |
Borough | boroughcode | text | Borough the work order is in | Queens Brooklyn Bronx Staten Island Manhattan view top 100 |
CommunityBoard | communityboard | number | Community Board the work order is in | 503.0 413.0 501.0 407.0 411.0 view top 100 |
BuildingNumber | buildingnumber | text | Building number of the Planting Space address | 0 * / 00 1 view top 100 |
StreetName | streetname | text | Street name of the work order | 0 / BROADWAY 00 OCEAN PARKWAY view top 100 |
LocationDetails | locationdetails | text | Internal agency codes to give additional details about location | 1F 2F 1f 1S 1X view top 100 |
ActualFinishDate | actualfinishdate | text | Date of work order completion | 2017-06-26 11:11:11.0000000 2017-04-04 11:11:11.0000000 2022-01-10 12:00:00.0000000 2022-06-28 04:00:00.0000000 2017-04-21 11:11:11.0000000 view top 100 |
WOContract | wocontract | text | Indicates contract if work was completed using a contractor | BP-Q17 BP-Q20 BP-Q18 BP-B22 BP-B18 view top 100 |
ParkName | parkname | text | Name of park if work order is in a park | Pelham Bay Park Riverside Park Flushing Meadows Corona Park Crotona Park Mosholu Parkway view top 100 |
ParkZone | parkzone | text | Name of zone in park if work order is in a park | R046-ZN05 X033-ZN03 B082-ZN04 R065-ZN08 R065-ZN11 view top 100 |
CancelReason | cancelreason | text | Reason for why the work order was cancelled | VOID - Refer to Location Detail or Comments for Reason {MU 05/2022} EAB Treatment Work Order has expired. Trees require inspection for future EAB contracts. BBO Overwriting in FY19 Previously Pruned view top 100 |
WOCategory | wocategory | text | Work order category | Block Pruning Risk Mitigation Tree Planting Post-Failure Tree/Debris Removal Stump Removal view top 100 |
SanitationAssignedDate | sanitationassigneddate | text | 2020-08-13 16:31:19.0000000 2020-08-11 19:25:59.0000000 2020-08-10 16:27:28.0000000 2020-08-06 21:40:03.0000000 2020-08-12 19:32:02.0000000 view top 100 | |
SanitationRemovalDate | sanitationremovaldate | text | 2020-08-13 12:31:08.0000000 2020-08-12 06:52:20.0000000 2020-08-11 06:50:57.0000000 2020-08-13 15:40:19.0000000 2020-08-09 15:06:45.0000000 view top 100 | |
SanitationUpdatedDate | sanitationupdateddate | text | 2020-08-09 15:40:40.0000000 2020-08-13 16:48:33.0000000 2020-08-08 15:43:44.0000000 2020-08-12 06:52:20.0000000 2020-08-11 07:02:52.0000000 view top 100 | |
WOWoodRemains | wowoodremains | text | Indicates if work order has wood remains that need to be picked up | No Wood Debris All Wood Removed Unprocessed Wood < 4 in diam, <4 ft length < 12 in diam, <4 ft length view top 100 |
WOEquipment | woequipment | text | Indicates what equipment is needed to complete work | Bucket & Chipper Bucket, Loader & Chipper Chipper Bucket & Loader Truck - Pickup view top 100 |
Postcode | zipcode | number | Zipcode work order is in | 10312.0 10314.0 10306.0 11385.0 10309.0 view top 100 |
CityCouncil | citycouncil | number | City council district work order is in | 51.0 50.0 19.0 23.0 49.0 view top 100 |
StateSenate | statesenate | number | State senate district work order is in | 24.0 11.0 15.0 34.0 14.0 view top 100 |
StateAssembly | stateassembly | number | State assembly district work order is in | 62.0 26.0 64.0 63.0 33.0 view top 100 |
Congressional | congressional | number | Congressional district work order is in | 11.0 6.0 5.0 8.0 14.0 view top 100 |
SanitationZone | sanitationzone | text | Sanitation zone work order is in | 2031A 5023C 5011C 5012D 5024C view top 100 |
PhysicalID | physicalid | number | PhysicalID of CSCL line segment that the PS address is associated with | 78145 191525 78970 58005 94786 view top 100 |
CrossStreet1 | crossstreet1 | text | Name of first cross street | BEND DEAD END BROADWAY ALLEY 1 AVENUE view top 100 |
CrossStreet2 | crossstreet2 | text | Name of second cross street | BEND DEAD END 3 AVENUE 5 AVENUE 2 AVENUE view top 100 |
PlantingSpaceGlobalID | plantingspaceglobalid | text | Unique identifier for planting space associated with work order | C1FECDF7-2298-4017-98B7-BE4EA17AC1D6 80D01121-944A-45A6-B02C-6232BEEB8DB7 B77DA87B-6DD8-4484-936A-339F66C1AA43 67BAA7B1-C926-49B9-A89C-C75559375940 0309910E-82AB-4934-A8BE-DF09939FD270 view top 100 |
TreePointGlobalID | treepointglobalid | text | Unique identifier for tree point associated with work order | 8EA61BBB-C933-45F4-9519-61320AD5FC21 330045B7-F188-4981-A865-E28239CDE36A BE2AF776-EE10-48E8-807D-FCF8D78044CE C963DB83-18CC-4E24-BF84-86BD04F37838 0151FC6B-AD5D-49B5-92EB-95E01AA2B8A3 view top 100 |
InspectionGlobalID | inspectionglobalid | text | Unique identifier for inspection associated with work order | F9F5AC35-42EA-4D55-8F7C-A96BDE886A5B E1582D5E-A14C-4002-912B-B25BC97C2CE0 DBC0BFC5-E913-45CC-950A-9959B6B10BCF 491C2A5B-9DCD-471D-89B4-D635D6C40160 8A2A4D64-09CE-44DD-AE27-C73634B62512 view top 100 |
GlobalID | globalid | text | Unique identifier for each inspection | 02C28EF5-3AA9-4849-BA39-6F592B712271 E1A10B27-A9F0-4E4D-A260-E6C47B419319 F92190F4-93A8-4F56-A1D3-2F670A6A573A DF345663-9B97-45C6-897D-9D1D8E9DF06E 1BB7A5B8-72FF-487A-93DE-824EAB53374A view top 100 |
SidewalkDamage | sidewalkdamage | number | Indicates if the sidewalk was damaged by the tree | 1.0 0.0 view top 100 |
WOWireConflict | wowireconflict | text | Indicates if the tree is in conflict with a utility wire | No Util Conflict Present Electric Utility Open All Conflicts Resolved Electric Utility Pending Elec Util Clear (other utils req) view top 100 |
CrewGlobalID | crewglobalid | text | Unique identifier of crew that performed the work | 324F88D5-7630-43D8-BFF3-F3D329A003EC A2637397-0208-4AEE-B7C7-8CF269E32A6C A294DC04-BBD0-45E1-B38C-AFB90EA98923 43142BE2-4091-457C-84C7-2CF1A67BFBFE CB20317D-3EB9-4F7B-94E6-10DAE6C3DAC6 view top 100 |
Geometry | geometry | text | POINT (-73.9738759436809943 40.6657652471453162) POINT (-73.7982750634676847 40.7362381756493193) POINT (-73.8406896963284396 40.6981100138146772) POINT (-73.7221111528645139 40.7336452959187056) POINT (-73.8083421182318631 40.7767310995658789) view top 100 | |
ClosedDate | closeddate | text | Date the work order record was closed | 2017-04-13 10:00:00.0000000 2017-08-09 11:11:11.0000000 2022-06-07 04:00:00.0000000 2023-06-16 04:00:00.0000000 2017-07-31 11:11:11.0000000 view top 100 |
CancelDate | canceldate | text | Date work order was cancelled | 2021-07-27 00:00:00.0000000 2018-08-02 10:20:11.0000000 2021-12-02 12:00:00.0000000 2023-02-15 05:00:00.0000000 2018-06-30 12:00:00.0000000 view top 100 |
CreatedDate | createddate | text | Date work order was created | 2016-07-14 17:19:00.0000000 2016-07-14 17:19:24.0000000 2015-04-02 04:00:00.0000000 2015-04-03 04:00:00.0000000 2015-07-23 15:00:00.0000000 view top 100 |
UpdatedDate | updateddate | text | Date work order was last updated | 2017-04-13 10:00:00.0000000 2017-08-09 11:11:11.0000000 2023-06-16 04:00:00.0000000 2017-07-31 11:11:11.0000000 2017-04-20 11:11:11.0000000 view top 100 |
WOEntity | woentity | text | Indicates if the work was completed by in-house crews, capital or expense contractors, or other groups | Expense In-House Capital Horticulture Permitted view top 100 |
PROJSTARTDATE | projstartdate | text | Projected start date of work | 2015-10-15 00:00:00.0000000 2016-03-15 00:00:00.0000000 2022-03-15 00:00:00.0000000 2016-10-15 00:00:00.0000000 2023-03-15 00:00:00.0000000 view top 100 |
WOProject | woproject | text | Indicates if work is associated with specific project | Block Pruning P&D - EAB YSTP SubStatus 1 Commitment view top 100 |
RecommendedSpecies | recommendedspecies | text | Species intended for planting | Platanus x acerifolia - London planetree Fraxinus pennsylvanica - Green ash Quercus palustris - pin oak Gleditsia triacanthos var. inermis - Thornless honeylocust Pyrus calleryana - Callery pear view top 100 |
Latitude | latitude | number | 40.612318 40.582105 40.887111 40.828347 40.749356 view top 100 | |
Longitude | longitude | number | -74.023732 -73.825569 -73.913697 -73.921838 -73.999257 view top 100 | |
Census Tract | census_tract | number | 892.01 1571.01 884 1579.01 1579.02 view top 100 | |
BIN | bin | number | 4000000 1000000 3000000 2000000 1012266 view top 100 | |
BBL | bbl | number | 1009720001 1009780001 4076320002 4071150002 1006700001 view top 100 | |
NTA | nta | text | Auburndale Murray Hill-Broadway Flushing South Ozone Park Glen Oaks-Floral Park-New Hyde Park Queens Village view top 100 | |
Location | location | point | {"coordinates":[-73.973875943681,40.665765247145316],"type":"Point"} {"coordinates":[-73.79827506346768,40.73623817564932],"type":"Point"} {"coordinates":[-73.84068969632844,40.69811001381468],"type":"Point"} {"coordinates":[-73.80834211823186,40.77673109956588],"type":"Point"} {"coordinates":[-73.72211115286451,40.733645295918706],"type":"Point"} view top 100 |