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
1039214
Transaction Id: 1039214 • Contract Number: QG-1119MR • Work Order Id: 21242154
Transaction Id
1039214
Contract Number
QG-1119MR
Work Order Id
21242154
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
41.0
Total Cost
1961.44
Transaction Date
1906-04-06T00:00:00.000
1039215
Transaction Id: 1039215 • Contract Number: QG-1119MR • Work Order Id: 21242154
Transaction Id
1039215
Contract Number
QG-1119MR
Work Order Id
21242154
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.8
Units Used
37.0
Total Cost
1731.6
Transaction Date
1905-12-29T00:00:00.000
1039216
Transaction Id: 1039216 • Contract Number: QG-1119MR • Work Order Id: 21242154
Transaction Id
1039216
Contract Number
QG-1119MR
Work Order Id
21242154
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
1203.0
Total Cost
1563900.0
Transaction Date
6527-01-22T00:00:00.000
1039217
Transaction Id: 1039217 • Contract Number: QG-1119MR • Work Order Id: 19409475
Transaction Id
1039217
Contract Number
QG-1119MR
Work Order Id
19409475
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
41.0
Total Cost
1961.44
Transaction Date
1906-04-06T00:00:00.000
1039218
Transaction Id: 1039218 • Contract Number: QG-1119MR • Work Order Id: 19409475
Transaction Id
1039218
Contract Number
QG-1119MR
Work Order Id
19409475
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.8
Units Used
37.0
Total Cost
1731.6
Transaction Date
1905-12-29T00:00:00.000
1039219
Transaction Id: 1039219 • Contract Number: QG-1119MR • Work Order Id: 19409475
Transaction Id
1039219
Contract Number
QG-1119MR
Work Order Id
19409475
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
1203.0
Total Cost
1563900.0
Transaction Date
6527-01-22T00:00:00.000
1039221
Transaction Id: 1039221 • Contract Number: QG-1119MR • Work Order Id: 20400057
Transaction Id
1039221
Contract Number
QG-1119MR
Work Order Id
20400057
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.8
Units Used
37.0
Total Cost
1731.6
Transaction Date
1902-08-16T00:00:00.000
1039222
Transaction Id: 1039222 • Contract Number: QG-1119MR • Work Order Id: 20400057
Transaction Id
1039222
Contract Number
QG-1119MR
Work Order Id
20400057
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
41.0
Total Cost
1961.44
Transaction Date
1902-01-15T00:00:00.000
1039223
Transaction Id: 1039223 • Contract Number: QG-1119MR • Work Order Id: 20400057
Transaction Id
1039223
Contract Number
QG-1119MR
Work Order Id
20400057
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
1203.0
Total Cost
1563900.0
Transaction Date
1899-12-30T00:00:00.000
1039224
Transaction Id: 1039224 • Contract Number: QG-1119MR • Work Order Id: 20397524
Transaction Id
1039224
Contract Number
QG-1119MR
Work Order Id
20397524
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.8
Units Used
37.0
Total Cost
1731.6
Transaction Date
1902-08-16T00:00:00.000
1039225
Transaction Id: 1039225 • Contract Number: QG-1119MR • Work Order Id: 20397524
Transaction Id
1039225
Contract Number
QG-1119MR
Work Order Id
20397524
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
41.0
Total Cost
1961.44
Transaction Date
1902-01-15T00:00:00.000
1039226
Transaction Id: 1039226 • Contract Number: QG-1119MR • Work Order Id: 20397524
Transaction Id
1039226
Contract Number
QG-1119MR
Work Order Id
20397524
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
1203.0
Total Cost
1563900.0
Transaction Date
1899-12-30T00:00:00.000
1039231
Transaction Id: 1039231 • Contract Number: QG-1119MR • Work Order Id: 20716725
Transaction Id
1039231
Contract Number
QG-1119MR
Work Order Id
20716725
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.8
Units Used
37.0
Total Cost
1731.6
Transaction Date
1902-08-16T00:00:00.000
1039232
Transaction Id: 1039232 • Contract Number: QG-1119MR • Work Order Id: 20716725
Transaction Id
1039232
Contract Number
QG-1119MR
Work Order Id
20716725
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
41.0
Total Cost
1961.44
Transaction Date
1902-01-15T00:00:00.000
1039233
Transaction Id: 1039233 • Contract Number: QG-1119MR • Work Order Id: 20716725
Transaction Id
1039233
Contract Number
QG-1119MR
Work Order Id
20716725
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
1203.0
Total Cost
1563900.0
Transaction Date
1899-12-30T00:00:00.000
1039239
Transaction Id: 1039239 • Contract Number: QG-1119MR • Work Order Id: 20734228
Transaction Id
1039239
Contract Number
QG-1119MR
Work Order Id
20734228
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.8
Units Used
37.0
Total Cost
1731.6
Transaction Date
1902-08-16T00:00:00.000
1039240
Transaction Id: 1039240 • Contract Number: QG-1119MR • Work Order Id: 20734228
Transaction Id
1039240
Contract Number
QG-1119MR
Work Order Id
20734228
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
41.0
Total Cost
1961.44
Transaction Date
1902-01-15T00:00:00.000
1063622
Transaction Id: 1063622 • Contract Number: QG-523M • Work Order Id: 23056345
Transaction Id
1063622
Contract Number
QG-523M
Work Order Id
23056345
Line Item Id
619.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
30.0
Units Used
26.2
Total Cost
786.0
Transaction Date
2024-04-10T00:00:00.000
1113404
Transaction Id: 1113404 • Contract Number: BG-322M • Work Order Id: 25995994
Transaction Id
1113404
Contract Number
BG-322M
Work Order Id
25995994
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-04T00:00:00.000
1039241
Transaction Id: 1039241 • Contract Number: QG-1119MR • Work Order Id: 20734228
Transaction Id
1039241
Contract Number
QG-1119MR
Work Order Id
20734228
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
1203.0
Total Cost
1563900.0
Transaction Date
1899-12-30T00:00:00.000
1039245
Transaction Id: 1039245 • Contract Number: QG-1119MR • Work Order Id: 20937283
Transaction Id
1039245
Contract Number
QG-1119MR
Work Order Id
20937283
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.8
Units Used
37.0
Total Cost
1731.6
Transaction Date
1902-08-16T00:00:00.000
1039246
Transaction Id: 1039246 • Contract Number: QG-1119MR • Work Order Id: 20937283
Transaction Id
1039246
Contract Number
QG-1119MR
Work Order Id
20937283
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
41.0
Total Cost
1961.44
Transaction Date
1902-01-15T00:00:00.000
1039247
Transaction Id: 1039247 • Contract Number: QG-1119MR • Work Order Id: 20937283
Transaction Id
1039247
Contract Number
QG-1119MR
Work Order Id
20937283
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
1203.0
Total Cost
1563900.0
Transaction Date
1899-12-30T00:00:00.000
1039248
Transaction Id: 1039248 • Contract Number: QG-1119MR • Work Order Id: 20937239
Transaction Id
1039248
Contract Number
QG-1119MR
Work Order Id
20937239
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.8
Units Used
37.0
Total Cost
1731.6
Transaction Date
1902-08-16T00:00:00.000
1039251
Transaction Id: 1039251 • Contract Number: QG-1119MR • Work Order Id: 20990044
Transaction Id
1039251
Contract Number
QG-1119MR
Work Order Id
20990044
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.8
Units Used
37.0
Total Cost
1731.6
Transaction Date
1902-08-16T00:00:00.000
1039252
Transaction Id: 1039252 • Contract Number: QG-1119MR • Work Order Id: 20990044
Transaction Id
1039252
Contract Number
QG-1119MR
Work Order Id
20990044
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
41.0
Total Cost
1961.44
Transaction Date
1902-01-15T00:00:00.000
1039253
Transaction Id: 1039253 • Contract Number: QG-1119MR • Work Order Id: 20990044
Transaction Id
1039253
Contract Number
QG-1119MR
Work Order Id
20990044
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
1203.0
Total Cost
1563900.0
Transaction Date
1899-12-30T00:00:00.000
1039258
Transaction Id: 1039258 • Contract Number: QG-1119MR • Work Order Id: 19155469
Transaction Id
1039258
Contract Number
QG-1119MR
Work Order Id
19155469
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
41.0
Total Cost
1961.44
Transaction Date
1902-01-15T00:00:00.000
1041265
Transaction Id: 1041265 • Contract Number: QG-222M • Work Order Id: 21288706
Transaction Id
1041265
Contract Number
QG-222M
Work Order Id
21288706
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
31.5
Total Cost
882.0
Transaction Date
2023-10-09T00:00:00.000
1041267
Transaction Id: 1041267 • Contract Number: QG-222M • Work Order Id: 21288708
Transaction Id
1041267
Contract Number
QG-222M
Work Order Id
21288708
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
31.5
Total Cost
882.0
Transaction Date
2023-10-09T00:00:00.000
1041269
Transaction Id: 1041269 • Contract Number: QG-222M • Work Order Id: 21288709
Transaction Id
1041269
Contract Number
QG-222M
Work Order Id
21288709
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
31.5
Total Cost
882.0
Transaction Date
2023-10-09T00:00:00.000
1041271
Transaction Id: 1041271 • Contract Number: QG-222M • Work Order Id: 21288710
Transaction Id
1041271
Contract Number
QG-222M
Work Order Id
21288710
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
31.5
Total Cost
882.0
Transaction Date
2023-10-09T00:00:00.000
1054074
Transaction Id: 1054074 • Contract Number: BG-422M • Work Order Id: 20582539
Transaction Id
1054074
Contract Number
BG-422M
Work Order Id
20582539
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
18.5
Total Cost
703.0
Transaction Date
2023-11-28T00:00:00.000
1054075
Transaction Id: 1054075 • Contract Number: BG-422M • Work Order Id: 20582539
Transaction Id
1054075
Contract Number
BG-422M
Work Order Id
20582539
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
35.0
Units Used
22.0
Total Cost
770.0
Transaction Date
2023-11-28T00:00:00.000
1047804
Transaction Id: 1047804 • Contract Number: MG-422M • Work Order Id: 21674728
Transaction Id
1047804
Contract Number
MG-422M
Work Order Id
21674728
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
625.0
Units Used
1.0
Total Cost
625.0
Transaction Date
2023-10-26T00:00:00.000
1043222
Transaction Id: 1043222 • Contract Number: MG-322M • Work Order Id: 21726558
Transaction Id
1043222
Contract Number
MG-322M
Work Order Id
21726558
Line Item Id
750.0
Item Number
14
Line Item Description
PLANTING TREES, 15-20 GALLON FABRIC BAGS
Unit Of Measure
EA
Unit Price
800.0
Units Used
1.0
Total Cost
800.0
Transaction Date
2024-05-01T00:00:00.000
1049967
Transaction Id: 1049967 • Contract Number: XG-619M • Work Order Id: 21485226
Transaction Id
1049967
Contract Number
XG-619M
Work Order Id
21485226
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
50.0
Total Cost
2100.0
Transaction Date
2023-12-01T00:00:00.000
1051193
Transaction Id: 1051193 • Contract Number: RG-619MR • Work Order Id: 21403210
Transaction Id
1051193
Contract Number
RG-619MR
Work Order Id
21403210
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
45.0
Total Cost
1170.0
Transaction Date
2023-11-10T00:00:00.000
1051727
Transaction Id: 1051727 • Contract Number: BG-422M • Work Order Id: 16102842
Transaction Id
1051727
Contract Number
BG-422M
Work Order Id
16102842
Line Item Id
650.0
Item Number
16
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
2024-01-03T00:00:00.000
1051560
Transaction Id: 1051560 • Contract Number: BG-422M • Work Order Id: 7700971
Transaction Id
1051560
Contract Number
BG-422M
Work Order Id
7700971
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
38.2
Total Cost
1451.6000000000001
Transaction Date
2023-11-16T00:00:00.000
1052390
Transaction Id: 1052390 • Contract Number: BG-422M • Work Order Id: 20614835
Transaction Id
1052390
Contract Number
BG-422M
Work Order Id
20614835
Line Item Id
650.0
Item Number
16
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
2023-12-28T00:00:00.000
1055073
Transaction Id: 1055073 • Contract Number: BG-222M • Work Order Id: 20696646
Transaction Id
1055073
Contract Number
BG-222M
Work Order Id
20696646
Line Item Id
763.0
Item Number
42R
Line Item Description
STEEL TREE BED GUARD - B (R)
Unit Of Measure
LF
Unit Price
134.0
Units Used
6.2
Total Cost
830.8000000000001
Transaction Date
2023-11-08T00:00:00.000
1060465
Transaction Id: 1060465 • Contract Number: BG-322M • Work Order Id: 18752957
Transaction Id
1060465
Contract Number
BG-322M
Work Order Id
18752957
Line Item Id
616.0
Item Number
09
Line Item Description
TREE REMOVAL OF OVER 12 UP TO AND INCLUDING 18 INCHES DBH
Unit Of Measure
EA
Unit Price
715.0
Units Used
1.0
Total Cost
715.0
Transaction Date
2024-02-27T00:00:00.000
1057031
Transaction Id: 1057031 • Contract Number: QG-1119MR • Work Order Id: 22183162
Transaction Id
1057031
Contract Number
QG-1119MR
Work Order Id
22183162
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-01-03T00:00:00.000
1061301
Transaction Id: 1061301 • Contract Number: MG-1219MA • Work Order Id: 21689796
Transaction Id
1061301
Contract Number
MG-1219MA
Work Order Id
21689796
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
52.0
Units Used
48.3
Total Cost
2511.6
Transaction Date
2024-03-25T00:00:00.000
1062800
Transaction Id: 1062800 • Contract Number: MG-1219MA • Work Order Id: 23202328
Transaction Id
1062800
Contract Number
MG-1219MA
Work Order Id
23202328
Line Item Id
312.0
Item Number
25
Line Item Description
REMOVE AND RESET METAL TREE GUARDS AND GRATES
Unit Of Measure
HR
Unit Price
125.0
Units Used
0.25
Total Cost
31.25
Transaction Date
2024-03-14T00:00:00.000
1063620
Transaction Id: 1063620 • Contract Number: QG-523M • Work Order Id: 23056345
Transaction Id
1063620
Contract Number
QG-523M
Work Order Id
23056345
Line Item Id
757.0
Item Number
28
Line Item Description
PLANTING GROW BAG/PACKAGED TREES 25-35 GAL(CONTRACTOR-PROCURED)
Unit Of Measure
EA
Unit Price
900.0
Units Used
1.0
Total Cost
900.0
Transaction Date
2024-05-08T00:00:00.000
1059332
Transaction Id: 1059332 • Contract Number: QG-1119MR • Work Order Id: 21242163
Transaction Id
1059332
Contract Number
QG-1119MR
Work Order Id
21242163
Line Item Id
626.0
Item Number
26
Line Item Description
TOPSOIL FOR TREE BED AREAS
Unit Of Measure
CF
Unit Price
20.8
Units Used
10.89
Total Cost
226.51200000000003
Transaction Date
2024-01-30T00:00:00.000
1059334
Transaction Id: 1059334 • Contract Number: QG-1119MR • Work Order Id: 21246386
Transaction Id
1059334
Contract Number
QG-1119MR
Work Order Id
21246386
Line Item Id
626.0
Item Number
26
Line Item Description
TOPSOIL FOR TREE BED AREAS
Unit Of Measure
CF
Unit Price
20.8
Units Used
10.89
Total Cost
226.51200000000003
Transaction Date
2024-01-30T00:00:00.000
1059571
Transaction Id: 1059571 • Contract Number: QG-1119MR • Work Order Id: 971052
Transaction Id
1059571
Contract Number
QG-1119MR
Work Order Id
971052
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
53.4
Total Cost
2554.656
Transaction Date
2024-01-11T00:00:00.000
NYC Data AI • Public-data exploration interface