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
745295
Transaction Id: 745295 • Contract Number: QG-215M • Work Order Id: 682531
Transaction Id
745295
Contract Number
QG-215M
Work Order Id
682531
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-03T00:00:00.000
745306
Transaction Id: 745306 • Contract Number: QG-215M • Work Order Id: 688141
Transaction Id
745306
Contract Number
QG-215M
Work Order Id
688141
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-10T00:00:00.000
745307
Transaction Id: 745307 • Contract Number: QG-215M • Work Order Id: 688141
Transaction Id
745307
Contract Number
QG-215M
Work Order Id
688141
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-10T00:00:00.000
745308
Transaction Id: 745308 • Contract Number: QG-215M • Work Order Id: 827850
Transaction Id
745308
Contract Number
QG-215M
Work Order Id
827850
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
2016-01-15T00:00:00.000
745309
Transaction Id: 745309 • Contract Number: QG-215M • Work Order Id: 827850
Transaction Id
745309
Contract Number
QG-215M
Work Order Id
827850
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
29.7
Total Cost
326.7
Transaction Date
2016-01-15T00:00:00.000
745310
Transaction Id: 745310 • Contract Number: QG-215M • Work Order Id: 683756
Transaction Id
745310
Contract Number
QG-215M
Work Order Id
683756
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-10T00:00:00.000
745311
Transaction Id: 745311 • Contract Number: QG-215M • Work Order Id: 683756
Transaction Id
745311
Contract Number
QG-215M
Work Order Id
683756
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
23.6
Total Cost
259.6
Transaction Date
2015-12-10T00:00:00.000
745312
Transaction Id: 745312 • Contract Number: QG-215M • Work Order Id: 664874
Transaction Id
745312
Contract Number
QG-215M
Work Order Id
664874
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
745313
Transaction Id: 745313 • Contract Number: QG-215M • Work Order Id: 664874
Transaction Id
745313
Contract Number
QG-215M
Work Order Id
664874
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-14T00:00:00.000
745314
Transaction Id: 745314 • Contract Number: QG-215M • Work Order Id: 666114
Transaction Id
745314
Contract Number
QG-215M
Work Order Id
666114
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
2016-01-15T00:00:00.000
745315
Transaction Id: 745315 • Contract Number: QG-215M • Work Order Id: 666114
Transaction Id
745315
Contract Number
QG-215M
Work Order Id
666114
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
2016-01-15T00:00:00.000
745326
Transaction Id: 745326 • Contract Number: QG-215M • Work Order Id: 684137
Transaction Id
745326
Contract Number
QG-215M
Work Order Id
684137
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
745327
Transaction Id: 745327 • Contract Number: QG-215M • Work Order Id: 684137
Transaction Id
745327
Contract Number
QG-215M
Work Order Id
684137
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-22T00:00:00.000
745328
Transaction Id: 745328 • Contract Number: QG-215M • Work Order Id: 661021
Transaction Id
745328
Contract Number
QG-215M
Work Order Id
661021
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
745329
Transaction Id: 745329 • Contract Number: QG-215M • Work Order Id: 661021
Transaction Id
745329
Contract Number
QG-215M
Work Order Id
661021
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-22T00:00:00.000
745330
Transaction Id: 745330 • Contract Number: QG-215M • Work Order Id: 663685
Transaction Id
745330
Contract Number
QG-215M
Work Order Id
663685
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
745331
Transaction Id: 745331 • Contract Number: QG-215M • Work Order Id: 663685
Transaction Id
745331
Contract Number
QG-215M
Work Order Id
663685
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-22T00:00:00.000
745336
Transaction Id: 745336 • Contract Number: QG-215M • Work Order Id: 682532
Transaction Id
745336
Contract Number
QG-215M
Work Order Id
682532
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
745337
Transaction Id: 745337 • Contract Number: QG-215M • Work Order Id: 682532
Transaction Id
745337
Contract Number
QG-215M
Work Order Id
682532
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-24T00:00:00.000
745338
Transaction Id: 745338 • Contract Number: QG-215M • Work Order Id: 683358
Transaction Id
745338
Contract Number
QG-215M
Work Order Id
683358
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
745339
Transaction Id: 745339 • Contract Number: QG-215M • Work Order Id: 683358
Transaction Id
745339
Contract Number
QG-215M
Work Order Id
683358
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-24T00:00:00.000
745340
Transaction Id: 745340 • Contract Number: QG-215M • Work Order Id: 690504
Transaction Id
745340
Contract Number
QG-215M
Work Order Id
690504
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
745341
Transaction Id: 745341 • Contract Number: QG-215M • Work Order Id: 690504
Transaction Id
745341
Contract Number
QG-215M
Work Order Id
690504
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-24T00:00:00.000
745342
Transaction Id: 745342 • Contract Number: QG-215M • Work Order Id: 696101
Transaction Id
745342
Contract Number
QG-215M
Work Order Id
696101
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
745343
Transaction Id: 745343 • Contract Number: QG-215M • Work Order Id: 696101
Transaction Id
745343
Contract Number
QG-215M
Work Order Id
696101
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-24T00:00:00.000
745344
Transaction Id: 745344 • Contract Number: QG-215M • Work Order Id: 660152
Transaction Id
745344
Contract Number
QG-215M
Work Order Id
660152
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-11T00:00:00.000
745345
Transaction Id: 745345 • Contract Number: QG-215M • Work Order Id: 660152
Transaction Id
745345
Contract Number
QG-215M
Work Order Id
660152
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-11T00:00:00.000
745358
Transaction Id: 745358 • Contract Number: QG-215M • Work Order Id: 728519
Transaction Id
745358
Contract Number
QG-215M
Work Order Id
728519
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
2016-01-15T00:00:00.000
745359
Transaction Id: 745359 • Contract Number: QG-215M • Work Order Id: 728519
Transaction Id
745359
Contract Number
QG-215M
Work Order Id
728519
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
2016-01-15T00:00:00.000
745360
Transaction Id: 745360 • Contract Number: QG-215M • Work Order Id: 729333
Transaction Id
745360
Contract Number
QG-215M
Work Order Id
729333
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
2016-01-15T00:00:00.000
745361
Transaction Id: 745361 • Contract Number: QG-215M • Work Order Id: 729333
Transaction Id
745361
Contract Number
QG-215M
Work Order Id
729333
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
2016-01-15T00:00:00.000
745370
Transaction Id: 745370 • Contract Number: QG-215M • Work Order Id: 728131
Transaction Id
745370
Contract Number
QG-215M
Work Order Id
728131
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-15T00:00:00.000
745371
Transaction Id: 745371 • Contract Number: QG-215M • Work Order Id: 728131
Transaction Id
745371
Contract Number
QG-215M
Work Order Id
728131
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.7
Total Cost
272.4
Transaction Date
2015-12-15T00:00:00.000
745378
Transaction Id: 745378 • Contract Number: QG-215M • Work Order Id: 728132
Transaction Id
745378
Contract Number
QG-215M
Work Order Id
728132
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-15T00:00:00.000
745379
Transaction Id: 745379 • Contract Number: QG-215M • Work Order Id: 728132
Transaction Id
745379
Contract Number
QG-215M
Work Order Id
728132
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-10T00:00:00.000
745380
Transaction Id: 745380 • Contract Number: QG-215M • Work Order Id: 728140
Transaction Id
745380
Contract Number
QG-215M
Work Order Id
728140
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-15T00:00:00.000
745381
Transaction Id: 745381 • Contract Number: QG-215M • Work Order Id: 728140
Transaction Id
745381
Contract Number
QG-215M
Work Order Id
728140
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
19.0
Total Cost
209.0
Transaction Date
2015-12-15T00:00:00.000
745382
Transaction Id: 745382 • Contract Number: QG-215M • Work Order Id: 732932
Transaction Id
745382
Contract Number
QG-215M
Work Order Id
732932
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-09T00:00:00.000
745383
Transaction Id: 745383 • Contract Number: QG-215M • Work Order Id: 732932
Transaction Id
745383
Contract Number
QG-215M
Work Order Id
732932
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-09T00:00:00.000
745388
Transaction Id: 745388 • Contract Number: QG-215M • Work Order Id: 792640
Transaction Id
745388
Contract Number
QG-215M
Work Order Id
792640
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-09T00:00:00.000
745389
Transaction Id: 745389 • Contract Number: QG-215M • Work Order Id: 792640
Transaction Id
745389
Contract Number
QG-215M
Work Order Id
792640
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-09T00:00:00.000
745390
Transaction Id: 745390 • Contract Number: QG-215M • Work Order Id: 789042
Transaction Id
745390
Contract Number
QG-215M
Work Order Id
789042
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-09T00:00:00.000
745391
Transaction Id: 745391 • Contract Number: QG-215M • Work Order Id: 789042
Transaction Id
745391
Contract Number
QG-215M
Work Order Id
789042
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-09T00:00:00.000
745412
Transaction Id: 745412 • Contract Number: QG-215M • Work Order Id: 728142
Transaction Id
745412
Contract Number
QG-215M
Work Order Id
728142
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-09T00:00:00.000
745413
Transaction Id: 745413 • Contract Number: QG-215M • Work Order Id: 728142
Transaction Id
745413
Contract Number
QG-215M
Work Order Id
728142
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-09T00:00:00.000
745414
Transaction Id: 745414 • Contract Number: QG-215M • Work Order Id: 732938
Transaction Id
745414
Contract Number
QG-215M
Work Order Id
732938
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-09T00:00:00.000
745415
Transaction Id: 745415 • Contract Number: QG-215M • Work Order Id: 732938
Transaction Id
745415
Contract Number
QG-215M
Work Order Id
732938
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-09T00:00:00.000
745416
Transaction Id: 745416 • Contract Number: QG-215M • Work Order Id: 732939
Transaction Id
745416
Contract Number
QG-215M
Work Order Id
732939
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-09T00:00:00.000
745417
Transaction Id: 745417 • Contract Number: QG-215M • Work Order Id: 732939
Transaction Id
745417
Contract Number
QG-215M
Work Order Id
732939
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-09T00:00:00.000
745418
Transaction Id: 745418 • Contract Number: QG-215M • Work Order Id: 728144
Transaction Id
745418
Contract Number
QG-215M
Work Order Id
728144
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-09T00:00:00.000