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
746741
Transaction Id: 746741 • Contract Number: QG-215M • Work Order Id: 696515
Transaction Id
746741
Contract Number
QG-215M
Work Order Id
696515
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-11T00:00:00.000
746742
Transaction Id: 746742 • Contract Number: QG-215M • Work Order Id: 696515
Transaction Id
746742
Contract Number
QG-215M
Work Order Id
696515
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-12-11T00:00:00.000
746747
Transaction Id: 746747 • Contract Number: QG-215M • Work Order Id: 691716
Transaction Id
746747
Contract Number
QG-215M
Work Order Id
691716
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
746748
Transaction Id: 746748 • Contract Number: QG-215M • Work Order Id: 691716
Transaction Id
746748
Contract Number
QG-215M
Work Order Id
691716
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
22.0
Total Cost
242.0
Transaction Date
2016-01-13T00:00:00.000
746749
Transaction Id: 746749 • Contract Number: QG-215M • Work Order Id: 696521
Transaction Id
746749
Contract Number
QG-215M
Work Order Id
696521
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
746750
Transaction Id: 746750 • Contract Number: QG-215M • Work Order Id: 696521
Transaction Id
746750
Contract Number
QG-215M
Work Order Id
696521
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
20.8
Total Cost
228.8
Transaction Date
2016-01-13T00:00:00.000
746751
Transaction Id: 746751 • Contract Number: QG-215M • Work Order Id: 691718
Transaction Id
746751
Contract Number
QG-215M
Work Order Id
691718
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
746752
Transaction Id: 746752 • Contract Number: QG-215M • Work Order Id: 691718
Transaction Id
746752
Contract Number
QG-215M
Work Order Id
691718
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
21.0
Total Cost
231.0
Transaction Date
2016-01-13T00:00:00.000
746753
Transaction Id: 746753 • Contract Number: QG-215M • Work Order Id: 694116
Transaction Id
746753
Contract Number
QG-215M
Work Order Id
694116
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
746754
Transaction Id: 746754 • Contract Number: QG-215M • Work Order Id: 694116
Transaction Id
746754
Contract Number
QG-215M
Work Order Id
694116
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
21.0
Total Cost
231.0
Transaction Date
2016-01-13T00:00:00.000
746759
Transaction Id: 746759 • Contract Number: QG-215M • Work Order Id: 691721
Transaction Id
746759
Contract Number
QG-215M
Work Order Id
691721
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-11T00:00:00.000
746760
Transaction Id: 746760 • Contract Number: QG-215M • Work Order Id: 691721
Transaction Id
746760
Contract Number
QG-215M
Work Order Id
691721
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
22.2
Total Cost
244.2
Transaction Date
2015-12-11T00:00:00.000
746761
Transaction Id: 746761 • Contract Number: QG-215M • Work Order Id: 696126
Transaction Id
746761
Contract Number
QG-215M
Work Order Id
696126
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-11T00:00:00.000
746762
Transaction Id: 746762 • Contract Number: QG-215M • Work Order Id: 696126
Transaction Id
746762
Contract Number
QG-215M
Work Order Id
696126
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-12-11T00:00:00.000
746765
Transaction Id: 746765 • Contract Number: QG-215M • Work Order Id: 692928
Transaction Id
746765
Contract Number
QG-215M
Work Order Id
692928
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-14T00:00:00.000
746766
Transaction Id: 746766 • Contract Number: QG-215M • Work Order Id: 692928
Transaction Id
746766
Contract Number
QG-215M
Work Order Id
692928
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2016-01-14T00:00:00.000
746767
Transaction Id: 746767 • Contract Number: QG-215M • Work Order Id: 695717
Transaction Id
746767
Contract Number
QG-215M
Work Order Id
695717
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-14T00:00:00.000
746768
Transaction Id: 746768 • Contract Number: QG-215M • Work Order Id: 695717
Transaction Id
746768
Contract Number
QG-215M
Work Order Id
695717
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2016-01-14T00:00:00.000
746771
Transaction Id: 746771 • Contract Number: QG-215M • Work Order Id: 819850
Transaction Id
746771
Contract Number
QG-215M
Work Order Id
819850
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-14T00:00:00.000
746772
Transaction Id: 746772 • Contract Number: QG-215M • Work Order Id: 819850
Transaction Id
746772
Contract Number
QG-215M
Work Order Id
819850
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2016-01-14T00:00:00.000
746773
Transaction Id: 746773 • Contract Number: QG-215M • Work Order Id: 835436
Transaction Id
746773
Contract Number
QG-215M
Work Order Id
835436
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-14T00:00:00.000
746774
Transaction Id: 746774 • Contract Number: QG-215M • Work Order Id: 835436
Transaction Id
746774
Contract Number
QG-215M
Work Order Id
835436
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2016-01-14T00:00:00.000
746777
Transaction Id: 746777 • Contract Number: QG-215M • Work Order Id: 689725
Transaction Id
746777
Contract Number
QG-215M
Work Order Id
689725
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-11T00:00:00.000
746778
Transaction Id: 746778 • Contract Number: QG-215M • Work Order Id: 689725
Transaction Id
746778
Contract Number
QG-215M
Work Order Id
689725
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-12-11T00:00:00.000
746781
Transaction Id: 746781 • Contract Number: QG-215M • Work Order Id: 691730
Transaction Id
746781
Contract Number
QG-215M
Work Order Id
691730
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-25T00:00:00.000
746782
Transaction Id: 746782 • Contract Number: QG-215M • Work Order Id: 691730
Transaction Id
746782
Contract Number
QG-215M
Work Order Id
691730
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000
746783
Transaction Id: 746783 • Contract Number: QG-215M • Work Order Id: 663709
Transaction Id
746783
Contract Number
QG-215M
Work Order Id
663709
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-25T00:00:00.000
746784
Transaction Id: 746784 • Contract Number: QG-215M • Work Order Id: 663709
Transaction Id
746784
Contract Number
QG-215M
Work Order Id
663709
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000
746785
Transaction Id: 746785 • Contract Number: QG-215M • Work Order Id: 661054
Transaction Id
746785
Contract Number
QG-215M
Work Order Id
661054
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-25T00:00:00.000
746786
Transaction Id: 746786 • Contract Number: QG-215M • Work Order Id: 661054
Transaction Id
746786
Contract Number
QG-215M
Work Order Id
661054
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000
746787
Transaction Id: 746787 • Contract Number: QG-215M • Work Order Id: 663715
Transaction Id
746787
Contract Number
QG-215M
Work Order Id
663715
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
746788
Transaction Id: 746788 • Contract Number: QG-215M • Work Order Id: 663715
Transaction Id
746788
Contract Number
QG-215M
Work Order Id
663715
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
62.0
Total Cost
1054.0
Transaction Date
2016-01-13T00:00:00.000
746789
Transaction Id: 746789 • Contract Number: QG-215M • Work Order Id: 661065
Transaction Id
746789
Contract Number
QG-215M
Work Order Id
661065
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-25T00:00:00.000
746790
Transaction Id: 746790 • Contract Number: QG-215M • Work Order Id: 661065
Transaction Id
746790
Contract Number
QG-215M
Work Order Id
661065
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000
746792
Transaction Id: 746792 • Contract Number: QG-215M • Work Order Id: 662999
Transaction Id
746792
Contract Number
QG-215M
Work Order Id
662999
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-25T00:00:00.000
746793
Transaction Id: 746793 • Contract Number: QG-215M • Work Order Id: 662999
Transaction Id
746793
Contract Number
QG-215M
Work Order Id
662999
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000
746794
Transaction Id: 746794 • Contract Number: QG-215M • Work Order Id: 665333
Transaction Id
746794
Contract Number
QG-215M
Work Order Id
665333
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-25T00:00:00.000
746795
Transaction Id: 746795 • Contract Number: QG-215M • Work Order Id: 665333
Transaction Id
746795
Contract Number
QG-215M
Work Order Id
665333
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000
746796
Transaction Id: 746796 • Contract Number: QG-215M • Work Order Id: 664117
Transaction Id
746796
Contract Number
QG-215M
Work Order Id
664117
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-25T00:00:00.000
746797
Transaction Id: 746797 • Contract Number: QG-215M • Work Order Id: 664117
Transaction Id
746797
Contract Number
QG-215M
Work Order Id
664117
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000
746798
Transaction Id: 746798 • Contract Number: QG-215M • Work Order Id: 664551
Transaction Id
746798
Contract Number
QG-215M
Work Order Id
664551
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-25T00:00:00.000
746799
Transaction Id: 746799 • Contract Number: QG-215M • Work Order Id: 664551
Transaction Id
746799
Contract Number
QG-215M
Work Order Id
664551
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000
746800
Transaction Id: 746800 • Contract Number: QG-215M • Work Order Id: 659449
Transaction Id
746800
Contract Number
QG-215M
Work Order Id
659449
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-25T00:00:00.000
746801
Transaction Id: 746801 • Contract Number: QG-215M • Work Order Id: 659449
Transaction Id
746801
Contract Number
QG-215M
Work Order Id
659449
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000
746802
Transaction Id: 746802 • Contract Number: QG-215M • Work Order Id: 663002
Transaction Id
746802
Contract Number
QG-215M
Work Order Id
663002
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-25T00:00:00.000
746803
Transaction Id: 746803 • Contract Number: QG-215M • Work Order Id: 663002
Transaction Id
746803
Contract Number
QG-215M
Work Order Id
663002
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000
746804
Transaction Id: 746804 • Contract Number: QG-215M • Work Order Id: 663007
Transaction Id
746804
Contract Number
QG-215M
Work Order Id
663007
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-25T00:00:00.000
746805
Transaction Id: 746805 • Contract Number: QG-215M • Work Order Id: 663007
Transaction Id
746805
Contract Number
QG-215M
Work Order Id
663007
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000
746806
Transaction Id: 746806 • Contract Number: QG-215M • Work Order Id: 664927
Transaction Id
746806
Contract Number
QG-215M
Work Order Id
664927
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-25T00:00:00.000
746807
Transaction Id: 746807 • Contract Number: QG-215M • Work Order Id: 664927
Transaction Id
746807
Contract Number
QG-215M
Work Order Id
664927
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-11-25T00:00:00.000