Ask NYC Browse All Data Public Safety Transportation Health Buildings

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

Environment Department of Parks and Recreation (DPR) Dataset kcfe-uypz 11 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
745919
Transaction Id: 745919 • Contract Number: QG-215M • Work Order Id: 647600
Transaction Id
745919
Contract Number
QG-215M
Work Order Id
647600
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
20.9
Total Cost
355.29999999999995
Transaction Date
2015-09-14T00:00:00.000
745920
Transaction Id: 745920 • Contract Number: QG-215M • Work Order Id: 647600
Transaction Id
745920
Contract Number
QG-215M
Work Order Id
647600
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
20.8
Total Cost
249.60000000000002
Transaction Date
2015-09-14T00:00:00.000
745921
Transaction Id: 745921 • Contract Number: QG-215M • Work Order Id: 649536
Transaction Id
745921
Contract Number
QG-215M
Work Order Id
649536
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
745922
Transaction Id: 745922 • Contract Number: QG-215M • Work Order Id: 649536
Transaction Id
745922
Contract Number
QG-215M
Work Order Id
649536
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
20.9
Total Cost
355.29999999999995
Transaction Date
2015-09-14T00:00:00.000
745923
Transaction Id: 745923 • Contract Number: QG-215M • Work Order Id: 649536
Transaction Id
745923
Contract Number
QG-215M
Work Order Id
649536
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
20.8
Total Cost
249.60000000000002
Transaction Date
2015-09-14T00:00:00.000
745924
Transaction Id: 745924 • Contract Number: QG-215M • Work Order Id: 647601
Transaction Id
745924
Contract Number
QG-215M
Work Order Id
647601
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
745925
Transaction Id: 745925 • Contract Number: QG-215M • Work Order Id: 647601
Transaction Id
745925
Contract Number
QG-215M
Work Order Id
647601
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
20.9
Total Cost
355.29999999999995
Transaction Date
2015-09-14T00:00:00.000
745926
Transaction Id: 745926 • Contract Number: QG-215M • Work Order Id: 647601
Transaction Id
745926
Contract Number
QG-215M
Work Order Id
647601
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
20.8
Total Cost
249.60000000000002
Transaction Date
2015-09-14T00:00:00.000
745927
Transaction Id: 745927 • Contract Number: QG-215M • Work Order Id: 649543
Transaction Id
745927
Contract Number
QG-215M
Work Order Id
649543
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
745928
Transaction Id: 745928 • Contract Number: QG-215M • Work Order Id: 649543
Transaction Id
745928
Contract Number
QG-215M
Work Order Id
649543
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
20.9
Total Cost
355.29999999999995
Transaction Date
2015-09-14T00:00:00.000
745929
Transaction Id: 745929 • Contract Number: QG-215M • Work Order Id: 649543
Transaction Id
745929
Contract Number
QG-215M
Work Order Id
649543
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
20.8
Total Cost
249.60000000000002
Transaction Date
2015-09-14T00:00:00.000
745933
Transaction Id: 745933 • Contract Number: QG-215M • Work Order Id: 653996
Transaction Id
745933
Contract Number
QG-215M
Work Order Id
653996
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-01T00:00:00.000
745934
Transaction Id: 745934 • Contract Number: QG-215M • Work Order Id: 653996
Transaction Id
745934
Contract Number
QG-215M
Work Order Id
653996
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
21.7
Total Cost
368.9
Transaction Date
2015-09-18T00:00:00.000
745935
Transaction Id: 745935 • Contract Number: QG-215M • Work Order Id: 653996
Transaction Id
745935
Contract Number
QG-215M
Work Order Id
653996
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
33.9
Total Cost
406.79999999999995
Transaction Date
2015-09-18T00:00:00.000
745937
Transaction Id: 745937 • Contract Number: QG-215M • Work Order Id: 653998
Transaction Id
745937
Contract Number
QG-215M
Work Order Id
653998
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-01T00:00:00.000
745938
Transaction Id: 745938 • Contract Number: QG-215M • Work Order Id: 653998
Transaction Id
745938
Contract Number
QG-215M
Work Order Id
653998
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
15.3
Units Used
23.0
Total Cost
351.90000000000003
Transaction Date
2015-09-18T00:00:00.000
745939
Transaction Id: 745939 • Contract Number: QG-215M • Work Order Id: 653998
Transaction Id
745939
Contract Number
QG-215M
Work Order Id
653998
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
10.8
Units Used
25.3
Total Cost
273.24
Transaction Date
2015-09-18T00:00:00.000
745940
Transaction Id: 745940 • Contract Number: QG-215M • Work Order Id: 653998
Transaction Id
745940
Contract Number
QG-215M
Work Order Id
653998
Line Item Id
286.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
95.0
Units Used
1.0
Total Cost
95.0
Transaction Date
2015-09-09T00:00:00.000
745941
Transaction Id: 745941 • Contract Number: QG-215M • Work Order Id: 653302
Transaction Id
745941
Contract Number
QG-215M
Work Order Id
653302
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-01T00:00:00.000
745942
Transaction Id: 745942 • Contract Number: QG-215M • Work Order Id: 653302
Transaction Id
745942
Contract Number
QG-215M
Work Order Id
653302
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
15.3
Units Used
24.5
Total Cost
374.85
Transaction Date
2015-09-18T00:00:00.000
745943
Transaction Id: 745943 • Contract Number: QG-215M • Work Order Id: 653302
Transaction Id
745943
Contract Number
QG-215M
Work Order Id
653302
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
10.8
Units Used
26.3
Total Cost
284.04
Transaction Date
2015-09-18T00:00:00.000
745944
Transaction Id: 745944 • Contract Number: QG-215M • Work Order Id: 653302
Transaction Id
745944
Contract Number
QG-215M
Work Order Id
653302
Line Item Id
335.0
Item Number
05
Line Item Description
STUMP REMOVALS OF OVER 30 TO 36 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2015-09-09T00:00:00.000
745945
Transaction Id: 745945 • Contract Number: QG-215M • Work Order Id: 655203
Transaction Id
745945
Contract Number
QG-215M
Work Order Id
655203
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-07T00:00:00.000
745946
Transaction Id: 745946 • Contract Number: QG-215M • Work Order Id: 655203
Transaction Id
745946
Contract Number
QG-215M
Work Order Id
655203
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
15.3
Units Used
13.9
Total Cost
212.67000000000002
Transaction Date
2015-09-18T00:00:00.000
745947
Transaction Id: 745947 • Contract Number: QG-215M • Work Order Id: 655203
Transaction Id
745947
Contract Number
QG-215M
Work Order Id
655203
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
10.8
Units Used
26.7
Total Cost
288.36
Transaction Date
2015-09-18T00:00:00.000
745948
Transaction Id: 745948 • Contract Number: QG-215M • Work Order Id: 655203
Transaction Id
745948
Contract Number
QG-215M
Work Order Id
655203
Line Item Id
304.0
Item Number
04
Line Item Description
STUMP REMOVALS OF OVER 24 TO 30 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
175.0
Units Used
1.0
Total Cost
175.0
Transaction Date
2015-09-09T00:00:00.000
745950
Transaction Id: 745950 • Contract Number: QG-215M • Work Order Id: 651592
Transaction Id
745950
Contract Number
QG-215M
Work Order Id
651592
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
745951
Transaction Id: 745951 • Contract Number: QG-215M • Work Order Id: 651592
Transaction Id
745951
Contract Number
QG-215M
Work Order Id
651592
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
25.0
Total Cost
300.0
Transaction Date
2015-09-11T00:00:00.000
745952
Transaction Id: 745952 • Contract Number: QG-215M • Work Order Id: 651592
Transaction Id
745952
Contract Number
QG-215M
Work Order Id
651592
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
25.0
Total Cost
425.0
Transaction Date
2015-09-11T00:00:00.000
745953
Transaction Id: 745953 • Contract Number: QG-215M • Work Order Id: 651197
Transaction Id
745953
Contract Number
QG-215M
Work Order Id
651197
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
745955
Transaction Id: 745955 • Contract Number: QG-215M • Work Order Id: 651197
Transaction Id
745955
Contract Number
QG-215M
Work Order Id
651197
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
50.0
Total Cost
850.0
Transaction Date
2015-09-11T00:00:00.000
745956
Transaction Id: 745956 • Contract Number: QG-215M • Work Order Id: 651202
Transaction Id
745956
Contract Number
QG-215M
Work Order Id
651202
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-12-28T00:00:00.000
745957
Transaction Id: 745957 • Contract Number: QG-215M • Work Order Id: 651202
Transaction Id
745957
Contract Number
QG-215M
Work Order Id
651202
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
50.0
Total Cost
850.0
Transaction Date
2015-12-28T00:00:00.000
745958
Transaction Id: 745958 • Contract Number: QG-215M • Work Order Id: 649749
Transaction Id
745958
Contract Number
QG-215M
Work Order Id
649749
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
745959
Transaction Id: 745959 • Contract Number: QG-215M • Work Order Id: 649749
Transaction Id
745959
Contract Number
QG-215M
Work Order Id
649749
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
25.0
Total Cost
300.0
Transaction Date
2015-09-11T00:00:00.000
745960
Transaction Id: 745960 • Contract Number: QG-215M • Work Order Id: 649749
Transaction Id
745960
Contract Number
QG-215M
Work Order Id
649749
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
25.0
Total Cost
425.0
Transaction Date
2015-09-11T00:00:00.000
745961
Transaction Id: 745961 • Contract Number: QG-215M • Work Order Id: 649523
Transaction Id
745961
Contract Number
QG-215M
Work Order Id
649523
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-17T00:00:00.000
745962
Transaction Id: 745962 • Contract Number: QG-215M • Work Order Id: 649523
Transaction Id
745962
Contract Number
QG-215M
Work Order Id
649523
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
25.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
745963
Transaction Id: 745963 • Contract Number: QG-215M • Work Order Id: 649523
Transaction Id
745963
Contract Number
QG-215M
Work Order Id
649523
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
745964
Transaction Id: 745964 • Contract Number: QG-215M • Work Order Id: 648376
Transaction Id
745964
Contract Number
QG-215M
Work Order Id
648376
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-17T00:00:00.000
745965
Transaction Id: 745965 • Contract Number: QG-215M • Work Order Id: 648376
Transaction Id
745965
Contract Number
QG-215M
Work Order Id
648376
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
25.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
745966
Transaction Id: 745966 • Contract Number: QG-215M • Work Order Id: 648376
Transaction Id
745966
Contract Number
QG-215M
Work Order Id
648376
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
745967
Transaction Id: 745967 • Contract Number: QG-215M • Work Order Id: 648377
Transaction Id
745967
Contract Number
QG-215M
Work Order Id
648377
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-17T00:00:00.000
745968
Transaction Id: 745968 • Contract Number: QG-215M • Work Order Id: 648377
Transaction Id
745968
Contract Number
QG-215M
Work Order Id
648377
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
25.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
745969
Transaction Id: 745969 • Contract Number: QG-215M • Work Order Id: 648377
Transaction Id
745969
Contract Number
QG-215M
Work Order Id
648377
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
745970
Transaction Id: 745970 • Contract Number: QG-215M • Work Order Id: 649525
Transaction Id
745970
Contract Number
QG-215M
Work Order Id
649525
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-17T00:00:00.000
745971
Transaction Id: 745971 • Contract Number: QG-215M • Work Order Id: 649525
Transaction Id
745971
Contract Number
QG-215M
Work Order Id
649525
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
25.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
745972
Transaction Id: 745972 • Contract Number: QG-215M • Work Order Id: 649525
Transaction Id
745972
Contract Number
QG-215M
Work Order Id
649525
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
745973
Transaction Id: 745973 • Contract Number: QG-215M • Work Order Id: 647587
Transaction Id
745973
Contract Number
QG-215M
Work Order Id
647587
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-17T00:00:00.000
745974
Transaction Id: 745974 • Contract Number: QG-215M • Work Order Id: 647587
Transaction Id
745974
Contract Number
QG-215M
Work Order Id
647587
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
25.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
NYC Data AI • Public-data exploration interface