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
1128692
Transaction Id: 1128692 • Contract Number: QG-424M • Work Order Id: 26040160
Transaction Id
1128692
Contract Number
QG-424M
Work Order Id
26040160
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
35.0
Total Cost
1120.0
Transaction Date
2025-05-07T00:00:00.000
1128800
Transaction Id: 1128800 • Contract Number: BG-123M • Work Order Id: 25614517
Transaction Id
1128800
Contract Number
BG-123M
Work Order Id
25614517
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
24.0
Units Used
50.0
Total Cost
1200.0
Transaction Date
2025-05-20T00:00:00.000
1129162
Transaction Id: 1129162 • Contract Number: BG-423M • Work Order Id: 22953749
Transaction Id
1129162
Contract Number
BG-423M
Work Order Id
22953749
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
22.0
Units Used
30.7
Total Cost
675.4
Transaction Date
2025-05-20T00:00:00.000
1130353
Transaction Id: 1130353 • Contract Number: QG-424M • Work Order Id: 26483942
Transaction Id
1130353
Contract Number
QG-424M
Work Order Id
26483942
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.0
Total Cost
936.0
Transaction Date
2025-05-30T00:00:00.000
1131646
Transaction Id: 1131646 • Contract Number: BG-123M • Work Order Id: 24509005
Transaction Id
1131646
Contract Number
BG-123M
Work Order Id
24509005
Line Item Id
293.0
Item Number
39
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
6.0
Units Used
12.0
Total Cost
72.0
Transaction Date
2025-06-06T00:00:00.000
1134624
Transaction Id: 1134624 • Contract Number: QG-323M • Work Order Id: 26875570
Transaction Id
1134624
Contract Number
QG-323M
Work Order Id
26875570
Line Item Id
292.0
Item Number
38
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
14.0
Units Used
0.74
Total Cost
10.36
Transaction Date
2025-07-18T00:00:00.000
1134675
Transaction Id: 1134675 • Contract Number: QG-323M • Work Order Id: 26892307
Transaction Id
1134675
Contract Number
QG-323M
Work Order Id
26892307
Line Item Id
628.0
Item Number
49
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
115.0
Units Used
16.8
Total Cost
1932.0
Transaction Date
2025-10-01T00:00:00.000
1137090
Transaction Id: 1137090 • Contract Number: BG-924M • Work Order Id: 27115695
Transaction Id
1137090
Contract Number
BG-924M
Work Order Id
27115695
Line Item Id
627.0
Item Number
48
Line Item Description
STEEL TREE BED GUARD - A
Unit Of Measure
LF
Unit Price
92.0
Units Used
11.1
Total Cost
1021.1999999999999
Transaction Date
2025-11-07T00:00:00.000
1137308
Transaction Id: 1137308 • Contract Number: BG-924M • Work Order Id: 27189095
Transaction Id
1137308
Contract Number
BG-924M
Work Order Id
27189095
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
30.0
Units Used
39.0
Total Cost
1170.0
Transaction Date
2026-05-01T00:00:00.000
1139467
Transaction Id: 1139467 • Contract Number: QG-324M • Work Order Id: 22844124
Transaction Id
1139467
Contract Number
QG-324M
Work Order Id
22844124
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
24.0
Units Used
58.9
Total Cost
1413.6
Transaction Date
2025-12-12T00:00:00.000
1139526
Transaction Id: 1139526 • Contract Number: QG-324M • Work Order Id: 23759393
Transaction Id
1139526
Contract Number
QG-324M
Work Order Id
23759393
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
20.5
Units Used
40.0
Total Cost
820.0
Transaction Date
2025-09-23T00:00:00.000
1139787
Transaction Id: 1139787 • Contract Number: QG-324M • Work Order Id: 26401547
Transaction Id
1139787
Contract Number
QG-324M
Work Order Id
26401547
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
24.0
Units Used
30.2
Total Cost
724.8
Transaction Date
2025-10-06T00:00:00.000
1140139
Transaction Id: 1140139 • Contract Number: QG-324M • Work Order Id: 27709563
Transaction Id
1140139
Contract Number
QG-324M
Work Order Id
27709563
Line Item Id
721.0
Item Number
45
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
600.0
Units Used
0.11
Total Cost
66.0
Transaction Date
2026-03-13T00:00:00.000
1142598
Transaction Id: 1142598 • Contract Number: QG-424M • Work Order Id: 25980971
Transaction Id
1142598
Contract Number
QG-424M
Work Order Id
25980971
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
17.5
Total Cost
455.0
Transaction Date
2026-05-11T00:00:00.000
1142995
Transaction Id: 1142995 • Contract Number: QG-424M • Work Order Id: 26094981
Transaction Id
1142995
Contract Number
QG-424M
Work Order Id
26094981
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
8.3
Total Cost
265.6
Transaction Date
2025-10-21T00:00:00.000
1143643
Transaction Id: 1143643 • Contract Number: QG-424M • Work Order Id: 26244139
Transaction Id
1143643
Contract Number
QG-424M
Work Order Id
26244139
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
28.0
Total Cost
728.0
Transaction Date
2025-10-29T00:00:00.000
1143733
Transaction Id: 1143733 • Contract Number: QG-424M • Work Order Id: 26251513
Transaction Id
1143733
Contract Number
QG-424M
Work Order Id
26251513
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
31.5
Total Cost
819.0
Transaction Date
2025-10-28T00:00:00.000
1145230
Transaction Id: 1145230 • Contract Number: QG-424M • Work Order Id: 27412906
Transaction Id
1145230
Contract Number
QG-424M
Work Order Id
27412906
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
28.0
Total Cost
728.0
Transaction Date
2025-11-05T00:00:00.000
1146998
Transaction Id: 1146998 • Contract Number: XG-124M • Work Order Id: 27335967
Transaction Id
1146998
Contract Number
XG-124M
Work Order Id
27335967
Line Item Id
629.0
Item Number
50
Line Item Description
STEEL TREE BED GUARD - C
Unit Of Measure
LF
Unit Price
108.0
Units Used
13.3
Total Cost
1436.4
Transaction Date
2026-03-16T00:00:00.000
1147872
Transaction Id: 1147872 • Contract Number: BG-824M • Work Order Id: 27375073
Transaction Id
1147872
Contract Number
BG-824M
Work Order Id
27375073
Line Item Id
619.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
23.0
Units Used
50.0
Total Cost
1150.0
Transaction Date
2025-10-28T00:00:00.000
1147913
Transaction Id: 1147913 • Contract Number: BG-824M • Work Order Id: 27395734
Transaction Id
1147913
Contract Number
BG-824M
Work Order Id
27395734
Line Item Id
619.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
23.0
Units Used
50.0
Total Cost
1150.0
Transaction Date
2025-10-28T00:00:00.000
1148205
Transaction Id: 1148205 • Contract Number: BG-824M • Work Order Id: 27438051
Transaction Id
1148205
Contract Number
BG-824M
Work Order Id
27438051
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
26.75
Units Used
15.0
Total Cost
401.25
Transaction Date
2025-12-31T00:00:00.000
1150794
Transaction Id: 1150794 • Contract Number: XG-424M • Work Order Id: 26185702
Transaction Id
1150794
Contract Number
XG-424M
Work Order Id
26185702
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
31.0
Units Used
12.3
Total Cost
381.3
Transaction Date
2025-09-25T00:00:00.000
1152218
Transaction Id: 1152218 • Contract Number: XG-324M • Work Order Id: 27120930
Transaction Id
1152218
Contract Number
XG-324M
Work Order Id
27120930
Line Item Id
619.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
27.0
Units Used
40.0
Total Cost
1080.0
Transaction Date
2025-11-25T00:00:00.000
1152359
Transaction Id: 1152359 • Contract Number: XG-324M • Work Order Id: 27187039
Transaction Id
1152359
Contract Number
XG-324M
Work Order Id
27187039
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
15.5
Total Cost
1550.0
Transaction Date
2026-04-07T00:00:00.000
1153261
Transaction Id: 1153261 • Contract Number: XG-324M • Work Order Id: 27735289
Transaction Id
1153261
Contract Number
XG-324M
Work Order Id
27735289
Line Item Id
630.0
Item Number
51
Line Item Description
STEEL TREE BED GUARD - D
Unit Of Measure
LF
Unit Price
100.0
Units Used
17.7
Total Cost
1770.0
Transaction Date
2026-04-06T00:00:00.000
1153289
Transaction Id: 1153289 • Contract Number: XG-324M • Work Order Id: 27745537
Transaction Id
1153289
Contract Number
XG-324M
Work Order Id
27745537
Line Item Id
619.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
27.0
Units Used
43.0
Total Cost
1161.0
Transaction Date
2025-11-21T00:00:00.000
1153919
Transaction Id: 1153919 • Contract Number: BG-123M • Work Order Id: 28169878
Transaction Id
1153919
Contract Number
BG-123M
Work Order Id
28169878
Line Item Id
566.0
Item Number
38R
Line Item Description
SHREDDED BARK MULCH (R)
Unit Of Measure
SY
Unit Price
14.5
Units Used
4.91
Total Cost
71.19500000000001
Transaction Date
2025-10-06T00:00:00.000
1154131
Transaction Id: 1154131 • Contract Number: XG-324M • Work Order Id: 27917065
Transaction Id
1154131
Contract Number
XG-324M
Work Order Id
27917065
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
31.0
Units Used
35.0
Total Cost
1085.0
Transaction Date
2025-11-20T00:00:00.000
1154275
Transaction Id: 1154275 • Contract Number: XG-124M • Work Order Id: 27271608
Transaction Id
1154275
Contract Number
XG-124M
Work Order Id
27271608
Line Item Id
293.0
Item Number
39
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
11.0
Units Used
15.0
Total Cost
165.0
Transaction Date
2025-10-10T00:00:00.000
1155588
Transaction Id: 1155588 • Contract Number: QG-424M • Work Order Id: 26211256
Transaction Id
1155588
Contract Number
QG-424M
Work Order Id
26211256
Line Item Id
465.0
Item Number
45
Line Item Description
CONCRETE CURB
Unit Of Measure
LF
Unit Price
100.0
Units Used
0.18
Total Cost
18.0
Transaction Date
2025-11-03T00:00:00.000
1157768
Transaction Id: 1157768 • Contract Number: MG-224M • Work Order Id: 27209471
Transaction Id
1157768
Contract Number
MG-224M
Work Order Id
27209471
Line Item Id
705.0
Item Number
11
Line Item Description
PREPARING NEW TREE BEDS
Unit Of Measure
SF
Unit Price
42.5
Units Used
52.5
Total Cost
2231.25
Transaction Date
2025-10-20T00:00:00.000
1159014
Transaction Id: 1159014 • Contract Number: MG-224M • Work Order Id: 27822530
Transaction Id
1159014
Contract Number
MG-224M
Work Order Id
27822530
Line Item Id
705.0
Item Number
11
Line Item Description
PREPARING NEW TREE BEDS
Unit Of Measure
SF
Unit Price
42.5
Units Used
52.5
Total Cost
2231.25
Transaction Date
2025-10-24T00:00:00.000
1159642
Transaction Id: 1159642 • Contract Number: XG-324M • Work Order Id: 27077508
Transaction Id
1159642
Contract Number
XG-324M
Work Order Id
27077508
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
200.0
Units Used
0.96
Total Cost
192.0
Transaction Date
2025-10-23T00:00:00.000
1160151
Transaction Id: 1160151 • Contract Number: XG-324M • Work Order Id: 27711418
Transaction Id
1160151
Contract Number
XG-324M
Work Order Id
27711418
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
200.0
Units Used
0.93
Total Cost
186.0
Transaction Date
2025-11-26T00:00:00.000
1160458
Transaction Id: 1160458 • Contract Number: XG-424M • Work Order Id: 27138857
Transaction Id
1160458
Contract Number
XG-424M
Work Order Id
27138857
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
200.0
Units Used
2.16
Total Cost
432.0
Transaction Date
2025-11-04T00:00:00.000
1161336
Transaction Id: 1161336 • Contract Number: MG-224M • Work Order Id: 28253125
Transaction Id
1161336
Contract Number
MG-224M
Work Order Id
28253125
Line Item Id
706.0
Item Number
12
Line Item Description
PREPARING EXISTING TREE BEDS
Unit Of Measure
SF
Unit Price
42.5
Units Used
47.1
Total Cost
2001.75
Transaction Date
2025-11-17T00:00:00.000
1163007
Transaction Id: 1163007 • Contract Number: QG-324M • Work Order Id: 27947633
Transaction Id
1163007
Contract Number
QG-324M
Work Order Id
27947633
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
24.0
Units Used
28.3
Total Cost
679.2
Transaction Date
2025-11-20T00:00:00.000
1163415
Transaction Id: 1163415 • Contract Number: XG-424M • Work Order Id: 27343622
Transaction Id
1163415
Contract Number
XG-424M
Work Order Id
27343622
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
200.0
Units Used
0.8
Total Cost
160.0
Transaction Date
2025-11-12T00:00:00.000
1166409
Transaction Id: 1166409 • Contract Number: QG-624M • Work Order Id: 27552564
Transaction Id
1166409
Contract Number
QG-624M
Work Order Id
27552564
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
75.0
Units Used
0.67
Total Cost
50.25
Transaction Date
2025-12-12T00:00:00.000
1170056
Transaction Id: 1170056 • Contract Number: XG-324M • Work Order Id: 28747667
Transaction Id
1170056
Contract Number
XG-324M
Work Order Id
28747667
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.56
Total Cost
278.0
Transaction Date
2026-04-06T00:00:00.000
1170899
Transaction Id: 1170899 • Contract Number: XG-324M • Work Order Id: 29022692
Transaction Id
1170899
Contract Number
XG-324M
Work Order Id
29022692
Line Item Id
619.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
27.0
Units Used
40.0
Total Cost
1080.0
Transaction Date
2026-04-29T00:00:00.000
1171106
Transaction Id: 1171106 • Contract Number: BG-624M • Work Order Id: 27666386
Transaction Id
1171106
Contract Number
BG-624M
Work Order Id
27666386
Line Item Id
721.0
Item Number
45
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
600.0
Units Used
0.02
Total Cost
12.0
Transaction Date
2026-03-19T00:00:00.000
1171172
Transaction Id: 1171172 • Contract Number: MG-224M • Work Order Id: 27875095
Transaction Id
1171172
Contract Number
MG-224M
Work Order Id
27875095
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
150.0
Units Used
0.19
Total Cost
28.5
Transaction Date
2026-04-03T00:00:00.000
1171578
Transaction Id: 1171578 • Contract Number: BG-824M • Work Order Id: 28974830
Transaction Id
1171578
Contract Number
BG-824M
Work Order Id
28974830
Units Used
40.0
Transaction Date
2026-04-03T00:00:00.000
1171918
Transaction Id: 1171918 • Contract Number: RG-124M • Work Order Id: 20037921
Transaction Id
1171918
Contract Number
RG-124M
Work Order Id
20037921
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
22.5
Total Cost
675.0
Transaction Date
2026-04-06T00:00:00.000
1172537
Transaction Id: 1172537 • Contract Number: BG-824M • Work Order Id: 29201805
Transaction Id
1172537
Contract Number
BG-824M
Work Order Id
29201805
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
26.75
Units Used
30.0
Total Cost
802.5
Transaction Date
2026-04-24T00:00:00.000
1173289
Transaction Id: 1173289 • Contract Number: RG-124M • Work Order Id: 28694046
Transaction Id
1173289
Contract Number
RG-124M
Work Order Id
28694046
Line Item Id
619.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
35.0
Units Used
40.0
Total Cost
1400.0
Transaction Date
2026-04-09T00:00:00.000
1174451
Transaction Id: 1174451 • Contract Number: QG-224M • Work Order Id: 27940804
Transaction Id
1174451
Contract Number
QG-224M
Work Order Id
27940804
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
15.0
Units Used
30.0
Total Cost
450.0
Transaction Date
2026-04-23T00:00:00.000
1174689
Transaction Id: 1174689 • Contract Number: BG-423M • Work Order Id: 22161806
Transaction Id
1174689
Contract Number
BG-423M
Work Order Id
22161806
Line Item Id
465.0
Item Number
45
Line Item Description
CONCRETE CURB
Unit Of Measure
LF
Unit Price
3000.0
Units Used
0.31
Total Cost
930.0
Transaction Date
2026-03-27T00:00:00.000