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
744243
Transaction Id: 744243 • Contract Number: MG-115M • Work Order Id: 661337
Transaction Id
744243
Contract Number
MG-115M
Work Order Id
661337
Line Item Id
312.0
Item Number
23
Line Item Description
REMOVE AND RESET METAL TREE GUARDS AND GRATES
Unit Of Measure
HR
Unit Price
75.0
Units Used
0.25
Total Cost
18.75
Transaction Date
2015-09-04T00:00:00.000
744244
Transaction Id: 744244 • Contract Number: MG-115M • Work Order Id: 662492
Transaction Id
744244
Contract Number
MG-115M
Work Order Id
662492
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
17.2
Total Cost
309.59999999999997
Transaction Date
2015-09-04T00:00:00.000
744245
Transaction Id: 744245 • Contract Number: MG-115M • Work Order Id: 662492
Transaction Id
744245
Contract Number
MG-115M
Work Order Id
662492
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
14.3
Total Cost
314.6
Transaction Date
2015-09-04T00:00:00.000
744246
Transaction Id: 744246 • Contract Number: MG-115M • Work Order Id: 660098
Transaction Id
744246
Contract Number
MG-115M
Work Order Id
660098
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
30.0
Total Cost
540.0
Transaction Date
2015-09-04T00:00:00.000
744247
Transaction Id: 744247 • Contract Number: MG-115M • Work Order Id: 660098
Transaction Id
744247
Contract Number
MG-115M
Work Order Id
660098
Line Item Id
312.0
Item Number
23
Line Item Description
REMOVE AND RESET METAL TREE GUARDS AND GRATES
Unit Of Measure
HR
Unit Price
75.0
Units Used
0.25
Total Cost
18.75
Transaction Date
2015-09-04T00:00:00.000
744248
Transaction Id: 744248 • Contract Number: MG-115M • Work Order Id: 660959
Transaction Id
744248
Contract Number
MG-115M
Work Order Id
660959
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
16.2
Units Used
25.7
Total Cost
416.34
Transaction Date
2015-09-04T00:00:00.000
744249
Transaction Id: 744249 • Contract Number: MG-115M • Work Order Id: 660959
Transaction Id
744249
Contract Number
MG-115M
Work Order Id
660959
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
175.0
Units Used
1.0
Total Cost
175.0
Transaction Date
2015-09-04T00:00:00.000
744250
Transaction Id: 744250 • Contract Number: MG-115M • Work Order Id: 660959
Transaction Id
744250
Contract Number
MG-115M
Work Order Id
660959
Line Item Id
312.0
Item Number
23
Line Item Description
REMOVE AND RESET METAL TREE GUARDS AND GRATES
Unit Of Measure
HR
Unit Price
75.0
Units Used
0.25
Total Cost
18.75
Transaction Date
2015-09-04T00:00:00.000
744251
Transaction Id: 744251 • Contract Number: MG-115M • Work Order Id: 660961
Transaction Id
744251
Contract Number
MG-115M
Work Order Id
660961
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
28.7
Total Cost
516.6
Transaction Date
2015-09-04T00:00:00.000
744252
Transaction Id: 744252 • Contract Number: MG-115M • Work Order Id: 660961
Transaction Id
744252
Contract Number
MG-115M
Work Order Id
660961
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
3.8
Total Cost
83.6
Transaction Date
2015-09-04T00:00:00.000
744253
Transaction Id: 744253 • Contract Number: QG-215M • Work Order Id: 682517
Transaction Id
744253
Contract Number
QG-215M
Work Order Id
682517
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
744254
Transaction Id: 744254 • Contract Number: QG-215M • Work Order Id: 682517
Transaction Id
744254
Contract Number
QG-215M
Work Order Id
682517
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
20.0
Total Cost
220.0
Transaction Date
2015-12-21T00:00:00.000
744257
Transaction Id: 744257 • Contract Number: QG-215M • Work Order Id: 698953
Transaction Id
744257
Contract Number
QG-215M
Work Order Id
698953
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-28T00:00:00.000
744258
Transaction Id: 744258 • Contract Number: QG-215M • Work Order Id: 698953
Transaction Id
744258
Contract Number
QG-215M
Work Order Id
698953
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
30.0
Total Cost
297.0
Transaction Date
2015-12-28T00:00:00.000
744263
Transaction Id: 744263 • Contract Number: QG-215M • Work Order Id: 782617
Transaction Id
744263
Contract Number
QG-215M
Work Order Id
782617
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-27T00:00:00.000
744264
Transaction Id: 744264 • Contract Number: QG-215M • Work Order Id: 782617
Transaction Id
744264
Contract Number
QG-215M
Work Order Id
782617
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
27.0
Total Cost
297.0
Transaction Date
2015-11-27T00:00:00.000
744265
Transaction Id: 744265 • Contract Number: QG-215M • Work Order Id: 785007
Transaction Id
744265
Contract Number
QG-215M
Work Order Id
785007
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-27T00:00:00.000
744266
Transaction Id: 744266 • Contract Number: QG-215M • Work Order Id: 785007
Transaction Id
744266
Contract Number
QG-215M
Work Order Id
785007
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
27.0
Total Cost
297.0
Transaction Date
2015-11-27T00:00:00.000
744269
Transaction Id: 744269 • Contract Number: QG-215M • Work Order Id: 792242
Transaction Id
744269
Contract Number
QG-215M
Work Order Id
792242
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-08T00:00:00.000
744270
Transaction Id: 744270 • Contract Number: QG-215M • Work Order Id: 792242
Transaction Id
744270
Contract Number
QG-215M
Work Order Id
792242
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-12-08T00:00:00.000
744275
Transaction Id: 744275 • Contract Number: QG-215M • Work Order Id: 660809
Transaction Id
744275
Contract Number
QG-215M
Work Order Id
660809
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-21T00:00:00.000
744276
Transaction Id: 744276 • Contract Number: QG-215M • Work Order Id: 660809
Transaction Id
744276
Contract Number
QG-215M
Work Order Id
660809
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-15T00:00:00.000
744277
Transaction Id: 744277 • Contract Number: QG-215M • Work Order Id: 658811
Transaction Id
744277
Contract Number
QG-215M
Work Order Id
658811
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-21T00:00:00.000
744278
Transaction Id: 744278 • Contract Number: QG-215M • Work Order Id: 658811
Transaction Id
744278
Contract Number
QG-215M
Work Order Id
658811
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-15T00:00:00.000
744279
Transaction Id: 744279 • Contract Number: QG-215M • Work Order Id: 639833
Transaction Id
744279
Contract Number
QG-215M
Work Order Id
639833
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
744280
Transaction Id: 744280 • Contract Number: QG-215M • Work Order Id: 639833
Transaction Id
744280
Contract Number
QG-215M
Work Order Id
639833
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-15T00:00:00.000
744281
Transaction Id: 744281 • Contract Number: QG-215M • Work Order Id: 651587
Transaction Id
744281
Contract Number
QG-215M
Work Order Id
651587
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-01T00:00:00.000
744282
Transaction Id: 744282 • Contract Number: QG-215M • Work Order Id: 651587
Transaction Id
744282
Contract Number
QG-215M
Work Order Id
651587
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-15T00:00:00.000
744283
Transaction Id: 744283 • Contract Number: QG-215M • Work Order Id: 643746
Transaction Id
744283
Contract Number
QG-215M
Work Order Id
643746
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
744284
Transaction Id: 744284 • Contract Number: QG-215M • Work Order Id: 643746
Transaction Id
744284
Contract Number
QG-215M
Work Order Id
643746
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-15T00:00:00.000
744285
Transaction Id: 744285 • Contract Number: QG-215M • Work Order Id: 647676
Transaction Id
744285
Contract Number
QG-215M
Work Order Id
647676
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
744286
Transaction Id: 744286 • Contract Number: QG-215M • Work Order Id: 647676
Transaction Id
744286
Contract Number
QG-215M
Work Order Id
647676
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-11T00:00:00.000
744287
Transaction Id: 744287 • Contract Number: QG-215M • Work Order Id: 647870
Transaction Id
744287
Contract Number
QG-215M
Work Order Id
647870
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
744288
Transaction Id: 744288 • Contract Number: QG-215M • Work Order Id: 647870
Transaction Id
744288
Contract Number
QG-215M
Work Order Id
647870
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-11T00:00:00.000
744289
Transaction Id: 744289 • Contract Number: QG-215M • Work Order Id: 653573
Transaction Id
744289
Contract Number
QG-215M
Work Order Id
653573
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
744290
Transaction Id: 744290 • Contract Number: QG-215M • Work Order Id: 653573
Transaction Id
744290
Contract Number
QG-215M
Work Order Id
653573
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-11T00:00:00.000
744291
Transaction Id: 744291 • Contract Number: QG-215M • Work Order Id: 651691
Transaction Id
744291
Contract Number
QG-215M
Work Order Id
651691
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-28T00:00:00.000
744292
Transaction Id: 744292 • Contract Number: QG-215M • Work Order Id: 651691
Transaction Id
744292
Contract Number
QG-215M
Work Order Id
651691
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-12-28T00:00:00.000
744293
Transaction Id: 744293 • Contract Number: QG-215M • Work Order Id: 644835
Transaction Id
744293
Contract Number
QG-215M
Work Order Id
644835
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
744294
Transaction Id: 744294 • Contract Number: QG-215M • Work Order Id: 644835
Transaction Id
744294
Contract Number
QG-215M
Work Order Id
644835
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-14T00:00:00.000
744295
Transaction Id: 744295 • Contract Number: QG-215M • Work Order Id: 980248
Transaction Id
744295
Contract Number
QG-215M
Work Order Id
980248
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-06T00:00:00.000
744296
Transaction Id: 744296 • Contract Number: QG-215M • Work Order Id: 980248
Transaction Id
744296
Contract Number
QG-215M
Work Order Id
980248
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-10-06T00:00:00.000
744297
Transaction Id: 744297 • Contract Number: QG-215M • Work Order Id: 651868
Transaction Id
744297
Contract Number
QG-215M
Work Order Id
651868
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
744298
Transaction Id: 744298 • Contract Number: QG-215M • Work Order Id: 651868
Transaction Id
744298
Contract Number
QG-215M
Work Order Id
651868
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-11T00:00:00.000
744299
Transaction Id: 744299 • Contract Number: QG-215M • Work Order Id: 656372
Transaction Id
744299
Contract Number
QG-215M
Work Order Id
656372
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
744300
Transaction Id: 744300 • Contract Number: QG-215M • Work Order Id: 656372
Transaction Id
744300
Contract Number
QG-215M
Work Order Id
656372
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-25T00:00:00.000
744301
Transaction Id: 744301 • Contract Number: QG-215M • Work Order Id: 655191
Transaction Id
744301
Contract Number
QG-215M
Work Order Id
655191
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
744302
Transaction Id: 744302 • Contract Number: QG-215M • Work Order Id: 655191
Transaction Id
744302
Contract Number
QG-215M
Work Order Id
655191
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-25T00:00:00.000
744303
Transaction Id: 744303 • Contract Number: QG-215M • Work Order Id: 644417
Transaction Id
744303
Contract Number
QG-215M
Work Order Id
644417
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
744304
Transaction Id: 744304 • Contract Number: QG-215M • Work Order Id: 644417
Transaction Id
744304
Contract Number
QG-215M
Work Order Id
644417
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-08T00:00:00.000
NYC Data AI • Public-data exploration interface