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
1056587
Transaction Id: 1056587 • Contract Number: RG-619MR • Work Order Id: 21403206
Transaction Id
1056587
Contract Number
RG-619MR
Work Order Id
21403206
Line Item Id
620.0
Item Number
11
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
2023-12-29T00:00:00.000
1057128
Transaction Id: 1057128 • Contract Number: BG-1619MR • Work Order Id: 20886753
Transaction Id
1057128
Contract Number
BG-1619MR
Work Order Id
20886753
Line Item Id
721.0
Item Number
34
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
2600.0
Units Used
0.28
Total Cost
728.0000000000001
Transaction Date
2024-01-05T00:00:00.000
1057448
Transaction Id: 1057448 • Contract Number: MG-1219MA • Work Order Id: 19944144
Transaction Id
1057448
Contract Number
MG-1219MA
Work Order Id
19944144
Line Item Id
628.0
Item Number
41
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
110.0
Units Used
15.4
Total Cost
1694.0
Transaction Date
2023-12-20T00:00:00.000
1059306
Transaction Id: 1059306 • Contract Number: BG-222M • Work Order Id: 20688889
Transaction Id
1059306
Contract Number
BG-222M
Work Order Id
20688889
Line Item Id
294.0
Item Number
33
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
1.0
Units Used
0.1
Total Cost
0.1
Transaction Date
2024-01-29T00:00:00.000
1060379
Transaction Id: 1060379 • Contract Number: QG-222M • Work Order Id: 21166974
Transaction Id
1060379
Contract Number
QG-222M
Work Order Id
21166974
Line Item Id
342.0
Item Number
36
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
40.0
Units Used
36.3
Total Cost
1452.0
Transaction Date
2024-02-07T00:00:00.000
1060529
Transaction Id: 1060529 • Contract Number: MG-1319MA • Work Order Id: 13154350
Transaction Id
1060529
Contract Number
MG-1319MA
Work Order Id
13154350
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
51.0
Units Used
36.0
Total Cost
1836.0
Transaction Date
2024-03-22T00:00:00.000
1061131
Transaction Id: 1061131 • Contract Number: MG-1319MA • Work Order Id: 18035773
Transaction Id
1061131
Contract Number
MG-1319MA
Work Order Id
18035773
Line Item Id
465.0
Item Number
34
Line Item Description
CONCRETE CURB
Unit Of Measure
LF
Unit Price
1765.0
Units Used
0.34
Total Cost
600.1
Transaction Date
2025-10-29T00:00:00.000
1061505
Transaction Id: 1061505 • Contract Number: MG-1219MA • Work Order Id: 21743228
Transaction Id
1061505
Contract Number
MG-1219MA
Work Order Id
21743228
Line Item Id
628.0
Item Number
41
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
110.0
Units Used
14.1
Total Cost
1551.0
Transaction Date
2024-08-23T00:00:00.000
1063882
Transaction Id: 1063882 • Contract Number: QG-1119MR • Work Order Id: 21242187
Transaction Id
1063882
Contract Number
QG-1119MR
Work Order Id
21242187
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
43.68
Units Used
36.0
Total Cost
1572.48
Transaction Date
2024-05-02T00:00:00.000
1064926
Transaction Id: 1064926 • Contract Number: XG-122M • Work Order Id: 22267189
Transaction Id
1064926
Contract Number
XG-122M
Work Order Id
22267189
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
36.0
Total Cost
1080.0
Transaction Date
2024-04-25T00:00:00.000
1065102
Transaction Id: 1065102 • Contract Number: XG-122M • Work Order Id: 22316867
Transaction Id
1065102
Contract Number
XG-122M
Work Order Id
22316867
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
36.0
Total Cost
1080.0
Transaction Date
2024-04-25T00:00:00.000
1065154
Transaction Id: 1065154 • Contract Number: XG-122M • Work Order Id: 22405400
Transaction Id
1065154
Contract Number
XG-122M
Work Order Id
22405400
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
25.0
Total Cost
750.0
Transaction Date
2024-04-26T00:00:00.000
1065455
Transaction Id: 1065455 • Contract Number: XG-122M • Work Order Id: 22532243
Transaction Id
1065455
Contract Number
XG-122M
Work Order Id
22532243
Line Item Id
295.0
Item Number
42
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
200.0
Units Used
0.0
Total Cost
0.0
Transaction Date
2024-04-17T00:00:00.000
1066108
Transaction Id: 1066108 • Contract Number: BG-1319M • Work Order Id: 21374355
Transaction Id
1066108
Contract Number
BG-1319M
Work Order Id
21374355
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.0
Units Used
24.0
Total Cost
1104.0
Transaction Date
2024-06-05T00:00:00.000
1066512
Transaction Id: 1066512 • Contract Number: BG-1319M • Work Order Id: 22501158
Transaction Id
1066512
Contract Number
BG-1319M
Work Order Id
22501158
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
43.0
Units Used
28.0
Total Cost
1204.0
Transaction Date
2024-04-25T00:00:00.000
1067378
Transaction Id: 1067378 • Contract Number: BG-1319M • Work Order Id: 22473222
Transaction Id
1067378
Contract Number
BG-1319M
Work Order Id
22473222
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
35.0
Total Cost
1470.0
Transaction Date
2024-05-06T00:00:00.000
1067624
Transaction Id: 1067624 • Contract Number: BG-622M • Work Order Id: 22710038
Transaction Id
1067624
Contract Number
BG-622M
Work Order Id
22710038
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
34.0
Units Used
42.0
Total Cost
1428.0
Transaction Date
2024-03-28T00:00:00.000
1067852
Transaction Id: 1067852 • Contract Number: QG-1219M • Work Order Id: 22460317
Transaction Id
1067852
Contract Number
QG-1219M
Work Order Id
22460317
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
31.5
Total Cost
1165.5
Transaction Date
2024-06-14T00:00:00.000
1069379
Transaction Id: 1069379 • Contract Number: QG-523M • Work Order Id: 22024029
Transaction Id
1069379
Contract Number
QG-523M
Work Order Id
22024029
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
38.8
Total Cost
1164.0
Transaction Date
2024-04-04T00:00:00.000
1071038
Transaction Id: 1071038 • Contract Number: QG-523M • Work Order Id: 21921966
Transaction Id
1071038
Contract Number
QG-523M
Work Order Id
21921966
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
23.9
Total Cost
597.5
Transaction Date
2024-04-17T00:00:00.000
1072097
Transaction Id: 1072097 • Contract Number: QG-423M • Work Order Id: 19935651
Transaction Id
1072097
Contract Number
QG-423M
Work Order Id
19935651
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
27.5
Total Cost
687.5
Transaction Date
2024-04-30T00:00:00.000
1072141
Transaction Id: 1072141 • Contract Number: QG-423M • Work Order Id: 20712856
Transaction Id
1072141
Contract Number
QG-423M
Work Order Id
20712856
Line Item Id
620.0
Item Number
13
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
2024-06-10T00:00:00.000
1072868
Transaction Id: 1072868 • Contract Number: QG-423M • Work Order Id: 23536257
Transaction Id
1072868
Contract Number
QG-423M
Work Order Id
23536257
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
31.5
Total Cost
787.5
Transaction Date
2024-04-23T00:00:00.000
1073076
Transaction Id: 1073076 • Contract Number: QG-322M • Work Order Id: 11217795
Transaction Id
1073076
Contract Number
QG-322M
Work Order Id
11217795
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
24.6
Units Used
36.0
Total Cost
885.6
Transaction Date
2024-04-25T00:00:00.000
1073259
Transaction Id: 1073259 • Contract Number: MG-1319MA • Work Order Id: 22383601
Transaction Id
1073259
Contract Number
MG-1319MA
Work Order Id
22383601
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
10.0
Units Used
9.1
Total Cost
91.0
Transaction Date
2024-04-25T00:00:00.000
1074030
Transaction Id: 1074030 • Contract Number: XG-423M • Work Order Id: 20035416
Transaction Id
1074030
Contract Number
XG-423M
Work Order Id
20035416
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
30.0
Total Cost
600.0
Transaction Date
2024-04-30T00:00:00.000
1074246
Transaction Id: 1074246 • Contract Number: BG-422M • Work Order Id: 23727459
Transaction Id
1074246
Contract Number
BG-422M
Work Order Id
23727459
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
38.0
Units Used
36.0
Total Cost
1368.0
Transaction Date
2024-04-30T00:00:00.000
1074468
Transaction Id: 1074468 • Contract Number: QG-1219M • Work Order Id: 21832973
Transaction Id
1074468
Contract Number
QG-1219M
Work Order Id
21832973
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
32.7
Total Cost
1209.9
Transaction Date
2024-06-25T00:00:00.000
1074686
Transaction Id: 1074686 • Contract Number: QG-1219M • Work Order Id: 22525345
Transaction Id
1074686
Contract Number
QG-1219M
Work Order Id
22525345
Line Item Id
753.0
Item Number
9R
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS (R)
Unit Of Measure
SF
Unit Price
43.0
Units Used
10.0
Total Cost
430.0
Transaction Date
2024-06-20T00:00:00.000
1074731
Transaction Id: 1074731 • Contract Number: QG-1219M • Work Order Id: 23037777
Transaction Id
1074731
Contract Number
QG-1219M
Work Order Id
23037777
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
22.2
Total Cost
821.4
Transaction Date
2024-06-17T00:00:00.000
1076326
Transaction Id: 1076326 • Contract Number: QG-322M • Work Order Id: 22637530
Transaction Id
1076326
Contract Number
QG-322M
Work Order Id
22637530
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
24.6
Units Used
36.0
Total Cost
885.6
Transaction Date
2024-05-06T00:00:00.000
1076547
Transaction Id: 1076547 • Contract Number: XG-619M • Work Order Id: 21468484
Transaction Id
1076547
Contract Number
XG-619M
Work Order Id
21468484
Line Item Id
721.0
Item Number
34
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
500.0
Units Used
0.04
Total Cost
20.0
Transaction Date
2024-07-30T00:00:00.000
1077090
Transaction Id: 1077090 • Contract Number: XG-619M • Work Order Id: 22532126
Transaction Id
1077090
Contract Number
XG-619M
Work Order Id
22532126
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
28.0
Total Cost
1036.0
Transaction Date
2024-05-22T00:00:00.000
1078142
Transaction Id: 1078142 • Contract Number: XG-619M • Work Order Id: 22280164
Transaction Id
1078142
Contract Number
XG-619M
Work Order Id
22280164
Line Item Id
294.0
Item Number
29
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
350.0
Units Used
0.51
Total Cost
178.5
Transaction Date
2024-05-09T00:00:00.000
1080013
Transaction Id: 1080013 • Contract Number: XG-323M • Work Order Id: 22882129
Transaction Id
1080013
Contract Number
XG-323M
Work Order Id
22882129
Units Used
1.0
Transaction Date
2024-05-22T00:00:00.000
1080925
Transaction Id: 1080925 • Contract Number: XG-423M • Work Order Id: 22380917
Transaction Id
1080925
Contract Number
XG-423M
Work Order Id
22380917
Line Item Id
293.0
Item Number
39
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
5.0
Units Used
21.3
Total Cost
106.5
Transaction Date
2024-05-28T00:00:00.000
1081688
Transaction Id: 1081688 • Contract Number: BG-422M • Work Order Id: 22981619
Transaction Id
1081688
Contract Number
BG-422M
Work Order Id
22981619
Line Item Id
293.0
Item Number
32
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
10.0
Units Used
3.2
Total Cost
32.0
Transaction Date
2024-06-06T00:00:00.000
1082910
Transaction Id: 1082910 • Contract Number: BG-719M • Work Order Id: 14222783
Transaction Id
1082910
Contract Number
BG-719M
Work Order Id
14222783
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
10.0
Units Used
27.0
Total Cost
270.0
Transaction Date
2021-12-22T00:00:00.000
1083716
Transaction Id: 1083716 • Contract Number: XG-323M • Work Order Id: 23047545
Transaction Id
1083716
Contract Number
XG-323M
Work Order Id
23047545
Line Item Id
465.0
Item Number
45
Line Item Description
CONCRETE CURB
Unit Of Measure
LF
Unit Price
1600.0
Units Used
0.25
Total Cost
400.0
Transaction Date
2024-06-26T00:00:00.000
1083988
Transaction Id: 1083988 • Contract Number: XG-423M • Work Order Id: 14031843
Transaction Id
1083988
Contract Number
XG-423M
Work Order Id
14031843
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
100.0
Units Used
0.47
Total Cost
47.0
Transaction Date
2024-07-12T00:00:00.000
1084295
Transaction Id: 1084295 • Contract Number: BG-523M • Work Order Id: 24506995
Transaction Id
1084295
Contract Number
BG-523M
Work Order Id
24506995
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
34.0
Units Used
50.0
Total Cost
1700.0
Transaction Date
2024-12-10T00:00:00.000
1084390
Transaction Id: 1084390 • Contract Number: QG-1219M • Work Order Id: 23056295
Transaction Id
1084390
Contract Number
QG-1219M
Work Order Id
23056295
Line Item Id
721.0
Item Number
34
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
500.0
Units Used
0.21
Total Cost
105.0
Transaction Date
2024-07-25T00:00:00.000
1085649
Transaction Id: 1085649 • Contract Number: BG-323M • Work Order Id: 24629181
Transaction Id
1085649
Contract Number
BG-323M
Work Order Id
24629181
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
59.2
Total Cost
2190.4
Transaction Date
2024-10-29T00:00:00.000
1087381
Transaction Id: 1087381 • Contract Number: IHTP - Pilot • Work Order Id: 24673643
Transaction Id
1087381
Contract Number
IHTP - Pilot
Work Order Id
24673643
Line Item Id
620.0
Item Number
10
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Units Used
25.0
Transaction Date
2025-03-10T00:00:00.000
1089022
Transaction Id: 1089022 • Contract Number: BG-323M • Work Order Id: 22866455
Transaction Id
1089022
Contract Number
BG-323M
Work Order Id
22866455
Line Item Id
292.0
Item Number
38
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
15.0
Units Used
1.2
Total Cost
18.0
Transaction Date
2024-12-07T00:00:00.000
1089747
Transaction Id: 1089747 • Contract Number: BG-323M • Work Order Id: 24815856
Transaction Id
1089747
Contract Number
BG-323M
Work Order Id
24815856
Line Item Id
629.0
Item Number
50
Line Item Description
STEEL TREE BED GUARD - C
Unit Of Measure
LF
Unit Price
90.0
Units Used
19.0
Total Cost
1710.0
Transaction Date
2025-03-14T00:00:00.000
1091856
Transaction Id: 1091856 • Contract Number: XG-423M • Work Order Id: 24370023
Transaction Id
1091856
Contract Number
XG-423M
Work Order Id
24370023
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
38.3
Total Cost
766.0
Transaction Date
2024-10-21T00:00:00.000
1092630
Transaction Id: 1092630 • Contract Number: XG-423M • Work Order Id: 24629993
Transaction Id
1092630
Contract Number
XG-423M
Work Order Id
24629993
Line Item Id
721.0
Item Number
45
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
1850.0
Units Used
0.1
Total Cost
185.0
Transaction Date
2025-02-14T00:00:00.000
1092679
Transaction Id: 1092679 • Contract Number: XG-423M • Work Order Id: 24755851
Transaction Id
1092679
Contract Number
XG-423M
Work Order Id
24755851
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
13.9
Total Cost
1278.8
Transaction Date
2025-03-13T00:00:00.000
1093867
Transaction Id: 1093867 • Contract Number: QG-1119MR • Work Order Id: 21333842
Transaction Id
1093867
Contract Number
QG-1119MR
Work Order Id
21333842
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
43.68
Units Used
33.8
Total Cost
1476.3839999999998
Transaction Date
2024-11-18T00:00:00.000
NYC Data AI • Public-data exploration interface