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
745868
Transaction Id: 745868 • Contract Number: QG-215M • Work Order Id: 651476
Transaction Id
745868
Contract Number
QG-215M
Work Order Id
651476
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
44.4
Total Cost
754.8
Transaction Date
2015-09-08T00:00:00.000
745869
Transaction Id: 745869 • Contract Number: QG-215M • Work Order Id: 653213
Transaction Id
745869
Contract Number
QG-215M
Work Order Id
653213
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
745870
Transaction Id: 745870 • Contract Number: QG-215M • Work Order Id: 653213
Transaction Id
745870
Contract Number
QG-215M
Work Order Id
653213
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
31.3
Total Cost
532.1
Transaction Date
2015-09-08T00:00:00.000
745871
Transaction Id: 745871 • Contract Number: QG-215M • Work Order Id: 653617
Transaction Id
745871
Contract Number
QG-215M
Work Order Id
653617
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
745872
Transaction Id: 745872 • Contract Number: QG-215M • Work Order Id: 653617
Transaction Id
745872
Contract Number
QG-215M
Work Order Id
653617
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
31.3
Total Cost
532.1
Transaction Date
2015-09-08T00:00:00.000
745873
Transaction Id: 745873 • Contract Number: QG-215M • Work Order Id: 651478
Transaction Id
745873
Contract Number
QG-215M
Work Order Id
651478
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
745874
Transaction Id: 745874 • Contract Number: QG-215M • Work Order Id: 651478
Transaction Id
745874
Contract Number
QG-215M
Work Order Id
651478
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
41.0
Total Cost
697.0
Transaction Date
2015-09-08T00:00:00.000
745875
Transaction Id: 745875 • Contract Number: QG-215M • Work Order Id: 651863
Transaction Id
745875
Contract Number
QG-215M
Work Order Id
651863
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
745876
Transaction Id: 745876 • Contract Number: QG-215M • Work Order Id: 651863
Transaction Id
745876
Contract Number
QG-215M
Work Order Id
651863
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
38.7
Total Cost
657.9000000000001
Transaction Date
2015-09-08T00:00:00.000
745877
Transaction Id: 745877 • Contract Number: QG-215M • Work Order Id: 652138
Transaction Id
745877
Contract Number
QG-215M
Work Order Id
652138
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
745878
Transaction Id: 745878 • Contract Number: QG-215M • Work Order Id: 652138
Transaction Id
745878
Contract Number
QG-215M
Work Order Id
652138
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
32.3
Total Cost
549.0999999999999
Transaction Date
2015-09-08T00:00:00.000
745879
Transaction Id: 745879 • Contract Number: QG-215M • Work Order Id: 651957
Transaction Id
745879
Contract Number
QG-215M
Work Order Id
651957
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
745880
Transaction Id: 745880 • Contract Number: QG-215M • Work Order Id: 651957
Transaction Id
745880
Contract Number
QG-215M
Work Order Id
651957
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
33.3
Total Cost
566.0999999999999
Transaction Date
2015-09-08T00:00:00.000
745881
Transaction Id: 745881 • Contract Number: QG-215M • Work Order Id: 664068
Transaction Id
745881
Contract Number
QG-215M
Work Order Id
664068
Line Item Id
335.0
Item Number
05
Line Item Description
STUMP REMOVALS OF OVER 30 TO 36 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2016-04-30T00:00:00.000
745882
Transaction Id: 745882 • Contract Number: QG-215M • Work Order Id: 648415
Transaction Id
745882
Contract Number
QG-215M
Work Order Id
648415
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
745883
Transaction Id: 745883 • Contract Number: QG-215M • Work Order Id: 648415
Transaction Id
745883
Contract Number
QG-215M
Work Order Id
648415
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
25.0
Total Cost
425.0
Transaction Date
2015-09-11T00:00:00.000
745884
Transaction Id: 745884 • Contract Number: QG-215M • Work Order Id: 648415
Transaction Id
745884
Contract Number
QG-215M
Work Order Id
648415
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.0
Total Cost
300.0
Transaction Date
2015-09-11T00:00:00.000
745885
Transaction Id: 745885 • Contract Number: QG-215M • Work Order Id: 649955
Transaction Id
745885
Contract Number
QG-215M
Work Order Id
649955
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
745886
Transaction Id: 745886 • Contract Number: QG-215M • Work Order Id: 649955
Transaction Id
745886
Contract Number
QG-215M
Work Order Id
649955
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
25.0
Total Cost
425.0
Transaction Date
2015-09-11T00:00:00.000
745887
Transaction Id: 745887 • Contract Number: QG-215M • Work Order Id: 649955
Transaction Id
745887
Contract Number
QG-215M
Work Order Id
649955
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.0
Total Cost
300.0
Transaction Date
2015-09-11T00:00:00.000
745888
Transaction Id: 745888 • Contract Number: QG-215M • Work Order Id: 651564
Transaction Id
745888
Contract Number
QG-215M
Work Order Id
651564
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
745889
Transaction Id: 745889 • Contract Number: QG-215M • Work Order Id: 651564
Transaction Id
745889
Contract Number
QG-215M
Work Order Id
651564
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
21.7
Total Cost
368.9
Transaction Date
2015-09-14T00:00:00.000
745890
Transaction Id: 745890 • Contract Number: QG-215M • Work Order Id: 651564
Transaction Id
745890
Contract Number
QG-215M
Work Order Id
651564
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
20.0
Total Cost
240.0
Transaction Date
2015-09-14T00:00:00.000
745891
Transaction Id: 745891 • Contract Number: QG-215M • Work Order Id: 647792
Transaction Id
745891
Contract Number
QG-215M
Work Order Id
647792
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
745892
Transaction Id: 745892 • Contract Number: QG-215M • Work Order Id: 647792
Transaction Id
745892
Contract Number
QG-215M
Work Order Id
647792
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
20.4
Total Cost
346.79999999999995
Transaction Date
2015-09-14T00:00:00.000
745893
Transaction Id: 745893 • Contract Number: QG-215M • Work Order Id: 647792
Transaction Id
745893
Contract Number
QG-215M
Work Order Id
647792
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
20.3
Total Cost
243.60000000000002
Transaction Date
2015-09-14T00:00:00.000
745894
Transaction Id: 745894 • Contract Number: QG-215M • Work Order Id: 653987
Transaction Id
745894
Contract Number
QG-215M
Work Order Id
653987
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-25T00:00:00.000
745895
Transaction Id: 745895 • Contract Number: QG-215M • Work Order Id: 653987
Transaction Id
745895
Contract Number
QG-215M
Work Order Id
653987
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
5.0
Total Cost
85.0
Transaction Date
2015-09-25T00:00:00.000
745896
Transaction Id: 745896 • Contract Number: QG-215M • Work Order Id: 653987
Transaction Id
745896
Contract Number
QG-215M
Work Order Id
653987
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
32.0
Total Cost
384.0
Transaction Date
2015-09-25T00:00:00.000
745897
Transaction Id: 745897 • Contract Number: QG-215M • Work Order Id: 651698
Transaction Id
745897
Contract Number
QG-215M
Work Order Id
651698
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
745898
Transaction Id: 745898 • Contract Number: QG-215M • Work Order Id: 651698
Transaction Id
745898
Contract Number
QG-215M
Work Order Id
651698
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
46.1
Total Cost
783.7
Transaction Date
2015-09-14T00:00:00.000
745900
Transaction Id: 745900 • Contract Number: QG-215M • Work Order Id: 647780
Transaction Id
745900
Contract Number
QG-215M
Work Order Id
647780
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
745901
Transaction Id: 745901 • Contract Number: QG-215M • Work Order Id: 647780
Transaction Id
745901
Contract Number
QG-215M
Work Order Id
647780
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
25.0
Total Cost
425.0
Transaction Date
2015-09-11T00:00:00.000
745902
Transaction Id: 745902 • Contract Number: QG-215M • Work Order Id: 647780
Transaction Id
745902
Contract Number
QG-215M
Work Order Id
647780
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.0
Total Cost
300.0
Transaction Date
2015-09-11T00:00:00.000
745903
Transaction Id: 745903 • Contract Number: QG-215M • Work Order Id: 993039
Transaction Id
745903
Contract Number
QG-215M
Work Order Id
993039
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-25T00:00:00.000
745904
Transaction Id: 745904 • Contract Number: QG-215M • Work Order Id: 993039
Transaction Id
745904
Contract Number
QG-215M
Work Order Id
993039
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
13.5
Total Cost
229.5
Transaction Date
2015-09-25T00:00:00.000
745905
Transaction Id: 745905 • Contract Number: QG-215M • Work Order Id: 993039
Transaction Id
745905
Contract Number
QG-215M
Work Order Id
993039
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.0
Total Cost
300.0
Transaction Date
2015-09-25T00:00:00.000
745906
Transaction Id: 745906 • Contract Number: QG-215M • Work Order Id: 647947
Transaction Id
745906
Contract Number
QG-215M
Work Order Id
647947
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
745907
Transaction Id: 745907 • Contract Number: QG-215M • Work Order Id: 647947
Transaction Id
745907
Contract Number
QG-215M
Work Order Id
647947
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
11.8
Total Cost
200.60000000000002
Transaction Date
2015-09-22T00:00:00.000
745908
Transaction Id: 745908 • Contract Number: QG-215M • Work Order Id: 647947
Transaction Id
745908
Contract Number
QG-215M
Work Order Id
647947
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
20.1
Total Cost
241.20000000000002
Transaction Date
2015-09-22T00:00:00.000
745909
Transaction Id: 745909 • Contract Number: QG-215M • Work Order Id: 647599
Transaction Id
745909
Contract Number
QG-215M
Work Order Id
647599
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
745910
Transaction Id: 745910 • Contract Number: QG-215M • Work Order Id: 647599
Transaction Id
745910
Contract Number
QG-215M
Work Order Id
647599
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
20.9
Total Cost
355.29999999999995
Transaction Date
2015-09-14T00:00:00.000
745911
Transaction Id: 745911 • Contract Number: QG-215M • Work Order Id: 647599
Transaction Id
745911
Contract Number
QG-215M
Work Order Id
647599
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
20.8
Total Cost
249.60000000000002
Transaction Date
2015-09-14T00:00:00.000
745912
Transaction Id: 745912 • Contract Number: QG-215M • Work Order Id: 647595
Transaction Id
745912
Contract Number
QG-215M
Work Order Id
647595
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
745913
Transaction Id: 745913 • Contract Number: QG-215M • Work Order Id: 647595
Transaction Id
745913
Contract Number
QG-215M
Work Order Id
647595
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
20.9
Total Cost
355.29999999999995
Transaction Date
2015-09-14T00:00:00.000
745914
Transaction Id: 745914 • Contract Number: QG-215M • Work Order Id: 647595
Transaction Id
745914
Contract Number
QG-215M
Work Order Id
647595
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
20.8
Total Cost
249.60000000000002
Transaction Date
2015-09-14T00:00:00.000
745915
Transaction Id: 745915 • Contract Number: QG-215M • Work Order Id: 647597
Transaction Id
745915
Contract Number
QG-215M
Work Order Id
647597
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
745916
Transaction Id: 745916 • Contract Number: QG-215M • Work Order Id: 647597
Transaction Id
745916
Contract Number
QG-215M
Work Order Id
647597
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
20.9
Total Cost
355.29999999999995
Transaction Date
2015-09-14T00:00:00.000
745917
Transaction Id: 745917 • Contract Number: QG-215M • Work Order Id: 647597
Transaction Id
745917
Contract Number
QG-215M
Work Order Id
647597
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
20.8
Total Cost
249.60000000000002
Transaction Date
2015-09-14T00:00:00.000
745918
Transaction Id: 745918 • Contract Number: QG-215M • Work Order Id: 647600
Transaction Id
745918
Contract Number
QG-215M
Work Order Id
647600
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