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
745229
Transaction Id: 745229 • Contract Number: QG-215M • Work Order Id: 703717
Transaction Id
745229
Contract Number
QG-215M
Work Order Id
703717
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
745230
Transaction Id: 745230 • Contract Number: QG-215M • Work Order Id: 703717
Transaction Id
745230
Contract Number
QG-215M
Work Order Id
703717
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
29.2
Total Cost
289.08
Transaction Date
2015-12-21T00:00:00.000
745231
Transaction Id: 745231 • Contract Number: QG-215M • Work Order Id: 662033
Transaction Id
745231
Contract Number
QG-215M
Work Order Id
662033
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-22T00:00:00.000
745232
Transaction Id: 745232 • Contract Number: QG-215M • Work Order Id: 662033
Transaction Id
745232
Contract Number
QG-215M
Work Order Id
662033
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
22.0
Total Cost
242.0
Transaction Date
2015-12-22T00:00:00.000
745235
Transaction Id: 745235 • Contract Number: QG-215M • Work Order Id: 686107
Transaction Id
745235
Contract Number
QG-215M
Work Order Id
686107
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
745236
Transaction Id: 745236 • Contract Number: QG-215M • Work Order Id: 686107
Transaction Id
745236
Contract Number
QG-215M
Work Order Id
686107
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-21T00:00:00.000
745237
Transaction Id: 745237 • Contract Number: QG-215M • Work Order Id: 686107
Transaction Id
745237
Contract Number
QG-215M
Work Order Id
686107
Line Item Id
335.0
Item Number
05
Line Item Description
STUMP REMOVALS OF OVER 30 TO 36 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2015-11-02T00:00:00.000
745238
Transaction Id: 745238 • Contract Number: QG-215M • Work Order Id: 662484
Transaction Id
745238
Contract Number
QG-215M
Work Order Id
662484
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-30T00:00:00.000
745239
Transaction Id: 745239 • Contract Number: QG-215M • Work Order Id: 662484
Transaction Id
745239
Contract Number
QG-215M
Work Order Id
662484
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-11-30T00:00:00.000
745252
Transaction Id: 745252 • Contract Number: QG-215M • Work Order Id: 681349
Transaction Id
745252
Contract Number
QG-215M
Work Order Id
681349
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-04T00:00:00.000
745253
Transaction Id: 745253 • Contract Number: QG-215M • Work Order Id: 681349
Transaction Id
745253
Contract Number
QG-215M
Work Order Id
681349
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-04T00:00:00.000
745254
Transaction Id: 745254 • Contract Number: QG-215M • Work Order Id: 684112
Transaction Id
745254
Contract Number
QG-215M
Work Order Id
684112
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-25T00:00:00.000
745255
Transaction Id: 745255 • Contract Number: QG-215M • Work Order Id: 684112
Transaction Id
745255
Contract Number
QG-215M
Work Order Id
684112
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-11-25T00:00:00.000
745256
Transaction Id: 745256 • Contract Number: QG-215M • Work Order Id: 686125
Transaction Id
745256
Contract Number
QG-215M
Work Order Id
686125
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-25T00:00:00.000
745257
Transaction Id: 745257 • Contract Number: QG-215M • Work Order Id: 686125
Transaction Id
745257
Contract Number
QG-215M
Work Order Id
686125
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-11-25T00:00:00.000
745258
Transaction Id: 745258 • Contract Number: QG-215M • Work Order Id: 682919
Transaction Id
745258
Contract Number
QG-215M
Work Order Id
682919
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-25T00:00:00.000
745259
Transaction Id: 745259 • Contract Number: QG-215M • Work Order Id: 682919
Transaction Id
745259
Contract Number
QG-215M
Work Order Id
682919
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-11-25T00:00:00.000
745260
Transaction Id: 745260 • Contract Number: QG-215M • Work Order Id: 686127
Transaction Id
745260
Contract Number
QG-215M
Work Order Id
686127
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-25T00:00:00.000
745261
Transaction Id: 745261 • Contract Number: QG-215M • Work Order Id: 686127
Transaction Id
745261
Contract Number
QG-215M
Work Order Id
686127
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-11-25T00:00:00.000
745262
Transaction Id: 745262 • Contract Number: QG-215M • Work Order Id: 686919
Transaction Id
745262
Contract Number
QG-215M
Work Order Id
686919
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-25T00:00:00.000
745263
Transaction Id: 745263 • Contract Number: QG-215M • Work Order Id: 686919
Transaction Id
745263
Contract Number
QG-215M
Work Order Id
686919
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-11-25T00:00:00.000
745264
Transaction Id: 745264 • Contract Number: QG-215M • Work Order Id: 685721
Transaction Id
745264
Contract Number
QG-215M
Work Order Id
685721
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
745265
Transaction Id: 745265 • Contract Number: QG-215M • Work Order Id: 685721
Transaction Id
745265
Contract Number
QG-215M
Work Order Id
685721
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
23.0
Total Cost
253.0
Transaction Date
2015-12-21T00:00:00.000
745266
Transaction Id: 745266 • Contract Number: QG-215M • Work Order Id: 701327
Transaction Id
745266
Contract Number
QG-215M
Work Order Id
701327
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
745267
Transaction Id: 745267 • Contract Number: QG-215M • Work Order Id: 701327
Transaction Id
745267
Contract Number
QG-215M
Work Order Id
701327
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
22.0
Total Cost
217.8
Transaction Date
2015-12-21T00:00:00.000
745268
Transaction Id: 745268 • Contract Number: QG-215M • Work Order Id: 681356
Transaction Id
745268
Contract Number
QG-215M
Work Order Id
681356
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-25T00:00:00.000
745269
Transaction Id: 745269 • Contract Number: QG-215M • Work Order Id: 681356
Transaction Id
745269
Contract Number
QG-215M
Work Order Id
681356
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-11-25T00:00:00.000
745270
Transaction Id: 745270 • Contract Number: QG-215M • Work Order Id: 688519
Transaction Id
745270
Contract Number
QG-215M
Work Order Id
688519
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-25T00:00:00.000
745271
Transaction Id: 745271 • Contract Number: QG-215M • Work Order Id: 688519
Transaction Id
745271
Contract Number
QG-215M
Work Order Id
688519
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-11-25T00:00:00.000
745272
Transaction Id: 745272 • Contract Number: QG-215M • Work Order Id: 686925
Transaction Id
745272
Contract Number
QG-215M
Work Order Id
686925
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-25T00:00:00.000
745273
Transaction Id: 745273 • Contract Number: QG-215M • Work Order Id: 686925
Transaction Id
745273
Contract Number
QG-215M
Work Order Id
686925
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-11-25T00:00:00.000
745274
Transaction Id: 745274 • Contract Number: QG-215M • Work Order Id: 684126
Transaction Id
745274
Contract Number
QG-215M
Work Order Id
684126
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-25T00:00:00.000
745275
Transaction Id: 745275 • Contract Number: QG-215M • Work Order Id: 684126
Transaction Id
745275
Contract Number
QG-215M
Work Order Id
684126
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-11-25T00:00:00.000
745276
Transaction Id: 745276 • Contract Number: QG-215M • Work Order Id: 705725
Transaction Id
745276
Contract Number
QG-215M
Work Order Id
705725
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
745277
Transaction Id: 745277 • Contract Number: QG-215M • Work Order Id: 705725
Transaction Id
745277
Contract Number
QG-215M
Work Order Id
705725
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
2016-01-14T00:00:00.000
745278
Transaction Id: 745278 • Contract Number: QG-215M • Work Order Id: 688133
Transaction Id
745278
Contract Number
QG-215M
Work Order Id
688133
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-25T00:00:00.000
745279
Transaction Id: 745279 • Contract Number: QG-215M • Work Order Id: 688133
Transaction Id
745279
Contract Number
QG-215M
Work Order Id
688133
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-11-25T00:00:00.000
745280
Transaction Id: 745280 • Contract Number: QG-215M • Work Order Id: 686140
Transaction Id
745280
Contract Number
QG-215M
Work Order Id
686140
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-03T00:00:00.000
745281
Transaction Id: 745281 • Contract Number: QG-215M • Work Order Id: 686140
Transaction Id
745281
Contract Number
QG-215M
Work Order Id
686140
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-03T00:00:00.000
745282
Transaction Id: 745282 • Contract Number: QG-215M • Work Order Id: 688928
Transaction Id
745282
Contract Number
QG-215M
Work Order Id
688928
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-03T00:00:00.000
745283
Transaction Id: 745283 • Contract Number: QG-215M • Work Order Id: 688928
Transaction Id
745283
Contract Number
QG-215M
Work Order Id
688928
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-03T00:00:00.000
745284
Transaction Id: 745284 • Contract Number: QG-215M • Work Order Id: 684923
Transaction Id
745284
Contract Number
QG-215M
Work Order Id
684923
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-03T00:00:00.000
745285
Transaction Id: 745285 • Contract Number: QG-215M • Work Order Id: 684923
Transaction Id
745285
Contract Number
QG-215M
Work Order Id
684923
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-03T00:00:00.000
745286
Transaction Id: 745286 • Contract Number: QG-215M • Work Order Id: 688527
Transaction Id
745286
Contract Number
QG-215M
Work Order Id
688527
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-03T00:00:00.000
745287
Transaction Id: 745287 • Contract Number: QG-215M • Work Order Id: 688527
Transaction Id
745287
Contract Number
QG-215M
Work Order Id
688527
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-03T00:00:00.000
745288
Transaction Id: 745288 • Contract Number: QG-215M • Work Order Id: 685729
Transaction Id
745288
Contract Number
QG-215M
Work Order Id
685729
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-03T00:00:00.000
745289
Transaction Id: 745289 • Contract Number: QG-215M • Work Order Id: 685729
Transaction Id
745289
Contract Number
QG-215M
Work Order Id
685729
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-03T00:00:00.000
745290
Transaction Id: 745290 • Contract Number: QG-215M • Work Order Id: 688930
Transaction Id
745290
Contract Number
QG-215M
Work Order Id
688930
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-03T00:00:00.000
745291
Transaction Id: 745291 • Contract Number: QG-215M • Work Order Id: 688930
Transaction Id
745291
Contract Number
QG-215M
Work Order Id
688930
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-03T00:00:00.000
745294
Transaction Id: 745294 • Contract Number: QG-215M • Work Order Id: 682531
Transaction Id
745294
Contract Number
QG-215M
Work Order Id
682531
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-03T00:00:00.000