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
1113313
Transaction Id: 1113313 • Contract Number: BG-322M • Work Order Id: 26027644
Transaction Id
1113313
Contract Number
BG-322M
Work Order Id
26027644
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
10.2
Total Cost
285.59999999999997
Transaction Date
2025-04-02T00:00:00.000
1113314
Transaction Id: 1113314 • Contract Number: BG-322M • Work Order Id: 26027650
Transaction Id
1113314
Contract Number
BG-322M
Work Order Id
26027650
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
9.2
Total Cost
257.59999999999997
Transaction Date
2025-04-02T00:00:00.000
1113315
Transaction Id: 1113315 • Contract Number: BG-322M • Work Order Id: 26027643
Transaction Id
1113315
Contract Number
BG-322M
Work Order Id
26027643
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
10.2
Total Cost
285.59999999999997
Transaction Date
2025-04-03T00:00:00.000
1113316
Transaction Id: 1113316 • Contract Number: BG-322M • Work Order Id: 25997738
Transaction Id
1113316
Contract Number
BG-322M
Work Order Id
25997738
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
7.2
Total Cost
201.6
Transaction Date
2025-04-03T00:00:00.000
1113317
Transaction Id: 1113317 • Contract Number: BG-322M • Work Order Id: 25997744
Transaction Id
1113317
Contract Number
BG-322M
Work Order Id
25997744
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
17.0
Total Cost
476.0
Transaction Date
2025-04-03T00:00:00.000
1113318
Transaction Id: 1113318 • Contract Number: BG-322M • Work Order Id: 25997739
Transaction Id
1113318
Contract Number
BG-322M
Work Order Id
25997739
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
6.7
Total Cost
187.6
Transaction Date
2025-04-03T00:00:00.000
1113319
Transaction Id: 1113319 • Contract Number: BG-322M • Work Order Id: 25997741
Transaction Id
1113319
Contract Number
BG-322M
Work Order Id
25997741
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
8.1
Total Cost
226.79999999999998
Transaction Date
2025-04-03T00:00:00.000
1113320
Transaction Id: 1113320 • Contract Number: BG-322M • Work Order Id: 25997747
Transaction Id
1113320
Contract Number
BG-322M
Work Order Id
25997747
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
6.8
Total Cost
190.4
Transaction Date
2025-04-03T00:00:00.000
1113321
Transaction Id: 1113321 • Contract Number: BG-322M • Work Order Id: 25997742
Transaction Id
1113321
Contract Number
BG-322M
Work Order Id
25997742
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
8.0
Total Cost
224.0
Transaction Date
2025-04-03T00:00:00.000
1113322
Transaction Id: 1113322 • Contract Number: BG-322M • Work Order Id: 25997745
Transaction Id
1113322
Contract Number
BG-322M
Work Order Id
25997745
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
10.0
Total Cost
280.0
Transaction Date
2025-04-03T00:00:00.000
1113323
Transaction Id: 1113323 • Contract Number: BG-322M • Work Order Id: 25997743
Transaction Id
1113323
Contract Number
BG-322M
Work Order Id
25997743
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
11.8
Total Cost
330.40000000000003
Transaction Date
2025-04-03T00:00:00.000
1113324
Transaction Id: 1113324 • Contract Number: BG-322M • Work Order Id: 25995989
Transaction Id
1113324
Contract Number
BG-322M
Work Order Id
25995989
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
12.5
Total Cost
350.0
Transaction Date
2025-04-03T00:00:00.000
1113399
Transaction Id: 1113399 • Contract Number: BG-322M • Work Order Id: 25995992
Transaction Id
1113399
Contract Number
BG-322M
Work Order Id
25995992
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
8.1
Total Cost
226.79999999999998
Transaction Date
2025-04-04T00:00:00.000
1113400
Transaction Id: 1113400 • Contract Number: BG-322M • Work Order Id: 25995991
Transaction Id
1113400
Contract Number
BG-322M
Work Order Id
25995991
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
5.0
Total Cost
140.0
Transaction Date
2025-04-04T00:00:00.000
1113401
Transaction Id: 1113401 • Contract Number: BG-322M • Work Order Id: 25995990
Transaction Id
1113401
Contract Number
BG-322M
Work Order Id
25995990
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
10.6
Total Cost
296.8
Transaction Date
2025-04-04T00:00:00.000
1113405
Transaction Id: 1113405 • Contract Number: BG-322M • Work Order Id: 25995997
Transaction Id
1113405
Contract Number
BG-322M
Work Order Id
25995997
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
12.4
Total Cost
347.2
Transaction Date
2025-04-04T00:00:00.000
1113406
Transaction Id: 1113406 • Contract Number: BG-322M • Work Order Id: 25995998
Transaction Id
1113406
Contract Number
BG-322M
Work Order Id
25995998
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
5.3
Total Cost
148.4
Transaction Date
2025-04-04T00:00:00.000
1113407
Transaction Id: 1113407 • Contract Number: BG-322M • Work Order Id: 25996002
Transaction Id
1113407
Contract Number
BG-322M
Work Order Id
25996002
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
10.0
Total Cost
280.0
Transaction Date
2025-04-04T00:00:00.000
1113408
Transaction Id: 1113408 • Contract Number: BG-322M • Work Order Id: 25996001
Transaction Id
1113408
Contract Number
BG-322M
Work Order Id
25996001
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
4.4
Total Cost
123.20000000000002
Transaction Date
2025-04-04T00:00:00.000
1113409
Transaction Id: 1113409 • Contract Number: BG-322M • Work Order Id: 25995988
Transaction Id
1113409
Contract Number
BG-322M
Work Order Id
25995988
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
6.5
Total Cost
182.0
Transaction Date
2025-04-04T00:00:00.000
1113410
Transaction Id: 1113410 • Contract Number: BG-322M • Work Order Id: 25995999
Transaction Id
1113410
Contract Number
BG-322M
Work Order Id
25995999
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
4.6
Total Cost
128.79999999999998
Transaction Date
2025-04-04T00:00:00.000
1113411
Transaction Id: 1113411 • Contract Number: BG-322M • Work Order Id: 25996000
Transaction Id
1113411
Contract Number
BG-322M
Work Order Id
25996000
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
11.5
Total Cost
322.0
Transaction Date
2025-04-04T00:00:00.000
1113412
Transaction Id: 1113412 • Contract Number: BG-322M • Work Order Id: 25995993
Transaction Id
1113412
Contract Number
BG-322M
Work Order Id
25995993
Line Item Id
621.0
Item Number
30
Line Item Description
GRANITE BLOCK PAVERS FOR TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
10.6
Total Cost
296.8
Transaction Date
2025-04-04T00:00:00.000
1122472
Transaction Id: 1122472 • Contract Number: MG-1319MA • Work Order Id: 26093629
Transaction Id
1122472
Contract Number
MG-1319MA
Work Order Id
26093629
Line Item Id
764.0
Item Number
29R
Line Item Description
UNCLASSIFIED EXCAVATION (R)
Unit Of Measure
CY
Unit Price
243.0
Units Used
1.48
Total Cost
359.64
Transaction Date
2025-04-22T00:00:00.000
1110375
Transaction Id: 1110375 • Contract Number: CNYG-224M • Work Order Id: 26015146
Transaction Id
1110375
Contract Number
CNYG-224M
Work Order Id
26015146
Line Item Id
743.0
Item Number
01
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS WITH CITY-PROCURED SOIL
Unit Of Measure
SF
Unit Price
35.0
Units Used
31.9
Total Cost
1116.5
Transaction Date
2025-05-09T00:00:00.000
1128852
Transaction Id: 1128852 • Contract Number: QG-424M • Work Order Id: 26517796
Transaction Id
1128852
Contract Number
QG-424M
Work Order Id
26517796
Line Item Id
724.0
Item Number
20
Line Item Description
PLANTING PROCURED STREET TREES, 3.0 – 3.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
800.0
Units Used
1.0
Total Cost
800.0
Transaction Date
2025-05-19T00:00:00.000
1130231
Transaction Id: 1130231 • Contract Number: BG-423M • Work Order Id: 25637273
Transaction Id
1130231
Contract Number
BG-423M
Work Order Id
25637273
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
39.0
Units Used
47.5
Total Cost
1852.5
Transaction Date
2025-05-29T00:00:00.000
1116865
Transaction Id: 1116865 • Contract Number: QG-323M • Work Order Id: 26112079
Transaction Id
1116865
Contract Number
QG-323M
Work Order Id
26112079
Line Item Id
342.0
Item Number
43
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
25.0
Units Used
25.0
Total Cost
625.0
Transaction Date
2025-06-20T00:00:00.000
1116867
Transaction Id: 1116867 • Contract Number: QG-323M • Work Order Id: 26112079
Transaction Id
1116867
Contract Number
QG-323M
Work Order Id
26112079
Line Item Id
725.0
Item Number
46
Line Item Description
FOUNDATION MATERIAL FOR CONCRETE (MEASURED ON SITE)
Unit Of Measure
CY
Unit Price
40.0
Units Used
0.16
Total Cost
6.4
Transaction Date
2025-06-12T00:00:00.000
1113252
Transaction Id: 1113252 • Contract Number: BG-123M • Work Order Id: 25751156
Transaction Id
1113252
Contract Number
BG-123M
Work Order Id
25751156
Line Item Id
759.0
Item Number
07
Line Item Description
TREE REMOVAL OF OVER 4 UP TO AND INCLUDING 8 INCHES DBH
Unit Of Measure
EA
Unit Price
150.0
Units Used
1.0
Total Cost
150.0
Transaction Date
2025-03-10T00:00:00.000
1113253
Transaction Id: 1113253 • Contract Number: BG-123M • Work Order Id: 25751156
Transaction Id
1113253
Contract Number
BG-123M
Work Order Id
25751156
Line Item Id
611.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 8 UP TO AND INCLUDING 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2025-03-10T00:00:00.000
1132410
Transaction Id: 1132410 • Contract Number: QG-424M • Work Order Id: 26517797
Transaction Id
1132410
Contract Number
QG-424M
Work Order Id
26517797
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
2025-05-19T00:00:00.000
1132411
Transaction Id: 1132411 • Contract Number: XG-324M • Work Order Id: 26560917
Transaction Id
1132411
Contract Number
XG-324M
Work Order Id
26560917
Line Item Id
651.0
Item Number
21
Line Item Description
PLANTING PROCURED STREET TREES, 3.5 – 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
800.0
Units Used
1.0
Total Cost
800.0
Transaction Date
2025-06-18T00:00:00.000
1132663
Transaction Id: 1132663 • Contract Number: BG-123M • Work Order Id: 25985543
Transaction Id
1132663
Contract Number
BG-123M
Work Order Id
25985543
Line Item Id
312.0
Item Number
36
Line Item Description
REMOVE AND RESET METAL TREE GUARDS AND GRATES
Unit Of Measure
HR
Unit Price
145.0
Units Used
0.25
Total Cost
36.25
Transaction Date
2025-05-15T00:00:00.000
1125844
Transaction Id: 1125844 • Contract Number: BG-824M • Work Order Id: 25933887
Transaction Id
1125844
Contract Number
BG-824M
Work Order Id
25933887
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
150.0
Units Used
2.46
Total Cost
369.0
Transaction Date
2025-05-22T00:00:00.000
1139263
Transaction Id: 1139263 • Contract Number: BG-624M • Work Order Id: 26226148
Transaction Id
1139263
Contract Number
BG-624M
Work Order Id
26226148
Line Item Id
342.0
Item Number
43
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
28.0
Units Used
34.0
Total Cost
952.0
Transaction Date
2025-05-08T00:00:00.000
1139264
Transaction Id: 1139264 • Contract Number: BG-624M • Work Order Id: 26226148
Transaction Id
1139264
Contract Number
BG-624M
Work Order Id
26226148
Line Item Id
725.0
Item Number
46
Line Item Description
FOUNDATION MATERIAL FOR CONCRETE (MEASURED ON SITE)
Unit Of Measure
CY
Unit Price
125.0
Units Used
0.37
Total Cost
46.25
Transaction Date
2025-05-08T00:00:00.000
1134652
Transaction Id: 1134652 • Contract Number: QG-323M • Work Order Id: 26891848
Transaction Id
1134652
Contract Number
QG-323M
Work Order Id
26891848
Line Item Id
312.0
Item Number
36
Line Item Description
REMOVE AND RESET METAL TREE GUARDS AND GRATES
Unit Of Measure
HR
Unit Price
75.0
Units Used
0.25
Total Cost
18.75
Transaction Date
2025-07-21T00:00:00.000
1013089
Transaction Id: 1013089 • Contract Number: MG-1319MA • Work Order Id: 17026427
Transaction Id
1013089
Contract Number
MG-1319MA
Work Order Id
17026427
Line Item Id
623.0
Item Number
22
Line Item Description
EXPANSION OF EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
84.0
Units Used
25.8
Total Cost
2167.2000000000003
Transaction Date
2023-02-01T00:00:00.000
1090109
Transaction Id: 1090109 • Contract Number: MG-1319MA • Work Order Id: 24398431
Transaction Id
1090109
Contract Number
MG-1319MA
Work Order Id
24398431
Line Item Id
763.0
Item Number
38R
Line Item Description
STEEL TREE BED GUARD - B (R)
Unit Of Measure
LF
Unit Price
200.0
Units Used
13.6
Total Cost
2720.0
Transaction Date
2025-06-04T00:00:00.000
1123811
Transaction Id: 1123811 • Contract Number: XG-324M • Work Order Id: 25875808
Transaction Id
1123811
Contract Number
XG-324M
Work Order Id
25875808
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
34.7
Total Cost
1075.7
Transaction Date
2025-05-07T00:00:00.000
1136148
Transaction Id: 1136148 • Contract Number: BG-924M • Work Order Id: 26968023
Transaction Id
1136148
Contract Number
BG-924M
Work Order Id
26968023
Line Item Id
625.0
Item Number
35
Line Item Description
REMOVE DEBRIS (TREE BED AND TREE CANOPY)
Unit Of Measure
HR
Unit Price
69.0
Units Used
0.1
Total Cost
6.9
Transaction Date
2025-08-27T00:00:00.000
1139357
Transaction Id: 1139357 • Contract Number: BG-924M • Work Order Id: 26968023
Transaction Id
1139357
Contract Number
BG-924M
Work Order Id
26968023
Line Item Id
624.0
Item Number
34
Line Item Description
REMOVE BLOCK AND/OR STONE PAVEMENT
Unit Of Measure
SF
Unit Price
10.0
Units Used
17.6
Total Cost
176.0
Transaction Date
2025-08-27T00:00:00.000
1139358
Transaction Id: 1139358 • Contract Number: BG-924M • Work Order Id: 26968023
Transaction Id
1139358
Contract Number
BG-924M
Work Order Id
26968023
Line Item Id
626.0
Item Number
37
Line Item Description
TOPSOIL FOR TREE BED AREAS
Unit Of Measure
CF
Unit Price
5.0
Units Used
11.67
Total Cost
58.35
Transaction Date
2025-08-27T00:00:00.000
1139359
Transaction Id: 1139359 • Contract Number: BG-924M • Work Order Id: 26968023
Transaction Id
1139359
Contract Number
BG-924M
Work Order Id
26968023
Line Item Id
292.0
Item Number
38
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
9.0
Units Used
3.89
Total Cost
35.01
Transaction Date
2025-08-27T00:00:00.000
1146090
Transaction Id: 1146090 • Contract Number: XG-124M • Work Order Id: 24871156
Transaction Id
1146090
Contract Number
XG-124M
Work Order Id
24871156
Line Item Id
722.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 4 UP TO AND INCLUDING 8 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2025-10-10T00:00:00.000
1146189
Transaction Id: 1146189 • Contract Number: XG-124M • Work Order Id: 26409767
Transaction Id
1146189
Contract Number
XG-124M
Work Order Id
26409767
Line Item Id
722.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 4 UP TO AND INCLUDING 8 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2025-10-14T00:00:00.000
1146454
Transaction Id: 1146454 • Contract Number: XG-124M • Work Order Id: 27024412
Transaction Id
1146454
Contract Number
XG-124M
Work Order Id
27024412
Line Item Id
295.0
Item Number
41
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
210.0
Units Used
0.25
Total Cost
52.5
Transaction Date
2025-10-10T00:00:00.000
1154037
Transaction Id: 1154037 • Contract Number: XG-424M • Work Order Id: 26248628
Transaction Id
1154037
Contract Number
XG-424M
Work Order Id
26248628
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
900.0
Units Used
1.0
Total Cost
900.0
Transaction Date
2025-10-07T00:00:00.000
1154168
Transaction Id: 1154168 • Contract Number: XG-324M • Work Order Id: 27888943
Transaction Id
1154168
Contract Number
XG-324M
Work Order Id
27888943
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
200.0
Units Used
150.0
Total Cost
30000.0
Transaction Date
1900-07-04T00:00:00.000