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
745170
Transaction Id: 745170 • Contract Number: QG-215M • Work Order Id: 686502
Transaction Id
745170
Contract Number
QG-215M
Work Order Id
686502
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-21T00:00:00.000
745172
Transaction Id: 745172 • Contract Number: QG-215M • Work Order Id: 957049
Transaction Id
745172
Contract Number
QG-215M
Work Order Id
957049
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
745173
Transaction Id: 745173 • Contract Number: QG-215M • Work Order Id: 957049
Transaction Id
745173
Contract Number
QG-215M
Work Order Id
957049
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
745177
Transaction Id: 745177 • Contract Number: QG-215M • Work Order Id: 698113
Transaction Id
745177
Contract Number
QG-215M
Work Order Id
698113
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-09-29T00:00:00.000
745178
Transaction Id: 745178 • Contract Number: QG-215M • Work Order Id: 698113
Transaction Id
745178
Contract Number
QG-215M
Work Order Id
698113
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
28.0
Total Cost
277.2
Transaction Date
2015-09-11T00:00:00.000
745179
Transaction Id: 745179 • Contract Number: QG-215M • Work Order Id: 644441
Transaction Id
745179
Contract Number
QG-215M
Work Order Id
644441
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-09-17T00:00:00.000
745180
Transaction Id: 745180 • Contract Number: QG-215M • Work Order Id: 644441
Transaction Id
745180
Contract Number
QG-215M
Work Order Id
644441
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-09-14T00:00:00.000
745181
Transaction Id: 745181 • Contract Number: QG-215M • Work Order Id: 692138
Transaction Id
745181
Contract Number
QG-215M
Work Order Id
692138
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-09-17T00:00:00.000
745182
Transaction Id: 745182 • Contract Number: QG-215M • Work Order Id: 692138
Transaction Id
745182
Contract Number
QG-215M
Work Order Id
692138
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-09-14T00:00:00.000
745183
Transaction Id: 745183 • Contract Number: QG-215M • Work Order Id: 690534
Transaction Id
745183
Contract Number
QG-215M
Work Order Id
690534
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-09-17T00:00:00.000
745184
Transaction Id: 745184 • Contract Number: QG-215M • Work Order Id: 690534
Transaction Id
745184
Contract Number
QG-215M
Work Order Id
690534
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-09-14T00:00:00.000
745185
Transaction Id: 745185 • Contract Number: QG-215M • Work Order Id: 692942
Transaction Id
745185
Contract Number
QG-215M
Work Order Id
692942
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-01T00:00:00.000
745186
Transaction Id: 745186 • Contract Number: QG-215M • Work Order Id: 692942
Transaction Id
745186
Contract Number
QG-215M
Work Order Id
692942
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
48.0
Total Cost
475.20000000000005
Transaction Date
2015-09-15T00:00:00.000
745187
Transaction Id: 745187 • Contract Number: QG-215M • Work Order Id: 668491
Transaction Id
745187
Contract Number
QG-215M
Work Order Id
668491
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
745188
Transaction Id: 745188 • Contract Number: QG-215M • Work Order Id: 668491
Transaction Id
745188
Contract Number
QG-215M
Work Order Id
668491
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-28T00:00:00.000
745189
Transaction Id: 745189 • Contract Number: QG-215M • Work Order Id: 668491
Transaction Id
745189
Contract Number
QG-215M
Work Order Id
668491
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-12-28T00:00:00.000
745192
Transaction Id: 745192 • Contract Number: QG-215M • Work Order Id: 666090
Transaction Id
745192
Contract Number
QG-215M
Work Order Id
666090
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
745193
Transaction Id: 745193 • Contract Number: QG-215M • Work Order Id: 666090
Transaction Id
745193
Contract Number
QG-215M
Work Order Id
666090
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
745194
Transaction Id: 745194 • Contract Number: QG-215M • Work Order Id: 666090
Transaction Id
745194
Contract Number
QG-215M
Work Order Id
666090
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-09-30T00:00:00.000
745195
Transaction Id: 745195 • Contract Number: QG-215M • Work Order Id: 975444
Transaction Id
745195
Contract Number
QG-215M
Work Order Id
975444
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-15T00:00:00.000
745196
Transaction Id: 745196 • Contract Number: QG-215M • Work Order Id: 975444
Transaction Id
745196
Contract Number
QG-215M
Work Order Id
975444
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
16.5
Total Cost
163.35
Transaction Date
2016-01-15T00:00:00.000
745197
Transaction Id: 745197 • Contract Number: QG-215M • Work Order Id: 975444
Transaction Id
745197
Contract Number
QG-215M
Work Order Id
975444
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
75.0
Units Used
1.0
Total Cost
75.0
Transaction Date
2015-10-02T00:00:00.000
745198
Transaction Id: 745198 • Contract Number: QG-215M • Work Order Id: 702913
Transaction Id
745198
Contract Number
QG-215M
Work Order Id
702913
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-13T00:00:00.000
745199
Transaction Id: 745199 • Contract Number: QG-215M • Work Order Id: 702913
Transaction Id
745199
Contract Number
QG-215M
Work Order Id
702913
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
2016-01-13T00:00:00.000
745200
Transaction Id: 745200 • Contract Number: QG-215M • Work Order Id: 663688
Transaction Id
745200
Contract Number
QG-215M
Work Order Id
663688
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-16T00:00:00.000
745201
Transaction Id: 745201 • Contract Number: QG-215M • Work Order Id: 663688
Transaction Id
745201
Contract Number
QG-215M
Work Order Id
663688
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-16T00:00:00.000
745202
Transaction Id: 745202 • Contract Number: QG-215M • Work Order Id: 698518
Transaction Id
745202
Contract Number
QG-215M
Work Order Id
698518
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-16T00:00:00.000
745203
Transaction Id: 745203 • Contract Number: QG-215M • Work Order Id: 698518
Transaction Id
745203
Contract Number
QG-215M
Work Order Id
698518
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
37.3
Total Cost
410.29999999999995
Transaction Date
2015-12-16T00:00:00.000
745205
Transaction Id: 745205 • Contract Number: QG-215M • Work Order Id: 701325
Transaction Id
745205
Contract Number
QG-215M
Work Order Id
701325
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
26.5
Total Cost
262.35
Transaction Date
2015-11-27T00:00:00.000
745207
Transaction Id: 745207 • Contract Number: QG-215M • Work Order Id: 703312
Transaction Id
745207
Contract Number
QG-215M
Work Order Id
703312
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
26.5
Total Cost
262.35
Transaction Date
2015-11-27T00:00:00.000
745208
Transaction Id: 745208 • Contract Number: QG-215M • Work Order Id: 816652
Transaction Id
745208
Contract Number
QG-215M
Work Order Id
816652
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-16T00:00:00.000
745209
Transaction Id: 745209 • Contract Number: QG-215M • Work Order Id: 816652
Transaction Id
745209
Contract Number
QG-215M
Work Order Id
816652
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
37.9
Total Cost
416.9
Transaction Date
2015-12-16T00:00:00.000
745211
Transaction Id: 745211 • Contract Number: QG-215M • Work Order Id: 661277
Transaction Id
745211
Contract Number
QG-215M
Work Order Id
661277
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-09-24T00:00:00.000
745212
Transaction Id: 745212 • Contract Number: QG-215M • Work Order Id: 661277
Transaction Id
745212
Contract Number
QG-215M
Work Order Id
661277
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
28.5
Total Cost
282.15000000000003
Transaction Date
2015-09-24T00:00:00.000
745213
Transaction Id: 745213 • Contract Number: QG-215M • Work Order Id: 661277
Transaction Id
745213
Contract Number
QG-215M
Work Order Id
661277
Line Item Id
304.0
Item Number
04
Line Item Description
STUMP REMOVALS OF OVER 24 TO 30 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
175.0
Units Used
1.0
Total Cost
175.0
Transaction Date
2015-09-24T00:00:00.000
745214
Transaction Id: 745214 • Contract Number: QG-215M • Work Order Id: 660908
Transaction Id
745214
Contract Number
QG-215M
Work Order Id
660908
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-09-24T00:00:00.000
745215
Transaction Id: 745215 • Contract Number: QG-215M • Work Order Id: 660908
Transaction Id
745215
Contract Number
QG-215M
Work Order Id
660908
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
20.0
Total Cost
220.0
Transaction Date
2015-09-24T00:00:00.000
745216
Transaction Id: 745216 • Contract Number: QG-215M • Work Order Id: 698121
Transaction Id
745216
Contract Number
QG-215M
Work Order Id
698121
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
745217
Transaction Id: 745217 • Contract Number: QG-215M • Work Order Id: 698121
Transaction Id
745217
Contract Number
QG-215M
Work Order Id
698121
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
34.4
Total Cost
340.56
Transaction Date
2015-09-18T00:00:00.000
745218
Transaction Id: 745218 • Contract Number: QG-215M • Work Order Id: 698123
Transaction Id
745218
Contract Number
QG-215M
Work Order Id
698123
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-30T00:00:00.000
745219
Transaction Id: 745219 • Contract Number: QG-215M • Work Order Id: 698123
Transaction Id
745219
Contract Number
QG-215M
Work Order Id
698123
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
28.1
Total Cost
278.19
Transaction Date
2015-12-30T00:00:00.000
745220
Transaction Id: 745220 • Contract Number: QG-215M • Work Order Id: 701720
Transaction Id
745220
Contract Number
QG-215M
Work Order Id
701720
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-19T00:00:00.000
745221
Transaction Id: 745221 • Contract Number: QG-215M • Work Order Id: 701720
Transaction Id
745221
Contract Number
QG-215M
Work Order Id
701720
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-19T00:00:00.000
745222
Transaction Id: 745222 • Contract Number: QG-215M • Work Order Id: 700919
Transaction Id
745222
Contract Number
QG-215M
Work Order Id
700919
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-21T00:00:00.000
745223
Transaction Id: 745223 • Contract Number: QG-215M • Work Order Id: 700919
Transaction Id
745223
Contract Number
QG-215M
Work Order Id
700919
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
28.0
Total Cost
277.2
Transaction Date
2015-12-21T00:00:00.000
745224
Transaction Id: 745224 • Contract Number: QG-215M • Work Order Id: 666915
Transaction Id
745224
Contract Number
QG-215M
Work Order Id
666915
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-21T00:00:00.000
745225
Transaction Id: 745225 • Contract Number: QG-215M • Work Order Id: 666915
Transaction Id
745225
Contract Number
QG-215M
Work Order Id
666915
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
45.0
Total Cost
445.5
Transaction Date
2015-12-21T00:00:00.000
745226
Transaction Id: 745226 • Contract Number: QG-215M • Work Order Id: 666915
Transaction Id
745226
Contract Number
QG-215M
Work Order Id
666915
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
745227
Transaction Id: 745227 • Contract Number: QG-215M • Work Order Id: 700920
Transaction Id
745227
Contract Number
QG-215M
Work Order Id
700920
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-21T00:00:00.000
745228
Transaction Id: 745228 • Contract Number: QG-215M • Work Order Id: 700920
Transaction Id
745228
Contract Number
QG-215M
Work Order Id
700920
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
33.0
Total Cost
326.7
Transaction Date
2015-12-21T00:00:00.000