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
747545
Transaction Id: 747545 • Contract Number: BG-415M • Work Order Id: 649960
Transaction Id
747545
Contract Number
BG-415M
Work Order Id
649960
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
747546
Transaction Id: 747546 • Contract Number: BG-415M • Work Order Id: 648421
Transaction Id
747546
Contract Number
BG-415M
Work Order Id
648421
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
45.0
Total Cost
630.0
Transaction Date
2015-11-16T00:00:00.000
747547
Transaction Id: 747547 • Contract Number: BG-415M • Work Order Id: 648421
Transaction Id
747547
Contract Number
BG-415M
Work Order Id
648421
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
747548
Transaction Id: 747548 • Contract Number: BG-415M • Work Order Id: 647637
Transaction Id
747548
Contract Number
BG-415M
Work Order Id
647637
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
43.4
Total Cost
607.6
Transaction Date
2015-11-16T00:00:00.000
747549
Transaction Id: 747549 • Contract Number: BG-415M • Work Order Id: 647637
Transaction Id
747549
Contract Number
BG-415M
Work Order Id
647637
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-24T00:00:00.000
747550
Transaction Id: 747550 • Contract Number: BG-415M • Work Order Id: 647640
Transaction Id
747550
Contract Number
BG-415M
Work Order Id
647640
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
54.2
Total Cost
758.8000000000001
Transaction Date
2015-11-16T00:00:00.000
747551
Transaction Id: 747551 • Contract Number: BG-415M • Work Order Id: 647640
Transaction Id
747551
Contract Number
BG-415M
Work Order Id
647640
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-24T00:00:00.000
747552
Transaction Id: 747552 • Contract Number: BG-415M • Work Order Id: 647644
Transaction Id
747552
Contract Number
BG-415M
Work Order Id
647644
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
55.0
Total Cost
770.0
Transaction Date
2015-11-16T00:00:00.000
747553
Transaction Id: 747553 • Contract Number: BG-415M • Work Order Id: 647644
Transaction Id
747553
Contract Number
BG-415M
Work Order Id
647644
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
747554
Transaction Id: 747554 • Contract Number: BG-415M • Work Order Id: 649571
Transaction Id
747554
Contract Number
BG-415M
Work Order Id
649571
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.0
Total Cost
504.0
Transaction Date
2015-11-16T00:00:00.000
747555
Transaction Id: 747555 • Contract Number: BG-415M • Work Order Id: 649571
Transaction Id
747555
Contract Number
BG-415M
Work Order Id
649571
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
747556
Transaction Id: 747556 • Contract Number: BG-415M • Work Order Id: 649574
Transaction Id
747556
Contract Number
BG-415M
Work Order Id
649574
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.8
Total Cost
683.1999999999999
Transaction Date
2015-11-16T00:00:00.000
747557
Transaction Id: 747557 • Contract Number: BG-415M • Work Order Id: 649574
Transaction Id
747557
Contract Number
BG-415M
Work Order Id
649574
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-24T00:00:00.000
747558
Transaction Id: 747558 • Contract Number: BG-415M • Work Order Id: 649576
Transaction Id
747558
Contract Number
BG-415M
Work Order Id
649576
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-16T00:00:00.000
747559
Transaction Id: 747559 • Contract Number: BG-415M • Work Order Id: 649576
Transaction Id
747559
Contract Number
BG-415M
Work Order Id
649576
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
747560
Transaction Id: 747560 • Contract Number: BG-415M • Work Order Id: 649971
Transaction Id
747560
Contract Number
BG-415M
Work Order Id
649971
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
54.9
Total Cost
768.6
Transaction Date
2015-11-16T00:00:00.000
747561
Transaction Id: 747561 • Contract Number: BG-415M • Work Order Id: 649971
Transaction Id
747561
Contract Number
BG-415M
Work Order Id
649971
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
747562
Transaction Id: 747562 • Contract Number: BG-415M • Work Order Id: 647651
Transaction Id
747562
Contract Number
BG-415M
Work Order Id
647651
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-16T00:00:00.000
747563
Transaction Id: 747563 • Contract Number: BG-415M • Work Order Id: 647651
Transaction Id
747563
Contract Number
BG-415M
Work Order Id
647651
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
747564
Transaction Id: 747564 • Contract Number: BG-415M • Work Order Id: 650786
Transaction Id
747564
Contract Number
BG-415M
Work Order Id
650786
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
43.0
Total Cost
602.0
Transaction Date
2015-11-16T00:00:00.000
747565
Transaction Id: 747565 • Contract Number: BG-415M • Work Order Id: 650786
Transaction Id
747565
Contract Number
BG-415M
Work Order Id
650786
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
747566
Transaction Id: 747566 • Contract Number: BG-415M • Work Order Id: 649582
Transaction Id
747566
Contract Number
BG-415M
Work Order Id
649582
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.1
Total Cost
379.40000000000003
Transaction Date
2015-11-16T00:00:00.000
747567
Transaction Id: 747567 • Contract Number: BG-415M • Work Order Id: 649582
Transaction Id
747567
Contract Number
BG-415M
Work Order Id
649582
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
747568
Transaction Id: 747568 • Contract Number: BG-415M • Work Order Id: 649583
Transaction Id
747568
Contract Number
BG-415M
Work Order Id
649583
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.7
Total Cost
387.8
Transaction Date
2015-11-16T00:00:00.000
747569
Transaction Id: 747569 • Contract Number: BG-415M • Work Order Id: 649583
Transaction Id
747569
Contract Number
BG-415M
Work Order Id
649583
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
747570
Transaction Id: 747570 • Contract Number: BG-415M • Work Order Id: 649975
Transaction Id
747570
Contract Number
BG-415M
Work Order Id
649975
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
747571
Transaction Id: 747571 • Contract Number: BG-415M • Work Order Id: 649975
Transaction Id
747571
Contract Number
BG-415M
Work Order Id
649975
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
747572
Transaction Id: 747572 • Contract Number: BG-415M • Work Order Id: 647657
Transaction Id
747572
Contract Number
BG-415M
Work Order Id
647657
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
32.0
Total Cost
448.0
Transaction Date
2015-11-16T00:00:00.000
747573
Transaction Id: 747573 • Contract Number: BG-415M • Work Order Id: 647657
Transaction Id
747573
Contract Number
BG-415M
Work Order Id
647657
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-24T00:00:00.000
747574
Transaction Id: 747574 • Contract Number: BG-415M • Work Order Id: 647658
Transaction Id
747574
Contract Number
BG-415M
Work Order Id
647658
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
32.0
Total Cost
448.0
Transaction Date
2015-11-16T00:00:00.000
747575
Transaction Id: 747575 • Contract Number: BG-415M • Work Order Id: 647658
Transaction Id
747575
Contract Number
BG-415M
Work Order Id
647658
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
747576
Transaction Id: 747576 • Contract Number: BG-415M • Work Order Id: 648434
Transaction Id
747576
Contract Number
BG-415M
Work Order Id
648434
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.3
Total Cost
438.2
Transaction Date
2015-11-16T00:00:00.000
747577
Transaction Id: 747577 • Contract Number: BG-415M • Work Order Id: 648434
Transaction Id
747577
Contract Number
BG-415M
Work Order Id
648434
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
747578
Transaction Id: 747578 • Contract Number: BG-415M • Work Order Id: 643569
Transaction Id
747578
Contract Number
BG-415M
Work Order Id
643569
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
23.3
Total Cost
326.2
Transaction Date
2015-11-06T00:00:00.000
747579
Transaction Id: 747579 • Contract Number: BG-415M • Work Order Id: 643569
Transaction Id
747579
Contract Number
BG-415M
Work Order Id
643569
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
747580
Transaction Id: 747580 • Contract Number: BG-415M • Work Order Id: 649977
Transaction Id
747580
Contract Number
BG-415M
Work Order Id
649977
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
45.0
Total Cost
630.0
Transaction Date
2015-11-06T00:00:00.000
747581
Transaction Id: 747581 • Contract Number: BG-415M • Work Order Id: 649977
Transaction Id
747581
Contract Number
BG-415M
Work Order Id
649977
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
747582
Transaction Id: 747582 • Contract Number: BG-415M • Work Order Id: 643570
Transaction Id
747582
Contract Number
BG-415M
Work Order Id
643570
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
43.1
Total Cost
603.4
Transaction Date
2015-11-06T00:00:00.000
747583
Transaction Id: 747583 • Contract Number: BG-415M • Work Order Id: 643570
Transaction Id
747583
Contract Number
BG-415M
Work Order Id
643570
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
747584
Transaction Id: 747584 • Contract Number: BG-415M • Work Order Id: 647538
Transaction Id
747584
Contract Number
BG-415M
Work Order Id
647538
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
35.6
Total Cost
498.40000000000003
Transaction Date
2015-11-03T00:00:00.000
747585
Transaction Id: 747585 • Contract Number: BG-415M • Work Order Id: 647538
Transaction Id
747585
Contract Number
BG-415M
Work Order Id
647538
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-03T00:00:00.000
747586
Transaction Id: 747586 • Contract Number: BG-415M • Work Order Id: 649142
Transaction Id
747586
Contract Number
BG-415M
Work Order Id
649142
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
35.8
Total Cost
501.19999999999993
Transaction Date
2015-10-21T00:00:00.000
747587
Transaction Id: 747587 • Contract Number: BG-415M • Work Order Id: 649142
Transaction Id
747587
Contract Number
BG-415M
Work Order Id
649142
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-09T00:00:00.000
747588
Transaction Id: 747588 • Contract Number: BG-415M • Work Order Id: 661018
Transaction Id
747588
Contract Number
BG-415M
Work Order Id
661018
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
35.4
Total Cost
495.59999999999997
Transaction Date
2015-11-02T00:00:00.000
747589
Transaction Id: 747589 • Contract Number: BG-415M • Work Order Id: 661018
Transaction Id
747589
Contract Number
BG-415M
Work Order Id
661018
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
747590
Transaction Id: 747590 • Contract Number: BG-415M • Work Order Id: 664482
Transaction Id
747590
Contract Number
BG-415M
Work Order Id
664482
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-02T00:00:00.000
747591
Transaction Id: 747591 • Contract Number: BG-415M • Work Order Id: 664482
Transaction Id
747591
Contract Number
BG-415M
Work Order Id
664482
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
747592
Transaction Id: 747592 • Contract Number: BG-415M • Work Order Id: 647960
Transaction Id
747592
Contract Number
BG-415M
Work Order Id
647960
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
35.0
Total Cost
490.0
Transaction Date
2015-11-02T00:00:00.000
747593
Transaction Id: 747593 • Contract Number: BG-415M • Work Order Id: 647960
Transaction Id
747593
Contract Number
BG-415M
Work Order Id
647960
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
747594
Transaction Id: 747594 • Contract Number: BG-415M • Work Order Id: 667326
Transaction Id
747594
Contract Number
BG-415M
Work Order Id
667326
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-10-23T00:00:00.000