Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Tree Contract Work Details

kcfe-uypzEnvironment11 columns
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
View on NYC Open Data↗

Quality

B89.6 / 100

From a 500-row sample across 11 columns.

completeness99/ 25% weight
consistency64/ 20% weight
accuracy90/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Forestry Tree Points0.45
  • Watershed Water Quality Data0.33
  • Parks Trails0.33
  • Drinking Water Quality Distribution Monitoring Data0.32
  • Water and Sewer Permits0.32
  • Forestry Work Orders0.30
  • Air Quality and Health Impacts0.30
  • NYC Parks Sectors0.29

Sample rows

transaction_idcontract_numberwork_order_idline_item_iditem_numberline_item_descriptionunit_of_measureunit_priceunits_usedtotal_costtransaction_date
873024XG-116M8002280647.009PREPARING NEW SIDEWALK TREE BEDSSF24.021.0504.01903-06-03T00:00:00.000
873025XG-116M

Columns

11 queryable · 11 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
transaction_idinteger—0%10907871186650896642
contract_numbertext—0%MG-1319MAQG-1219MXG-619M
work_order_idinteger—0%295572892616713026221462
line_item_idinteger—0%650.0647.0619.0
item_numbertext—

Query this from your own app

GET /api/datasets/kcfe-uypz
GET /api/datasets/kcfe-uypz/quality
GET /api/datasets/kcfe-uypz/related
GET /api/columns?dataset=kcfe-uypz
8002280
310.0
12
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
EA
775.0
560.0
434000.0
1902-02-13T00:00:00.000
878221XG-116MR8236161646.0—PREAPRING EXISTING SIDEWALK TREE BEDS (R)SF———1903-06-03T00:00:00.000
878223XG-116MR8236241646.0—PREAPRING EXISTING SIDEWALK TREE BEDS (R)SF———1903-06-03T00:00:00.000
878226XG-116MR8240003646.0—PREAPRING EXISTING SIDEWALK TREE BEDS (R)SF———1903-06-03T00:00:00.000
878228XG-116MR8239997646.0—PREAPRING EXISTING SIDEWALK TREE BEDS (R)SF———1903-06-03T00:00:00.000
878230XG-116MR8243911646.0—PREAPRING EXISTING SIDEWALK TREE BEDS (R)SF———1903-06-03T00:00:00.000
878232XG-116MR8243910646.0—PREAPRING EXISTING SIDEWALK TREE BEDS (R)SF———1903-06-03T00:00:00.000
880604BG-418M8564755647.009PREPARING NEW SIDEWALK TREE BEDSSF40.046.71868.02018-10-01T00:00:00.000
880608BG-418M8564757647.009PREPARING NEW SIDEWALK TREE BEDSSF40.039.21568.02018-10-01T00:00:00.000
0%
121109
line_item_descriptiontext—0%PLANTING PROCURED STREET…PREPARING NEW SIDEWALK T…PREPARING EXISTING SIDEW…
unit_of_measurecategorical—0%SFEALFof 7
unit_priceinteger—0%20.030.0900.0
units_usedfloat—0%1.036.050.0
total_costinteger—0%900.01000.01200.0
transaction_datedatetime—0%2026-05-27T00:00:00.0002021-12-13T00:00:00.0002026-05-26T00:00:00.000