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
745419
Transaction Id: 745419 • Contract Number: QG-215M • Work Order Id: 728144
Transaction Id
745419
Contract Number
QG-215M
Work Order Id
728144
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
745420
Transaction Id: 745420 • Contract Number: QG-215M • Work Order Id: 734130
Transaction Id
745420
Contract Number
QG-215M
Work Order Id
734130
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-07T00:00:00.000
745421
Transaction Id: 745421 • Contract Number: QG-215M • Work Order Id: 734130
Transaction Id
745421
Contract Number
QG-215M
Work Order Id
734130
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-07T00:00:00.000
745448
Transaction Id: 745448 • Contract Number: QG-215M • Work Order Id: 730134
Transaction Id
745448
Contract Number
QG-215M
Work Order Id
730134
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-07T00:00:00.000
745449
Transaction Id: 745449 • Contract Number: QG-215M • Work Order Id: 730134
Transaction Id
745449
Contract Number
QG-215M
Work Order Id
730134
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-07T00:00:00.000
745450
Transaction Id: 745450 • Contract Number: QG-215M • Work Order Id: 736121
Transaction Id
745450
Contract Number
QG-215M
Work Order Id
736121
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
745451
Transaction Id: 745451 • Contract Number: QG-215M • Work Order Id: 736121
Transaction Id
745451
Contract Number
QG-215M
Work Order Id
736121
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
745464
Transaction Id: 745464 • Contract Number: QG-215M • Work Order Id: 735723
Transaction Id
745464
Contract Number
QG-215M
Work Order Id
735723
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
745465
Transaction Id: 745465 • Contract Number: QG-215M • Work Order Id: 735723
Transaction Id
745465
Contract Number
QG-215M
Work Order Id
735723
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.4
Total Cost
257.4
Transaction Date
2015-12-09T00:00:00.000
745466
Transaction Id: 745466 • Contract Number: QG-215M • Work Order Id: 735326
Transaction Id
745466
Contract Number
QG-215M
Work Order Id
735326
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
745467
Transaction Id: 745467 • Contract Number: QG-215M • Work Order Id: 735326
Transaction Id
745467
Contract Number
QG-215M
Work Order Id
735326
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.3
Total Cost
256.3
Transaction Date
2015-12-09T00:00:00.000
745468
Transaction Id: 745468 • Contract Number: QG-215M • Work Order Id: 736523
Transaction Id
745468
Contract Number
QG-215M
Work Order Id
736523
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
745469
Transaction Id: 745469 • Contract Number: QG-215M • Work Order Id: 736523
Transaction Id
745469
Contract Number
QG-215M
Work Order Id
736523
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
745470
Transaction Id: 745470 • Contract Number: QG-215M • Work Order Id: 737325
Transaction Id
745470
Contract Number
QG-215M
Work Order Id
737325
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-07T00:00:00.000
745471
Transaction Id: 745471 • Contract Number: QG-215M • Work Order Id: 737325
Transaction Id
745471
Contract Number
QG-215M
Work Order Id
737325
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-07T00:00:00.000
745474
Transaction Id: 745474 • Contract Number: QG-215M • Work Order Id: 738521
Transaction Id
745474
Contract Number
QG-215M
Work Order Id
738521
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-07T00:00:00.000
745475
Transaction Id: 745475 • Contract Number: QG-215M • Work Order Id: 738521
Transaction Id
745475
Contract Number
QG-215M
Work Order Id
738521
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-07T00:00:00.000
745476
Transaction Id: 745476 • Contract Number: QG-215M • Work Order Id: 662942
Transaction Id
745476
Contract Number
QG-215M
Work Order Id
662942
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
745477
Transaction Id: 745477 • Contract Number: QG-215M • Work Order Id: 662942
Transaction Id
745477
Contract Number
QG-215M
Work Order Id
662942
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
745478
Transaction Id: 745478 • Contract Number: QG-215M • Work Order Id: 739721
Transaction Id
745478
Contract Number
QG-215M
Work Order Id
739721
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-07T00:00:00.000
745479
Transaction Id: 745479 • Contract Number: QG-215M • Work Order Id: 739721
Transaction Id
745479
Contract Number
QG-215M
Work Order Id
739721
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
18.8
Total Cost
206.8
Transaction Date
2015-12-07T00:00:00.000
745486
Transaction Id: 745486 • Contract Number: QG-215M • Work Order Id: 661000
Transaction Id
745486
Contract Number
QG-215M
Work Order Id
661000
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
745487
Transaction Id: 745487 • Contract Number: QG-215M • Work Order Id: 661000
Transaction Id
745487
Contract Number
QG-215M
Work Order Id
661000
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
745488
Transaction Id: 745488 • Contract Number: QG-215M • Work Order Id: 663663
Transaction Id
745488
Contract Number
QG-215M
Work Order Id
663663
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
745489
Transaction Id: 745489 • Contract Number: QG-215M • Work Order Id: 663663
Transaction Id
745489
Contract Number
QG-215M
Work Order Id
663663
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
745490
Transaction Id: 745490 • Contract Number: QG-215M • Work Order Id: 664060
Transaction Id
745490
Contract Number
QG-215M
Work Order Id
664060
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
745491
Transaction Id: 745491 • Contract Number: QG-215M • Work Order Id: 664060
Transaction Id
745491
Contract Number
QG-215M
Work Order Id
664060
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
745492
Transaction Id: 745492 • Contract Number: QG-215M • Work Order Id: 736133
Transaction Id
745492
Contract Number
QG-215M
Work Order Id
736133
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-21T00:00:00.000
745493
Transaction Id: 745493 • Contract Number: QG-215M • Work Order Id: 736133
Transaction Id
745493
Contract Number
QG-215M
Work Order Id
736133
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-11-05T00:00:00.000
745494
Transaction Id: 745494 • Contract Number: QG-215M • Work Order Id: 738527
Transaction Id
745494
Contract Number
QG-215M
Work Order Id
738527
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-21T00:00:00.000
745495
Transaction Id: 745495 • Contract Number: QG-215M • Work Order Id: 738527
Transaction Id
745495
Contract Number
QG-215M
Work Order Id
738527
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-11-05T00:00:00.000
745496
Transaction Id: 745496 • Contract Number: QG-215M • Work Order Id: 736925
Transaction Id
745496
Contract Number
QG-215M
Work Order Id
736925
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-07T00:00:00.000
745497
Transaction Id: 745497 • Contract Number: QG-215M • Work Order Id: 736925
Transaction Id
745497
Contract Number
QG-215M
Work Order Id
736925
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.3
Total Cost
223.3
Transaction Date
2015-12-07T00:00:00.000
745498
Transaction Id: 745498 • Contract Number: QG-215M • Work Order Id: 820641
Transaction Id
745498
Contract Number
QG-215M
Work Order Id
820641
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-07T00:00:00.000
745499
Transaction Id: 745499 • Contract Number: QG-215M • Work Order Id: 820641
Transaction Id
745499
Contract Number
QG-215M
Work Order Id
820641
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
22.8
Total Cost
250.8
Transaction Date
2015-12-07T00:00:00.000
745508
Transaction Id: 745508 • Contract Number: QG-215M • Work Order Id: 738943
Transaction Id
745508
Contract Number
QG-215M
Work Order Id
738943
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-07T00:00:00.000
745509
Transaction Id: 745509 • Contract Number: QG-215M • Work Order Id: 738943
Transaction Id
745509
Contract Number
QG-215M
Work Order Id
738943
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-07T00:00:00.000
745510
Transaction Id: 745510 • Contract Number: QG-215M • Work Order Id: 735747
Transaction Id
745510
Contract Number
QG-215M
Work Order Id
735747
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-07T00:00:00.000
745511
Transaction Id: 745511 • Contract Number: QG-215M • Work Order Id: 735747
Transaction Id
745511
Contract Number
QG-215M
Work Order Id
735747
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-07T00:00:00.000
745512
Transaction Id: 745512 • Contract Number: QG-215M • Work Order Id: 738148
Transaction Id
745512
Contract Number
QG-215M
Work Order Id
738148
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-07T00:00:00.000
745513
Transaction Id: 745513 • Contract Number: QG-215M • Work Order Id: 738148
Transaction Id
745513
Contract Number
QG-215M
Work Order Id
738148
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-07T00:00:00.000
745514
Transaction Id: 745514 • Contract Number: QG-215M • Work Order Id: 735749
Transaction Id
745514
Contract Number
QG-215M
Work Order Id
735749
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-21T00:00:00.000
745515
Transaction Id: 745515 • Contract Number: QG-215M • Work Order Id: 735749
Transaction Id
745515
Contract Number
QG-215M
Work Order Id
735749
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-11-05T00:00:00.000
745516
Transaction Id: 745516 • Contract Number: QG-215M • Work Order Id: 741741
Transaction Id
745516
Contract Number
QG-215M
Work Order Id
741741
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-21T00:00:00.000
745517
Transaction Id: 745517 • Contract Number: QG-215M • Work Order Id: 741741
Transaction Id
745517
Contract Number
QG-215M
Work Order Id
741741
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-11-05T00:00:00.000
745518
Transaction Id: 745518 • Contract Number: QG-215M • Work Order Id: 747738
Transaction Id
745518
Contract Number
QG-215M
Work Order Id
747738
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-21T00:00:00.000
745519
Transaction Id: 745519 • Contract Number: QG-215M • Work Order Id: 747738
Transaction Id
745519
Contract Number
QG-215M
Work Order Id
747738
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-11-05T00:00:00.000
745520
Transaction Id: 745520 • Contract Number: QG-215M • Work Order Id: 749738
Transaction Id
745520
Contract Number
QG-215M
Work Order Id
749738
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-21T00:00:00.000
745521
Transaction Id: 745521 • Contract Number: QG-215M • Work Order Id: 749738
Transaction Id
745521
Contract Number
QG-215M
Work Order Id
749738
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-11-05T00:00:00.000
745522
Transaction Id: 745522 • Contract Number: QG-215M • Work Order Id: 746136
Transaction Id
745522
Contract Number
QG-215M
Work Order Id
746136
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-21T00:00:00.000