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
747698
Transaction Id: 747698 • Contract Number: BG-415M • Work Order Id: 676507
Transaction Id
747698
Contract Number
BG-415M
Work Order Id
676507
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
747699
Transaction Id: 747699 • Contract Number: BG-415M • Work Order Id: 682100
Transaction Id
747699
Contract Number
BG-415M
Work Order Id
682100
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.9
Total Cost
446.59999999999997
Transaction Date
2015-10-21T00:00:00.000
747700
Transaction Id: 747700 • Contract Number: BG-415M • Work Order Id: 682100
Transaction Id
747700
Contract Number
BG-415M
Work Order Id
682100
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
747701
Transaction Id: 747701 • Contract Number: BG-415M • Work Order Id: 678515
Transaction Id
747701
Contract Number
BG-415M
Work Order Id
678515
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-21T00:00:00.000
747702
Transaction Id: 747702 • Contract Number: BG-415M • Work Order Id: 678515
Transaction Id
747702
Contract Number
BG-415M
Work Order Id
678515
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
747703
Transaction Id: 747703 • Contract Number: BG-415M • Work Order Id: 678108
Transaction Id
747703
Contract Number
BG-415M
Work Order Id
678108
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.6
Total Cost
470.40000000000003
Transaction Date
2015-10-21T00:00:00.000
747704
Transaction Id: 747704 • Contract Number: BG-415M • Work Order Id: 678108
Transaction Id
747704
Contract Number
BG-415M
Work Order Id
678108
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
747705
Transaction Id: 747705 • Contract Number: BG-415M • Work Order Id: 676109
Transaction Id
747705
Contract Number
BG-415M
Work Order Id
676109
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.8
Total Cost
501.19999999999993
Transaction Date
2015-10-22T00:00:00.000
747706
Transaction Id: 747706 • Contract Number: BG-415M • Work Order Id: 676109
Transaction Id
747706
Contract Number
BG-415M
Work Order Id
676109
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
747707
Transaction Id: 747707 • Contract Number: BG-415M • Work Order Id: 678105
Transaction Id
747707
Contract Number
BG-415M
Work Order Id
678105
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.7
Total Cost
401.8
Transaction Date
2015-10-22T00:00:00.000
747708
Transaction Id: 747708 • Contract Number: BG-415M • Work Order Id: 678105
Transaction Id
747708
Contract Number
BG-415M
Work Order Id
678105
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
747709
Transaction Id: 747709 • Contract Number: BG-415M • Work Order Id: 677307
Transaction Id
747709
Contract Number
BG-415M
Work Order Id
677307
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-22T00:00:00.000
747710
Transaction Id: 747710 • Contract Number: BG-415M • Work Order Id: 677307
Transaction Id
747710
Contract Number
BG-415M
Work Order Id
677307
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
747711
Transaction Id: 747711 • Contract Number: BG-415M • Work Order Id: 674909
Transaction Id
747711
Contract Number
BG-415M
Work Order Id
674909
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.9
Total Cost
404.59999999999997
Transaction Date
2015-10-22T00:00:00.000
747712
Transaction Id: 747712 • Contract Number: BG-415M • Work Order Id: 674909
Transaction Id
747712
Contract Number
BG-415M
Work Order Id
674909
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
747713
Transaction Id: 747713 • Contract Number: BG-415M • Work Order Id: 676907
Transaction Id
747713
Contract Number
BG-415M
Work Order Id
676907
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
24.5
Total Cost
343.0
Transaction Date
2015-10-22T00:00:00.000
747714
Transaction Id: 747714 • Contract Number: BG-415M • Work Order Id: 676907
Transaction Id
747714
Contract Number
BG-415M
Work Order Id
676907
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
747715
Transaction Id: 747715 • Contract Number: BG-415M • Work Order Id: 680931
Transaction Id
747715
Contract Number
BG-415M
Work Order Id
680931
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.0
Total Cost
672.0
Transaction Date
2015-10-20T00:00:00.000
747716
Transaction Id: 747716 • Contract Number: BG-415M • Work Order Id: 680931
Transaction Id
747716
Contract Number
BG-415M
Work Order Id
680931
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
747717
Transaction Id: 747717 • Contract Number: BG-415M • Work Order Id: 671692
Transaction Id
747717
Contract Number
BG-415M
Work Order Id
671692
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.9
Total Cost
516.6
Transaction Date
2015-10-30T00:00:00.000
747718
Transaction Id: 747718 • Contract Number: BG-415M • Work Order Id: 671692
Transaction Id
747718
Contract Number
BG-415M
Work Order Id
671692
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-02T00:00:00.000
747719
Transaction Id: 747719 • Contract Number: BG-415M • Work Order Id: 671695
Transaction Id
747719
Contract Number
BG-415M
Work Order Id
671695
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.3
Total Cost
424.2
Transaction Date
2015-10-29T00:00:00.000
747720
Transaction Id: 747720 • Contract Number: BG-415M • Work Order Id: 671695
Transaction Id
747720
Contract Number
BG-415M
Work Order Id
671695
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
747721
Transaction Id: 747721 • Contract Number: BG-415M • Work Order Id: 670496
Transaction Id
747721
Contract Number
BG-415M
Work Order Id
670496
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.8
Total Cost
515.1999999999999
Transaction Date
2015-10-30T00:00:00.000
747722
Transaction Id: 747722 • Contract Number: BG-415M • Work Order Id: 670496
Transaction Id
747722
Contract Number
BG-415M
Work Order Id
670496
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
747723
Transaction Id: 747723 • Contract Number: BG-415M • Work Order Id: 670502
Transaction Id
747723
Contract Number
BG-415M
Work Order Id
670502
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.0
Total Cost
350.0
Transaction Date
2015-10-30T00:00:00.000
747724
Transaction Id: 747724 • Contract Number: BG-415M • Work Order Id: 670502
Transaction Id
747724
Contract Number
BG-415M
Work Order Id
670502
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
747725
Transaction Id: 747725 • Contract Number: BG-415M • Work Order Id: 674092
Transaction Id
747725
Contract Number
BG-415M
Work Order Id
674092
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.1
Total Cost
659.4
Transaction Date
2015-10-30T00:00:00.000
747726
Transaction Id: 747726 • Contract Number: BG-415M • Work Order Id: 674092
Transaction Id
747726
Contract Number
BG-415M
Work Order Id
674092
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
747727
Transaction Id: 747727 • Contract Number: BG-415M • Work Order Id: 670499
Transaction Id
747727
Contract Number
BG-415M
Work Order Id
670499
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-30T00:00:00.000
747728
Transaction Id: 747728 • Contract Number: BG-415M • Work Order Id: 670499
Transaction Id
747728
Contract Number
BG-415M
Work Order Id
670499
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
747729
Transaction Id: 747729 • Contract Number: BG-415M • Work Order Id: 673696
Transaction Id
747729
Contract Number
BG-415M
Work Order Id
673696
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.3
Total Cost
606.1999999999999
Transaction Date
2015-10-30T00:00:00.000
747730
Transaction Id: 747730 • Contract Number: BG-415M • Work Order Id: 673696
Transaction Id
747730
Contract Number
BG-415M
Work Order Id
673696
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
747731
Transaction Id: 747731 • Contract Number: BG-415M • Work Order Id: 670893
Transaction Id
747731
Contract Number
BG-415M
Work Order Id
670893
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
32.6
Total Cost
456.40000000000003
Transaction Date
2015-10-30T00:00:00.000
747732
Transaction Id: 747732 • Contract Number: BG-415M • Work Order Id: 670893
Transaction Id
747732
Contract Number
BG-415M
Work Order Id
670893
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
747735
Transaction Id: 747735 • Contract Number: BG-415M • Work Order Id: 678526
Transaction Id
747735
Contract Number
BG-415M
Work Order Id
678526
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
51.7
Total Cost
723.8000000000001
Transaction Date
2015-10-29T00:00:00.000
747736
Transaction Id: 747736 • Contract Number: BG-415M • Work Order Id: 678526
Transaction Id
747736
Contract Number
BG-415M
Work Order Id
678526
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
747737
Transaction Id: 747737 • Contract Number: BG-415M • Work Order Id: 672493
Transaction Id
747737
Contract Number
BG-415M
Work Order Id
672493
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
49.2
Total Cost
688.8000000000001
Transaction Date
2015-10-29T00:00:00.000
747738
Transaction Id: 747738 • Contract Number: BG-415M • Work Order Id: 672493
Transaction Id
747738
Contract Number
BG-415M
Work Order Id
672493
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
747739
Transaction Id: 747739 • Contract Number: BG-415M • Work Order Id: 673698
Transaction Id
747739
Contract Number
BG-415M
Work Order Id
673698
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.3
Total Cost
676.1999999999999
Transaction Date
2015-10-29T00:00:00.000
747740
Transaction Id: 747740 • Contract Number: BG-415M • Work Order Id: 673698
Transaction Id
747740
Contract Number
BG-415M
Work Order Id
673698
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
747741
Transaction Id: 747741 • Contract Number: BG-415M • Work Order Id: 672495
Transaction Id
747741
Contract Number
BG-415M
Work Order Id
672495
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.3
Total Cost
438.2
Transaction Date
2015-10-29T00:00:00.000
747742
Transaction Id: 747742 • Contract Number: BG-415M • Work Order Id: 672495
Transaction Id
747742
Contract Number
BG-415M
Work Order Id
672495
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
747743
Transaction Id: 747743 • Contract Number: BG-415M • Work Order Id: 670897
Transaction Id
747743
Contract Number
BG-415M
Work Order Id
670897
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
32.3
Total Cost
452.19999999999993
Transaction Date
2015-10-29T00:00:00.000
747744
Transaction Id: 747744 • Contract Number: BG-415M • Work Order Id: 670897
Transaction Id
747744
Contract Number
BG-415M
Work Order Id
670897
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
747745
Transaction Id: 747745 • Contract Number: BG-415M • Work Order Id: 673703
Transaction Id
747745
Contract Number
BG-415M
Work Order Id
673703
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.2
Total Cost
548.8000000000001
Transaction Date
2015-10-29T00:00:00.000
747746
Transaction Id: 747746 • Contract Number: BG-415M • Work Order Id: 673703
Transaction Id
747746
Contract Number
BG-415M
Work Order Id
673703
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
747747
Transaction Id: 747747 • Contract Number: BG-415M • Work Order Id: 670901
Transaction Id
747747
Contract Number
BG-415M
Work Order Id
670901
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.4
Total Cost
607.6
Transaction Date
2015-10-30T00:00:00.000
747748
Transaction Id: 747748 • Contract Number: BG-415M • Work Order Id: 670901
Transaction Id
747748
Contract Number
BG-415M
Work Order Id
670901
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-02T00:00:00.000
747749
Transaction Id: 747749 • Contract Number: BG-415M • Work Order Id: 680115
Transaction Id
747749
Contract Number
BG-415M
Work Order Id
680115
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-11-03T00:00:00.000