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
746380
Transaction Id: 746380 • Contract Number: QG-215M • Work Order Id: 651700
Transaction Id
746380
Contract Number
QG-215M
Work Order Id
651700
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
36.4
Total Cost
618.8
Transaction Date
2015-09-14T00:00:00.000
746383
Transaction Id: 746383 • Contract Number: QG-215M • Work Order Id: 651967
Transaction Id
746383
Contract Number
QG-215M
Work Order Id
651967
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
746384
Transaction Id: 746384 • Contract Number: QG-215M • Work Order Id: 651967
Transaction Id
746384
Contract Number
QG-215M
Work Order Id
651967
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.0
Total Cost
544.0
Transaction Date
2015-09-14T00:00:00.000
746385
Transaction Id: 746385 • Contract Number: QG-215M • Work Order Id: 655609
Transaction Id
746385
Contract Number
QG-215M
Work Order Id
655609
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
746386
Transaction Id: 746386 • Contract Number: QG-215M • Work Order Id: 655609
Transaction Id
746386
Contract Number
QG-215M
Work Order Id
655609
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
36.1
Total Cost
613.7
Transaction Date
2015-09-14T00:00:00.000
746387
Transaction Id: 746387 • Contract Number: QG-215M • Work Order Id: 655614
Transaction Id
746387
Contract Number
QG-215M
Work Order Id
655614
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
746388
Transaction Id: 746388 • Contract Number: QG-215M • Work Order Id: 655614
Transaction Id
746388
Contract Number
QG-215M
Work Order Id
655614
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
33.3
Total Cost
566.0999999999999
Transaction Date
2015-09-14T00:00:00.000
746389
Transaction Id: 746389 • Contract Number: QG-215M • Work Order Id: 654036
Transaction Id
746389
Contract Number
QG-215M
Work Order Id
654036
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-25T00:00:00.000
746390
Transaction Id: 746390 • Contract Number: QG-215M • Work Order Id: 654036
Transaction Id
746390
Contract Number
QG-215M
Work Order Id
654036
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.4
Total Cost
584.8
Transaction Date
2015-09-25T00:00:00.000
746391
Transaction Id: 746391 • Contract Number: QG-215M • Work Order Id: 651853
Transaction Id
746391
Contract Number
QG-215M
Work Order Id
651853
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-25T00:00:00.000
746392
Transaction Id: 746392 • Contract Number: QG-215M • Work Order Id: 651853
Transaction Id
746392
Contract Number
QG-215M
Work Order Id
651853
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
37.0
Total Cost
629.0
Transaction Date
2015-09-25T00:00:00.000
746393
Transaction Id: 746393 • Contract Number: QG-215M • Work Order Id: 651855
Transaction Id
746393
Contract Number
QG-215M
Work Order Id
651855
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-25T00:00:00.000
746394
Transaction Id: 746394 • Contract Number: QG-215M • Work Order Id: 651855
Transaction Id
746394
Contract Number
QG-215M
Work Order Id
651855
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
36.1
Total Cost
613.7
Transaction Date
2015-09-25T00:00:00.000
746395
Transaction Id: 746395 • Contract Number: QG-215M • Work Order Id: 818238
Transaction Id
746395
Contract Number
QG-215M
Work Order Id
818238
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-25T00:00:00.000
746396
Transaction Id: 746396 • Contract Number: QG-215M • Work Order Id: 818238
Transaction Id
746396
Contract Number
QG-215M
Work Order Id
818238
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-25T00:00:00.000
746397
Transaction Id: 746397 • Contract Number: QG-215M • Work Order Id: 641787
Transaction Id
746397
Contract Number
QG-215M
Work Order Id
641787
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-21T00:00:00.000
746398
Transaction Id: 746398 • Contract Number: QG-215M • Work Order Id: 641787
Transaction Id
746398
Contract Number
QG-215M
Work Order Id
641787
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
29.5
Total Cost
501.5
Transaction Date
2015-09-17T00:00:00.000
746399
Transaction Id: 746399 • Contract Number: QG-215M • Work Order Id: 652121
Transaction Id
746399
Contract Number
QG-215M
Work Order Id
652121
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-21T00:00:00.000
746400
Transaction Id: 746400 • Contract Number: QG-215M • Work Order Id: 652121
Transaction Id
746400
Contract Number
QG-215M
Work Order Id
652121
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
48.5
Total Cost
824.5
Transaction Date
2015-09-17T00:00:00.000
746401
Transaction Id: 746401 • Contract Number: QG-215M • Work Order Id: 656426
Transaction Id
746401
Contract Number
QG-215M
Work Order Id
656426
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
746402
Transaction Id: 746402 • Contract Number: QG-215M • Work Order Id: 656426
Transaction Id
746402
Contract Number
QG-215M
Work Order Id
656426
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
33.0
Total Cost
561.0
Transaction Date
2015-09-17T00:00:00.000
746403
Transaction Id: 746403 • Contract Number: QG-215M • Work Order Id: 656427
Transaction Id
746403
Contract Number
QG-215M
Work Order Id
656427
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
746404
Transaction Id: 746404 • Contract Number: QG-215M • Work Order Id: 656427
Transaction Id
746404
Contract Number
QG-215M
Work Order Id
656427
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.0
Total Cost
680.0
Transaction Date
2015-09-17T00:00:00.000
746407
Transaction Id: 746407 • Contract Number: QG-215M • Work Order Id: 653174
Transaction Id
746407
Contract Number
QG-215M
Work Order Id
653174
Line Item Id
538.0
Item Number
07
Line Item Description
TREE REMOVAL OF OVER 12 TO 18 INCHES DBH
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2016-03-21T00:00:00.000
746408
Transaction Id: 746408 • Contract Number: QG-215M • Work Order Id: 655632
Transaction Id
746408
Contract Number
QG-215M
Work Order Id
655632
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
2016-04-30T00:00:00.000
746411
Transaction Id: 746411 • Contract Number: QG-215M • Work Order Id: 651891
Transaction Id
746411
Contract Number
QG-215M
Work Order Id
651891
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
746412
Transaction Id: 746412 • Contract Number: QG-215M • Work Order Id: 651891
Transaction Id
746412
Contract Number
QG-215M
Work Order Id
651891
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
41.2
Total Cost
700.4000000000001
Transaction Date
2015-09-22T00:00:00.000
746413
Transaction Id: 746413 • Contract Number: QG-215M • Work Order Id: 652159
Transaction Id
746413
Contract Number
QG-215M
Work Order Id
652159
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
746414
Transaction Id: 746414 • Contract Number: QG-215M • Work Order Id: 652159
Transaction Id
746414
Contract Number
QG-215M
Work Order Id
652159
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.3
Total Cost
736.0999999999999
Transaction Date
2015-09-22T00:00:00.000
746415
Transaction Id: 746415 • Contract Number: QG-215M • Work Order Id: 652159
Transaction Id
746415
Contract Number
QG-215M
Work Order Id
652159
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
16.0
Total Cost
992.0
Transaction Date
2016-03-21T00:00:00.000
746416
Transaction Id: 746416 • Contract Number: QG-215M • Work Order Id: 662013
Transaction Id
746416
Contract Number
QG-215M
Work Order Id
662013
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
746417
Transaction Id: 746417 • Contract Number: QG-215M • Work Order Id: 662013
Transaction Id
746417
Contract Number
QG-215M
Work Order Id
662013
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
45.1
Total Cost
487.08000000000004
Transaction Date
2015-11-24T00:00:00.000
746418
Transaction Id: 746418 • Contract Number: QG-215M • Work Order Id: 662013
Transaction Id
746418
Contract Number
QG-215M
Work Order Id
662013
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-09-30T00:00:00.000
746420
Transaction Id: 746420 • Contract Number: QG-215M • Work Order Id: 658834
Transaction Id
746420
Contract Number
QG-215M
Work Order Id
658834
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
46.7
Total Cost
560.4000000000001
Transaction Date
2015-11-24T00:00:00.000
746421
Transaction Id: 746421 • Contract Number: QG-215M • Work Order Id: 653245
Transaction Id
746421
Contract Number
QG-215M
Work Order Id
653245
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
746422
Transaction Id: 746422 • Contract Number: QG-215M • Work Order Id: 653245
Transaction Id
746422
Contract Number
QG-215M
Work Order Id
653245
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.3
Total Cost
600.0999999999999
Transaction Date
2015-09-22T00:00:00.000
746423
Transaction Id: 746423 • Contract Number: QG-215M • Work Order Id: 651511
Transaction Id
746423
Contract Number
QG-215M
Work Order Id
651511
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
746424
Transaction Id: 746424 • Contract Number: QG-215M • Work Order Id: 651511
Transaction Id
746424
Contract Number
QG-215M
Work Order Id
651511
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.4
Total Cost
584.8
Transaction Date
2015-09-22T00:00:00.000
746426
Transaction Id: 746426 • Contract Number: QG-215M • Work Order Id: 647545
Transaction Id
746426
Contract Number
QG-215M
Work Order Id
647545
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
15.3
Units Used
26.3
Total Cost
402.39000000000004
Transaction Date
2015-09-22T00:00:00.000
746428
Transaction Id: 746428 • Contract Number: QG-215M • Work Order Id: 659223
Transaction Id
746428
Contract Number
QG-215M
Work Order Id
659223
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
746429
Transaction Id: 746429 • Contract Number: QG-215M • Work Order Id: 661628
Transaction Id
746429
Contract Number
QG-215M
Work Order Id
661628
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
746430
Transaction Id: 746430 • Contract Number: QG-215M • Work Order Id: 661628
Transaction Id
746430
Contract Number
QG-215M
Work Order Id
661628
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
26.5
Total Cost
318.0
Transaction Date
2016-01-13T00:00:00.000
746433
Transaction Id: 746433 • Contract Number: QG-215M • Work Order Id: 645547
Transaction Id
746433
Contract Number
QG-215M
Work Order Id
645547
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
746434
Transaction Id: 746434 • Contract Number: QG-215M • Work Order Id: 645547
Transaction Id
746434
Contract Number
QG-215M
Work Order Id
645547
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.7
Total Cost
793.9000000000001
Transaction Date
2015-09-18T00:00:00.000
746435
Transaction Id: 746435 • Contract Number: QG-215M • Work Order Id: 644825
Transaction Id
746435
Contract Number
QG-215M
Work Order Id
644825
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
746436
Transaction Id: 746436 • Contract Number: QG-215M • Work Order Id: 644825
Transaction Id
746436
Contract Number
QG-215M
Work Order Id
644825
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.1
Total Cost
783.7
Transaction Date
2015-09-18T00:00:00.000
746437
Transaction Id: 746437 • Contract Number: QG-215M • Work Order Id: 639818
Transaction Id
746437
Contract Number
QG-215M
Work Order Id
639818
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-21T00:00:00.000
746438
Transaction Id: 746438 • Contract Number: QG-215M • Work Order Id: 639818
Transaction Id
746438
Contract Number
QG-215M
Work Order Id
639818
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.1
Total Cost
783.7
Transaction Date
2015-09-18T00:00:00.000
746439
Transaction Id: 746439 • Contract Number: QG-215M • Work Order Id: 695737
Transaction Id
746439
Contract Number
QG-215M
Work Order Id
695737
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-21T00:00:00.000
746440
Transaction Id: 746440 • Contract Number: QG-215M • Work Order Id: 695737
Transaction Id
746440
Contract Number
QG-215M
Work Order Id
695737
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-17T00:00:00.000