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
747645
Transaction Id: 747645 • Contract Number: BG-415M • Work Order Id: 671707
Transaction Id
747645
Contract Number
BG-415M
Work Order Id
671707
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
747646
Transaction Id: 747646 • Contract Number: BG-415M • Work Order Id: 672501
Transaction Id
747646
Contract Number
BG-415M
Work Order Id
672501
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-10-27T00:00:00.000
747647
Transaction Id: 747647 • Contract Number: BG-415M • Work Order Id: 672501
Transaction Id
747647
Contract Number
BG-415M
Work Order Id
672501
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
747648
Transaction Id: 747648 • Contract Number: BG-415M • Work Order Id: 671710
Transaction Id
747648
Contract Number
BG-415M
Work Order Id
671710
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
747649
Transaction Id: 747649 • Contract Number: BG-415M • Work Order Id: 667761
Transaction Id
747649
Contract Number
BG-415M
Work Order Id
667761
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-10-27T00:00:00.000
747650
Transaction Id: 747650 • Contract Number: BG-415M • Work Order Id: 667761
Transaction Id
747650
Contract Number
BG-415M
Work Order Id
667761
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
747651
Transaction Id: 747651 • Contract Number: BG-415M • Work Order Id: 671711
Transaction Id
747651
Contract Number
BG-415M
Work Order Id
671711
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-27T00:00:00.000
747652
Transaction Id: 747652 • Contract Number: BG-415M • Work Order Id: 671711
Transaction Id
747652
Contract Number
BG-415M
Work Order Id
671711
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
747653
Transaction Id: 747653 • Contract Number: BG-415M • Work Order Id: 672112
Transaction Id
747653
Contract Number
BG-415M
Work Order Id
672112
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.4
Total Cost
621.6
Transaction Date
2015-10-27T00:00:00.000
747654
Transaction Id: 747654 • Contract Number: BG-415M • Work Order Id: 672112
Transaction Id
747654
Contract Number
BG-415M
Work Order Id
672112
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
747655
Transaction Id: 747655 • Contract Number: BG-415M • Work Order Id: 674109
Transaction Id
747655
Contract Number
BG-415M
Work Order Id
674109
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
36.0
Total Cost
504.0
Transaction Date
2015-10-26T00:00:00.000
747656
Transaction Id: 747656 • Contract Number: BG-415M • Work Order Id: 674109
Transaction Id
747656
Contract Number
BG-415M
Work Order Id
674109
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
747657
Transaction Id: 747657 • Contract Number: BG-415M • Work Order Id: 672906
Transaction Id
747657
Contract Number
BG-415M
Work Order Id
672906
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.8
Total Cost
641.1999999999999
Transaction Date
2015-10-26T00:00:00.000
747658
Transaction Id: 747658 • Contract Number: BG-415M • Work Order Id: 672906
Transaction Id
747658
Contract Number
BG-415M
Work Order Id
672906
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
747659
Transaction Id: 747659 • Contract Number: BG-415M • Work Order Id: 672117
Transaction Id
747659
Contract Number
BG-415M
Work Order Id
672117
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-26T00:00:00.000
747660
Transaction Id: 747660 • Contract Number: BG-415M • Work Order Id: 672117
Transaction Id
747660
Contract Number
BG-415M
Work Order Id
672117
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
747661
Transaction Id: 747661 • Contract Number: BG-415M • Work Order Id: 672118
Transaction Id
747661
Contract Number
BG-415M
Work Order Id
672118
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
36.0
Total Cost
504.0
Transaction Date
2015-10-26T00:00:00.000
747662
Transaction Id: 747662 • Contract Number: BG-415M • Work Order Id: 672118
Transaction Id
747662
Contract Number
BG-415M
Work Order Id
672118
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
747663
Transaction Id: 747663 • Contract Number: BG-415M • Work Order Id: 1305863
Transaction Id
747663
Contract Number
BG-415M
Work Order Id
1305863
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-26T00:00:00.000
747664
Transaction Id: 747664 • Contract Number: BG-415M • Work Order Id: 1305863
Transaction Id
747664
Contract Number
BG-415M
Work Order Id
1305863
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-23T00:00:00.000
747665
Transaction Id: 747665 • Contract Number: BG-415M • Work Order Id: 672506
Transaction Id
747665
Contract Number
BG-415M
Work Order Id
672506
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
33.0
Total Cost
462.0
Transaction Date
2015-10-26T00:00:00.000
747666
Transaction Id: 747666 • Contract Number: BG-415M • Work Order Id: 672506
Transaction Id
747666
Contract Number
BG-415M
Work Order Id
672506
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
747667
Transaction Id: 747667 • Contract Number: BG-415M • Work Order Id: 672507
Transaction Id
747667
Contract Number
BG-415M
Work Order Id
672507
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
36.5
Total Cost
511.0
Transaction Date
2015-10-26T00:00:00.000
747668
Transaction Id: 747668 • Contract Number: BG-415M • Work Order Id: 672507
Transaction Id
747668
Contract Number
BG-415M
Work Order Id
672507
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
747669
Transaction Id: 747669 • Contract Number: BG-415M • Work Order Id: 674111
Transaction Id
747669
Contract Number
BG-415M
Work Order Id
674111
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-26T00:00:00.000
747670
Transaction Id: 747670 • Contract Number: BG-415M • Work Order Id: 674111
Transaction Id
747670
Contract Number
BG-415M
Work Order Id
674111
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
747671
Transaction Id: 747671 • Contract Number: BG-415M • Work Order Id: 674112
Transaction Id
747671
Contract Number
BG-415M
Work Order Id
674112
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-26T00:00:00.000
747672
Transaction Id: 747672 • Contract Number: BG-415M • Work Order Id: 674112
Transaction Id
747672
Contract Number
BG-415M
Work Order Id
674112
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
747673
Transaction Id: 747673 • Contract Number: BG-415M • Work Order Id: 673307
Transaction Id
747673
Contract Number
BG-415M
Work Order Id
673307
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.1
Total Cost
365.40000000000003
Transaction Date
2015-10-26T00:00:00.000
747674
Transaction Id: 747674 • Contract Number: BG-415M • Work Order Id: 673307
Transaction Id
747674
Contract Number
BG-415M
Work Order Id
673307
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-23T00:00:00.000
747677
Transaction Id: 747677 • Contract Number: BG-415M • Work Order Id: 665278
Transaction Id
747677
Contract Number
BG-415M
Work Order Id
665278
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.3
Total Cost
410.2
Transaction Date
2015-10-23T00:00:00.000
747678
Transaction Id: 747678 • Contract Number: BG-415M • Work Order Id: 665278
Transaction Id
747678
Contract Number
BG-415M
Work Order Id
665278
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
747681
Transaction Id: 747681 • Contract Number: BG-415M • Work Order Id: 674115
Transaction Id
747681
Contract Number
BG-415M
Work Order Id
674115
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-23T00:00:00.000
747682
Transaction Id: 747682 • Contract Number: BG-415M • Work Order Id: 674115
Transaction Id
747682
Contract Number
BG-415M
Work Order Id
674115
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
747683
Transaction Id: 747683 • Contract Number: BG-415M • Work Order Id: 672516
Transaction Id
747683
Contract Number
BG-415M
Work Order Id
672516
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
30.7
Total Cost
429.8
Transaction Date
2015-10-23T00:00:00.000
747787
Transaction Id: 747787 • Contract Number: BG-415M • Work Order Id: 672089
Transaction Id
747787
Contract Number
BG-415M
Work Order Id
672089
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
11.1
Total Cost
155.4
Transaction Date
2015-11-03T00:00:00.000
747684
Transaction Id: 747684 • Contract Number: BG-415M • Work Order Id: 672516
Transaction Id
747684
Contract Number
BG-415M
Work Order Id
672516
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
747685
Transaction Id: 747685 • Contract Number: BG-415M • Work Order Id: 672912
Transaction Id
747685
Contract Number
BG-415M
Work Order Id
672912
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.2
Total Cost
520.8000000000001
Transaction Date
2015-10-23T00:00:00.000
747686
Transaction Id: 747686 • Contract Number: BG-415M • Work Order Id: 672912
Transaction Id
747686
Contract Number
BG-415M
Work Order Id
672912
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
747687
Transaction Id: 747687 • Contract Number: BG-415M • Work Order Id: 673723
Transaction Id
747687
Contract Number
BG-415M
Work Order Id
673723
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.4
Total Cost
593.6
Transaction Date
2015-10-22T00:00:00.000
747688
Transaction Id: 747688 • Contract Number: BG-415M • Work Order Id: 673723
Transaction Id
747688
Contract Number
BG-415M
Work Order Id
673723
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
747689
Transaction Id: 747689 • Contract Number: BG-415M • Work Order Id: 671721
Transaction Id
747689
Contract Number
BG-415M
Work Order Id
671721
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-10-22T00:00:00.000
747690
Transaction Id: 747690 • Contract Number: BG-415M • Work Order Id: 671721
Transaction Id
747690
Contract Number
BG-415M
Work Order Id
671721
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
747691
Transaction Id: 747691 • Contract Number: BG-415M • Work Order Id: 680907
Transaction Id
747691
Contract Number
BG-415M
Work Order Id
680907
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
31.5
Total Cost
441.0
Transaction Date
2015-10-23T00:00:00.000
747692
Transaction Id: 747692 • Contract Number: BG-415M • Work Order Id: 680907
Transaction Id
747692
Contract Number
BG-415M
Work Order Id
680907
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
747693
Transaction Id: 747693 • Contract Number: BG-415M • Work Order Id: 681702
Transaction Id
747693
Contract Number
BG-415M
Work Order Id
681702
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.3
Total Cost
564.1999999999999
Transaction Date
2015-10-23T00:00:00.000
747694
Transaction Id: 747694 • Contract Number: BG-415M • Work Order Id: 681702
Transaction Id
747694
Contract Number
BG-415M
Work Order Id
681702
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
747695
Transaction Id: 747695 • Contract Number: BG-415M • Work Order Id: 649166
Transaction Id
747695
Contract Number
BG-415M
Work Order Id
649166
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
38.3
Total Cost
536.1999999999999
Transaction Date
2015-11-02T00:00:00.000
747696
Transaction Id: 747696 • Contract Number: BG-415M • Work Order Id: 649166
Transaction Id
747696
Contract Number
BG-415M
Work Order Id
649166
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
747697
Transaction Id: 747697 • Contract Number: BG-415M • Work Order Id: 676507
Transaction Id
747697
Contract Number
BG-415M
Work Order Id
676507
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-21T00:00:00.000