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
1154169
Transaction Id: 1154169 • Contract Number: XG-324M • Work Order Id: 27888943
Transaction Id
1154169
Contract Number
XG-324M
Work Order Id
27888943
Line Item Id
725.0
Item Number
46
Line Item Description
FOUNDATION MATERIAL FOR CONCRETE (MEASURED ON SITE)
Unit Of Measure
CY
Unit Price
50.0
Units Used
111.0
Total Cost
5550.0
Transaction Date
1900-02-14T00:00:00.000
1154170
Transaction Id: 1154170 • Contract Number: XG-324M • Work Order Id: 27888943
Transaction Id
1154170
Contract Number
XG-324M
Work Order Id
27888943
Line Item Id
342.0
Item Number
43
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
34.0
Units Used
34.0
Total Cost
1156.0
Transaction Date
1904-08-26T00:00:00.000
1155557
Transaction Id: 1155557 • Contract Number: QG-424M • Work Order Id: 26102864
Transaction Id
1155557
Contract Number
QG-424M
Work Order Id
26102864
Line Item Id
659.0
Item Number
15
Line Item Description
PREPARING LAWN TREE BEDS WITH AMENDED EXISTING SOIL
Unit Of Measure
SF
Unit Price
18.0
Units Used
24.5
Total Cost
441.0
Transaction Date
2025-10-23T00:00:00.000
1136781
Transaction Id: 1136781 • Contract Number: BG-924M • Work Order Id: 27040511
Transaction Id
1136781
Contract Number
BG-924M
Work Order Id
27040511
Line Item Id
628.0
Item Number
49
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
92.0
Units Used
17.5
Total Cost
1610.0
Transaction Date
2025-10-27T00:00:00.000
1138349
Transaction Id: 1138349 • Contract Number: BG-824M • Work Order Id: 25862336
Transaction Id
1138349
Contract Number
BG-824M
Work Order Id
25862336
Line Item Id
659.0
Item Number
15
Line Item Description
PREPARING LAWN TREE BEDS WITH AMENDED EXISTING SOIL
Unit Of Measure
SF
Unit Price
15.0
Units Used
30.0
Total Cost
450.0
Transaction Date
2025-08-28T00:00:00.000
1151854
Transaction Id: 1151854 • Contract Number: XG-324M • Work Order Id: 27077508
Transaction Id
1151854
Contract Number
XG-324M
Work Order Id
27077508
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-12-12T00:00:00.000
1163655
Transaction Id: 1163655 • Contract Number: QG-324M • Work Order Id: 26309494
Transaction Id
1163655
Contract Number
QG-324M
Work Order Id
26309494
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
51.3
Total Cost
1231.1999999999998
Transaction Date
2025-11-21T00:00:00.000
1160036
Transaction Id: 1160036 • Contract Number: BG-624M • Work Order Id: 26047328
Transaction Id
1160036
Contract Number
BG-624M
Work Order Id
26047328
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
910.0
Units Used
1.0
Total Cost
910.0
Transaction Date
2025-10-31T00:00:00.000
1165404
Transaction Id: 1165404 • Contract Number: BG-724M • Work Order Id: 27268206
Transaction Id
1165404
Contract Number
BG-724M
Work Order Id
27268206
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.0
Units Used
45.5
Total Cost
2138.5
Transaction Date
2025-12-05T00:00:00.000
1166436
Transaction Id: 1166436 • Contract Number: QG-424M • Work Order Id: 26529364
Transaction Id
1166436
Contract Number
QG-424M
Work Order Id
26529364
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-12-05T00:00:00.000
1135186
Transaction Id: 1135186 • Contract Number: BG-123M • Work Order Id: 26694605
Transaction Id
1135186
Contract Number
BG-123M
Work Order Id
26694605
Line Item Id
624.0
Item Number
34
Line Item Description
REMOVE BLOCK AND/OR STONE PAVEMENT
Unit Of Measure
SF
Unit Price
30.0
Units Used
48.8
Total Cost
1464.0
Transaction Date
2025-07-31T00:00:00.000
1135241
Transaction Id: 1135241 • Contract Number: BG-123M • Work Order Id: 26694990
Transaction Id
1135241
Contract Number
BG-123M
Work Order Id
26694990
Line Item Id
624.0
Item Number
34
Line Item Description
REMOVE BLOCK AND/OR STONE PAVEMENT
Unit Of Measure
SF
Unit Price
30.0
Units Used
40.0
Total Cost
1200.0
Transaction Date
2025-08-06T00:00:00.000
1135243
Transaction Id: 1135243 • Contract Number: BG-123M • Work Order Id: 26694989
Transaction Id
1135243
Contract Number
BG-123M
Work Order Id
26694989
Line Item Id
624.0
Item Number
34
Line Item Description
REMOVE BLOCK AND/OR STONE PAVEMENT
Unit Of Measure
SF
Unit Price
30.0
Units Used
39.8
Total Cost
1194.0
Transaction Date
2025-08-06T00:00:00.000
1159633
Transaction Id: 1159633 • Contract Number: XG-324M • Work Order Id: 27077516
Transaction Id
1159633
Contract Number
XG-324M
Work Order Id
27077516
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
40.0
Total Cost
1240.0
Transaction Date
2025-10-22T00:00:00.000
1168605
Transaction Id: 1168605 • Contract Number: QG-324M • Work Order Id: 24738377
Transaction Id
1168605
Contract Number
QG-324M
Work Order Id
24738377
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.7
Total Cost
688.8
Transaction Date
2025-12-31T00:00:00.000
1168606
Transaction Id: 1168606 • Contract Number: QG-324M • Work Order Id: 24738375
Transaction Id
1168606
Contract Number
QG-324M
Work Order Id
24738375
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
13.1
Total Cost
314.4
Transaction Date
2025-12-31T00:00:00.000
1168607
Transaction Id: 1168607 • Contract Number: QG-324M • Work Order Id: 24738375
Transaction Id
1168607
Contract Number
QG-324M
Work Order Id
24738375
Line Item Id
619.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
23.0
Total Cost
460.0
Transaction Date
2025-12-31T00:00:00.000
1168608
Transaction Id: 1168608 • Contract Number: QG-324M • Work Order Id: 24738376
Transaction Id
1168608
Contract Number
QG-324M
Work Order Id
24738376
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
40.0
Total Cost
960.0
Transaction Date
2025-12-31T00:00:00.000
1168609
Transaction Id: 1168609 • Contract Number: QG-324M • Work Order Id: 27878184
Transaction Id
1168609
Contract Number
QG-324M
Work Order Id
27878184
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
32.5
Total Cost
780.0
Transaction Date
2025-12-31T00:00:00.000
1168610
Transaction Id: 1168610 • Contract Number: QG-324M • Work Order Id: 27860765
Transaction Id
1168610
Contract Number
QG-324M
Work Order Id
27860765
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
200.0
Units Used
1.0
Total Cost
200.0
Transaction Date
2025-12-31T00:00:00.000
1168611
Transaction Id: 1168611 • Contract Number: QG-324M • Work Order Id: 27860765
Transaction Id
1168611
Contract Number
QG-324M
Work Order Id
27860765
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
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2025-12-31T00:00:00.000
1168612
Transaction Id: 1168612 • Contract Number: QG-324M • Work Order Id: 27860765
Transaction Id
1168612
Contract Number
QG-324M
Work Order Id
27860765
Line Item Id
619.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
26.7
Total Cost
534.0
Transaction Date
2025-12-31T00:00:00.000
1168613
Transaction Id: 1168613 • Contract Number: QG-324M • Work Order Id: 26656856
Transaction Id
1168613
Contract Number
QG-324M
Work Order Id
26656856
Line Item Id
619.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
33.9
Total Cost
678.0
Transaction Date
2025-12-31T00:00:00.000
1139545
Transaction Id: 1139545 • Contract Number: QG-324M • Work Order Id: 23987236
Transaction Id
1139545
Contract Number
QG-324M
Work Order Id
23987236
Line Item Id
627.0
Item Number
48
Line Item Description
STEEL TREE BED GUARD - A
Unit Of Measure
LF
Unit Price
140.0
Units Used
16.3
Total Cost
2282.0
Transaction Date
2026-03-14T00:00:00.000
1140015
Transaction Id: 1140015 • Contract Number: QG-324M • Work Order Id: 27395883
Transaction Id
1140015
Contract Number
QG-324M
Work Order Id
27395883
Line Item Id
627.0
Item Number
48
Line Item Description
STEEL TREE BED GUARD - A
Unit Of Measure
LF
Unit Price
140.0
Units Used
15.8
Total Cost
2212.0
Transaction Date
2026-03-14T00:00:00.000
1159142
Transaction Id: 1159142 • Contract Number: BG-123M • Work Order Id: 28292877
Transaction Id
1159142
Contract Number
BG-123M
Work Order Id
28292877
Line Item Id
342.0
Item Number
43
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
20.0
Units Used
13.5
Total Cost
270.0
Transaction Date
2025-06-04T00:00:00.000
1169466
Transaction Id: 1169466 • Contract Number: BG-824M • Work Order Id: 27046982
Transaction Id
1169466
Contract Number
BG-824M
Work Order Id
27046982
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
150.0
Units Used
0.82
Total Cost
122.99999999999999
Transaction Date
2026-03-10T00:00:00.000
1170112
Transaction Id: 1170112 • Contract Number: BG-824M • Work Order Id: 27103429
Transaction Id
1170112
Contract Number
BG-824M
Work Order Id
27103429
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
150.0
Units Used
0.27
Total Cost
40.5
Transaction Date
2026-03-13T00:00:00.000
1170117
Transaction Id: 1170117 • Contract Number: BG-824M • Work Order Id: 27360805
Transaction Id
1170117
Contract Number
BG-824M
Work Order Id
27360805
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
150.0
Units Used
0.87
Total Cost
130.5
Transaction Date
2026-03-13T00:00:00.000
1170121
Transaction Id: 1170121 • Contract Number: BG-824M • Work Order Id: 26928097
Transaction Id
1170121
Contract Number
BG-824M
Work Order Id
26928097
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
150.0
Units Used
0.77
Total Cost
115.5
Transaction Date
2026-03-13T00:00:00.000
1168672
Transaction Id: 1168672 • Contract Number: QG-324M • Work Order Id: 26411957
Transaction Id
1168672
Contract Number
QG-324M
Work Order Id
26411957
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
39.7
Total Cost
952.8000000000001
Transaction Date
2026-01-07T00:00:00.000
1147888
Transaction Id: 1147888 • Contract Number: BG-824M • Work Order Id: 27385221
Transaction Id
1147888
Contract Number
BG-824M
Work Order Id
27385221
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
45.4
Total Cost
1214.45
Transaction Date
2025-11-25T00:00:00.000
1147889
Transaction Id: 1147889 • Contract Number: BG-824M • Work Order Id: 27385221
Transaction Id
1147889
Contract Number
BG-824M
Work Order Id
27385221
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
1000.0
Units Used
1.0
Total Cost
1000.0
Transaction Date
2025-11-25T00:00:00.000
1162802
Transaction Id: 1162802 • Contract Number: QG-324M • Work Order Id: 26611851
Transaction Id
1162802
Contract Number
QG-324M
Work Order Id
26611851
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
1000.0
Units Used
1.0
Total Cost
1000.0
Transaction Date
2025-12-13T00:00:00.000
1180878
Transaction Id: 1180878 • Contract Number: XG-324M • Work Order Id: 27451510
Transaction Id
1180878
Contract Number
XG-324M
Work Order Id
27451510
Line Item Id
279.0
Item Number
30
Line Item Description
TRANSPLANTING TREES UP TO 4” CALIPER
Unit Of Measure
EA
Unit Price
700.0
Units Used
1.0
Total Cost
700.0
Transaction Date
2026-05-06T00:00:00.000
1180880
Transaction Id: 1180880 • Contract Number: XG-324M • Work Order Id: 27451550
Transaction Id
1180880
Contract Number
XG-324M
Work Order Id
27451550
Line Item Id
279.0
Item Number
30
Line Item Description
TRANSPLANTING TREES UP TO 4” CALIPER
Unit Of Measure
EA
Unit Price
700.0
Units Used
1.0
Total Cost
700.0
Transaction Date
2026-05-06T00:00:00.000
1184003
Transaction Id: 1184003 • Contract Number: BG-724M • Work Order Id: 27275267
Transaction Id
1184003
Contract Number
BG-724M
Work Order Id
27275267
Line Item Id
623.0
Item Number
33
Line Item Description
EXPANSION OF EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
4.8
Total Cost
120.0
Transaction Date
2026-05-14T00:00:00.000
1184005
Transaction Id: 1184005 • Contract Number: BG-724M • Work Order Id: 27271627
Transaction Id
1184005
Contract Number
BG-724M
Work Order Id
27271627
Line Item Id
623.0
Item Number
33
Line Item Description
EXPANSION OF EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
4.8
Total Cost
120.0
Transaction Date
2026-05-14T00:00:00.000
1184007
Transaction Id: 1184007 • Contract Number: BG-724M • Work Order Id: 27235702
Transaction Id
1184007
Contract Number
BG-724M
Work Order Id
27235702
Line Item Id
623.0
Item Number
33
Line Item Description
EXPANSION OF EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
11.3
Total Cost
282.5
Transaction Date
2026-05-14T00:00:00.000
1171351
Transaction Id: 1171351 • Contract Number: QG-424M • Work Order Id: 29089677
Transaction Id
1171351
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
949276
Transaction Id: 949276 • Contract Number: BG-419M • Work Order Id: 6502067
Transaction Id
949276
Contract Number
BG-419M
Work Order Id
6502067
Units Used
0.05
Transaction Date
2020-12-08T00:00:00.000
1133756
Transaction Id: 1133756 • Contract Number: MG-1319MA • Work Order Id: 19806246
Transaction Id
1133756
Contract Number
MG-1319MA
Work Order Id
19806246
Line Item Id
798.0
Item Number
39R
Line Item Description
STEEL TREE BED GUARD - C ®
Unit Of Measure
LF
Unit Price
200.0
Units Used
12.8
Total Cost
2560.0
Transaction Date
2025-10-14T00:00:00.000
1168275
Transaction Id: 1168275 • Contract Number: BG-624M • Work Order Id: 27498294
Transaction Id
1168275
Contract Number
BG-624M
Work Order Id
27498294
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
910.0
Units Used
1.0
Total Cost
910.0
Transaction Date
2026-01-05T00:00:00.000
1185713
Transaction Id: 1185713 • Contract Number: QG-324M • Work Order Id: 29389521
Transaction Id
1185713
Contract Number
QG-324M
Work Order Id
29389521
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
1000.0
Units Used
1.0
Total Cost
1000.0
Transaction Date
2026-06-03T00:00:00.000
746695
Transaction Id: 746695 • Contract Number: QG-215M • Work Order Id: 662897
Transaction Id
746695
Contract Number
QG-215M
Work Order Id
662897
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-12-11T00:00:00.000
749713
Transaction Id: 749713 • Contract Number: BG-115M • Work Order Id: 637447
Transaction Id
749713
Contract Number
BG-115M
Work Order Id
637447
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
75.0
Units Used
16.5
Total Cost
1237.5
Transaction Date
2016-03-01T00:00:00.000
752496
Transaction Id: 752496 • Contract Number: QG-115M • Work Order Id: 1191051
Transaction Id
752496
Contract Number
QG-115M
Work Order Id
1191051
Line Item Id
289.0
Item Number
22
Line Item Description
REMOVE DEBRIS (TREE PIT AND CANOPY)
Unit Of Measure
HR
Unit Price
150.0
Units Used
0.25
Total Cost
37.5
Transaction Date
2015-11-02T00:00:00.000
753070
Transaction Id: 753070 • Contract Number: QG-214M • Work Order Id: 778209
Transaction Id
753070
Contract Number
QG-214M
Work Order Id
778209
Line Item Id
314.0
Item Number
10
Line Item Description
Preparing Lawn Tree Pits
Unit Of Measure
SF
Unit Price
8.0
Units Used
25.0
Total Cost
200.0
Transaction Date
2015-09-28T00:00:00.000
754716
Transaction Id: 754716 • Contract Number: MG-214M • Work Order Id: 1501507
Transaction Id
754716
Contract Number
MG-214M
Work Order Id
1501507
Line Item Id
499.0
Item Number
25
Line Item Description
TOPSOIL FOR TREE PIT AREAS
Unit Of Measure
CF
Unit Price
10.0
Units Used
11.4
Total Cost
114.0
Transaction Date
2015-12-08T00:00:00.000
754968
Transaction Id: 754968 • Contract Number: MG-214M • Work Order Id: 649554
Transaction Id
754968
Contract Number
MG-214M
Work Order Id
649554
Line Item Id
293.0
Item Number
27
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
12.0
Units Used
22.5
Total Cost
270.0
Transaction Date
2015-10-26T00:00:00.000
NYC Data AI • Public-data exploration interface