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
1063078
Transaction Id: 1063078 • Contract Number: QG-1119MR • Work Order Id: 19358338
Transaction Id
1063078
Contract Number
QG-1119MR
Work Order Id
19358338
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2024-05-28T00:00:00.000
1068800
Transaction Id: 1068800 • Contract Number: XG-122M • Work Order Id: 22316843
Transaction Id
1068800
Contract Number
XG-122M
Work Order Id
22316843
Line Item Id
613.0
Item Number
05
Line Item Description
STUMP REMOVALS OF OVER 24 UP TO AND INCLUDING 30 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
1100.0
Units Used
1.0
Total Cost
1100.0
Transaction Date
2024-03-27T00:00:00.000
1063279
Transaction Id: 1063279 • Contract Number: QG-1119MR • Work Order Id: 20990005
Transaction Id
1063279
Contract Number
QG-1119MR
Work Order Id
20990005
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
30.0
Total Cost
1435.2
Transaction Date
2024-05-13T00:00:00.000
1070012
Transaction Id: 1070012 • Contract Number: BG-322M • Work Order Id: 18783370
Transaction Id
1070012
Contract Number
BG-322M
Work Order Id
18783370
Line Item Id
295.0
Item Number
42
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
210.0
Units Used
1.39
Total Cost
291.9
Transaction Date
2024-04-09T00:00:00.000
1070952
Transaction Id: 1070952 • Contract Number: BG-322M • Work Order Id: 18753251
Transaction Id
1070952
Contract Number
BG-322M
Work Order Id
18753251
Line Item Id
295.0
Item Number
42
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
210.0
Units Used
1.39
Total Cost
291.9
Transaction Date
2024-04-11T00:00:00.000
1070953
Transaction Id: 1070953 • Contract Number: BG-322M • Work Order Id: 18783368
Transaction Id
1070953
Contract Number
BG-322M
Work Order Id
18783368
Line Item Id
295.0
Item Number
42
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
210.0
Units Used
1.39
Total Cost
291.9
Transaction Date
2024-04-11T00:00:00.000
1070954
Transaction Id: 1070954 • Contract Number: BG-322M • Work Order Id: 18783367
Transaction Id
1070954
Contract Number
BG-322M
Work Order Id
18783367
Line Item Id
295.0
Item Number
42
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
210.0
Units Used
1.39
Total Cost
291.9
Transaction Date
2024-04-11T00:00:00.000
1070955
Transaction Id: 1070955 • Contract Number: BG-322M • Work Order Id: 18783369
Transaction Id
1070955
Contract Number
BG-322M
Work Order Id
18783369
Line Item Id
295.0
Item Number
42
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
210.0
Units Used
1.39
Total Cost
291.9
Transaction Date
2024-04-11T00:00:00.000
1063859
Transaction Id: 1063859 • Contract Number: QG-1119MR • Work Order Id: 20500787
Transaction Id
1063859
Contract Number
QG-1119MR
Work Order Id
20500787
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2024-05-06T00:00:00.000
1073585
Transaction Id: 1073585 • Contract Number: BG-322M • Work Order Id: 23727668
Transaction Id
1073585
Contract Number
BG-322M
Work Order Id
23727668
Line Item Id
295.0
Item Number
42
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
210.0
Units Used
2.0
Total Cost
420.0
Transaction Date
2024-04-26T00:00:00.000
1073675
Transaction Id: 1073675 • Contract Number: MG-1319MA • Work Order Id: 18035772
Transaction Id
1073675
Contract Number
MG-1319MA
Work Order Id
18035772
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.8
Units Used
50.0
Total Cost
2290.0
Transaction Date
2024-04-04T00:00:00.000
1073676
Transaction Id: 1073676 • Contract Number: MG-1319MA • Work Order Id: 18035772
Transaction Id
1073676
Contract Number
MG-1319MA
Work Order Id
18035772
Line Item Id
295.0
Item Number
30
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
590.0
Units Used
0.3
Total Cost
177.0
Transaction Date
2024-04-04T00:00:00.000
1061447
Transaction Id: 1061447 • Contract Number: MG-1219MA • Work Order Id: 21740276
Transaction Id
1061447
Contract Number
MG-1219MA
Work Order Id
21740276
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
48.0
Units Used
25.0
Total Cost
1200.0
Transaction Date
2024-04-09T00:00:00.000
1063619
Transaction Id: 1063619 • Contract Number: QG-523M • Work Order Id: 23056345
Transaction Id
1063619
Contract Number
QG-523M
Work Order Id
23056345
Line Item Id
614.0
Item Number
6
Line Item Description
STUMP REMOVALS OF OVER 30 UP TO AND INCLUDING 36 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
1600.0
Units Used
1.0
Total Cost
1600.0
Transaction Date
2024-03-21T00:00:00.000
1074402
Transaction Id: 1074402 • Contract Number: QG-1219M • Work Order Id: 21801736
Transaction Id
1074402
Contract Number
QG-1219M
Work Order Id
21801736
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1200.0
Units Used
1.0
Total Cost
1200.0
Transaction Date
2024-06-29T00:00:00.000
1080633
Transaction Id: 1080633 • Contract Number: BG-323M • Work Order Id: 17401509
Transaction Id
1080633
Contract Number
BG-323M
Work Order Id
17401509
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
2024-05-28T00:00:00.000
1085301
Transaction Id: 1085301 • Contract Number: BG-323M • Work Order Id: 24252954
Transaction Id
1085301
Contract Number
BG-323M
Work Order Id
24252954
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
50.0
Total Cost
1850.0
Transaction Date
2024-10-22T00:00:00.000
1083063
Transaction Id: 1083063 • Contract Number: MG-1319MA • Work Order Id: 23955626
Transaction Id
1083063
Contract Number
MG-1319MA
Work Order Id
23955626
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
50.0
Units Used
21.0
Total Cost
1050.0
Transaction Date
2024-06-19T00:00:00.000
1083298
Transaction Id: 1083298 • Contract Number: QG-1119MR • Work Order Id: 19412887
Transaction Id
1083298
Contract Number
QG-1119MR
Work Order Id
19412887
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2024-05-28T00:00:00.000
1083318
Transaction Id: 1083318 • Contract Number: MG-1319MA • Work Order Id: 15508967
Transaction Id
1083318
Contract Number
MG-1319MA
Work Order Id
15508967
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
50.0
Units Used
36.0
Total Cost
1800.0
Transaction Date
2024-06-21T00:00:00.000
1083319
Transaction Id: 1083319 • Contract Number: MG-1319MA • Work Order Id: 15508967
Transaction Id
1083319
Contract Number
MG-1319MA
Work Order Id
15508967
Line Item Id
295.0
Item Number
30
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
590.0
Units Used
1.0
Total Cost
590.0
Transaction Date
2024-06-21T00:00:00.000
1083352
Transaction Id: 1083352 • Contract Number: MG-1319MA • Work Order Id: 23698234
Transaction Id
1083352
Contract Number
MG-1319MA
Work Order Id
23698234
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
50.0
Units Used
18.0
Total Cost
900.0
Transaction Date
2024-06-26T00:00:00.000
1083353
Transaction Id: 1083353 • Contract Number: MG-1319MA • Work Order Id: 23698234
Transaction Id
1083353
Contract Number
MG-1319MA
Work Order Id
23698234
Line Item Id
295.0
Item Number
30
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
590.0
Units Used
0.7
Total Cost
413.0
Transaction Date
2024-06-26T00:00:00.000
1083528
Transaction Id: 1083528 • Contract Number: MG-1319MA • Work Order Id: 24115980
Transaction Id
1083528
Contract Number
MG-1319MA
Work Order Id
24115980
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
50.0
Units Used
18.0
Total Cost
900.0
Transaction Date
2024-06-26T00:00:00.000
1083533
Transaction Id: 1083533 • Contract Number: MG-1319MA • Work Order Id: 24115979
Transaction Id
1083533
Contract Number
MG-1319MA
Work Order Id
24115979
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
50.0
Units Used
18.0
Total Cost
900.0
Transaction Date
2024-06-26T00:00:00.000
1083536
Transaction Id: 1083536 • Contract Number: MG-1319MA • Work Order Id: 24115979
Transaction Id
1083536
Contract Number
MG-1319MA
Work Order Id
24115979
Line Item Id
295.0
Item Number
30
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
590.0
Units Used
1.1
Total Cost
649.0
Transaction Date
2024-06-26T00:00:00.000
1083538
Transaction Id: 1083538 • Contract Number: MG-1319MA • Work Order Id: 24115980
Transaction Id
1083538
Contract Number
MG-1319MA
Work Order Id
24115980
Line Item Id
295.0
Item Number
30
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
590.0
Units Used
0.5
Total Cost
295.0
Transaction Date
2024-06-26T00:00:00.000
1018211
Transaction Id: 1018211 • Contract Number: MG-1319MA • Work Order Id: 9278929
Transaction Id
1018211
Contract Number
MG-1319MA
Work Order Id
9278929
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1117.0
Units Used
0.0
Total Cost
0.0
Transaction Date
2024-07-01T00:00:00.000
1018213
Transaction Id: 1018213 • Contract Number: MG-1319MA • Work Order Id: 9278930
Transaction Id
1018213
Contract Number
MG-1319MA
Work Order Id
9278930
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1117.0
Units Used
0.0
Total Cost
0.0
Transaction Date
2024-07-01T00:00:00.000
1061954
Transaction Id: 1061954 • Contract Number: MG-1219MA • Work Order Id: 22027038
Transaction Id
1061954
Contract Number
MG-1219MA
Work Order Id
22027038
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
19.8
Total Cost
2178.0
Transaction Date
2024-08-22T00:00:00.000
1061963
Transaction Id: 1061963 • Contract Number: MG-1219MA • Work Order Id: 22027039
Transaction Id
1061963
Contract Number
MG-1219MA
Work Order Id
22027039
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
19.5
Total Cost
2145.0
Transaction Date
2024-08-22T00:00:00.000
1064326
Transaction Id: 1064326 • Contract Number: QG-1119MR • Work Order Id: 20968430
Transaction Id
1064326
Contract Number
QG-1119MR
Work Order Id
20968430
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2024-05-03T00:00:00.000
1081586
Transaction Id: 1081586 • Contract Number: BG-323M • Work Order Id: 23347976
Transaction Id
1081586
Contract Number
BG-323M
Work Order Id
23347976
Units Used
1.0
Transaction Date
2024-06-05T00:00:00.000
1089811
Transaction Id: 1089811 • Contract Number: BG-323M • Work Order Id: 24818382
Transaction Id
1089811
Contract Number
BG-323M
Work Order Id
24818382
Line Item Id
743.0
Item Number
16
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS WITH CITY-PROCURED SOIL
Unit Of Measure
SF
Unit Price
35.0
Units Used
43.8
Total Cost
1533.0
Transaction Date
2024-11-29T00:00:00.000
1091055
Transaction Id: 1091055 • Contract Number: QG-523M • Work Order Id: 25198985
Transaction Id
1091055
Contract Number
QG-523M
Work Order Id
25198985
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
33.3
Total Cost
998.9999999999999
Transaction Date
2024-10-18T00:00:00.000
1084260
Transaction Id: 1084260 • Contract Number: QG-1119MR • Work Order Id: 22261900
Transaction Id
1084260
Contract Number
QG-1119MR
Work Order Id
22261900
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2024-07-03T00:00:00.000
1098389
Transaction Id: 1098389 • Contract Number: BG-523M • Work Order Id: 24436902
Transaction Id
1098389
Contract Number
BG-523M
Work Order Id
24436902
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
350.0
Units Used
1.0
Total Cost
350.0
Transaction Date
2024-11-01T00:00:00.000
1103267
Transaction Id: 1103267 • Contract Number: XG-423M • Work Order Id: 24547485
Transaction Id
1103267
Contract Number
XG-423M
Work Order Id
24547485
Line Item Id
758.0
Item Number
29
Line Item Description
PLANTING GROW BAG/PACKAGED TREES 35-45 GAL (CONTRACTOR-PROCURED)
Unit Of Measure
EA
Unit Price
1475.0
Units Used
0.25
Total Cost
368.75
Transaction Date
2024-11-26T00:00:00.000
1031562
Transaction Id: 1031562 • Contract Number: QG-422M • Work Order Id: 19740926
Transaction Id
1031562
Contract Number
QG-422M
Work Order Id
19740926
Line Item Id
549.0
Item Number
14®
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CAL (R)
Unit Of Measure
EA
Unit Price
1000.0
Units Used
1.0
Total Cost
1000.0
Transaction Date
2023-06-02T00:00:00.000
1096715
Transaction Id: 1096715 • Contract Number: XG-323M • Work Order Id: 24369503
Transaction Id
1096715
Contract Number
XG-323M
Work Order Id
24369503
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
1560.0
Units Used
1.0
Total Cost
1560.0
Transaction Date
2024-12-13T00:00:00.000
1097157
Transaction Id: 1097157 • Contract Number: XG-323M • Work Order Id: 24916394
Transaction Id
1097157
Contract Number
XG-323M
Work Order Id
24916394
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
100.0
Units Used
2.51
Total Cost
250.99999999999997
Transaction Date
2024-11-22T00:00:00.000
1099871
Transaction Id: 1099871 • Contract Number: CNYG-1420MR • Work Order Id: 22627331
Transaction Id
1099871
Contract Number
CNYG-1420MR
Work Order Id
22627331
Line Item Id
627.0
Item Number
01
Line Item Description
STEEL TREE BED GUARD - A
Unit Of Measure
LF
Unit Price
102.13
Units Used
16.17
Total Cost
1651.4421000000002
Transaction Date
2024-11-06T00:00:00.000
1113305
Transaction Id: 1113305 • Contract Number: BG-322M • Work Order Id: 26027647
Transaction Id
1113305
Contract Number
BG-322M
Work Order Id
26027647
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
30.0
Total Cost
840.0
Transaction Date
2025-04-02T00:00:00.000
1113306
Transaction Id: 1113306 • Contract Number: BG-322M • Work Order Id: 26027653
Transaction Id
1113306
Contract Number
BG-322M
Work Order Id
26027653
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-02T00:00:00.000
1113307
Transaction Id: 1113307 • Contract Number: BG-322M • Work Order Id: 26027651
Transaction Id
1113307
Contract Number
BG-322M
Work Order Id
26027651
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.5
Total Cost
210.0
Transaction Date
2025-04-02T00:00:00.000
1113308
Transaction Id: 1113308 • Contract Number: BG-322M • Work Order Id: 26027641
Transaction Id
1113308
Contract Number
BG-322M
Work Order Id
26027641
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-02T00:00:00.000
1113309
Transaction Id: 1113309 • Contract Number: BG-322M • Work Order Id: 26027652
Transaction Id
1113309
Contract Number
BG-322M
Work Order Id
26027652
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.0
Total Cost
252.0
Transaction Date
2025-04-02T00:00:00.000
1113310
Transaction Id: 1113310 • Contract Number: BG-322M • Work Order Id: 26027642
Transaction Id
1113310
Contract Number
BG-322M
Work Order Id
26027642
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-02T00:00:00.000
1113311
Transaction Id: 1113311 • Contract Number: BG-322M • Work Order Id: 26027646
Transaction Id
1113311
Contract Number
BG-322M
Work Order Id
26027646
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.5
Total Cost
266.0
Transaction Date
2025-04-02T00:00:00.000
1113312
Transaction Id: 1113312 • Contract Number: BG-322M • Work Order Id: 26027640
Transaction Id
1113312
Contract Number
BG-322M
Work Order Id
26027640
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.5
Total Cost
294.0
Transaction Date
2025-04-02T00:00:00.000
NYC Data AI • Public-data exploration interface