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
747807
Transaction Id: 747807 • Contract Number: BG-415M • Work Order Id: 675322
Transaction Id
747807
Contract Number
BG-415M
Work Order Id
675322
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-03T00:00:00.000
747808
Transaction Id: 747808 • Contract Number: BG-415M • Work Order Id: 670909
Transaction Id
747808
Contract Number
BG-415M
Work Order Id
670909
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
12.6
Units Used
18.2
Total Cost
229.32
Transaction Date
2015-10-26T00:00:00.000
747809
Transaction Id: 747809 • Contract Number: BG-415M • Work Order Id: 670909
Transaction Id
747809
Contract Number
BG-415M
Work Order Id
670909
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.0
Units Used
17.2
Total Cost
154.79999999999998
Transaction Date
2015-10-26T00:00:00.000
747810
Transaction Id: 747810 • Contract Number: BG-415M • Work Order Id: 670909
Transaction Id
747810
Contract Number
BG-415M
Work Order Id
670909
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-23T00:00:00.000
747811
Transaction Id: 747811 • Contract Number: BG-415M • Work Order Id: 647537
Transaction Id
747811
Contract Number
BG-415M
Work Order Id
647537
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
9.8
Total Cost
137.20000000000002
Transaction Date
2015-11-02T00:00:00.000
747812
Transaction Id: 747812 • Contract Number: BG-415M • Work Order Id: 647537
Transaction Id
747812
Contract Number
BG-415M
Work Order Id
647537
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
12.7
Total Cost
127.0
Transaction Date
2015-11-02T00:00:00.000
747813
Transaction Id: 747813 • Contract Number: BG-415M • Work Order Id: 647537
Transaction Id
747813
Contract Number
BG-415M
Work Order Id
647537
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-02-09T00:00:00.000
747814
Transaction Id: 747814 • Contract Number: BG-415M • Work Order Id: 647542
Transaction Id
747814
Contract Number
BG-415M
Work Order Id
647542
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
16.4
Total Cost
229.59999999999997
Transaction Date
2015-10-21T00:00:00.000
747815
Transaction Id: 747815 • Contract Number: BG-415M • Work Order Id: 647542
Transaction Id
747815
Contract Number
BG-415M
Work Order Id
647542
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
16.7
Total Cost
167.0
Transaction Date
2015-10-21T00:00:00.000
747816
Transaction Id: 747816 • Contract Number: BG-415M • Work Order Id: 647542
Transaction Id
747816
Contract Number
BG-415M
Work Order Id
647542
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-02-09T00:00:00.000
747820
Transaction Id: 747820 • Contract Number: BG-415M • Work Order Id: 678121
Transaction Id
747820
Contract Number
BG-415M
Work Order Id
678121
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
27.4
Total Cost
383.59999999999997
Transaction Date
2015-11-04T00:00:00.000
747821
Transaction Id: 747821 • Contract Number: BG-415M • Work Order Id: 678121
Transaction Id
747821
Contract Number
BG-415M
Work Order Id
678121
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
27.0
Total Cost
270.0
Transaction Date
2015-11-04T00:00:00.000
747822
Transaction Id: 747822 • Contract Number: BG-415M • Work Order Id: 678121
Transaction Id
747822
Contract Number
BG-415M
Work Order Id
678121
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
747823
Transaction Id: 747823 • Contract Number: BG-415M • Work Order Id: 668953
Transaction Id
747823
Contract Number
BG-415M
Work Order Id
668953
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
10.3
Total Cost
144.20000000000002
Transaction Date
2015-10-29T00:00:00.000
747824
Transaction Id: 747824 • Contract Number: BG-415M • Work Order Id: 668953
Transaction Id
747824
Contract Number
BG-415M
Work Order Id
668953
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
23.7
Total Cost
237.0
Transaction Date
2015-10-29T00:00:00.000
747825
Transaction Id: 747825 • Contract Number: BG-415M • Work Order Id: 668953
Transaction Id
747825
Contract Number
BG-415M
Work Order Id
668953
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-02-09T00:00:00.000
747826
Transaction Id: 747826 • Contract Number: BG-415M • Work Order Id: 653131
Transaction Id
747826
Contract Number
BG-415M
Work Order Id
653131
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
12.6
Units Used
28.5
Total Cost
359.09999999999997
Transaction Date
2015-11-12T00:00:00.000
747827
Transaction Id: 747827 • Contract Number: BG-415M • Work Order Id: 653131
Transaction Id
747827
Contract Number
BG-415M
Work Order Id
653131
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.0
Units Used
21.5
Total Cost
193.5
Transaction Date
2015-11-12T00:00:00.000
747828
Transaction Id: 747828 • Contract Number: BG-415M • Work Order Id: 653131
Transaction Id
747828
Contract Number
BG-415M
Work Order Id
653131
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-08T00:00:00.000
747829
Transaction Id: 747829 • Contract Number: BG-415M • Work Order Id: 674928
Transaction Id
747829
Contract Number
BG-415M
Work Order Id
674928
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
6.8
Total Cost
95.2
Transaction Date
2015-11-03T00:00:00.000
747830
Transaction Id: 747830 • Contract Number: BG-415M • Work Order Id: 674928
Transaction Id
747830
Contract Number
BG-415M
Work Order Id
674928
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
21.0
Total Cost
210.0
Transaction Date
2015-11-03T00:00:00.000
747831
Transaction Id: 747831 • Contract Number: BG-415M • Work Order Id: 674928
Transaction Id
747831
Contract Number
BG-415M
Work Order Id
674928
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-03T00:00:00.000
747832
Transaction Id: 747832 • Contract Number: BG-415M • Work Order Id: 647985
Transaction Id
747832
Contract Number
BG-415M
Work Order Id
647985
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
12.6
Units Used
20.5
Total Cost
258.3
Transaction Date
2015-10-21T00:00:00.000
747833
Transaction Id: 747833 • Contract Number: BG-415M • Work Order Id: 647985
Transaction Id
747833
Contract Number
BG-415M
Work Order Id
647985
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.0
Units Used
29.9
Total Cost
269.09999999999997
Transaction Date
2015-10-21T00:00:00.000
747834
Transaction Id: 747834 • Contract Number: BG-415M • Work Order Id: 647985
Transaction Id
747834
Contract Number
BG-415M
Work Order Id
647985
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
747835
Transaction Id: 747835 • Contract Number: BG-415M • Work Order Id: 678525
Transaction Id
747835
Contract Number
BG-415M
Work Order Id
678525
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
21.0
Total Cost
294.0
Transaction Date
2015-10-30T00:00:00.000
747836
Transaction Id: 747836 • Contract Number: BG-415M • Work Order Id: 678525
Transaction Id
747836
Contract Number
BG-415M
Work Order Id
678525
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
25.7
Total Cost
257.0
Transaction Date
2015-10-30T00:00:00.000
747837
Transaction Id: 747837 • Contract Number: BG-415M • Work Order Id: 678525
Transaction Id
747837
Contract Number
BG-415M
Work Order Id
678525
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
747841
Transaction Id: 747841 • Contract Number: BG-415M • Work Order Id: 671687
Transaction Id
747841
Contract Number
BG-415M
Work Order Id
671687
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
11.4
Total Cost
159.6
Transaction Date
2015-11-03T00:00:00.000
747842
Transaction Id: 747842 • Contract Number: BG-415M • Work Order Id: 671687
Transaction Id
747842
Contract Number
BG-415M
Work Order Id
671687
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
24.6
Total Cost
246.0
Transaction Date
2015-11-03T00:00:00.000
747843
Transaction Id: 747843 • Contract Number: BG-415M • Work Order Id: 671687
Transaction Id
747843
Contract Number
BG-415M
Work Order Id
671687
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-03T00:00:00.000
747844
Transaction Id: 747844 • Contract Number: BG-415M • Work Order Id: 681738
Transaction Id
747844
Contract Number
BG-415M
Work Order Id
681738
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
12.6
Units Used
7.6
Total Cost
95.75999999999999
Transaction Date
2015-11-02T00:00:00.000
747845
Transaction Id: 747845 • Contract Number: BG-415M • Work Order Id: 681738
Transaction Id
747845
Contract Number
BG-415M
Work Order Id
681738
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.0
Units Used
20.4
Total Cost
183.6
Transaction Date
2015-11-02T00:00:00.000
747846
Transaction Id: 747846 • Contract Number: BG-415M • Work Order Id: 681738
Transaction Id
747846
Contract Number
BG-415M
Work Order Id
681738
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-02-09T00:00:00.000
747847
Transaction Id: 747847 • Contract Number: BG-415M • Work Order Id: 648334
Transaction Id
747847
Contract Number
BG-415M
Work Order Id
648334
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
12.6
Units Used
4.6
Total Cost
57.959999999999994
Transaction Date
2015-10-21T00:00:00.000
747848
Transaction Id: 747848 • Contract Number: BG-415M • Work Order Id: 648334
Transaction Id
747848
Contract Number
BG-415M
Work Order Id
648334
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.0
Units Used
24.7
Total Cost
222.29999999999998
Transaction Date
2015-10-21T00:00:00.000
747849
Transaction Id: 747849 • Contract Number: BG-415M • Work Order Id: 648334
Transaction Id
747849
Contract Number
BG-415M
Work Order Id
648334
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
747850
Transaction Id: 747850 • Contract Number: BG-415M • Work Order Id: 647955
Transaction Id
747850
Contract Number
BG-415M
Work Order Id
647955
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
12.6
Units Used
6.0
Total Cost
75.6
Transaction Date
2015-10-21T00:00:00.000
747851
Transaction Id: 747851 • Contract Number: BG-415M • Work Order Id: 647955
Transaction Id
747851
Contract Number
BG-415M
Work Order Id
647955
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.0
Units Used
28.7
Total Cost
258.3
Transaction Date
2015-10-21T00:00:00.000
747852
Transaction Id: 747852 • Contract Number: BG-415M • Work Order Id: 647955
Transaction Id
747852
Contract Number
BG-415M
Work Order Id
647955
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
747853
Transaction Id: 747853 • Contract Number: BG-415M • Work Order Id: 647980
Transaction Id
747853
Contract Number
BG-415M
Work Order Id
647980
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
16.0
Total Cost
224.0
Transaction Date
2015-10-29T00:00:00.000
747854
Transaction Id: 747854 • Contract Number: BG-415M • Work Order Id: 647980
Transaction Id
747854
Contract Number
BG-415M
Work Order Id
647980
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
24.0
Total Cost
240.0
Transaction Date
2015-10-29T00:00:00.000
747855
Transaction Id: 747855 • Contract Number: BG-415M • Work Order Id: 647980
Transaction Id
747855
Contract Number
BG-415M
Work Order Id
647980
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-02-09T00:00:00.000
747857
Transaction Id: 747857 • Contract Number: BG-415M • Work Order Id: 648435
Transaction Id
747857
Contract Number
BG-415M
Work Order Id
648435
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.0
Units Used
29.6
Total Cost
266.40000000000003
Transaction Date
2015-11-16T00:00:00.000
747858
Transaction Id: 747858 • Contract Number: BG-415M • Work Order Id: 648435
Transaction Id
747858
Contract Number
BG-415M
Work Order Id
648435
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-25T00:00:00.000
747859
Transaction Id: 747859 • Contract Number: BG-415M • Work Order Id: 649160
Transaction Id
747859
Contract Number
BG-415M
Work Order Id
649160
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
12.6
Units Used
13.8
Total Cost
173.88
Transaction Date
2015-10-21T00:00:00.000
747860
Transaction Id: 747860 • Contract Number: BG-415M • Work Order Id: 649160
Transaction Id
747860
Contract Number
BG-415M
Work Order Id
649160
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.0
Units Used
27.9
Total Cost
251.1
Transaction Date
2015-10-21T00:00:00.000
747861
Transaction Id: 747861 • Contract Number: BG-415M • Work Order Id: 649160
Transaction Id
747861
Contract Number
BG-415M
Work Order Id
649160
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
747865
Transaction Id: 747865 • Contract Number: BG-415M • Work Order Id: 648338
Transaction Id
747865
Contract Number
BG-415M
Work Order Id
648338
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
12.0
Total Cost
168.0
Transaction Date
2015-10-30T00:00:00.000
747866
Transaction Id: 747866 • Contract Number: BG-415M • Work Order Id: 648338
Transaction Id
747866
Contract Number
BG-415M
Work Order Id
648338
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
18.0
Total Cost
180.0
Transaction Date
2015-10-30T00:00:00.000