Forestry Work Orders

data.cityofnewyork.us | Last Updated 20 May 2024

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 NameAPI Column NameData TypeDescriptionSample Values
OBJECTIDobjectidnumberUnique identifier for each tree point
WOTypewotypetextIndicates the type of work order
WOStatuswostatustextIndicates the work order status
WOPrioritywoprioritytextIndicates work order priority
BoroughboroughcodetextBorough the work order is in
CommunityBoardcommunityboardnumberCommunity Board the work order is in
BuildingNumberbuildingnumbertextBuilding number of the Planting Space address
StreetNamestreetnametextStreet name of the work order
LocationDetailslocationdetailstextInternal agency codes to give additional details about location
ActualFinishDateactualfinishdatetextDate of work order completion
WOContractwocontracttextIndicates contract if work was completed using a contractor
ParkNameparknametextName of park if work order is in a park
ParkZoneparkzonetextName of zone in park if work order is in a park
CancelReasoncancelreasontextReason for why the work order was cancelled
WOCategorywocategorytextWork order category
SanitationAssignedDatesanitationassigneddatetext
SanitationRemovalDatesanitationremovaldatetext
SanitationUpdatedDatesanitationupdateddatetext
WOWoodRemainswowoodremainstextIndicates if work order has wood remains that need to be picked up
WOEquipmentwoequipmenttextIndicates what equipment is needed to complete work
PostcodezipcodenumberZipcode work order is in
CityCouncilcitycouncilnumberCity council district work order is in
StateSenatestatesenatenumberState senate district work order is in
StateAssemblystateassemblynumberState assembly district work order is in
CongressionalcongressionalnumberCongressional district work order is in
SanitationZonesanitationzonetextSanitation zone work order is in
PhysicalIDphysicalidnumberPhysicalID of CSCL line segment that the PS address is associated with
CrossStreet1crossstreet1textName of first cross street
CrossStreet2crossstreet2textName of second cross street
PlantingSpaceGlobalIDplantingspaceglobalidtextUnique identifier for planting space associated with work order
TreePointGlobalIDtreepointglobalidtextUnique identifier for tree point associated with work order
InspectionGlobalIDinspectionglobalidtextUnique identifier for inspection associated with work order
GlobalIDglobalidtextUnique identifier for each inspection
SidewalkDamagesidewalkdamagenumberIndicates if the sidewalk was damaged by the tree
WOWireConflictwowireconflicttextIndicates if the tree is in conflict with a utility wire
CrewGlobalIDcrewglobalidtextUnique identifier of crew that performed the work
Geometrygeometrytext
ClosedDatecloseddatetextDate the work order record was closed
CancelDatecanceldatetextDate work order was cancelled
CreatedDatecreateddatetextDate work order was created
UpdatedDateupdateddatetextDate work order was last updated
WOEntitywoentitytextIndicates if the work was completed by in-house crews, capital or expense contractors, or other groups
PROJSTARTDATEprojstartdatetextProjected start date of work
WOProjectwoprojecttextIndicates if work is associated with specific project
RecommendedSpeciesrecommendedspeciestextSpecies intended for planting
Latitudelatitudenumber
Longitudelongitudenumber
Census Tractcensus_tractnumber
BINbinnumber
BBLbblnumber
NTAntatext
Locationlocationpoint