Ask NYC Browse All Data Public Safety Transportation Health Buildings

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
747750
Transaction Id: 747750 • Contract Number: BG-415M • Work Order Id: 680115
Transaction Id
747750
Contract Number
BG-415M
Work Order Id
680115
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-07T00:00:00.000
747751
Transaction Id: 747751 • Contract Number: BG-415M • Work Order Id: 680515
Transaction Id
747751
Contract Number
BG-415M
Work Order Id
680515
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
46.6
Total Cost
652.4
Transaction Date
2015-11-03T00:00:00.000
747752
Transaction Id: 747752 • Contract Number: BG-415M • Work Order Id: 680515
Transaction Id
747752
Contract Number
BG-415M
Work Order Id
680515
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-07T00:00:00.000
747753
Transaction Id: 747753 • Contract Number: BG-415M • Work Order Id: 676123
Transaction Id
747753
Contract Number
BG-415M
Work Order Id
676123
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
42.0
Total Cost
588.0
Transaction Date
2015-11-03T00:00:00.000
747754
Transaction Id: 747754 • Contract Number: BG-415M • Work Order Id: 676123
Transaction Id
747754
Contract Number
BG-415M
Work Order Id
676123
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-07T00:00:00.000
747755
Transaction Id: 747755 • Contract Number: BG-415M • Work Order Id: 661016
Transaction Id
747755
Contract Number
BG-415M
Work Order Id
661016
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
55.2
Total Cost
772.8000000000001
Transaction Date
2015-11-02T00:00:00.000
747756
Transaction Id: 747756 • Contract Number: BG-415M • Work Order Id: 661016
Transaction Id
747756
Contract Number
BG-415M
Work Order Id
661016
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-07T00:00:00.000
747757
Transaction Id: 747757 • Contract Number: BG-415M • Work Order Id: 664074
Transaction Id
747757
Contract Number
BG-415M
Work Order Id
664074
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
56.7
Total Cost
793.8000000000001
Transaction Date
2015-11-02T00:00:00.000
747758
Transaction Id: 747758 • Contract Number: BG-415M • Work Order Id: 664074
Transaction Id
747758
Contract Number
BG-415M
Work Order Id
664074
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-07T00:00:00.000
747759
Transaction Id: 747759 • Contract Number: BG-415M • Work Order Id: 661019
Transaction Id
747759
Contract Number
BG-415M
Work Order Id
661019
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
45.0
Total Cost
630.0
Transaction Date
2015-11-02T00:00:00.000
747760
Transaction Id: 747760 • Contract Number: BG-415M • Work Order Id: 661019
Transaction Id
747760
Contract Number
BG-415M
Work Order Id
661019
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-07T00:00:00.000
747761
Transaction Id: 747761 • Contract Number: BG-415M • Work Order Id: 682112
Transaction Id
747761
Contract Number
BG-415M
Work Order Id
682112
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
33.1
Total Cost
463.40000000000003
Transaction Date
2015-10-30T00:00:00.000
747762
Transaction Id: 747762 • Contract Number: BG-415M • Work Order Id: 682112
Transaction Id
747762
Contract Number
BG-415M
Work Order Id
682112
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
747763
Transaction Id: 747763 • Contract Number: BG-415M • Work Order Id: 670885
Transaction Id
747763
Contract Number
BG-415M
Work Order Id
670885
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
30.4
Total Cost
425.59999999999997
Transaction Date
2015-11-03T00:00:00.000
747764
Transaction Id: 747764 • Contract Number: BG-415M • Work Order Id: 670885
Transaction Id
747764
Contract Number
BG-415M
Work Order Id
670885
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
4.9
Total Cost
49.0
Transaction Date
2015-11-03T00:00:00.000
747765
Transaction Id: 747765 • Contract Number: BG-415M • Work Order Id: 670885
Transaction Id
747765
Contract Number
BG-415M
Work Order Id
670885
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
747766
Transaction Id: 747766 • Contract Number: BG-415M • Work Order Id: 747374
Transaction Id
747766
Contract Number
BG-415M
Work Order Id
747374
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
34.8
Total Cost
438.47999999999996
Transaction Date
2015-10-23T00:00:00.000
747767
Transaction Id: 747767 • Contract Number: BG-415M • Work Order Id: 747374
Transaction Id
747767
Contract Number
BG-415M
Work Order Id
747374
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
9.5
Total Cost
85.5
Transaction Date
2015-10-23T00:00:00.000
747768
Transaction Id: 747768 • Contract Number: BG-415M • Work Order Id: 747374
Transaction Id
747768
Contract Number
BG-415M
Work Order Id
747374
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
747772
Transaction Id: 747772 • Contract Number: BG-415M • Work Order Id: 669718
Transaction Id
747772
Contract Number
BG-415M
Work Order Id
669718
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.2
Total Cost
254.51999999999998
Transaction Date
2015-10-26T00:00:00.000
747773
Transaction Id: 747773 • Contract Number: BG-415M • Work Order Id: 669718
Transaction Id
747773
Contract Number
BG-415M
Work Order Id
669718
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
15.6
Total Cost
140.4
Transaction Date
2015-10-26T00:00:00.000
747774
Transaction Id: 747774 • Contract Number: BG-415M • Work Order Id: 669718
Transaction Id
747774
Contract Number
BG-415M
Work Order Id
669718
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
747775
Transaction Id: 747775 • Contract Number: BG-415M • Work Order Id: 643161
Transaction Id
747775
Contract Number
BG-415M
Work Order Id
643161
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
22.9
Total Cost
288.53999999999996
Transaction Date
2015-11-06T00:00:00.000
747776
Transaction Id: 747776 • Contract Number: BG-415M • Work Order Id: 643161
Transaction Id
747776
Contract Number
BG-415M
Work Order Id
643161
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
19.9
Total Cost
179.1
Transaction Date
2015-11-06T00:00:00.000
747777
Transaction Id: 747777 • Contract Number: BG-415M • Work Order Id: 643161
Transaction Id
747777
Contract Number
BG-415M
Work Order Id
643161
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-27T00:00:00.000
747778
Transaction Id: 747778 • Contract Number: BG-415M • Work Order Id: 651127
Transaction Id
747778
Contract Number
BG-415M
Work Order Id
651127
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
29.6
Total Cost
372.96
Transaction Date
2015-11-12T00:00:00.000
747779
Transaction Id: 747779 • Contract Number: BG-415M • Work Order Id: 651127
Transaction Id
747779
Contract Number
BG-415M
Work Order Id
651127
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
12.1
Total Cost
108.89999999999999
Transaction Date
2015-11-12T00:00:00.000
747780
Transaction Id: 747780 • Contract Number: BG-415M • Work Order Id: 651127
Transaction Id
747780
Contract Number
BG-415M
Work Order Id
651127
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
747784
Transaction Id: 747784 • Contract Number: BG-415M • Work Order Id: 661020
Transaction Id
747784
Contract Number
BG-415M
Work Order Id
661020
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
36.2
Total Cost
506.80000000000007
Transaction Date
2015-11-02T00:00:00.000
747785
Transaction Id: 747785 • Contract Number: BG-415M • Work Order Id: 661020
Transaction Id
747785
Contract Number
BG-415M
Work Order Id
661020
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
13.3
Total Cost
133.0
Transaction Date
2015-11-02T00:00:00.000
747786
Transaction Id: 747786 • Contract Number: BG-415M • Work Order Id: 661020
Transaction Id
747786
Contract Number
BG-415M
Work Order Id
661020
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-07T00:00:00.000
747788
Transaction Id: 747788 • Contract Number: BG-415M • Work Order Id: 672089
Transaction Id
747788
Contract Number
BG-415M
Work Order Id
672089
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
17.6
Total Cost
176.0
Transaction Date
2015-11-03T00:00:00.000
747789
Transaction Id: 747789 • Contract Number: BG-415M • Work Order Id: 672089
Transaction Id
747789
Contract Number
BG-415M
Work Order Id
672089
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-17T00:00:00.000
747790
Transaction Id: 747790 • Contract Number: BG-415M • Work Order Id: 647540
Transaction Id
747790
Contract Number
BG-415M
Work Order Id
647540
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.7
Total Cost
361.62
Transaction Date
2015-10-21T00:00:00.000
747791
Transaction Id: 747791 • Contract Number: BG-415M • Work Order Id: 647540
Transaction Id
747791
Contract Number
BG-415M
Work Order Id
647540
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.8
Total Cost
187.20000000000002
Transaction Date
2015-10-21T00:00:00.000
747792
Transaction Id: 747792 • Contract Number: BG-415M • Work Order Id: 647540
Transaction Id
747792
Contract Number
BG-415M
Work Order Id
647540
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
747793
Transaction Id: 747793 • Contract Number: BG-415M • Work Order Id: 647952
Transaction Id
747793
Contract Number
BG-415M
Work Order Id
647952
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.0
Total Cost
226.79999999999998
Transaction Date
2015-10-30T00:00:00.000
747794
Transaction Id: 747794 • Contract Number: BG-415M • Work Order Id: 647952
Transaction Id
747794
Contract Number
BG-415M
Work Order Id
647952
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
16.7
Total Cost
150.29999999999998
Transaction Date
2015-10-30T00:00:00.000
747795
Transaction Id: 747795 • Contract Number: BG-415M • Work Order Id: 647952
Transaction Id
747795
Contract Number
BG-415M
Work Order Id
647952
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
747796
Transaction Id: 747796 • Contract Number: BG-415M • Work Order Id: 649147
Transaction Id
747796
Contract Number
BG-415M
Work Order Id
649147
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.3
Total Cost
230.58
Transaction Date
2015-10-21T00:00:00.000
747797
Transaction Id: 747797 • Contract Number: BG-415M • Work Order Id: 649147
Transaction Id
747797
Contract Number
BG-415M
Work Order Id
649147
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
25.0
Total Cost
225.0
Transaction Date
2015-10-21T00:00:00.000
747798
Transaction Id: 747798 • Contract Number: BG-415M • Work Order Id: 649147
Transaction Id
747798
Contract Number
BG-415M
Work Order Id
649147
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
747799
Transaction Id: 747799 • Contract Number: BG-415M • Work Order Id: 647967
Transaction Id
747799
Contract Number
BG-415M
Work Order Id
647967
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
7.7
Total Cost
107.8
Transaction Date
2015-10-20T00:00:00.000
747800
Transaction Id: 747800 • Contract Number: BG-415M • Work Order Id: 647967
Transaction Id
747800
Contract Number
BG-415M
Work Order Id
647967
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
22.9
Total Cost
229.0
Transaction Date
2015-10-20T00:00:00.000
747801
Transaction Id: 747801 • Contract Number: BG-415M • Work Order Id: 647967
Transaction Id
747801
Contract Number
BG-415M
Work Order Id
647967
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
747802
Transaction Id: 747802 • Contract Number: BG-415M • Work Order Id: 648371
Transaction Id
747802
Contract Number
BG-415M
Work Order Id
648371
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
14.2
Total Cost
178.92
Transaction Date
2015-10-21T00:00:00.000
747803
Transaction Id: 747803 • Contract Number: BG-415M • Work Order Id: 648371
Transaction Id
747803
Contract Number
BG-415M
Work Order Id
648371
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
23.8
Total Cost
214.20000000000002
Transaction Date
2015-10-21T00:00:00.000
747804
Transaction Id: 747804 • Contract Number: BG-415M • Work Order Id: 648371
Transaction Id
747804
Contract Number
BG-415M
Work Order Id
648371
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
747805
Transaction Id: 747805 • Contract Number: BG-415M • Work Order Id: 675322
Transaction Id
747805
Contract Number
BG-415M
Work Order Id
675322
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
28.8
Total Cost
403.2
Transaction Date
2015-11-03T00:00:00.000
747806
Transaction Id: 747806 • Contract Number: BG-415M • Work Order Id: 675322
Transaction Id
747806
Contract Number
BG-415M
Work Order Id
675322
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.0
Total Cost
250.0
Transaction Date
2015-11-03T00:00:00.000
NYC Data AI • Public-data exploration interface