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
745790
Transaction Id: 745790 • Contract Number: QG-215M • Work Order Id: 827852
Transaction Id
745790
Contract Number
QG-215M
Work Order Id
827852
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-21T00:00:00.000
745791
Transaction Id: 745791 • Contract Number: QG-215M • Work Order Id: 827852
Transaction Id
745791
Contract Number
QG-215M
Work Order Id
827852
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
42.0
Total Cost
415.8
Transaction Date
2015-12-21T00:00:00.000
745792
Transaction Id: 745792 • Contract Number: QG-215M • Work Order Id: 818657
Transaction Id
745792
Contract Number
QG-215M
Work Order Id
818657
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
745793
Transaction Id: 745793 • Contract Number: QG-215M • Work Order Id: 818657
Transaction Id
745793
Contract Number
QG-215M
Work Order Id
818657
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
25.4
Total Cost
251.46
Transaction Date
2016-01-13T00:00:00.000
745794
Transaction Id: 745794 • Contract Number: QG-215M • Work Order Id: 831039
Transaction Id
745794
Contract Number
QG-215M
Work Order Id
831039
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-22T00:00:00.000
745795
Transaction Id: 745795 • Contract Number: QG-215M • Work Order Id: 831039
Transaction Id
745795
Contract Number
QG-215M
Work Order Id
831039
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
37.3
Total Cost
369.27
Transaction Date
2015-12-22T00:00:00.000
745796
Transaction Id: 745796 • Contract Number: QG-215M • Work Order Id: 818263
Transaction Id
745796
Contract Number
QG-215M
Work Order Id
818263
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
745797
Transaction Id: 745797 • Contract Number: QG-215M • Work Order Id: 818263
Transaction Id
745797
Contract Number
QG-215M
Work Order Id
818263
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
28.0
Total Cost
277.2
Transaction Date
2015-12-11T00:00:00.000
745804
Transaction Id: 745804 • Contract Number: QG-215M • Work Order Id: 698929
Transaction Id
745804
Contract Number
QG-215M
Work Order Id
698929
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-19T00:00:00.000
745805
Transaction Id: 745805 • Contract Number: QG-215M • Work Order Id: 698929
Transaction Id
745805
Contract Number
QG-215M
Work Order Id
698929
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
42.0
Total Cost
415.8
Transaction Date
2015-12-19T00:00:00.000
745806
Transaction Id: 745806 • Contract Number: QG-215M • Work Order Id: 699719
Transaction Id
745806
Contract Number
QG-215M
Work Order Id
699719
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-30T00:00:00.000
745807
Transaction Id: 745807 • Contract Number: QG-215M • Work Order Id: 699719
Transaction Id
745807
Contract Number
QG-215M
Work Order Id
699719
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-11-30T00:00:00.000
745808
Transaction Id: 745808 • Contract Number: QG-215M • Work Order Id: 699332
Transaction Id
745808
Contract Number
QG-215M
Work Order Id
699332
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-21T00:00:00.000
745809
Transaction Id: 745809 • Contract Number: QG-215M • Work Order Id: 699332
Transaction Id
745809
Contract Number
QG-215M
Work Order Id
699332
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-12-21T00:00:00.000
745812
Transaction Id: 745812 • Contract Number: QG-215M • Work Order Id: 698930
Transaction Id
745812
Contract Number
QG-215M
Work Order Id
698930
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-03T00:00:00.000
745813
Transaction Id: 745813 • Contract Number: QG-215M • Work Order Id: 698930
Transaction Id
745813
Contract Number
QG-215M
Work Order Id
698930
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
32.7
Total Cost
323.73
Transaction Date
2015-12-03T00:00:00.000
745814
Transaction Id: 745814 • Contract Number: QG-215M • Work Order Id: 698522
Transaction Id
745814
Contract Number
QG-215M
Work Order Id
698522
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-03T00:00:00.000
745815
Transaction Id: 745815 • Contract Number: QG-215M • Work Order Id: 698522
Transaction Id
745815
Contract Number
QG-215M
Work Order Id
698522
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
37.3
Total Cost
369.27
Transaction Date
2015-12-03T00:00:00.000
745816
Transaction Id: 745816 • Contract Number: QG-215M • Work Order Id: 702521
Transaction Id
745816
Contract Number
QG-215M
Work Order Id
702521
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
745817
Transaction Id: 745817 • Contract Number: QG-215M • Work Order Id: 702521
Transaction Id
745817
Contract Number
QG-215M
Work Order Id
702521
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
35.0
Total Cost
346.5
Transaction Date
2015-12-11T00:00:00.000
745822
Transaction Id: 745822 • Contract Number: QG-215M • Work Order Id: 698526
Transaction Id
745822
Contract Number
QG-215M
Work Order Id
698526
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
745823
Transaction Id: 745823 • Contract Number: QG-215M • Work Order Id: 698526
Transaction Id
745823
Contract Number
QG-215M
Work Order Id
698526
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-12-11T00:00:00.000
745828
Transaction Id: 745828 • Contract Number: QG-215M • Work Order Id: 698131
Transaction Id
745828
Contract Number
QG-215M
Work Order Id
698131
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
745829
Transaction Id: 745829 • Contract Number: QG-215M • Work Order Id: 698131
Transaction Id
745829
Contract Number
QG-215M
Work Order Id
698131
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
32.0
Total Cost
316.8
Transaction Date
2015-12-11T00:00:00.000
745830
Transaction Id: 745830 • Contract Number: QG-215M • Work Order Id: 700925
Transaction Id
745830
Contract Number
QG-215M
Work Order Id
700925
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-21T00:00:00.000
745831
Transaction Id: 745831 • Contract Number: QG-215M • Work Order Id: 700925
Transaction Id
745831
Contract Number
QG-215M
Work Order Id
700925
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-12-21T00:00:00.000
745832
Transaction Id: 745832 • Contract Number: QG-215M • Work Order Id: 703317
Transaction Id
745832
Contract Number
QG-215M
Work Order Id
703317
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-30T00:00:00.000
745833
Transaction Id: 745833 • Contract Number: QG-215M • Work Order Id: 703317
Transaction Id
745833
Contract Number
QG-215M
Work Order Id
703317
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-11-30T00:00:00.000
745834
Transaction Id: 745834 • Contract Number: QG-215M • Work Order Id: 702525
Transaction Id
745834
Contract Number
QG-215M
Work Order Id
702525
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-31T00:00:00.000
745835
Transaction Id: 745835 • Contract Number: QG-215M • Work Order Id: 702525
Transaction Id
745835
Contract Number
QG-215M
Work Order Id
702525
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
31.9
Total Cost
315.81
Transaction Date
2015-12-31T00:00:00.000
745836
Transaction Id: 745836 • Contract Number: QG-215M • Work Order Id: 698527
Transaction Id
745836
Contract Number
QG-215M
Work Order Id
698527
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
745837
Transaction Id: 745837 • Contract Number: QG-215M • Work Order Id: 698527
Transaction Id
745837
Contract Number
QG-215M
Work Order Id
698527
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
21.2
Total Cost
209.88
Transaction Date
2016-01-14T00:00:00.000
745838
Transaction Id: 745838 • Contract Number: QG-215M • Work Order Id: 698530
Transaction Id
745838
Contract Number
QG-215M
Work Order Id
698530
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
745839
Transaction Id: 745839 • Contract Number: QG-215M • Work Order Id: 698530
Transaction Id
745839
Contract Number
QG-215M
Work Order Id
698530
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
26.7
Total Cost
264.33
Transaction Date
2016-01-14T00:00:00.000
745840
Transaction Id: 745840 • Contract Number: QG-215M • Work Order Id: 704125
Transaction Id
745840
Contract Number
QG-215M
Work Order Id
704125
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-30T00:00:00.000
745841
Transaction Id: 745841 • Contract Number: QG-215M • Work Order Id: 704125
Transaction Id
745841
Contract Number
QG-215M
Work Order Id
704125
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-11-30T00:00:00.000
745842
Transaction Id: 745842 • Contract Number: QG-215M • Work Order Id: 702530
Transaction Id
745842
Contract Number
QG-215M
Work Order Id
702530
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-31T00:00:00.000
745843
Transaction Id: 745843 • Contract Number: QG-215M • Work Order Id: 702530
Transaction Id
745843
Contract Number
QG-215M
Work Order Id
702530
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-12-31T00:00:00.000
745844
Transaction Id: 745844 • Contract Number: QG-215M • Work Order Id: 699338
Transaction Id
745844
Contract Number
QG-215M
Work Order Id
699338
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-15T00:00:00.000
745845
Transaction Id: 745845 • Contract Number: QG-215M • Work Order Id: 699338
Transaction Id
745845
Contract Number
QG-215M
Work Order Id
699338
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
37.3
Total Cost
369.27
Transaction Date
2016-01-15T00:00:00.000
745846
Transaction Id: 745846 • Contract Number: QG-215M • Work Order Id: 698532
Transaction Id
745846
Contract Number
QG-215M
Work Order Id
698532
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-30T00:00:00.000
745847
Transaction Id: 745847 • Contract Number: QG-215M • Work Order Id: 698532
Transaction Id
745847
Contract Number
QG-215M
Work Order Id
698532
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-11-30T00:00:00.000
745854
Transaction Id: 745854 • Contract Number: QG-215M • Work Order Id: 701333
Transaction Id
745854
Contract Number
QG-215M
Work Order Id
701333
Line Item Id
279.0
Item Number
16
Line Item Description
TRANSPLANTING TREES UP TO 4” CALIPER
Unit Of Measure
EA
Unit Price
400.0
Units Used
1.0
Total Cost
400.0
Transaction Date
2016-01-14T00:00:00.000
745855
Transaction Id: 745855 • Contract Number: QG-215M • Work Order Id: 701333
Transaction Id
745855
Contract Number
QG-215M
Work Order Id
701333
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
21.0
Total Cost
207.9
Transaction Date
2016-01-14T00:00:00.000
745856
Transaction Id: 745856 • Contract Number: QG-215M • Work Order Id: 700931
Transaction Id
745856
Contract Number
QG-215M
Work Order Id
700931
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-10T00:00:00.000
745857
Transaction Id: 745857 • Contract Number: QG-215M • Work Order Id: 700931
Transaction Id
745857
Contract Number
QG-215M
Work Order Id
700931
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-12-10T00:00:00.000
745864
Transaction Id: 745864 • Contract Number: QG-215M • Work Order Id: 654012
Transaction Id
745864
Contract Number
QG-215M
Work Order Id
654012
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
745865
Transaction Id: 745865 • Contract Number: QG-215M • Work Order Id: 654012
Transaction Id
745865
Contract Number
QG-215M
Work Order Id
654012
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
12.8
Total Cost
217.60000000000002
Transaction Date
2015-09-14T00:00:00.000
745866
Transaction Id: 745866 • Contract Number: QG-215M • Work Order Id: 654012
Transaction Id
745866
Contract Number
QG-215M
Work Order Id
654012
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
25.5
Total Cost
306.0
Transaction Date
2015-09-14T00:00:00.000
745867
Transaction Id: 745867 • Contract Number: QG-215M • Work Order Id: 651476
Transaction Id
745867
Contract Number
QG-215M
Work Order Id
651476
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