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
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Fresh
- Says it updates
- Monthly
- Actually updates about every
- 29.86 days
- Publisher last updated the data
- Sep 27, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Sep 27, 2026, 9:17 AM
- Rows in our copy
- 348,533
- Rows at the source
- 348,533
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
The publisher has not provided a data dictionary.
0 of 11 columns carry a concept; 0 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
transaction_date | transaction_date | The publisher describes this column nowhere. | Not bound | Calendar date | transaction_date | timestamp | — | |
line_item_id | line_item_id | The publisher describes this column nowhere. | Not bound | Number | line_item_id | numeric | — | |
line_item_description | line_item_description | The publisher describes this column nowhere. | Not bound | Text | line_item_description | text | — | |
contract_number | contract_number | The publisher describes this column nowhere. | Not bound | Text | contract_number | text | — | |
units_used | units_used | The publisher describes this column nowhere. | Not bound | Number | units_used | numeric | — | |
total_cost | total_cost | The publisher describes this column nowhere. | Not bound | Number | total_cost | numeric | — | |
unit_price | unit_price |
Download
This file was produced on Sep 27, 2026, 10:01 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/kcfe-uypz
- Version
- Content hash:
234c81162e13c962fc65a44231fd770bf4ee448dd4933637f50ce6ccd966fd67 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Sep 27, 2026, 9:17 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Sep 27, 2026, 3:49 PM | full_replace | success | 348,533 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 27, 2026, 3:49 PM | incremental | aborted | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Aug 28, 2026, 3:16 PM | incremental | success | 1 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 24, 2026, 3:15 AM | full_replace | success | 346,359 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.68 |
| Aug 24, 2026, 1:46 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.68 |
| Aug 20, 2026, 8:51 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.64 |
| Aug 20, 2026, 7:36 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.64 |
| Aug 20, 2026, 6:21 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.64 |
| Aug 20, 2026, 5:06 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.64 |
| Aug 20, 2026, 3:51 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.64 |