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
746135
Transaction Id: 746135 • Contract Number: QG-215M • Work Order Id: 688537
Transaction Id
746135
Contract Number
QG-215M
Work Order Id
688537
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.7
Total Cost
232.89999999999998
Transaction Date
2015-12-14T00:00:00.000
746136
Transaction Id: 746136 • Contract Number: QG-215M • Work Order Id: 667355
Transaction Id
746136
Contract Number
QG-215M
Work Order Id
667355
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-14T00:00:00.000
746137
Transaction Id: 746137 • Contract Number: QG-215M • Work Order Id: 667355
Transaction Id
746137
Contract Number
QG-215M
Work Order Id
667355
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
10.8
Units Used
28.0
Total Cost
302.40000000000003
Transaction Date
2015-12-14T00:00:00.000
746139
Transaction Id: 746139 • Contract Number: QG-215M • Work Order Id: 667355
Transaction Id
746139
Contract Number
QG-215M
Work Order Id
667355
Line Item Id
286.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
95.0
Units Used
1.0
Total Cost
95.0
Transaction Date
2015-10-02T00:00:00.000
746140
Transaction Id: 746140 • Contract Number: QG-215M • Work Order Id: 700120
Transaction Id
746140
Contract Number
QG-215M
Work Order Id
700120
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
746141
Transaction Id: 746141 • Contract Number: QG-215M • Work Order Id: 700120
Transaction Id
746141
Contract Number
QG-215M
Work Order Id
700120
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
10.8
Units Used
18.4
Total Cost
198.72
Transaction Date
2015-12-22T00:00:00.000
746142
Transaction Id: 746142 • Contract Number: QG-215M • Work Order Id: 700120
Transaction Id
746142
Contract Number
QG-215M
Work Order Id
700120
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
15.3
Units Used
15.0
Total Cost
229.5
Transaction Date
2015-12-22T00:00:00.000
746143
Transaction Id: 746143 • Contract Number: QG-215M • Work Order Id: 698923
Transaction Id
746143
Contract Number
QG-215M
Work Order Id
698923
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
746144
Transaction Id: 746144 • Contract Number: QG-215M • Work Order Id: 698923
Transaction Id
746144
Contract Number
QG-215M
Work Order Id
698923
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
22.3
Total Cost
267.6
Transaction Date
2015-12-22T00:00:00.000
746145
Transaction Id: 746145 • Contract Number: QG-215M • Work Order Id: 698923
Transaction Id
746145
Contract Number
QG-215M
Work Order Id
698923
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
28.0
Total Cost
476.0
Transaction Date
2015-12-22T00:00:00.000
746149
Transaction Id: 746149 • Contract Number: QG-215M • Work Order Id: 692541
Transaction Id
746149
Contract Number
QG-215M
Work Order Id
692541
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-04T00:00:00.000
746150
Transaction Id: 746150 • Contract Number: QG-215M • Work Order Id: 692541
Transaction Id
746150
Contract Number
QG-215M
Work Order Id
692541
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
47.4
Total Cost
805.8
Transaction Date
2015-12-04T00:00:00.000
746151
Transaction Id: 746151 • Contract Number: QG-215M • Work Order Id: 692541
Transaction Id
746151
Contract Number
QG-215M
Work Order Id
692541
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
14.7
Total Cost
911.4
Transaction Date
2016-03-14T00:00:00.000
746152
Transaction Id: 746152 • Contract Number: QG-215M • Work Order Id: 696548
Transaction Id
746152
Contract Number
QG-215M
Work Order Id
696548
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-04T00:00:00.000
746153
Transaction Id: 746153 • Contract Number: QG-215M • Work Order Id: 696548
Transaction Id
746153
Contract Number
QG-215M
Work Order Id
696548
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.7
Total Cost
793.9000000000001
Transaction Date
2015-12-04T00:00:00.000
746154
Transaction Id: 746154 • Contract Number: QG-215M • Work Order Id: 696548
Transaction Id
746154
Contract Number
QG-215M
Work Order Id
696548
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
17.0
Total Cost
1054.0
Transaction Date
2016-03-14T00:00:00.000
746155
Transaction Id: 746155 • Contract Number: QG-215M • Work Order Id: 691333
Transaction Id
746155
Contract Number
QG-215M
Work Order Id
691333
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-04T00:00:00.000
746156
Transaction Id: 746156 • Contract Number: QG-215M • Work Order Id: 691333
Transaction Id
746156
Contract Number
QG-215M
Work Order Id
691333
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
52.5
Total Cost
892.5
Transaction Date
2015-12-04T00:00:00.000
746157
Transaction Id: 746157 • Contract Number: QG-215M • Work Order Id: 691333
Transaction Id
746157
Contract Number
QG-215M
Work Order Id
691333
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
18.1
Total Cost
1122.2
Transaction Date
2016-03-14T00:00:00.000
746158
Transaction Id: 746158 • Contract Number: QG-215M • Work Order Id: 836636
Transaction Id
746158
Contract Number
QG-215M
Work Order Id
836636
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-04T00:00:00.000
746159
Transaction Id: 746159 • Contract Number: QG-215M • Work Order Id: 836636
Transaction Id
746159
Contract Number
QG-215M
Work Order Id
836636
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
50.0
Total Cost
850.0
Transaction Date
2015-12-04T00:00:00.000
746160
Transaction Id: 746160 • Contract Number: QG-215M • Work Order Id: 836636
Transaction Id
746160
Contract Number
QG-215M
Work Order Id
836636
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
17.6
Total Cost
1091.2
Transaction Date
2016-03-14T00:00:00.000
746161
Transaction Id: 746161 • Contract Number: QG-215M • Work Order Id: 821447
Transaction Id
746161
Contract Number
QG-215M
Work Order Id
821447
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-04T00:00:00.000
746162
Transaction Id: 746162 • Contract Number: QG-215M • Work Order Id: 821447
Transaction Id
746162
Contract Number
QG-215M
Work Order Id
821447
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
50.0
Total Cost
850.0
Transaction Date
2015-12-04T00:00:00.000
746164
Transaction Id: 746164 • Contract Number: QG-215M • Work Order Id: 836236
Transaction Id
746164
Contract Number
QG-215M
Work Order Id
836236
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-04T00:00:00.000
746165
Transaction Id: 746165 • Contract Number: QG-215M • Work Order Id: 836236
Transaction Id
746165
Contract Number
QG-215M
Work Order Id
836236
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
50.0
Total Cost
850.0
Transaction Date
2015-12-04T00:00:00.000
746176
Transaction Id: 746176 • Contract Number: QG-215M • Work Order Id: 696552
Transaction Id
746176
Contract Number
QG-215M
Work Order Id
696552
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-30T00:00:00.000
746177
Transaction Id: 746177 • Contract Number: QG-215M • Work Order Id: 696552
Transaction Id
746177
Contract Number
QG-215M
Work Order Id
696552
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
34.0
Total Cost
578.0
Transaction Date
2015-12-30T00:00:00.000
746178
Transaction Id: 746178 • Contract Number: QG-215M • Work Order Id: 696552
Transaction Id
746178
Contract Number
QG-215M
Work Order Id
696552
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
14.3
Total Cost
886.6
Transaction Date
2016-03-14T00:00:00.000
746227
Transaction Id: 746227 • Contract Number: QG-215M • Work Order Id: 702136
Transaction Id
746227
Contract Number
QG-215M
Work Order Id
702136
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-24T00:00:00.000
746228
Transaction Id: 746228 • Contract Number: QG-215M • Work Order Id: 702136
Transaction Id
746228
Contract Number
QG-215M
Work Order Id
702136
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
51.7
Total Cost
878.9000000000001
Transaction Date
2015-09-24T00:00:00.000
746229
Transaction Id: 746229 • Contract Number: QG-215M • Work Order Id: 702136
Transaction Id
746229
Contract Number
QG-215M
Work Order Id
702136
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
17.8
Total Cost
1103.6000000000001
Transaction Date
2016-03-14T00:00:00.000
746230
Transaction Id: 746230 • Contract Number: QG-215M • Work Order Id: 670112
Transaction Id
746230
Contract Number
QG-215M
Work Order Id
670112
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-04T00:00:00.000
746231
Transaction Id: 746231 • Contract Number: QG-215M • Work Order Id: 670112
Transaction Id
746231
Contract Number
QG-215M
Work Order Id
670112
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
51.7
Total Cost
878.9000000000001
Transaction Date
2015-12-03T00:00:00.000
746232
Transaction Id: 746232 • Contract Number: QG-215M • Work Order Id: 670112
Transaction Id
746232
Contract Number
QG-215M
Work Order Id
670112
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
17.5
Total Cost
1085.0
Transaction Date
2016-03-14T00:00:00.000
746236
Transaction Id: 746236 • Contract Number: QG-215M • Work Order Id: 669328
Transaction Id
746236
Contract Number
QG-215M
Work Order Id
669328
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
746237
Transaction Id: 746237 • Contract Number: QG-215M • Work Order Id: 669328
Transaction Id
746237
Contract Number
QG-215M
Work Order Id
669328
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
53.3
Total Cost
906.0999999999999
Transaction Date
2015-12-03T00:00:00.000
746238
Transaction Id: 746238 • Contract Number: QG-215M • Work Order Id: 669328
Transaction Id
746238
Contract Number
QG-215M
Work Order Id
669328
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
18.5
Total Cost
1147.0
Transaction Date
2016-03-14T00:00:00.000
746239
Transaction Id: 746239 • Contract Number: QG-215M • Work Order Id: 670113
Transaction Id
746239
Contract Number
QG-215M
Work Order Id
670113
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
746240
Transaction Id: 746240 • Contract Number: QG-215M • Work Order Id: 670113
Transaction Id
746240
Contract Number
QG-215M
Work Order Id
670113
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
51.3
Total Cost
872.0999999999999
Transaction Date
2015-12-03T00:00:00.000
746241
Transaction Id: 746241 • Contract Number: QG-215M • Work Order Id: 670113
Transaction Id
746241
Contract Number
QG-215M
Work Order Id
670113
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
17.5
Total Cost
1085.0
Transaction Date
2016-03-14T00:00:00.000
746242
Transaction Id: 746242 • Contract Number: QG-215M • Work Order Id: 666924
Transaction Id
746242
Contract Number
QG-215M
Work Order Id
666924
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
746243
Transaction Id: 746243 • Contract Number: QG-215M • Work Order Id: 666924
Transaction Id
746243
Contract Number
QG-215M
Work Order Id
666924
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
55.5
Total Cost
943.5
Transaction Date
2015-12-03T00:00:00.000
746244
Transaction Id: 746244 • Contract Number: QG-215M • Work Order Id: 666924
Transaction Id
746244
Contract Number
QG-215M
Work Order Id
666924
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
18.5
Total Cost
1147.0
Transaction Date
2016-03-14T00:00:00.000
746245
Transaction Id: 746245 • Contract Number: QG-215M • Work Order Id: 668122
Transaction Id
746245
Contract Number
QG-215M
Work Order Id
668122
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
746246
Transaction Id: 746246 • Contract Number: QG-215M • Work Order Id: 668122
Transaction Id
746246
Contract Number
QG-215M
Work Order Id
668122
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
50.8
Total Cost
863.5999999999999
Transaction Date
2015-12-03T00:00:00.000
746247
Transaction Id: 746247 • Contract Number: QG-215M • Work Order Id: 668122
Transaction Id
746247
Contract Number
QG-215M
Work Order Id
668122
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
17.1
Total Cost
1060.2
Transaction Date
2016-03-14T00:00:00.000
746248
Transaction Id: 746248 • Contract Number: QG-215M • Work Order Id: 669331
Transaction Id
746248
Contract Number
QG-215M
Work Order Id
669331
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
746249
Transaction Id: 746249 • Contract Number: QG-215M • Work Order Id: 669331
Transaction Id
746249
Contract Number
QG-215M
Work Order Id
669331
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
50.0
Total Cost
850.0
Transaction Date
2015-12-03T00:00:00.000
746250
Transaction Id: 746250 • Contract Number: QG-215M • Work Order Id: 669331
Transaction Id
746250
Contract Number
QG-215M
Work Order Id
669331
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
17.4
Total Cost
1078.8
Transaction Date
2016-03-14T00:00:00.000
NYC Data AI • Public-data exploration interface