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
747595
Transaction Id: 747595 • Contract Number: BG-415M • Work Order Id: 667326
Transaction Id
747595
Contract Number
BG-415M
Work Order Id
667326
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-06T00:00:00.000
747596
Transaction Id: 747596 • Contract Number: BG-415M • Work Order Id: 668118
Transaction Id
747596
Contract Number
BG-415M
Work Order Id
668118
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
42.8
Total Cost
599.1999999999999
Transaction Date
2015-10-23T00:00:00.000
747597
Transaction Id: 747597 • Contract Number: BG-415M • Work Order Id: 668118
Transaction Id
747597
Contract Number
BG-415M
Work Order Id
668118
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-01-12T00:00:00.000
747598
Transaction Id: 747598 • Contract Number: BG-415M • Work Order Id: 669705
Transaction Id
747598
Contract Number
BG-415M
Work Order Id
669705
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
34.6
Total Cost
484.40000000000003
Transaction Date
2015-10-21T00:00:00.000
747599
Transaction Id: 747599 • Contract Number: BG-415M • Work Order Id: 669705
Transaction Id
747599
Contract Number
BG-415M
Work Order Id
669705
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-09T00:00:00.000
747600
Transaction Id: 747600 • Contract Number: BG-415M • Work Order Id: 666923
Transaction Id
747600
Contract Number
BG-415M
Work Order Id
666923
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
37.3
Total Cost
522.1999999999999
Transaction Date
2015-11-06T00:00:00.000
747601
Transaction Id: 747601 • Contract Number: BG-415M • Work Order Id: 666923
Transaction Id
747601
Contract Number
BG-415M
Work Order Id
666923
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-11T00:00:00.000
747602
Transaction Id: 747602 • Contract Number: BG-415M • Work Order Id: 666100
Transaction Id
747602
Contract Number
BG-415M
Work Order Id
666100
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
34.7
Total Cost
485.80000000000007
Transaction Date
2015-11-06T00:00:00.000
747603
Transaction Id: 747603 • Contract Number: BG-415M • Work Order Id: 666100
Transaction Id
747603
Contract Number
BG-415M
Work Order Id
666100
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-01-07T00:00:00.000
747604
Transaction Id: 747604 • Contract Number: BG-415M • Work Order Id: 665393
Transaction Id
747604
Contract Number
BG-415M
Work Order Id
665393
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
48.8
Total Cost
683.1999999999999
Transaction Date
2015-10-29T00:00:00.000
747605
Transaction Id: 747605 • Contract Number: BG-415M • Work Order Id: 665393
Transaction Id
747605
Contract Number
BG-415M
Work Order Id
665393
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-21T00:00:00.000
747606
Transaction Id: 747606 • Contract Number: BG-415M • Work Order Id: 666102
Transaction Id
747606
Contract Number
BG-415M
Work Order Id
666102
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
43.6
Total Cost
610.4
Transaction Date
2015-10-29T00:00:00.000
747607
Transaction Id: 747607 • Contract Number: BG-415M • Work Order Id: 666102
Transaction Id
747607
Contract Number
BG-415M
Work Order Id
666102
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-05T00:00:00.000
747608
Transaction Id: 747608 • Contract Number: BG-415M • Work Order Id: 667335
Transaction Id
747608
Contract Number
BG-415M
Work Order Id
667335
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
42.1
Total Cost
589.4
Transaction Date
2015-10-29T00:00:00.000
747609
Transaction Id: 747609 • Contract Number: BG-415M • Work Order Id: 667335
Transaction Id
747609
Contract Number
BG-415M
Work Order Id
667335
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-05T00:00:00.000
747610
Transaction Id: 747610 • Contract Number: BG-415M • Work Order Id: 668531
Transaction Id
747610
Contract Number
BG-415M
Work Order Id
668531
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
35.4
Total Cost
495.59999999999997
Transaction Date
2015-10-29T00:00:00.000
747611
Transaction Id: 747611 • Contract Number: BG-415M • Work Order Id: 668531
Transaction Id
747611
Contract Number
BG-415M
Work Order Id
668531
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-21T00:00:00.000
747612
Transaction Id: 747612 • Contract Number: BG-415M • Work Order Id: 665397
Transaction Id
747612
Contract Number
BG-415M
Work Order Id
665397
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
50.0
Total Cost
700.0
Transaction Date
2015-10-29T00:00:00.000
747613
Transaction Id: 747613 • Contract Number: BG-415M • Work Order Id: 665397
Transaction Id
747613
Contract Number
BG-415M
Work Order Id
665397
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-10T00:00:00.000
747614
Transaction Id: 747614 • Contract Number: BG-415M • Work Order Id: 665723
Transaction Id
747614
Contract Number
BG-415M
Work Order Id
665723
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
39.6
Total Cost
554.4
Transaction Date
2015-10-29T00:00:00.000
747615
Transaction Id: 747615 • Contract Number: BG-415M • Work Order Id: 665723
Transaction Id
747615
Contract Number
BG-415M
Work Order Id
665723
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-06T00:00:00.000
747616
Transaction Id: 747616 • Contract Number: BG-415M • Work Order Id: 669713
Transaction Id
747616
Contract Number
BG-415M
Work Order Id
669713
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
47.9
Total Cost
670.6
Transaction Date
2015-10-29T00:00:00.000
747617
Transaction Id: 747617 • Contract Number: BG-415M • Work Order Id: 669713
Transaction Id
747617
Contract Number
BG-415M
Work Order Id
669713
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-06T00:00:00.000
747618
Transaction Id: 747618 • Contract Number: BG-415M • Work Order Id: 670114
Transaction Id
747618
Contract Number
BG-415M
Work Order Id
670114
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
41.3
Total Cost
578.1999999999999
Transaction Date
2015-10-27T00:00:00.000
747619
Transaction Id: 747619 • Contract Number: BG-415M • Work Order Id: 670114
Transaction Id
747619
Contract Number
BG-415M
Work Order Id
670114
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-06T00:00:00.000
747620
Transaction Id: 747620 • Contract Number: BG-415M • Work Order Id: 667341
Transaction Id
747620
Contract Number
BG-415M
Work Order Id
667341
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
50.4
Total Cost
705.6
Transaction Date
2015-10-27T00:00:00.000
747621
Transaction Id: 747621 • Contract Number: BG-415M • Work Order Id: 667341
Transaction Id
747621
Contract Number
BG-415M
Work Order Id
667341
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-01-06T00:00:00.000
747622
Transaction Id: 747622 • Contract Number: BG-415M • Work Order Id: 668954
Transaction Id
747622
Contract Number
BG-415M
Work Order Id
668954
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
41.6
Total Cost
582.4
Transaction Date
2015-10-23T00:00:00.000
747623
Transaction Id: 747623 • Contract Number: BG-415M • Work Order Id: 668954
Transaction Id
747623
Contract Number
BG-415M
Work Order Id
668954
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-10T00:00:00.000
747624
Transaction Id: 747624 • Contract Number: BG-415M • Work Order Id: 668538
Transaction Id
747624
Contract Number
BG-415M
Work Order Id
668538
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
26.3
Total Cost
368.2
Transaction Date
2015-10-23T00:00:00.000
747625
Transaction Id: 747625 • Contract Number: BG-415M • Work Order Id: 668538
Transaction Id
747625
Contract Number
BG-415M
Work Order Id
668538
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-10T00:00:00.000
747626
Transaction Id: 747626 • Contract Number: BG-415M • Work Order Id: 667737
Transaction Id
747626
Contract Number
BG-415M
Work Order Id
667737
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
45.0
Total Cost
630.0
Transaction Date
2015-10-21T00:00:00.000
747627
Transaction Id: 747627 • Contract Number: BG-415M • Work Order Id: 667737
Transaction Id
747627
Contract Number
BG-415M
Work Order Id
667737
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-12-19T00:00:00.000
747628
Transaction Id: 747628 • Contract Number: BG-415M • Work Order Id: 670884
Transaction Id
747628
Contract Number
BG-415M
Work Order Id
670884
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
45.4
Total Cost
635.6
Transaction Date
2015-10-21T00:00:00.000
747629
Transaction Id: 747629 • Contract Number: BG-415M • Work Order Id: 670884
Transaction Id
747629
Contract Number
BG-415M
Work Order Id
670884
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-12-19T00:00:00.000
747630
Transaction Id: 747630 • Contract Number: BG-415M • Work Order Id: 672086
Transaction Id
747630
Contract Number
BG-415M
Work Order Id
672086
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
27.4
Total Cost
383.59999999999997
Transaction Date
2015-10-29T00:00:00.000
747631
Transaction Id: 747631 • Contract Number: BG-415M • Work Order Id: 672086
Transaction Id
747631
Contract Number
BG-415M
Work Order Id
672086
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-04T00:00:00.000
747632
Transaction Id: 747632 • Contract Number: BG-415M • Work Order Id: 673689
Transaction Id
747632
Contract Number
BG-415M
Work Order Id
673689
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
40.0
Total Cost
560.0
Transaction Date
2015-10-29T00:00:00.000
747633
Transaction Id: 747633 • Contract Number: BG-415M • Work Order Id: 673689
Transaction Id
747633
Contract Number
BG-415M
Work Order Id
673689
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-05T00:00:00.000
747634
Transaction Id: 747634 • Contract Number: BG-415M • Work Order Id: 673690
Transaction Id
747634
Contract Number
BG-415M
Work Order Id
673690
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
42.9
Total Cost
600.6
Transaction Date
2015-10-29T00:00:00.000
747635
Transaction Id: 747635 • Contract Number: BG-415M • Work Order Id: 673690
Transaction Id
747635
Contract Number
BG-415M
Work Order Id
673690
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-05T00:00:00.000
747636
Transaction Id: 747636 • Contract Number: BG-415M • Work Order Id: 674096
Transaction Id
747636
Contract Number
BG-415M
Work Order Id
674096
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
28.0
Total Cost
392.0
Transaction Date
2015-10-27T00:00:00.000
747637
Transaction Id: 747637 • Contract Number: BG-415M • Work Order Id: 674096
Transaction Id
747637
Contract Number
BG-415M
Work Order Id
674096
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-02-09T00:00:00.000
747638
Transaction Id: 747638 • Contract Number: BG-415M • Work Order Id: 671295
Transaction Id
747638
Contract Number
BG-415M
Work Order Id
671295
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
42.0
Total Cost
588.0
Transaction Date
2015-10-27T00:00:00.000
747639
Transaction Id: 747639 • Contract Number: BG-415M • Work Order Id: 671295
Transaction Id
747639
Contract Number
BG-415M
Work Order Id
671295
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-02-09T00:00:00.000
747640
Transaction Id: 747640 • Contract Number: BG-415M • Work Order Id: 670903
Transaction Id
747640
Contract Number
BG-415M
Work Order Id
670903
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
44.6
Total Cost
624.4
Transaction Date
2015-10-27T00:00:00.000
747641
Transaction Id: 747641 • Contract Number: BG-415M • Work Order Id: 670903
Transaction Id
747641
Contract Number
BG-415M
Work Order Id
670903
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-10T00:00:00.000
747642
Transaction Id: 747642 • Contract Number: BG-415M • Work Order Id: 674100
Transaction Id
747642
Contract Number
BG-415M
Work Order Id
674100
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
29.7
Total Cost
415.8
Transaction Date
2015-10-27T00:00:00.000
747643
Transaction Id: 747643 • Contract Number: BG-415M • Work Order Id: 674100
Transaction Id
747643
Contract Number
BG-415M
Work Order Id
674100
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-06T00:00:00.000
747644
Transaction Id: 747644 • Contract Number: BG-415M • Work Order Id: 671707
Transaction Id
747644
Contract Number
BG-415M
Work Order Id
671707
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
25.7
Total Cost
359.8
Transaction Date
2015-10-27T00:00:00.000