About this Dataset

Tree Contract Work Details

Tree Contract Work Details contains information related to work performed on specific tree work contracts. This dataset can be joined to the Forestry Work Orders dataset (https://data.cityofnewyork.us/Environment/Forestry-Work-Orders/bdjm-n7q4) by joining work_order_id from Tree Contract Work Details to OBJECTID from Forestry Work Orders. There are many work_order_ids per single contract_number. Not all work orders in Forestry Work Orders are represented in this dataset because it is only used to track work on specific contracts.

Data Dictionary found here: https://docs.google.com/spreadsheets/d/1rAQL_d8yQ5axRIGl9vLxpr73rDmQUZ23VKQC8QQWIYI/edit?usp=sharing
Organization: City of New York
Last updated: 2020-11-10T17:03:53.513217
Tags: forestry, parks, trees

Tables

Table 1

@usgov.city_of_new_york_tree_contract_work_details.table_1

4.62 MB
288,149 rows
11 columns

CREATE TABLE table_1 (
  "transaction_id" BIGINT,
  "contract_number" VARCHAR,
  "work_order_id" BIGINT,
  "line_item_id" DOUBLE,
  "item_number" VARCHAR,
  "line_item_description" VARCHAR,
  "unit_of_measure" VARCHAR,
  "unit_price" DOUBLE,
  "units_used" DOUBLE,
  "total_cost" DOUBLE,
  "transaction_date" VARCHAR
);