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
747160
Transaction Id: 747160 • Contract Number: QG-215M • Work Order Id: 669315
Transaction Id
747160
Contract Number
QG-215M
Work Order Id
669315
Line Item Id
286.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
95.0
Units Used
1.0
Total Cost
95.0
Transaction Date
2015-11-02T00:00:00.000
747161
Transaction Id: 747161 • Contract Number: QG-215M • Work Order Id: 697714
Transaction Id
747161
Contract Number
QG-215M
Work Order Id
697714
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-12-28T00:00:00.000
747162
Transaction Id: 747162 • Contract Number: QG-215M • Work Order Id: 697714
Transaction Id
747162
Contract Number
QG-215M
Work Order Id
697714
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
20.0
Total Cost
198.0
Transaction Date
2015-12-28T00:00:00.000
747163
Transaction Id: 747163 • Contract Number: QG-215M • Work Order Id: 699317
Transaction Id
747163
Contract Number
QG-215M
Work Order Id
699317
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-12-31T00:00:00.000
747164
Transaction Id: 747164 • Contract Number: QG-215M • Work Order Id: 699317
Transaction Id
747164
Contract Number
QG-215M
Work Order Id
699317
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
24.0
Total Cost
237.60000000000002
Transaction Date
2015-12-31T00:00:00.000
747165
Transaction Id: 747165 • Contract Number: QG-215M • Work Order Id: 700114
Transaction Id
747165
Contract Number
QG-215M
Work Order Id
700114
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-24T00:00:00.000
747166
Transaction Id: 747166 • Contract Number: QG-215M • Work Order Id: 700114
Transaction Id
747166
Contract Number
QG-215M
Work Order Id
700114
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
32.9
Total Cost
325.71
Transaction Date
2015-09-14T00:00:00.000
747167
Transaction Id: 747167 • Contract Number: QG-215M • Work Order Id: 704111
Transaction Id
747167
Contract Number
QG-215M
Work Order Id
704111
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-24T00:00:00.000
747168
Transaction Id: 747168 • Contract Number: QG-215M • Work Order Id: 704111
Transaction Id
747168
Contract Number
QG-215M
Work Order Id
704111
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
24.0
Total Cost
237.60000000000002
Transaction Date
2015-11-24T00:00:00.000
747169
Transaction Id: 747169 • Contract Number: QG-215M • Work Order Id: 704112
Transaction Id
747169
Contract Number
QG-215M
Work Order Id
704112
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-24T00:00:00.000
747170
Transaction Id: 747170 • Contract Number: QG-215M • Work Order Id: 704112
Transaction Id
747170
Contract Number
QG-215M
Work Order Id
704112
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
24.0
Total Cost
237.60000000000002
Transaction Date
2015-11-24T00:00:00.000
747171
Transaction Id: 747171 • Contract Number: QG-215M • Work Order Id: 699717
Transaction Id
747171
Contract Number
QG-215M
Work Order Id
699717
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-24T00:00:00.000
747172
Transaction Id: 747172 • Contract Number: QG-215M • Work Order Id: 699717
Transaction Id
747172
Contract Number
QG-215M
Work Order Id
699717
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
24.0
Total Cost
237.60000000000002
Transaction Date
2015-11-24T00:00:00.000
747176
Transaction Id: 747176 • Contract Number: QG-215M • Work Order Id: 699314
Transaction Id
747176
Contract Number
QG-215M
Work Order Id
699314
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2016-01-14T00:00:00.000
747177
Transaction Id: 747177 • Contract Number: QG-215M • Work Order Id: 699314
Transaction Id
747177
Contract Number
QG-215M
Work Order Id
699314
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
10.8
Units Used
56.7
Total Cost
612.3600000000001
Transaction Date
2016-01-14T00:00:00.000
747178
Transaction Id: 747178 • Contract Number: QG-215M • Work Order Id: 699314
Transaction Id
747178
Contract Number
QG-215M
Work Order Id
699314
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
18.8
Total Cost
1353.6000000000001
Transaction Date
2016-03-14T00:00:00.000
747179
Transaction Id: 747179 • Contract Number: QG-215M • Work Order Id: 668515
Transaction Id
747179
Contract Number
QG-215M
Work Order Id
668515
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2016-01-14T00:00:00.000
747180
Transaction Id: 747180 • Contract Number: QG-215M • Work Order Id: 668515
Transaction Id
747180
Contract Number
QG-215M
Work Order Id
668515
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
34.7
Total Cost
416.40000000000003
Transaction Date
2016-01-14T00:00:00.000
747181
Transaction Id: 747181 • Contract Number: QG-215M • Work Order Id: 668515
Transaction Id
747181
Contract Number
QG-215M
Work Order Id
668515
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
15.8
Total Cost
1137.6000000000001
Transaction Date
2016-03-14T00:00:00.000
747182
Transaction Id: 747182 • Contract Number: QG-215M • Work Order Id: 651539
Transaction Id
747182
Contract Number
QG-215M
Work Order Id
651539
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-12-28T00:00:00.000
747188
Transaction Id: 747188 • Contract Number: QG-215M • Work Order Id: 650726
Transaction Id
747188
Contract Number
QG-215M
Work Order Id
650726
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
747189
Transaction Id: 747189 • Contract Number: QG-215M • Work Order Id: 650726
Transaction Id
747189
Contract Number
QG-215M
Work Order Id
650726
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
44.7
Total Cost
759.9000000000001
Transaction Date
2015-09-14T00:00:00.000
747190
Transaction Id: 747190 • Contract Number: QG-215M • Work Order Id: 649929
Transaction Id
747190
Contract Number
QG-215M
Work Order Id
649929
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
747191
Transaction Id: 747191 • Contract Number: QG-215M • Work Order Id: 649929
Transaction Id
747191
Contract Number
QG-215M
Work Order Id
649929
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
46.6
Total Cost
792.2
Transaction Date
2015-09-14T00:00:00.000
747192
Transaction Id: 747192 • Contract Number: QG-215M • Work Order Id: 649742
Transaction Id
747192
Contract Number
QG-215M
Work Order Id
649742
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
747193
Transaction Id: 747193 • Contract Number: QG-215M • Work Order Id: 649742
Transaction Id
747193
Contract Number
QG-215M
Work Order Id
649742
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
747194
Transaction Id: 747194 • Contract Number: QG-215M • Work Order Id: 649758
Transaction Id
747194
Contract Number
QG-215M
Work Order Id
649758
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
747195
Transaction Id: 747195 • Contract Number: QG-215M • Work Order Id: 649758
Transaction Id
747195
Contract Number
QG-215M
Work Order Id
649758
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
26.2
Total Cost
445.4
Transaction Date
2015-09-09T00:00:00.000
747196
Transaction Id: 747196 • Contract Number: QG-215M • Work Order Id: 651204
Transaction Id
747196
Contract Number
QG-215M
Work Order Id
651204
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
747197
Transaction Id: 747197 • Contract Number: QG-215M • Work Order Id: 651204
Transaction Id
747197
Contract Number
QG-215M
Work Order Id
651204
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
50.0
Total Cost
850.0
Transaction Date
2015-09-09T00:00:00.000
747198
Transaction Id: 747198 • Contract Number: QG-215M • Work Order Id: 651612
Transaction Id
747198
Contract Number
QG-215M
Work Order Id
651612
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
747199
Transaction Id: 747199 • Contract Number: QG-215M • Work Order Id: 651612
Transaction Id
747199
Contract Number
QG-215M
Work Order Id
651612
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
50.0
Total Cost
850.0
Transaction Date
2015-09-09T00:00:00.000
747200
Transaction Id: 747200 • Contract Number: QG-215M • Work Order Id: 651207
Transaction Id
747200
Contract Number
QG-215M
Work Order Id
651207
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
747201
Transaction Id: 747201 • Contract Number: QG-215M • Work Order Id: 651207
Transaction Id
747201
Contract Number
QG-215M
Work Order Id
651207
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
50.0
Total Cost
850.0
Transaction Date
2015-09-09T00:00:00.000
747202
Transaction Id: 747202 • Contract Number: QG-215M • Work Order Id: 647835
Transaction Id
747202
Contract Number
QG-215M
Work Order Id
647835
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
747203
Transaction Id: 747203 • Contract Number: QG-215M • Work Order Id: 647835
Transaction Id
747203
Contract Number
QG-215M
Work Order Id
647835
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
50.0
Total Cost
850.0
Transaction Date
2015-09-11T00:00:00.000
747204
Transaction Id: 747204 • Contract Number: QG-215M • Work Order Id: 661613
Transaction Id
747204
Contract Number
QG-215M
Work Order Id
661613
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-06T00:00:00.000
747205
Transaction Id: 747205 • Contract Number: QG-215M • Work Order Id: 661613
Transaction Id
747205
Contract Number
QG-215M
Work Order Id
661613
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
56.9
Total Cost
967.3
Transaction Date
2015-09-17T00:00:00.000
747206
Transaction Id: 747206 • Contract Number: QG-215M • Work Order Id: 649844
Transaction Id
747206
Contract Number
QG-215M
Work Order Id
649844
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
747207
Transaction Id: 747207 • Contract Number: QG-215M • Work Order Id: 649844
Transaction Id
747207
Contract Number
QG-215M
Work Order Id
649844
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
34.1
Total Cost
579.7
Transaction Date
2015-09-11T00:00:00.000
747208
Transaction Id: 747208 • Contract Number: QG-215M • Work Order Id: 648751
Transaction Id
747208
Contract Number
QG-215M
Work Order Id
648751
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
747209
Transaction Id: 747209 • Contract Number: QG-215M • Work Order Id: 648751
Transaction Id
747209
Contract Number
QG-215M
Work Order Id
648751
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
46.3
Total Cost
787.0999999999999
Transaction Date
2015-09-14T00:00:00.000
747210
Transaction Id: 747210 • Contract Number: QG-215M • Work Order Id: 817836
Transaction Id
747210
Contract Number
QG-215M
Work Order Id
817836
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-20T00:00:00.000
747211
Transaction Id: 747211 • Contract Number: QG-215M • Work Order Id: 817836
Transaction Id
747211
Contract Number
QG-215M
Work Order Id
817836
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
51.7
Total Cost
878.9000000000001
Transaction Date
2015-09-09T00:00:00.000
747215
Transaction Id: 747215 • Contract Number: QG-215M • Work Order Id: 971049
Transaction Id
747215
Contract Number
QG-215M
Work Order Id
971049
Line Item Id
342.0
Item Number
30
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
10.0
Units Used
35.3
Total Cost
353.0
Transaction Date
2015-09-10T00:00:00.000
747220
Transaction Id: 747220 • Contract Number: QG-215M • Work Order Id: 658834
Transaction Id
747220
Contract Number
QG-215M
Work Order Id
658834
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-11-24T00:00:00.000
747221
Transaction Id: 747221 • Contract Number: QG-215M • Work Order Id: 668958
Transaction Id
747221
Contract Number
QG-215M
Work Order Id
668958
Line Item Id
297.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
125.0
Units Used
1.0
Total Cost
125.0
Transaction Date
2015-09-21T00:00:00.000
747222
Transaction Id: 747222 • Contract Number: QG-215M • Work Order Id: 647545
Transaction Id
747222
Contract Number
QG-215M
Work Order Id
647545
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-05T00:00:00.000
747223
Transaction Id: 747223 • Contract Number: QG-215M • Work Order Id: 651436
Transaction Id
747223
Contract Number
QG-215M
Work Order Id
651436
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-07T00:00:00.000
747224
Transaction Id: 747224 • Contract Number: QG-215M • Work Order Id: 651436
Transaction Id
747224
Contract Number
QG-215M
Work Order Id
651436
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
47.8
Total Cost
812.5999999999999
Transaction Date
2015-09-15T00:00:00.000
NYC Data AI • Public-data exploration interface