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
747439
Transaction Id: 747439 • Contract Number: BG-415M • Work Order Id: 650813
Transaction Id
747439
Contract Number
BG-415M
Work Order Id
650813
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.0
Total Cost
784.0
Transaction Date
2015-11-16T00:00:00.000
747440
Transaction Id: 747440 • Contract Number: BG-415M • Work Order Id: 650813
Transaction Id
747440
Contract Number
BG-415M
Work Order Id
650813
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-16T00:00:00.000
747441
Transaction Id: 747441 • Contract Number: BG-415M • Work Order Id: 648454
Transaction Id
747441
Contract Number
BG-415M
Work Order Id
648454
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
40.0
Total Cost
560.0
Transaction Date
2015-11-12T00:00:00.000
747442
Transaction Id: 747442 • Contract Number: BG-415M • Work Order Id: 648454
Transaction Id
747442
Contract Number
BG-415M
Work Order Id
648454
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
747443
Transaction Id: 747443 • Contract Number: BG-415M • Work Order Id: 648484
Transaction Id
747443
Contract Number
BG-415M
Work Order Id
648484
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
44.6
Total Cost
624.4
Transaction Date
2015-11-12T00:00:00.000
747444
Transaction Id: 747444 • Contract Number: BG-415M • Work Order Id: 648484
Transaction Id
747444
Contract Number
BG-415M
Work Order Id
648484
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
747445
Transaction Id: 747445 • Contract Number: BG-415M • Work Order Id: 649997
Transaction Id
747445
Contract Number
BG-415M
Work Order Id
649997
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
39.8
Total Cost
557.1999999999999
Transaction Date
2015-11-12T00:00:00.000
747446
Transaction Id: 747446 • Contract Number: BG-415M • Work Order Id: 649997
Transaction Id
747446
Contract Number
BG-415M
Work Order Id
649997
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-25T00:00:00.000
747447
Transaction Id: 747447 • Contract Number: BG-415M • Work Order Id: 650815
Transaction Id
747447
Contract Number
BG-415M
Work Order Id
650815
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
48.2
Total Cost
674.8000000000001
Transaction Date
2015-11-12T00:00:00.000
747448
Transaction Id: 747448 • Contract Number: BG-415M • Work Order Id: 650815
Transaction Id
747448
Contract Number
BG-415M
Work Order Id
650815
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-25T00:00:00.000
747449
Transaction Id: 747449 • Contract Number: BG-415M • Work Order Id: 649610
Transaction Id
747449
Contract Number
BG-415M
Work Order Id
649610
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
27.8
Total Cost
389.2
Transaction Date
2015-11-12T00:00:00.000
747450
Transaction Id: 747450 • Contract Number: BG-415M • Work Order Id: 649610
Transaction Id
747450
Contract Number
BG-415M
Work Order Id
649610
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-25T00:00:00.000
747451
Transaction Id: 747451 • Contract Number: BG-415M • Work Order Id: 639581
Transaction Id
747451
Contract Number
BG-415M
Work Order Id
639581
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
48.0
Total Cost
672.0
Transaction Date
2015-11-12T00:00:00.000
747452
Transaction Id: 747452 • Contract Number: BG-415M • Work Order Id: 639581
Transaction Id
747452
Contract Number
BG-415M
Work Order Id
639581
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
747453
Transaction Id: 747453 • Contract Number: BG-415M • Work Order Id: 1303864
Transaction Id
747453
Contract Number
BG-415M
Work Order Id
1303864
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
47.2
Total Cost
660.8000000000001
Transaction Date
2015-11-12T00:00:00.000
747454
Transaction Id: 747454 • Contract Number: BG-415M • Work Order Id: 1303864
Transaction Id
747454
Contract Number
BG-415M
Work Order Id
1303864
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
747455
Transaction Id: 747455 • Contract Number: BG-415M • Work Order Id: 641940
Transaction Id
747455
Contract Number
BG-415M
Work Order Id
641940
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
49.2
Total Cost
688.8000000000001
Transaction Date
2015-11-12T00:00:00.000
747456
Transaction Id: 747456 • Contract Number: BG-415M • Work Order Id: 641940
Transaction Id
747456
Contract Number
BG-415M
Work Order Id
641940
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-16T00:00:00.000
747457
Transaction Id: 747457 • Contract Number: BG-415M • Work Order Id: 639208
Transaction Id
747457
Contract Number
BG-415M
Work Order Id
639208
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
31.7
Total Cost
443.8
Transaction Date
2015-11-16T00:00:00.000
747458
Transaction Id: 747458 • Contract Number: BG-415M • Work Order Id: 639208
Transaction Id
747458
Contract Number
BG-415M
Work Order Id
639208
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
747459
Transaction Id: 747459 • Contract Number: BG-415M • Work Order Id: 643139
Transaction Id
747459
Contract Number
BG-415M
Work Order Id
643139
Line Item Id
287.0
Item Number
20
Line Item Description
EXPANSION OF EXISTING SIDEWALK TREE PITS
Unit Of Measure
SF
Unit Price
14.0
Units Used
50.8
Total Cost
711.1999999999999
Transaction Date
2016-04-15T00:00:00.000
747460
Transaction Id: 747460 • Contract Number: BG-415M • Work Order Id: 643143
Transaction Id
747460
Contract Number
BG-415M
Work Order Id
643143
Line Item Id
287.0
Item Number
20
Line Item Description
EXPANSION OF EXISTING SIDEWALK TREE PITS
Unit Of Measure
SF
Unit Price
14.0
Units Used
54.2
Total Cost
758.8000000000001
Transaction Date
2016-04-15T00:00:00.000
747461
Transaction Id: 747461 • Contract Number: BG-415M • Work Order Id: 651126
Transaction Id
747461
Contract Number
BG-415M
Work Order Id
651126
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.3
Total Cost
466.19999999999993
Transaction Date
2015-11-12T00:00:00.000
747462
Transaction Id: 747462 • Contract Number: BG-415M • Work Order Id: 651126
Transaction Id
747462
Contract Number
BG-415M
Work Order Id
651126
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
747463
Transaction Id: 747463 • Contract Number: BG-415M • Work Order Id: 648523
Transaction Id
747463
Contract Number
BG-415M
Work Order Id
648523
Line Item Id
287.0
Item Number
20
Line Item Description
EXPANSION OF EXISTING SIDEWALK TREE PITS
Unit Of Measure
SF
Unit Price
14.0
Units Used
28.4
Total Cost
397.59999999999997
Transaction Date
2015-11-16T00:00:00.000
747464
Transaction Id: 747464 • Contract Number: BG-415M • Work Order Id: 640448
Transaction Id
747464
Contract Number
BG-415M
Work Order Id
640448
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
49.2
Total Cost
688.8000000000001
Transaction Date
2015-11-06T00:00:00.000
747465
Transaction Id: 747465 • Contract Number: BG-415M • Work Order Id: 640448
Transaction Id
747465
Contract Number
BG-415M
Work Order Id
640448
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
747466
Transaction Id: 747466 • Contract Number: BG-415M • Work Order Id: 642736
Transaction Id
747466
Contract Number
BG-415M
Work Order Id
642736
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
29.3
Total Cost
410.2
Transaction Date
2015-11-06T00:00:00.000
747467
Transaction Id: 747467 • Contract Number: BG-415M • Work Order Id: 642736
Transaction Id
747467
Contract Number
BG-415M
Work Order Id
642736
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-11T00:00:00.000
747468
Transaction Id: 747468 • Contract Number: BG-415M • Work Order Id: 647743
Transaction Id
747468
Contract Number
BG-415M
Work Order Id
647743
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
41.5
Total Cost
581.0
Transaction Date
2015-11-06T00:00:00.000
747469
Transaction Id: 747469 • Contract Number: BG-415M • Work Order Id: 647743
Transaction Id
747469
Contract Number
BG-415M
Work Order Id
647743
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
747470
Transaction Id: 747470 • Contract Number: BG-415M • Work Order Id: 649686
Transaction Id
747470
Contract Number
BG-415M
Work Order Id
649686
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
29.3
Total Cost
410.2
Transaction Date
2015-11-06T00:00:00.000
747471
Transaction Id: 747471 • Contract Number: BG-415M • Work Order Id: 649686
Transaction Id
747471
Contract Number
BG-415M
Work Order Id
649686
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
747472
Transaction Id: 747472 • Contract Number: BG-415M • Work Order Id: 639645
Transaction Id
747472
Contract Number
BG-415M
Work Order Id
639645
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
39.7
Total Cost
555.8000000000001
Transaction Date
2015-11-12T00:00:00.000
747473
Transaction Id: 747473 • Contract Number: BG-415M • Work Order Id: 639645
Transaction Id
747473
Contract Number
BG-415M
Work Order Id
639645
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
747474
Transaction Id: 747474 • Contract Number: BG-415M • Work Order Id: 652414
Transaction Id
747474
Contract Number
BG-415M
Work Order Id
652414
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.7
Total Cost
513.8000000000001
Transaction Date
2015-11-16T00:00:00.000
747475
Transaction Id: 747475 • Contract Number: BG-415M • Work Order Id: 652414
Transaction Id
747475
Contract Number
BG-415M
Work Order Id
652414
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
747476
Transaction Id: 747476 • Contract Number: BG-415M • Work Order Id: 653134
Transaction Id
747476
Contract Number
BG-415M
Work Order Id
653134
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
25.6
Total Cost
358.40000000000003
Transaction Date
2015-11-12T00:00:00.000
747477
Transaction Id: 747477 • Contract Number: BG-415M • Work Order Id: 653134
Transaction Id
747477
Contract Number
BG-415M
Work Order Id
653134
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
747478
Transaction Id: 747478 • Contract Number: BG-415M • Work Order Id: 656376
Transaction Id
747478
Contract Number
BG-415M
Work Order Id
656376
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
48.3
Total Cost
676.1999999999999
Transaction Date
2015-11-02T00:00:00.000
747479
Transaction Id: 747479 • Contract Number: BG-415M • Work Order Id: 656376
Transaction Id
747479
Contract Number
BG-415M
Work Order Id
656376
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-02T00:00:00.000
747480
Transaction Id: 747480 • Contract Number: BG-415M • Work Order Id: 655587
Transaction Id
747480
Contract Number
BG-415M
Work Order Id
655587
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
50.0
Total Cost
700.0
Transaction Date
2015-11-02T00:00:00.000
747481
Transaction Id: 747481 • Contract Number: BG-415M • Work Order Id: 655587
Transaction Id
747481
Contract Number
BG-415M
Work Order Id
655587
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-02T00:00:00.000
747482
Transaction Id: 747482 • Contract Number: BG-415M • Work Order Id: 655202
Transaction Id
747482
Contract Number
BG-415M
Work Order Id
655202
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.0
Total Cost
420.0
Transaction Date
2015-11-02T00:00:00.000
747483
Transaction Id: 747483 • Contract Number: BG-415M • Work Order Id: 655202
Transaction Id
747483
Contract Number
BG-415M
Work Order Id
655202
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
747484
Transaction Id: 747484 • Contract Number: BG-415M • Work Order Id: 655591
Transaction Id
747484
Contract Number
BG-415M
Work Order Id
655591
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
50.0
Total Cost
700.0
Transaction Date
2015-11-02T00:00:00.000
747485
Transaction Id: 747485 • Contract Number: BG-415M • Work Order Id: 655591
Transaction Id
747485
Contract Number
BG-415M
Work Order Id
655591
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
747486
Transaction Id: 747486 • Contract Number: BG-415M • Work Order Id: 655204
Transaction Id
747486
Contract Number
BG-415M
Work Order Id
655204
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
40.0
Total Cost
560.0
Transaction Date
2015-11-11T00:00:00.000
747487
Transaction Id: 747487 • Contract Number: BG-415M • Work Order Id: 655204
Transaction Id
747487
Contract Number
BG-415M
Work Order Id
655204
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
747488
Transaction Id: 747488 • Contract Number: BG-415M • Work Order Id: 653309
Transaction Id
747488
Contract Number
BG-415M
Work Order Id
653309
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
40.0
Total Cost
560.0
Transaction Date
2015-11-11T00:00:00.000