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
745641
Transaction Id: 745641 • Contract Number: QG-215M • Work Order Id: 751350
Transaction Id
745641
Contract Number
QG-215M
Work Order Id
751350
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.5
Total Cost
258.5
Transaction Date
2015-12-09T00:00:00.000
745652
Transaction Id: 745652 • Contract Number: QG-215M • Work Order Id: 760159
Transaction Id
745652
Contract Number
QG-215M
Work Order Id
760159
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
745653
Transaction Id: 745653 • Contract Number: QG-215M • Work Order Id: 760159
Transaction Id
745653
Contract Number
QG-215M
Work Order Id
760159
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
745656
Transaction Id: 745656 • Contract Number: QG-215M • Work Order Id: 749346
Transaction Id
745656
Contract Number
QG-215M
Work Order Id
749346
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
745657
Transaction Id: 745657 • Contract Number: QG-215M • Work Order Id: 749346
Transaction Id
745657
Contract Number
QG-215M
Work Order Id
749346
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
17.2
Total Cost
189.2
Transaction Date
2015-12-07T00:00:00.000
745662
Transaction Id: 745662 • Contract Number: QG-215M • Work Order Id: 747357
Transaction Id
745662
Contract Number
QG-215M
Work Order Id
747357
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
745663
Transaction Id: 745663 • Contract Number: QG-215M • Work Order Id: 747357
Transaction Id
745663
Contract Number
QG-215M
Work Order Id
747357
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
745668
Transaction Id: 745668 • Contract Number: QG-215M • Work Order Id: 747358
Transaction Id
745668
Contract Number
QG-215M
Work Order Id
747358
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
745669
Transaction Id: 745669 • Contract Number: QG-215M • Work Order Id: 747358
Transaction Id
745669
Contract Number
QG-215M
Work Order Id
747358
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.2
Total Cost
200.2
Transaction Date
2015-12-07T00:00:00.000
745670
Transaction Id: 745670 • Contract Number: QG-215M • Work Order Id: 743749
Transaction Id
745670
Contract Number
QG-215M
Work Order Id
743749
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
745671
Transaction Id: 745671 • Contract Number: QG-215M • Work Order Id: 743749
Transaction Id
745671
Contract Number
QG-215M
Work Order Id
743749
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.8
Total Cost
217.8
Transaction Date
2015-12-07T00:00:00.000
745673
Transaction Id: 745673 • Contract Number: QG-215M • Work Order Id: 748538
Transaction Id
745673
Contract Number
QG-215M
Work Order Id
748538
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
745674
Transaction Id: 745674 • Contract Number: QG-215M • Work Order Id: 748538
Transaction Id
745674
Contract Number
QG-215M
Work Order Id
748538
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-06T00:00:00.000
745675
Transaction Id: 745675 • Contract Number: QG-215M • Work Order Id: 749735
Transaction Id
745675
Contract Number
QG-215M
Work Order Id
749735
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
745676
Transaction Id: 745676 • Contract Number: QG-215M • Work Order Id: 749735
Transaction Id
745676
Contract Number
QG-215M
Work Order Id
749735
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-06T00:00:00.000
745677
Transaction Id: 745677 • Contract Number: QG-215M • Work Order Id: 749335
Transaction Id
745677
Contract Number
QG-215M
Work Order Id
749335
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
745678
Transaction Id: 745678 • Contract Number: QG-215M • Work Order Id: 749335
Transaction Id
745678
Contract Number
QG-215M
Work Order Id
749335
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-06T00:00:00.000
745679
Transaction Id: 745679 • Contract Number: QG-215M • Work Order Id: 786259
Transaction Id
745679
Contract Number
QG-215M
Work Order Id
786259
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
745680
Transaction Id: 745680 • Contract Number: QG-215M • Work Order Id: 786259
Transaction Id
745680
Contract Number
QG-215M
Work Order Id
786259
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-06T00:00:00.000
745681
Transaction Id: 745681 • Contract Number: QG-215M • Work Order Id: 787842
Transaction Id
745681
Contract Number
QG-215M
Work Order Id
787842
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
745682
Transaction Id: 745682 • Contract Number: QG-215M • Work Order Id: 787842
Transaction Id
745682
Contract Number
QG-215M
Work Order Id
787842
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-06T00:00:00.000
745685
Transaction Id: 745685 • Contract Number: QG-215M • Work Order Id: 789055
Transaction Id
745685
Contract Number
QG-215M
Work Order Id
789055
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
745686
Transaction Id: 745686 • Contract Number: QG-215M • Work Order Id: 789055
Transaction Id
745686
Contract Number
QG-215M
Work Order Id
789055
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-06T00:00:00.000
745687
Transaction Id: 745687 • Contract Number: QG-215M • Work Order Id: 787844
Transaction Id
745687
Contract Number
QG-215M
Work Order Id
787844
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
745688
Transaction Id: 745688 • Contract Number: QG-215M • Work Order Id: 787844
Transaction Id
745688
Contract Number
QG-215M
Work Order Id
787844
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-06T00:00:00.000
745689
Transaction Id: 745689 • Contract Number: QG-215M • Work Order Id: 745338
Transaction Id
745689
Contract Number
QG-215M
Work Order Id
745338
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
745690
Transaction Id: 745690 • Contract Number: QG-215M • Work Order Id: 745338
Transaction Id
745690
Contract Number
QG-215M
Work Order Id
745338
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-06T00:00:00.000
745691
Transaction Id: 745691 • Contract Number: QG-215M • Work Order Id: 747737
Transaction Id
745691
Contract Number
QG-215M
Work Order Id
747737
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
745692
Transaction Id: 745692 • Contract Number: QG-215M • Work Order Id: 747737
Transaction Id
745692
Contract Number
QG-215M
Work Order Id
747737
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-06T00:00:00.000
745693
Transaction Id: 745693 • Contract Number: QG-215M • Work Order Id: 792651
Transaction Id
745693
Contract Number
QG-215M
Work Order Id
792651
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
745694
Transaction Id: 745694 • Contract Number: QG-215M • Work Order Id: 792651
Transaction Id
745694
Contract Number
QG-215M
Work Order Id
792651
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-06T00:00:00.000
745695
Transaction Id: 745695 • Contract Number: QG-215M • Work Order Id: 746537
Transaction Id
745695
Contract Number
QG-215M
Work Order Id
746537
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
745696
Transaction Id: 745696 • Contract Number: QG-215M • Work Order Id: 746537
Transaction Id
745696
Contract Number
QG-215M
Work Order Id
746537
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-06T00:00:00.000
745697
Transaction Id: 745697 • Contract Number: QG-215M • Work Order Id: 746938
Transaction Id
745697
Contract Number
QG-215M
Work Order Id
746938
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
745698
Transaction Id: 745698 • Contract Number: QG-215M • Work Order Id: 746938
Transaction Id
745698
Contract Number
QG-215M
Work Order Id
746938
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-06T00:00:00.000
745699
Transaction Id: 745699 • Contract Number: QG-215M • Work Order Id: 746538
Transaction Id
745699
Contract Number
QG-215M
Work Order Id
746538
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
745700
Transaction Id: 745700 • Contract Number: QG-215M • Work Order Id: 746538
Transaction Id
745700
Contract Number
QG-215M
Work Order Id
746538
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-06T00:00:00.000
745701
Transaction Id: 745701 • Contract Number: QG-215M • Work Order Id: 748939
Transaction Id
745701
Contract Number
QG-215M
Work Order Id
748939
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
745702
Transaction Id: 745702 • Contract Number: QG-215M • Work Order Id: 748939
Transaction Id
745702
Contract Number
QG-215M
Work Order Id
748939
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-06T00:00:00.000
745703
Transaction Id: 745703 • Contract Number: QG-215M • Work Order Id: 748941
Transaction Id
745703
Contract Number
QG-215M
Work Order Id
748941
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
745704
Transaction Id: 745704 • Contract Number: QG-215M • Work Order Id: 748941
Transaction Id
745704
Contract Number
QG-215M
Work Order Id
748941
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-06T00:00:00.000
745705
Transaction Id: 745705 • Contract Number: QG-215M • Work Order Id: 746944
Transaction Id
745705
Contract Number
QG-215M
Work Order Id
746944
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
745706
Transaction Id: 745706 • Contract Number: QG-215M • Work Order Id: 746944
Transaction Id
745706
Contract Number
QG-215M
Work Order Id
746944
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-06T00:00:00.000
745707
Transaction Id: 745707 • Contract Number: QG-215M • Work Order Id: 748142
Transaction Id
745707
Contract Number
QG-215M
Work Order Id
748142
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
745708
Transaction Id: 745708 • Contract Number: QG-215M • Work Order Id: 748142
Transaction Id
745708
Contract Number
QG-215M
Work Order Id
748142
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-06T00:00:00.000
745709
Transaction Id: 745709 • Contract Number: QG-215M • Work Order Id: 748548
Transaction Id
745709
Contract Number
QG-215M
Work Order Id
748548
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
745710
Transaction Id: 745710 • Contract Number: QG-215M • Work Order Id: 748548
Transaction Id
745710
Contract Number
QG-215M
Work Order Id
748548
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-06T00:00:00.000
745711
Transaction Id: 745711 • Contract Number: QG-215M • Work Order Id: 746949
Transaction Id
745711
Contract Number
QG-215M
Work Order Id
746949
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
745712
Transaction Id: 745712 • Contract Number: QG-215M • Work Order Id: 746949
Transaction Id
745712
Contract Number
QG-215M
Work Order Id
746949
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-06T00:00:00.000
745713
Transaction Id: 745713 • Contract Number: QG-215M • Work Order Id: 744150
Transaction Id
745713
Contract Number
QG-215M
Work Order Id
744150
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