About this Dataset

Forestry Tasks

Tasks are specific actions that are sub-components of a Work Order. Some work, such as that performed by in-house crews, require at least one task for the purposes of accounting for labor hours. Tasks are typically used to indicate remaining work for jobs that did not get completed in one session (1 day).

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:00:37.975225
Tags: task, tree, work-order

Tables

Table 1

@usgov.city_of_new_york_forestry_tasks.table_1

17.67 MB
212389 rows
15 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "tasktype" VARCHAR,
  "completeddate" TIMESTAMP,
  "workorderglobalid" VARCHAR,
  "globalid" VARCHAR,
  "crewglobalid" VARCHAR,
  "taskentity" DOUBLE,
  "staffcpcc" DOUBLE,
  "staffcp" DOUBLE,
  "staffapsw" DOUBLE,
  "labortime" DOUBLE,
  "traveltime" DOUBLE,
  "staffcpw" DOUBLE,
  "staffforester" DOUBLE,
  "staffgardener" DOUBLE
);