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
744875
Transaction Id: 744875 • Contract Number: QG-215M • Work Order Id: 670115
Transaction Id
744875
Contract Number
QG-215M
Work Order Id
670115
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
744876
Transaction Id: 744876 • Contract Number: QG-215M • Work Order Id: 670115
Transaction Id
744876
Contract Number
QG-215M
Work Order Id
670115
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-13T00:00:00.000
744877
Transaction Id: 744877 • Contract Number: QG-215M • Work Order Id: 668121
Transaction Id
744877
Contract Number
QG-215M
Work Order Id
668121
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
744878
Transaction Id: 744878 • Contract Number: QG-215M • Work Order Id: 668121
Transaction Id
744878
Contract Number
QG-215M
Work Order Id
668121
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.4
Total Cost
235.39999999999998
Transaction Date
2016-01-13T00:00:00.000
744879
Transaction Id: 744879 • Contract Number: QG-215M • Work Order Id: 668958
Transaction Id
744879
Contract Number
QG-215M
Work Order Id
668958
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
744880
Transaction Id: 744880 • Contract Number: QG-215M • Work Order Id: 668958
Transaction Id
744880
Contract Number
QG-215M
Work Order Id
668958
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-21T00:00:00.000
744881
Transaction Id: 744881 • Contract Number: QG-215M • Work Order Id: 641847
Transaction Id
744881
Contract Number
QG-215M
Work Order Id
641847
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-17T00:00:00.000
744882
Transaction Id: 744882 • Contract Number: QG-215M • Work Order Id: 641847
Transaction Id
744882
Contract Number
QG-215M
Work Order Id
641847
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
23.0
Total Cost
253.0
Transaction Date
2015-09-08T00:00:00.000
744883
Transaction Id: 744883 • Contract Number: QG-215M • Work Order Id: 641848
Transaction Id
744883
Contract Number
QG-215M
Work Order Id
641848
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-17T00:00:00.000
744884
Transaction Id: 744884 • Contract Number: QG-215M • Work Order Id: 641848
Transaction Id
744884
Contract Number
QG-215M
Work Order Id
641848
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
23.0
Total Cost
253.0
Transaction Date
2015-09-08T00:00:00.000
744885
Transaction Id: 744885 • Contract Number: QG-215M • Work Order Id: 644809
Transaction Id
744885
Contract Number
QG-215M
Work Order Id
644809
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
744886
Transaction Id: 744886 • Contract Number: QG-215M • Work Order Id: 644809
Transaction Id
744886
Contract Number
QG-215M
Work Order Id
644809
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
23.0
Total Cost
253.0
Transaction Date
2015-09-11T00:00:00.000
744887
Transaction Id: 744887 • Contract Number: QG-215M • Work Order Id: 660056
Transaction Id
744887
Contract Number
QG-215M
Work Order Id
660056
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
744888
Transaction Id: 744888 • Contract Number: QG-215M • Work Order Id: 660056
Transaction Id
744888
Contract Number
QG-215M
Work Order Id
660056
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
23.0
Total Cost
253.0
Transaction Date
2015-09-11T00:00:00.000
744889
Transaction Id: 744889 • Contract Number: QG-215M • Work Order Id: 661658
Transaction Id
744889
Contract Number
QG-215M
Work Order Id
661658
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
744890
Transaction Id: 744890 • Contract Number: QG-215M • Work Order Id: 661658
Transaction Id
744890
Contract Number
QG-215M
Work Order Id
661658
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
23.0
Total Cost
253.0
Transaction Date
2015-09-11T00:00:00.000
744891
Transaction Id: 744891 • Contract Number: QG-215M • Work Order Id: 660872
Transaction Id
744891
Contract Number
QG-215M
Work Order Id
660872
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
744892
Transaction Id: 744892 • Contract Number: QG-215M • Work Order Id: 660872
Transaction Id
744892
Contract Number
QG-215M
Work Order Id
660872
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
23.0
Total Cost
227.70000000000002
Transaction Date
2015-09-11T00:00:00.000
744893
Transaction Id: 744893 • Contract Number: QG-215M • Work Order Id: 660872
Transaction Id
744893
Contract Number
QG-215M
Work Order Id
660872
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
2015-09-11T00:00:00.000
744894
Transaction Id: 744894 • Contract Number: QG-215M • Work Order Id: 643721
Transaction Id
744894
Contract Number
QG-215M
Work Order Id
643721
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
744895
Transaction Id: 744895 • Contract Number: QG-215M • Work Order Id: 643721
Transaction Id
744895
Contract Number
QG-215M
Work Order Id
643721
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
2015-09-11T00:00:00.000
744896
Transaction Id: 744896 • Contract Number: QG-215M • Work Order Id: 645563
Transaction Id
744896
Contract Number
QG-215M
Work Order Id
645563
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
744897
Transaction Id: 744897 • Contract Number: QG-215M • Work Order Id: 645563
Transaction Id
744897
Contract Number
QG-215M
Work Order Id
645563
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
2015-09-08T00:00:00.000
744898
Transaction Id: 744898 • Contract Number: QG-215M • Work Order Id: 644845
Transaction Id
744898
Contract Number
QG-215M
Work Order Id
644845
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
744899
Transaction Id: 744899 • Contract Number: QG-215M • Work Order Id: 644845
Transaction Id
744899
Contract Number
QG-215M
Work Order Id
644845
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
2015-09-08T00:00:00.000
744900
Transaction Id: 744900 • Contract Number: QG-215M • Work Order Id: 649905
Transaction Id
744900
Contract Number
QG-215M
Work Order Id
649905
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
744901
Transaction Id: 744901 • Contract Number: QG-215M • Work Order Id: 649905
Transaction Id
744901
Contract Number
QG-215M
Work Order Id
649905
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
2015-09-22T00:00:00.000
744904
Transaction Id: 744904 • Contract Number: QG-215M • Work Order Id: 651181
Transaction Id
744904
Contract Number
QG-215M
Work Order Id
651181
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
744905
Transaction Id: 744905 • Contract Number: QG-215M • Work Order Id: 651181
Transaction Id
744905
Contract Number
QG-215M
Work Order Id
651181
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
2015-09-08T00:00:00.000
744906
Transaction Id: 744906 • Contract Number: QG-215M • Work Order Id: 643753
Transaction Id
744906
Contract Number
QG-215M
Work Order Id
643753
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
744907
Transaction Id: 744907 • Contract Number: QG-215M • Work Order Id: 643753
Transaction Id
744907
Contract Number
QG-215M
Work Order Id
643753
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-20T00:00:00.000
744912
Transaction Id: 744912 • Contract Number: QG-215M • Work Order Id: 651281
Transaction Id
744912
Contract Number
QG-215M
Work Order Id
651281
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
744913
Transaction Id: 744913 • Contract Number: QG-215M • Work Order Id: 651281
Transaction Id
744913
Contract Number
QG-215M
Work Order Id
651281
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
2015-09-22T00:00:00.000
744914
Transaction Id: 744914 • Contract Number: QG-215M • Work Order Id: 651280
Transaction Id
744914
Contract Number
QG-215M
Work Order Id
651280
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
744915
Transaction Id: 744915 • Contract Number: QG-215M • Work Order Id: 651280
Transaction Id
744915
Contract Number
QG-215M
Work Order Id
651280
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
2015-09-22T00:00:00.000
744916
Transaction Id: 744916 • Contract Number: QG-215M • Work Order Id: 651683
Transaction Id
744916
Contract Number
QG-215M
Work Order Id
651683
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
744917
Transaction Id: 744917 • Contract Number: QG-215M • Work Order Id: 651683
Transaction Id
744917
Contract Number
QG-215M
Work Order Id
651683
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
2015-09-22T00:00:00.000
744918
Transaction Id: 744918 • Contract Number: QG-215M • Work Order Id: 651687
Transaction Id
744918
Contract Number
QG-215M
Work Order Id
651687
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
744919
Transaction Id: 744919 • Contract Number: QG-215M • Work Order Id: 651687
Transaction Id
744919
Contract Number
QG-215M
Work Order Id
651687
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
2015-09-22T00:00:00.000
744920
Transaction Id: 744920 • Contract Number: QG-215M • Work Order Id: 652334
Transaction Id
744920
Contract Number
QG-215M
Work Order Id
652334
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
744921
Transaction Id: 744921 • Contract Number: QG-215M • Work Order Id: 652334
Transaction Id
744921
Contract Number
QG-215M
Work Order Id
652334
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
2015-09-22T00:00:00.000
744922
Transaction Id: 744922 • Contract Number: QG-215M • Work Order Id: 656412
Transaction Id
744922
Contract Number
QG-215M
Work Order Id
656412
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
744923
Transaction Id: 744923 • Contract Number: QG-215M • Work Order Id: 656412
Transaction Id
744923
Contract Number
QG-215M
Work Order Id
656412
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
2015-09-22T00:00:00.000
744924
Transaction Id: 744924 • Contract Number: QG-215M • Work Order Id: 653169
Transaction Id
744924
Contract Number
QG-215M
Work Order Id
653169
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
744925
Transaction Id: 744925 • Contract Number: QG-215M • Work Order Id: 653169
Transaction Id
744925
Contract Number
QG-215M
Work Order Id
653169
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-14T00:00:00.000
744926
Transaction Id: 744926 • Contract Number: QG-215M • Work Order Id: 648564
Transaction Id
744926
Contract Number
QG-215M
Work Order Id
648564
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-17T00:00:00.000
744927
Transaction Id: 744927 • Contract Number: QG-215M • Work Order Id: 648564
Transaction Id
744927
Contract Number
QG-215M
Work Order Id
648564
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.0
Total Cost
220.0
Transaction Date
2015-09-08T00:00:00.000
744928
Transaction Id: 744928 • Contract Number: QG-215M • Work Order Id: 651170
Transaction Id
744928
Contract Number
QG-215M
Work Order Id
651170
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-17T00:00:00.000
744929
Transaction Id: 744929 • Contract Number: QG-215M • Work Order Id: 651170
Transaction Id
744929
Contract Number
QG-215M
Work Order Id
651170
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.0
Total Cost
220.0
Transaction Date
2015-09-08T00:00:00.000
744930
Transaction Id: 744930 • Contract Number: QG-215M • Work Order Id: 647803
Transaction Id
744930
Contract Number
QG-215M
Work Order Id
647803
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-17T00:00:00.000