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
744699
Transaction Id: 744699 • Contract Number: QG-215M • Work Order Id: 649697
Transaction Id
744699
Contract Number
QG-215M
Work Order Id
649697
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-23T00:00:00.000
744700
Transaction Id: 744700 • Contract Number: QG-215M • Work Order Id: 649697
Transaction Id
744700
Contract Number
QG-215M
Work Order Id
649697
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-04T00:00:00.000
744705
Transaction Id: 744705 • Contract Number: QG-215M • Work Order Id: 667334
Transaction Id
744705
Contract Number
QG-215M
Work Order Id
667334
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-23T00:00:00.000
744706
Transaction Id: 744706 • Contract Number: QG-215M • Work Order Id: 667334
Transaction Id
744706
Contract Number
QG-215M
Work Order Id
667334
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-04T00:00:00.000
744707
Transaction Id: 744707 • Contract Number: QG-215M • Work Order Id: 669712
Transaction Id
744707
Contract Number
QG-215M
Work Order Id
669712
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-23T00:00:00.000
744708
Transaction Id: 744708 • Contract Number: QG-215M • Work Order Id: 669712
Transaction Id
744708
Contract Number
QG-215M
Work Order Id
669712
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-04T00:00:00.000
744709
Transaction Id: 744709 • Contract Number: QG-215M • Work Order Id: 651442
Transaction Id
744709
Contract Number
QG-215M
Work Order Id
651442
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-07T00:00:00.000
744710
Transaction Id: 744710 • Contract Number: QG-215M • Work Order Id: 651442
Transaction Id
744710
Contract Number
QG-215M
Work Order Id
651442
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-21T00:00:00.000
744711
Transaction Id: 744711 • Contract Number: QG-215M • Work Order Id: 651372
Transaction Id
744711
Contract Number
QG-215M
Work Order Id
651372
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-07T00:00:00.000
744712
Transaction Id: 744712 • Contract Number: QG-215M • Work Order Id: 651372
Transaction Id
744712
Contract Number
QG-215M
Work Order Id
651372
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-21T00:00:00.000
744713
Transaction Id: 744713 • Contract Number: QG-215M • Work Order Id: 651763
Transaction Id
744713
Contract Number
QG-215M
Work Order Id
651763
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-07T00:00:00.000
744714
Transaction Id: 744714 • Contract Number: QG-215M • Work Order Id: 651763
Transaction Id
744714
Contract Number
QG-215M
Work Order Id
651763
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-21T00:00:00.000
744715
Transaction Id: 744715 • Contract Number: QG-215M • Work Order Id: 647944
Transaction Id
744715
Contract Number
QG-215M
Work Order Id
647944
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-07T00:00:00.000
744716
Transaction Id: 744716 • Contract Number: QG-215M • Work Order Id: 647944
Transaction Id
744716
Contract Number
QG-215M
Work Order Id
647944
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-21T00:00:00.000
744717
Transaction Id: 744717 • Contract Number: QG-215M • Work Order Id: 660009
Transaction Id
744717
Contract Number
QG-215M
Work Order Id
660009
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-14T00:00:00.000
744718
Transaction Id: 744718 • Contract Number: QG-215M • Work Order Id: 660009
Transaction Id
744718
Contract Number
QG-215M
Work Order Id
660009
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-14T00:00:00.000
744719
Transaction Id: 744719 • Contract Number: QG-215M • Work Order Id: 666532
Transaction Id
744719
Contract Number
QG-215M
Work Order Id
666532
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
744720
Transaction Id: 744720 • Contract Number: QG-215M • Work Order Id: 666532
Transaction Id
744720
Contract Number
QG-215M
Work Order Id
666532
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
744721
Transaction Id: 744721 • Contract Number: QG-215M • Work Order Id: 668948
Transaction Id
744721
Contract Number
QG-215M
Work Order Id
668948
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
744722
Transaction Id: 744722 • Contract Number: QG-215M • Work Order Id: 668948
Transaction Id
744722
Contract Number
QG-215M
Work Order Id
668948
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
744723
Transaction Id: 744723 • Contract Number: QG-215M • Work Order Id: 666105
Transaction Id
744723
Contract Number
QG-215M
Work Order Id
666105
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
744724
Transaction Id: 744724 • Contract Number: QG-215M • Work Order Id: 666105
Transaction Id
744724
Contract Number
QG-215M
Work Order Id
666105
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
744725
Transaction Id: 744725 • Contract Number: QG-215M • Work Order Id: 647558
Transaction Id
744725
Contract Number
QG-215M
Work Order Id
647558
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
744726
Transaction Id: 744726 • Contract Number: QG-215M • Work Order Id: 647558
Transaction Id
744726
Contract Number
QG-215M
Work Order Id
647558
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
744727
Transaction Id: 744727 • Contract Number: QG-215M • Work Order Id: 668535
Transaction Id
744727
Contract Number
QG-215M
Work Order Id
668535
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
744728
Transaction Id: 744728 • Contract Number: QG-215M • Work Order Id: 668535
Transaction Id
744728
Contract Number
QG-215M
Work Order Id
668535
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-23T00:00:00.000
744729
Transaction Id: 744729 • Contract Number: QG-215M • Work Order Id: 665724
Transaction Id
744729
Contract Number
QG-215M
Work Order Id
665724
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
744730
Transaction Id: 744730 • Contract Number: QG-215M • Work Order Id: 665724
Transaction Id
744730
Contract Number
QG-215M
Work Order Id
665724
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-23T00:00:00.000
744731
Transaction Id: 744731 • Contract Number: QG-215M • Work Order Id: 658812
Transaction Id
744731
Contract Number
QG-215M
Work Order Id
658812
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-31T00:00:00.000
744732
Transaction Id: 744732 • Contract Number: QG-215M • Work Order Id: 658812
Transaction Id
744732
Contract Number
QG-215M
Work Order Id
658812
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-31T00:00:00.000
744733
Transaction Id: 744733 • Contract Number: QG-215M • Work Order Id: 661615
Transaction Id
744733
Contract Number
QG-215M
Work Order Id
661615
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-31T00:00:00.000
744734
Transaction Id: 744734 • Contract Number: QG-215M • Work Order Id: 661615
Transaction Id
744734
Contract Number
QG-215M
Work Order Id
661615
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-31T00:00:00.000
744735
Transaction Id: 744735 • Contract Number: QG-215M • Work Order Id: 661211
Transaction Id
744735
Contract Number
QG-215M
Work Order Id
661211
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
744736
Transaction Id: 744736 • Contract Number: QG-215M • Work Order Id: 661211
Transaction Id
744736
Contract Number
QG-215M
Work Order Id
661211
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-17T00:00:00.000
744737
Transaction Id: 744737 • Contract Number: QG-215M • Work Order Id: 659215
Transaction Id
744737
Contract Number
QG-215M
Work Order Id
659215
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
744738
Transaction Id: 744738 • Contract Number: QG-215M • Work Order Id: 659215
Transaction Id
744738
Contract Number
QG-215M
Work Order Id
659215
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-17T00:00:00.000
744741
Transaction Id: 744741 • Contract Number: QG-215M • Work Order Id: 661618
Transaction Id
744741
Contract Number
QG-215M
Work Order Id
661618
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
744742
Transaction Id: 744742 • Contract Number: QG-215M • Work Order Id: 661618
Transaction Id
744742
Contract Number
QG-215M
Work Order Id
661618
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
744743
Transaction Id: 744743 • Contract Number: QG-215M • Work Order Id: 660019
Transaction Id
744743
Contract Number
QG-215M
Work Order Id
660019
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
744744
Transaction Id: 744744 • Contract Number: QG-215M • Work Order Id: 660019
Transaction Id
744744
Contract Number
QG-215M
Work Order Id
660019
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
744745
Transaction Id: 744745 • Contract Number: QG-215M • Work Order Id: 661619
Transaction Id
744745
Contract Number
QG-215M
Work Order Id
661619
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
744746
Transaction Id: 744746 • Contract Number: QG-215M • Work Order Id: 661619
Transaction Id
744746
Contract Number
QG-215M
Work Order Id
661619
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
744759
Transaction Id: 744759 • Contract Number: QG-215M • Work Order Id: 651131
Transaction Id
744759
Contract Number
QG-215M
Work Order Id
651131
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
744760
Transaction Id: 744760 • Contract Number: QG-215M • Work Order Id: 651131
Transaction Id
744760
Contract Number
QG-215M
Work Order Id
651131
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-17T00:00:00.000
744761
Transaction Id: 744761 • Contract Number: QG-215M • Work Order Id: 651538
Transaction Id
744761
Contract Number
QG-215M
Work Order Id
651538
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
744762
Transaction Id: 744762 • Contract Number: QG-215M • Work Order Id: 651538
Transaction Id
744762
Contract Number
QG-215M
Work Order Id
651538
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-17T00:00:00.000
744763
Transaction Id: 744763 • Contract Number: QG-215M • Work Order Id: 668936
Transaction Id
744763
Contract Number
QG-215M
Work Order Id
668936
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
744764
Transaction Id: 744764 • Contract Number: QG-215M • Work Order Id: 668936
Transaction Id
744764
Contract Number
QG-215M
Work Order Id
668936
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-17T00:00:00.000
744765
Transaction Id: 744765 • Contract Number: QG-215M • Work Order Id: 668117
Transaction Id
744765
Contract Number
QG-215M
Work Order Id
668117
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
744766
Transaction Id: 744766 • Contract Number: QG-215M • Work Order Id: 668117
Transaction Id
744766
Contract Number
QG-215M
Work Order Id
668117
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-17T00:00:00.000