About this Dataset

Forestry Work Orders

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
Organization: City of New York
Last updated: 2020-11-10T17:01:58.831218

Tables

Table 1

@usgov.city_of_new_york_forestry_work_orders.table_1

272.34 MB
1276236 rows
52 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "wotype" VARCHAR,
  "wostatus" VARCHAR,
  "wopriority" DOUBLE,
  "borough" VARCHAR,
  "communityboard" DOUBLE,
  "buildingnumber" VARCHAR,
  "streetname" VARCHAR,
  "locationdetails" VARCHAR,
  "actualfinishdate" VARCHAR,
  "wocontract" VARCHAR,
  "parkname" VARCHAR,
  "parkzone" VARCHAR,
  "cancelreason" VARCHAR,
  "wocategory" VARCHAR,
  "sanitationassigneddate" TIMESTAMP,
  "sanitationremovaldate" TIMESTAMP,
  "sanitationupdateddate" TIMESTAMP,
  "wowoodremains" VARCHAR,
  "woequipment" VARCHAR,
  "postcode" DOUBLE,
  "citycouncil" DOUBLE,
  "statesenate" DOUBLE,
  "stateassembly" DOUBLE,
  "congressional" DOUBLE,
  "sanitationzone" VARCHAR,
  "physicalid" DOUBLE,
  "crossstreet1" VARCHAR,
  "crossstreet2" VARCHAR,
  "plantingspaceglobalid" VARCHAR,
  "treepointglobalid" VARCHAR,
  "inspectionglobalid" VARCHAR,
  "globalid" VARCHAR,
  "sidewalkdamage" DOUBLE,
  "wowireconflict" VARCHAR,
  "crewglobalid" VARCHAR,
  "geometry" VARCHAR,
  "closeddate" TIMESTAMP,
  "canceldate" TIMESTAMP,
  "createddate" TIMESTAMP,
  "updateddate" TIMESTAMP,
  "woentity" VARCHAR,
  "projstartdate" TIMESTAMP,
  "woproject" VARCHAR,
  "recommendedspecies" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "location" VARCHAR
);