cityofnewyork-us/tree-contract-work-details-kcfe-uypz

  • forestry
  • parks
  • trees

Tree Contract Work Details

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

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
transaction_idtransaction_idtransaction_idNumber
transaction_datetransaction_datetransaction_dateCalendar date
contract_numbercontract_numbercontract_numberText
unit_of_measureunit_of_measureunit_of_measureText
line_item_descriptionline_item_descriptionline_item_descriptionText
item_numberitem_numberitem_numberText
line_item_idline_item_idline_item_idNumber
work_order_idwork_order_idwork_order_idNumber
unit_priceunit_priceunit_priceNumber
total_costtotal_costtotal_costNumber
units_usedunits_usedunits_usedNumber

Upstream Metadata