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
1175487
Transaction Id: 1175487 • Contract Number: XG-424M • Work Order Id: 29036336
Transaction Id
1175487
Contract Number
XG-424M
Work Order Id
29036336
Line Item Id
292.0
Item Number
38
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
50.0
Units Used
5.0
Total Cost
250.0
Transaction Date
2026-04-29T00:00:00.000
1177840
Transaction Id: 1177840 • Contract Number: QG-724M • Work Order Id: 28637788
Transaction Id
1177840
Contract Number
QG-724M
Work Order Id
28637788
Line Item Id
626.0
Item Number
46
Line Item Description
TOPSOIL FOR TREE BED AREAS
Unit Of Measure
CF
Unit Price
10.0
Units Used
17.0
Total Cost
170.0
Transaction Date
2026-04-20T00:00:00.000
1177893
Transaction Id: 1177893 • Contract Number: QG-724M • Work Order Id: 27409335
Transaction Id
1177893
Contract Number
QG-724M
Work Order Id
27409335
Line Item Id
620.0
Item Number
14
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
36.0
Total Cost
900.0
Transaction Date
2026-04-20T00:00:00.000
1178464
Transaction Id: 1178464 • Contract Number: XG-124M • Work Order Id: 28831261
Transaction Id
1178464
Contract Number
XG-124M
Work Order Id
28831261
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
41.7
Total Cost
1084.2
Transaction Date
2026-04-30T00:00:00.000
1180368
Transaction Id: 1180368 • Contract Number: QG-124M • Work Order Id: 23987073
Transaction Id
1180368
Contract Number
QG-124M
Work Order Id
23987073
Line Item Id
723.0
Item Number
07
Line Item Description
TREE REMOVALS OF OVER 4 UP TO AND INCLUDING 8 INCHES DBH
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2026-05-05T00:00:00.000
1180691
Transaction Id: 1180691 • Contract Number: QG-724M • Work Order Id: 27509688
Transaction Id
1180691
Contract Number
QG-724M
Work Order Id
27509688
Line Item Id
292.0
Item Number
47
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
12.0
Units Used
5.0
Total Cost
60.0
Transaction Date
2026-04-28T00:00:00.000
1180966
Transaction Id: 1180966 • Contract Number: QG-124M • Work Order Id: 29225736
Transaction Id
1180966
Contract Number
QG-124M
Work Order Id
29225736
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
30.0
Units Used
39.0
Total Cost
1170.0
Transaction Date
2026-05-08T00:00:00.000
1181016
Transaction Id: 1181016 • Contract Number: XG-124M • Work Order Id: 27892416
Transaction Id
1181016
Contract Number
XG-124M
Work Order Id
27892416
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
102.0
Units Used
0.46
Total Cost
46.92
Transaction Date
2026-05-11T00:00:00.000
1183162
Transaction Id: 1183162 • Contract Number: QG-424M • Work Order Id: 28822410
Transaction Id
1183162
Contract Number
QG-424M
Work Order Id
28822410
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
32.0
Units Used
26.7
Total Cost
854.4
Transaction Date
2026-05-19T00:00:00.000
1183578
Transaction Id: 1183578 • Contract Number: QG-424M • Work Order Id: 28930496
Transaction Id
1183578
Contract Number
QG-424M
Work Order Id
28930496
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
36.2
Total Cost
941.2
Transaction Date
2026-05-29T00:00:00.000
1183901
Transaction Id: 1183901 • Contract Number: QG-424M • Work Order Id: 29017553
Transaction Id
1183901
Contract Number
QG-424M
Work Order Id
29017553
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
21.5
Total Cost
559.0
Transaction Date
2026-06-02T00:00:00.000
1186491
Transaction Id: 1186491 • Contract Number: BG-224M • Work Order Id: 28747520
Transaction Id
1186491
Contract Number
BG-224M
Work Order Id
28747520
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
54.2
Total Cost
1355.0
Transaction Date
2026-05-21T00:00:00.000
1188298
Transaction Id: 1188298 • Contract Number: XG-124M • Work Order Id: 28277861
Transaction Id
1188298
Contract Number
XG-124M
Work Order Id
28277861
Line Item Id
729.0
Item Number
18
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
850.0
Units Used
1.0
Total Cost
850.0
Transaction Date
2026-05-27T00:00:00.000
1188687
Transaction Id: 1188687 • Contract Number: BG-724M • Work Order Id: 27547100
Transaction Id
1188687
Contract Number
BG-724M
Work Order Id
27547100
Line Item Id
631.0
Item Number
52
Line Item Description
STEEL TREE BED GUARD - E
Unit Of Measure
LF
Unit Price
100.0
Units Used
17.8
Total Cost
1780.0
Transaction Date
2026-05-18T00:00:00.000
1188694
Transaction Id: 1188694 • Contract Number: BG-724M • Work Order Id: 27596199
Transaction Id
1188694
Contract Number
BG-724M
Work Order Id
27596199
Line Item Id
629.0
Item Number
50
Line Item Description
STEEL TREE BED GUARD - C
Unit Of Measure
LF
Unit Price
100.0
Units Used
17.2
Total Cost
1720.0
Transaction Date
2026-05-19T00:00:00.000
1192029
Transaction Id: 1192029 • Contract Number: BG-624M • Work Order Id: 28831817
Transaction Id
1192029
Contract Number
BG-624M
Work Order Id
28831817
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
102.0
Units Used
0.62
Total Cost
63.24
Transaction Date
2026-06-11T00:00:00.000
1192153
Transaction Id: 1192153 • Contract Number: BG-624M • Work Order Id: 28931409
Transaction Id
1192153
Contract Number
BG-624M
Work Order Id
28931409
Line Item Id
293.0
Item Number
39
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
11.0
Units Used
21.5
Total Cost
236.5
Transaction Date
2026-06-03T00:00:00.000
1192860
Transaction Id: 1192860 • Contract Number: MG-224M • Work Order Id: 28991757
Transaction Id
1192860
Contract Number
MG-224M
Work Order Id
28991757
Line Item Id
810.0
Item Number
43B
Line Item Description
RESTORE SIDEWALK - OUTSTANDING
Unit Of Measure
SF
Unit Price
0.0
Units Used
24.2
Total Cost
0.0
Transaction Date
2026-07-13T00:00:00.000
1192923
Transaction Id: 1192923 • Contract Number: QG-124M • Work Order Id: 26492647
Transaction Id
1192923
Contract Number
QG-124M
Work Order Id
26492647
Line Item Id
756.0
Item Number
27
Line Item Description
PLANTING GROW BAG/PACKAGED TREES 35-45 GAL (CITY-PROCURED)
Unit Of Measure
EA
Unit Price
700.0
Units Used
1.0
Total Cost
700.0
Transaction Date
2026-06-16T00:00:00.000
1193158
Transaction Id: 1193158 • Contract Number: MG-224M • Work Order Id: 29839843
Transaction Id
1193158
Contract Number
MG-224M
Work Order Id
29839843
Line Item Id
812.0
Item Number
45B
Line Item Description
RESTORE CURB - OUTSTANDING
Unit Of Measure
SF
Unit Price
0.0
Units Used
60.0
Total Cost
0.0
Transaction Date
2026-07-13T00:00:00.000
1188918
Transaction Id: 1188918 • Contract Number: QG-424M • Work Order Id: 29089677
Transaction Id
1188918
Contract Number
QG-424M
Work Order Id
29089677
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
-22.1
Total Cost
-574.6
Transaction Date
2026-04-09T00:00:00.000
1188919
Transaction Id: 1188919 • Contract Number: QG-424M • Work Order Id: 29089677
Transaction Id
1188919
Contract Number
QG-424M
Work Order Id
29089677
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
22.1
Total Cost
574.6
Transaction Date
2026-04-09T00:00:00.000
1189171
Transaction Id: 1189171 • Contract Number: BG-224M • Work Order Id: 29012588
Transaction Id
1189171
Contract Number
BG-224M
Work Order Id
29012588
Line Item Id
650.0
Item Number
19
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
950.0
Units Used
1.0
Total Cost
950.0
Transaction Date
2026-05-29T00:00:00.000
1189206
Transaction Id: 1189206 • Contract Number: BG-224M • Work Order Id: 28747534
Transaction Id
1189206
Contract Number
BG-224M
Work Order Id
28747534
Line Item Id
729.0
Item Number
18
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
900.0
Units Used
1.0
Total Cost
900.0
Transaction Date
2026-05-26T00:00:00.000
1189208
Transaction Id: 1189208 • Contract Number: BG-224M • Work Order Id: 28747564
Transaction Id
1189208
Contract Number
BG-224M
Work Order Id
28747564
Line Item Id
650.0
Item Number
19
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
950.0
Units Used
1.0
Total Cost
950.0
Transaction Date
2026-05-26T00:00:00.000
1189212
Transaction Id: 1189212 • Contract Number: BG-224M • Work Order Id: 28747552
Transaction Id
1189212
Contract Number
BG-224M
Work Order Id
28747552
Line Item Id
650.0
Item Number
19
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
950.0
Units Used
1.0
Total Cost
950.0
Transaction Date
2026-05-26T00:00:00.000
1189881
Transaction Id: 1189881 • Contract Number: XG-324M • Work Order Id: 29738677
Transaction Id
1189881
Contract Number
XG-324M
Work Order Id
29738677
Line Item Id
292.0
Item Number
38
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
50.0
Units Used
2.2
Total Cost
110.00000000000001
Transaction Date
2026-06-05T00:00:00.000
1190073
Transaction Id: 1190073 • Contract Number: BG-724M • Work Order Id: 27596214
Transaction Id
1190073
Contract Number
BG-724M
Work Order Id
27596214
Line Item Id
628.0
Item Number
49
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
100.0
Units Used
14.8
Total Cost
1480.0
Transaction Date
2026-06-08T00:00:00.000
1190398
Transaction Id: 1190398 • Contract Number: QG-124M • Work Order Id: 29212375
Transaction Id
1190398
Contract Number
QG-124M
Work Order Id
29212375
Line Item Id
650.0
Item Number
19
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
800.0
Units Used
1.0
Total Cost
800.0
Transaction Date
2026-06-08T00:00:00.000
744356
Transaction Id: 744356 • Contract Number: QG-215M • Work Order Id: 667306
Transaction Id
744356
Contract Number
QG-215M
Work Order Id
667306
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-11T00:00:00.000
744167
Transaction Id: 744167 • Contract Number: BG-115M • Work Order Id: 711319
Transaction Id
744167
Contract Number
BG-115M
Work Order Id
711319
Line Item Id
342.0
Item Number
30
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
20.0
Units Used
40.0
Total Cost
800.0
Transaction Date
2015-11-02T00:00:00.000
744169
Transaction Id: 744169 • Contract Number: BG-115M • Work Order Id: 647789
Transaction Id
744169
Contract Number
BG-115M
Work Order Id
647789
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
425.0
Units Used
1.0
Total Cost
425.0
Transaction Date
2015-12-18T00:00:00.000
744170
Transaction Id: 744170 • Contract Number: BG-115M • Work Order Id: 647789
Transaction Id
744170
Contract Number
BG-115M
Work Order Id
647789
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
18.0
Units Used
46.4
Total Cost
835.1999999999999
Transaction Date
2015-09-17T00:00:00.000
744172
Transaction Id: 744172 • Contract Number: BG-115M • Work Order Id: 1189474
Transaction Id
744172
Contract Number
BG-115M
Work Order Id
1189474
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
425.0
Units Used
1.0
Total Cost
425.0
Transaction Date
2015-12-23T00:00:00.000
744173
Transaction Id: 744173 • Contract Number: BG-115M • Work Order Id: 1189474
Transaction Id
744173
Contract Number
BG-115M
Work Order Id
1189474
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
18.0
Units Used
32.6
Total Cost
586.8000000000001
Transaction Date
2015-09-18T00:00:00.000
744174
Transaction Id: 744174 • Contract Number: BG-115M • Work Order Id: 1189474
Transaction Id
744174
Contract Number
BG-115M
Work Order Id
1189474
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
18.0
Units Used
10.5
Total Cost
189.0
Transaction Date
2015-09-18T00:00:00.000
744175
Transaction Id: 744175 • Contract Number: BG-115M • Work Order Id: 649809
Transaction Id
744175
Contract Number
BG-115M
Work Order Id
649809
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
200.0
Units Used
1.0
Total Cost
200.0
Transaction Date
2015-09-21T00:00:00.000
744176
Transaction Id: 744176 • Contract Number: BG-115M • Work Order Id: 649809
Transaction Id
744176
Contract Number
BG-115M
Work Order Id
649809
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
425.0
Units Used
1.0
Total Cost
425.0
Transaction Date
2015-12-22T00:00:00.000
744177
Transaction Id: 744177 • Contract Number: BG-115M • Work Order Id: 649809
Transaction Id
744177
Contract Number
BG-115M
Work Order Id
649809
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
18.0
Units Used
34.7
Total Cost
624.6
Transaction Date
2015-09-21T00:00:00.000
744178
Transaction Id: 744178 • Contract Number: BG-115M • Work Order Id: 658804
Transaction Id
744178
Contract Number
BG-115M
Work Order Id
658804
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
125.0
Units Used
1.0
Total Cost
125.0
Transaction Date
2015-09-22T00:00:00.000
744179
Transaction Id: 744179 • Contract Number: BG-115M • Work Order Id: 658804
Transaction Id
744179
Contract Number
BG-115M
Work Order Id
658804
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
425.0
Units Used
1.0
Total Cost
425.0
Transaction Date
2015-12-05T00:00:00.000
744180
Transaction Id: 744180 • Contract Number: BG-115M • Work Order Id: 658804
Transaction Id
744180
Contract Number
BG-115M
Work Order Id
658804
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
18.0
Units Used
35.6
Total Cost
640.8000000000001
Transaction Date
2015-09-22T00:00:00.000
744181
Transaction Id: 744181 • Contract Number: BG-115M • Work Order Id: 658804
Transaction Id
744181
Contract Number
BG-115M
Work Order Id
658804
Line Item Id
289.0
Item Number
22
Line Item Description
REMOVE DEBRIS (TREE PIT AND CANOPY)
Unit Of Measure
HR
Unit Price
75.0
Units Used
0.25
Total Cost
18.75
Transaction Date
2015-09-22T00:00:00.000
744182
Transaction Id: 744182 • Contract Number: BG-115M • Work Order Id: 658804
Transaction Id
744182
Contract Number
BG-115M
Work Order Id
658804
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.0
Total Cost
1120.0
Transaction Date
2016-03-01T00:00:00.000
744184
Transaction Id: 744184 • Contract Number: BG-115M • Work Order Id: 659205
Transaction Id
744184
Contract Number
BG-115M
Work Order Id
659205
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
425.0
Units Used
1.0
Total Cost
425.0
Transaction Date
2015-12-05T00:00:00.000
744185
Transaction Id: 744185 • Contract Number: BG-115M • Work Order Id: 659205
Transaction Id
744185
Contract Number
BG-115M
Work Order Id
659205
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
18.0
Units Used
25.8
Total Cost
464.40000000000003
Transaction Date
2015-09-22T00:00:00.000
744186
Transaction Id: 744186 • Contract Number: BG-115M • Work Order Id: 659205
Transaction Id
744186
Contract Number
BG-115M
Work Order Id
659205
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
18.0
Units Used
25.0
Total Cost
450.0
Transaction Date
2015-09-22T00:00:00.000
744187
Transaction Id: 744187 • Contract Number: MG-115M • Work Order Id: 732934
Transaction Id
744187
Contract Number
MG-115M
Work Order Id
732934
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
25.0
Total Cost
450.0
Transaction Date
2015-09-03T00:00:00.000
744188
Transaction Id: 744188 • Contract Number: MG-115M • Work Order Id: 730932
Transaction Id
744188
Contract Number
MG-115M
Work Order Id
730932
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
25.0
Total Cost
450.0
Transaction Date
2015-09-03T00:00:00.000
744189
Transaction Id: 744189 • Contract Number: MG-115M • Work Order Id: 659339
Transaction Id
744189
Contract Number
MG-115M
Work Order Id
659339
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
32.0
Total Cost
576.0
Transaction Date
2015-09-03T00:00:00.000