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
746320
Transaction Id: 746320 • Contract Number: QG-215M • Work Order Id: 736548
Transaction Id
746320
Contract Number
QG-215M
Work Order Id
736548
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-15T00:00:00.000
746321
Transaction Id: 746321 • Contract Number: QG-215M • Work Order Id: 736548
Transaction Id
746321
Contract Number
QG-215M
Work Order Id
736548
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
23.0
Total Cost
391.0
Transaction Date
2015-12-10T00:00:00.000
746322
Transaction Id: 746322 • Contract Number: QG-215M • Work Order Id: 736548
Transaction Id
746322
Contract Number
QG-215M
Work Order Id
736548
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
17.0
Total Cost
1054.0
Transaction Date
2016-03-14T00:00:00.000
746323
Transaction Id: 746323 • Contract Number: QG-215M • Work Order Id: 736548
Transaction Id
746323
Contract Number
QG-215M
Work Order Id
736548
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
24.1
Total Cost
289.20000000000005
Transaction Date
2015-12-10T00:00:00.000
746324
Transaction Id: 746324 • Contract Number: QG-215M • Work Order Id: 740942
Transaction Id
746324
Contract Number
QG-215M
Work Order Id
740942
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-21T00:00:00.000
746325
Transaction Id: 746325 • Contract Number: QG-215M • Work Order Id: 740942
Transaction Id
746325
Contract Number
QG-215M
Work Order Id
740942
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.66
Total Cost
878.2199999999999
Transaction Date
2015-11-05T00:00:00.000
746326
Transaction Id: 746326 • Contract Number: QG-215M • Work Order Id: 746139
Transaction Id
746326
Contract Number
QG-215M
Work Order Id
746139
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-21T00:00:00.000
746327
Transaction Id: 746327 • Contract Number: QG-215M • Work Order Id: 746139
Transaction Id
746327
Contract Number
QG-215M
Work Order Id
746139
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
35.6
Total Cost
605.2
Transaction Date
2015-11-05T00:00:00.000
746328
Transaction Id: 746328 • Contract Number: QG-215M • Work Order Id: 748938
Transaction Id
746328
Contract Number
QG-215M
Work Order Id
748938
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-21T00:00:00.000
746329
Transaction Id: 746329 • Contract Number: QG-215M • Work Order Id: 748938
Transaction Id
746329
Contract Number
QG-215M
Work Order Id
748938
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
35.6
Total Cost
605.2
Transaction Date
2015-11-05T00:00:00.000
746330
Transaction Id: 746330 • Contract Number: QG-215M • Work Order Id: 756142
Transaction Id
746330
Contract Number
QG-215M
Work Order Id
756142
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-08T00:00:00.000
746331
Transaction Id: 746331 • Contract Number: QG-215M • Work Order Id: 756142
Transaction Id
746331
Contract Number
QG-215M
Work Order Id
756142
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.5
Total Cost
756.5
Transaction Date
2015-12-08T00:00:00.000
746332
Transaction Id: 746332 • Contract Number: QG-215M • Work Order Id: 751342
Transaction Id
746332
Contract Number
QG-215M
Work Order Id
751342
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-08T00:00:00.000
746333
Transaction Id: 746333 • Contract Number: QG-215M • Work Order Id: 751342
Transaction Id
746333
Contract Number
QG-215M
Work Order Id
751342
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
43.4
Total Cost
737.8
Transaction Date
2015-12-08T00:00:00.000
746550
Transaction Id: 746550 • Contract Number: QG-215M • Work Order Id: 655601
Transaction Id
746550
Contract Number
QG-215M
Work Order Id
655601
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
45.0
Total Cost
450.0
Transaction Date
2015-09-09T00:00:00.000
746342
Transaction Id: 746342 • Contract Number: QG-215M • Work Order Id: 762554
Transaction Id
746342
Contract Number
QG-215M
Work Order Id
762554
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-08T00:00:00.000
746343
Transaction Id: 746343 • Contract Number: QG-215M • Work Order Id: 762554
Transaction Id
746343
Contract Number
QG-215M
Work Order Id
762554
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
38.3
Total Cost
651.0999999999999
Transaction Date
2015-12-08T00:00:00.000
746344
Transaction Id: 746344 • Contract Number: QG-215M • Work Order Id: 762552
Transaction Id
746344
Contract Number
QG-215M
Work Order Id
762552
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-08T00:00:00.000
746345
Transaction Id: 746345 • Contract Number: QG-215M • Work Order Id: 762552
Transaction Id
746345
Contract Number
QG-215M
Work Order Id
762552
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
45.1
Total Cost
766.7
Transaction Date
2015-12-08T00:00:00.000
746346
Transaction Id: 746346 • Contract Number: QG-215M • Work Order Id: 762152
Transaction Id
746346
Contract Number
QG-215M
Work Order Id
762152
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-08T00:00:00.000
746347
Transaction Id: 746347 • Contract Number: QG-215M • Work Order Id: 762152
Transaction Id
746347
Contract Number
QG-215M
Work Order Id
762152
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
45.1
Total Cost
766.7
Transaction Date
2015-12-08T00:00:00.000
746348
Transaction Id: 746348 • Contract Number: QG-215M • Work Order Id: 762952
Transaction Id
746348
Contract Number
QG-215M
Work Order Id
762952
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-08T00:00:00.000
746349
Transaction Id: 746349 • Contract Number: QG-215M • Work Order Id: 762952
Transaction Id
746349
Contract Number
QG-215M
Work Order Id
762952
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
38.7
Total Cost
657.9000000000001
Transaction Date
2015-12-08T00:00:00.000
746352
Transaction Id: 746352 • Contract Number: QG-215M • Work Order Id: 659440
Transaction Id
746352
Contract Number
QG-215M
Work Order Id
659440
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-08T00:00:00.000
746353
Transaction Id: 746353 • Contract Number: QG-215M • Work Order Id: 659440
Transaction Id
746353
Contract Number
QG-215M
Work Order Id
659440
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.4
Total Cost
856.8
Transaction Date
2015-11-06T00:00:00.000
746354
Transaction Id: 746354 • Contract Number: QG-215M • Work Order Id: 664912
Transaction Id
746354
Contract Number
QG-215M
Work Order Id
664912
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-08T00:00:00.000
746355
Transaction Id: 746355 • Contract Number: QG-215M • Work Order Id: 664912
Transaction Id
746355
Contract Number
QG-215M
Work Order Id
664912
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-11-06T00:00:00.000
746356
Transaction Id: 746356 • Contract Number: QG-215M • Work Order Id: 663733
Transaction Id
746356
Contract Number
QG-215M
Work Order Id
663733
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-08T00:00:00.000
746357
Transaction Id: 746357 • Contract Number: QG-215M • Work Order Id: 663733
Transaction Id
746357
Contract Number
QG-215M
Work Order Id
663733
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-11-06T00:00:00.000
746358
Transaction Id: 746358 • Contract Number: QG-215M • Work Order Id: 663727
Transaction Id
746358
Contract Number
QG-215M
Work Order Id
663727
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-08T00:00:00.000
746359
Transaction Id: 746359 • Contract Number: QG-215M • Work Order Id: 663727
Transaction Id
746359
Contract Number
QG-215M
Work Order Id
663727
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-11-06T00:00:00.000
746360
Transaction Id: 746360 • Contract Number: QG-215M • Work Order Id: 651311
Transaction Id
746360
Contract Number
QG-215M
Work Order Id
651311
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
746361
Transaction Id: 746361 • Contract Number: QG-215M • Work Order Id: 651311
Transaction Id
746361
Contract Number
QG-215M
Work Order Id
651311
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
31.9
Total Cost
542.3
Transaction Date
2015-09-14T00:00:00.000
746363
Transaction Id: 746363 • Contract Number: QG-215M • Work Order Id: 649602
Transaction Id
746363
Contract Number
QG-215M
Work Order Id
649602
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
746364
Transaction Id: 746364 • Contract Number: QG-215M • Work Order Id: 649602
Transaction Id
746364
Contract Number
QG-215M
Work Order Id
649602
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.3
Total Cost
753.0999999999999
Transaction Date
2015-09-11T00:00:00.000
746365
Transaction Id: 746365 • Contract Number: QG-215M • Work Order Id: 648451
Transaction Id
746365
Contract Number
QG-215M
Work Order Id
648451
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
746366
Transaction Id: 746366 • Contract Number: QG-215M • Work Order Id: 648451
Transaction Id
746366
Contract Number
QG-215M
Work Order Id
648451
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
35.0
Total Cost
595.0
Transaction Date
2015-09-11T00:00:00.000
746367
Transaction Id: 746367 • Contract Number: QG-215M • Work Order Id: 646720
Transaction Id
746367
Contract Number
QG-215M
Work Order Id
646720
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
746368
Transaction Id: 746368 • Contract Number: QG-215M • Work Order Id: 646720
Transaction Id
746368
Contract Number
QG-215M
Work Order Id
646720
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
28.1
Total Cost
477.70000000000005
Transaction Date
2015-09-11T00:00:00.000
746369
Transaction Id: 746369 • Contract Number: QG-215M • Work Order Id: 646721
Transaction Id
746369
Contract Number
QG-215M
Work Order Id
646721
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
746370
Transaction Id: 746370 • Contract Number: QG-215M • Work Order Id: 646721
Transaction Id
746370
Contract Number
QG-215M
Work Order Id
646721
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
28.1
Total Cost
477.70000000000005
Transaction Date
2015-09-11T00:00:00.000
746371
Transaction Id: 746371 • Contract Number: QG-215M • Work Order Id: 647922
Transaction Id
746371
Contract Number
QG-215M
Work Order Id
647922
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
746372
Transaction Id: 746372 • Contract Number: QG-215M • Work Order Id: 647922
Transaction Id
746372
Contract Number
QG-215M
Work Order Id
647922
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
32.5
Total Cost
552.5
Transaction Date
2015-09-11T00:00:00.000
746373
Transaction Id: 746373 • Contract Number: QG-215M • Work Order Id: 668489
Transaction Id
746373
Contract Number
QG-215M
Work Order Id
668489
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
746374
Transaction Id: 746374 • Contract Number: QG-215M • Work Order Id: 668489
Transaction Id
746374
Contract Number
QG-215M
Work Order Id
668489
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
45.8
Total Cost
778.5999999999999
Transaction Date
2015-09-11T00:00:00.000
746375
Transaction Id: 746375 • Contract Number: QG-215M • Work Order Id: 649847
Transaction Id
746375
Contract Number
QG-215M
Work Order Id
649847
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
746376
Transaction Id: 746376 • Contract Number: QG-215M • Work Order Id: 649847
Transaction Id
746376
Contract Number
QG-215M
Work Order Id
649847
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
40.5
Total Cost
688.5
Transaction Date
2015-09-11T00:00:00.000
746377
Transaction Id: 746377 • Contract Number: QG-215M • Work Order Id: 651963
Transaction Id
746377
Contract Number
QG-215M
Work Order Id
651963
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
746378
Transaction Id: 746378 • Contract Number: QG-215M • Work Order Id: 651963
Transaction Id
746378
Contract Number
QG-215M
Work Order Id
651963
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
43.8
Total Cost
744.5999999999999
Transaction Date
2015-09-14T00:00:00.000
746379
Transaction Id: 746379 • Contract Number: QG-215M • Work Order Id: 651700
Transaction Id
746379
Contract Number
QG-215M
Work Order Id
651700
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