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
746808
Transaction Id: 746808 • Contract Number: QG-215M • Work Order Id: 663739
Transaction Id
746808
Contract Number
QG-215M
Work Order Id
663739
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-25T00:00:00.000
746809
Transaction Id: 746809 • Contract Number: QG-215M • Work Order Id: 663739
Transaction Id
746809
Contract Number
QG-215M
Work Order Id
663739
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-25T00:00:00.000
746810
Transaction Id: 746810 • Contract Number: QG-215M • Work Order Id: 663740
Transaction Id
746810
Contract Number
QG-215M
Work Order Id
663740
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-25T00:00:00.000
746811
Transaction Id: 746811 • Contract Number: QG-215M • Work Order Id: 663740
Transaction Id
746811
Contract Number
QG-215M
Work Order Id
663740
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-25T00:00:00.000
746812
Transaction Id: 746812 • Contract Number: QG-215M • Work Order Id: 663667
Transaction Id
746812
Contract Number
QG-215M
Work Order Id
663667
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-25T00:00:00.000
746813
Transaction Id: 746813 • Contract Number: QG-215M • Work Order Id: 663667
Transaction Id
746813
Contract Number
QG-215M
Work Order Id
663667
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
24.0
Total Cost
237.60000000000002
Transaction Date
2015-11-25T00:00:00.000
746814
Transaction Id: 746814 • Contract Number: QG-215M • Work Order Id: 663667
Transaction Id
746814
Contract Number
QG-215M
Work Order Id
663667
Line Item Id
304.0
Item Number
04
Line Item Description
STUMP REMOVALS OF OVER 24 TO 30 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
175.0
Units Used
1.0
Total Cost
175.0
Transaction Date
2015-11-02T00:00:00.000
746815
Transaction Id: 746815 • Contract Number: QG-215M • Work Order Id: 695327
Transaction Id
746815
Contract Number
QG-215M
Work Order Id
695327
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-21T00:00:00.000
746816
Transaction Id: 746816 • Contract Number: QG-215M • Work Order Id: 695327
Transaction Id
746816
Contract Number
QG-215M
Work Order Id
695327
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-21T00:00:00.000
746817
Transaction Id: 746817 • Contract Number: QG-215M • Work Order Id: 692940
Transaction Id
746817
Contract Number
QG-215M
Work Order Id
692940
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-21T00:00:00.000
746818
Transaction Id: 746818 • Contract Number: QG-215M • Work Order Id: 692940
Transaction Id
746818
Contract Number
QG-215M
Work Order Id
692940
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-21T00:00:00.000
746819
Transaction Id: 746819 • Contract Number: QG-215M • Work Order Id: 690934
Transaction Id
746819
Contract Number
QG-215M
Work Order Id
690934
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-21T00:00:00.000
746820
Transaction Id: 746820 • Contract Number: QG-215M • Work Order Id: 690934
Transaction Id
746820
Contract Number
QG-215M
Work Order Id
690934
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-21T00:00:00.000
746821
Transaction Id: 746821 • Contract Number: QG-215M • Work Order Id: 692537
Transaction Id
746821
Contract Number
QG-215M
Work Order Id
692537
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-03T00:00:00.000
746822
Transaction Id: 746822 • Contract Number: QG-215M • Work Order Id: 692537
Transaction Id
746822
Contract Number
QG-215M
Work Order Id
692537
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
21.4
Total Cost
235.39999999999998
Transaction Date
2015-12-03T00:00:00.000
746823
Transaction Id: 746823 • Contract Number: QG-215M • Work Order Id: 690535
Transaction Id
746823
Contract Number
QG-215M
Work Order Id
690535
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-30T00:00:00.000
746824
Transaction Id: 746824 • Contract Number: QG-215M • Work Order Id: 690535
Transaction Id
746824
Contract Number
QG-215M
Work Order Id
690535
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-30T00:00:00.000
746825
Transaction Id: 746825 • Contract Number: QG-215M • Work Order Id: 691331
Transaction Id
746825
Contract Number
QG-215M
Work Order Id
691331
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-30T00:00:00.000
746826
Transaction Id: 746826 • Contract Number: QG-215M • Work Order Id: 691331
Transaction Id
746826
Contract Number
QG-215M
Work Order Id
691331
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-30T00:00:00.000
746827
Transaction Id: 746827 • Contract Number: QG-215M • Work Order Id: 695332
Transaction Id
746827
Contract Number
QG-215M
Work Order Id
695332
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-30T00:00:00.000
746828
Transaction Id: 746828 • Contract Number: QG-215M • Work Order Id: 695332
Transaction Id
746828
Contract Number
QG-215M
Work Order Id
695332
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-30T00:00:00.000
746829
Transaction Id: 746829 • Contract Number: QG-215M • Work Order Id: 692944
Transaction Id
746829
Contract Number
QG-215M
Work Order Id
692944
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
746830
Transaction Id: 746830 • Contract Number: QG-215M • Work Order Id: 692944
Transaction Id
746830
Contract Number
QG-215M
Work Order Id
692944
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
746831
Transaction Id: 746831 • Contract Number: QG-215M • Work Order Id: 694526
Transaction Id
746831
Contract Number
QG-215M
Work Order Id
694526
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
746832
Transaction Id: 746832 • Contract Number: QG-215M • Work Order Id: 694526
Transaction Id
746832
Contract Number
QG-215M
Work Order Id
694526
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
746833
Transaction Id: 746833 • Contract Number: QG-215M • Work Order Id: 696141
Transaction Id
746833
Contract Number
QG-215M
Work Order Id
696141
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
746834
Transaction Id: 746834 • Contract Number: QG-215M • Work Order Id: 696141
Transaction Id
746834
Contract Number
QG-215M
Work Order Id
696141
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
746835
Transaction Id: 746835 • Contract Number: QG-215M • Work Order Id: 659397
Transaction Id
746835
Contract Number
QG-215M
Work Order Id
659397
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-04T00:00:00.000
746836
Transaction Id: 746836 • Contract Number: QG-215M • Work Order Id: 659397
Transaction Id
746836
Contract Number
QG-215M
Work Order Id
659397
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
40.8
Total Cost
489.59999999999997
Transaction Date
2015-12-04T00:00:00.000
746837
Transaction Id: 746837 • Contract Number: QG-215M • Work Order Id: 693739
Transaction Id
746837
Contract Number
QG-215M
Work Order Id
693739
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-04T00:00:00.000
746838
Transaction Id: 746838 • Contract Number: QG-215M • Work Order Id: 693739
Transaction Id
746838
Contract Number
QG-215M
Work Order Id
693739
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-04T00:00:00.000
746839
Transaction Id: 746839 • Contract Number: QG-215M • Work Order Id: 695742
Transaction Id
746839
Contract Number
QG-215M
Work Order Id
695742
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-04T00:00:00.000
746840
Transaction Id: 746840 • Contract Number: QG-215M • Work Order Id: 695742
Transaction Id
746840
Contract Number
QG-215M
Work Order Id
695742
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-04T00:00:00.000
746841
Transaction Id: 746841 • Contract Number: QG-215M • Work Order Id: 692950
Transaction Id
746841
Contract Number
QG-215M
Work Order Id
692950
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-04T00:00:00.000
746842
Transaction Id: 746842 • Contract Number: QG-215M • Work Order Id: 692950
Transaction Id
746842
Contract Number
QG-215M
Work Order Id
692950
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-04T00:00:00.000
746843
Transaction Id: 746843 • Contract Number: QG-215M • Work Order Id: 693742
Transaction Id
746843
Contract Number
QG-215M
Work Order Id
693742
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-14T00:00:00.000
746845
Transaction Id: 746845 • Contract Number: QG-215M • Work Order Id: 700515
Transaction Id
746845
Contract Number
QG-215M
Work Order Id
700515
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-22T00:00:00.000
746846
Transaction Id: 746846 • Contract Number: QG-215M • Work Order Id: 700515
Transaction Id
746846
Contract Number
QG-215M
Work Order Id
700515
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
42.8
Total Cost
727.5999999999999
Transaction Date
2015-12-22T00:00:00.000
746847
Transaction Id: 746847 • Contract Number: QG-215M • Work Order Id: 702114
Transaction Id
746847
Contract Number
QG-215M
Work Order Id
702114
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-22T00:00:00.000
746848
Transaction Id: 746848 • Contract Number: QG-215M • Work Order Id: 702114
Transaction Id
746848
Contract Number
QG-215M
Work Order Id
702114
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
46.7
Total Cost
793.9000000000001
Transaction Date
2015-12-22T00:00:00.000
746849
Transaction Id: 746849 • Contract Number: QG-215M • Work Order Id: 697318
Transaction Id
746849
Contract Number
QG-215M
Work Order Id
697318
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-30T00:00:00.000
746850
Transaction Id: 746850 • Contract Number: QG-215M • Work Order Id: 697318
Transaction Id
746850
Contract Number
QG-215M
Work Order Id
697318
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-30T00:00:00.000
746851
Transaction Id: 746851 • Contract Number: QG-215M • Work Order Id: 702515
Transaction Id
746851
Contract Number
QG-215M
Work Order Id
702515
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-22T00:00:00.000
746852
Transaction Id: 746852 • Contract Number: QG-215M • Work Order Id: 702515
Transaction Id
746852
Contract Number
QG-215M
Work Order Id
702515
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
50.8
Total Cost
609.5999999999999
Transaction Date
2015-12-22T00:00:00.000
746853
Transaction Id: 746853 • Contract Number: QG-215M • Work Order Id: 701317
Transaction Id
746853
Contract Number
QG-215M
Work Order Id
701317
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-22T00:00:00.000
746854
Transaction Id: 746854 • Contract Number: QG-215M • Work Order Id: 701317
Transaction Id
746854
Contract Number
QG-215M
Work Order Id
701317
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
51.7
Total Cost
620.4000000000001
Transaction Date
2015-12-22T00:00:00.000
746855
Transaction Id: 746855 • Contract Number: QG-215M • Work Order Id: 703713
Transaction Id
746855
Contract Number
QG-215M
Work Order Id
703713
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-30T00:00:00.000
746856
Transaction Id: 746856 • Contract Number: QG-215M • Work Order Id: 703713
Transaction Id
746856
Contract Number
QG-215M
Work Order Id
703713
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-30T00:00:00.000
746857
Transaction Id: 746857 • Contract Number: QG-215M • Work Order Id: 697319
Transaction Id
746857
Contract Number
QG-215M
Work Order Id
697319
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
746858
Transaction Id: 746858 • Contract Number: QG-215M • Work Order Id: 697319
Transaction Id
746858
Contract Number
QG-215M
Work Order Id
697319
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