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
744931
Transaction Id: 744931 • Contract Number: QG-215M • Work Order Id: 647803
Transaction Id
744931
Contract Number
QG-215M
Work Order Id
647803
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.0
Total Cost
220.0
Transaction Date
2015-09-08T00:00:00.000
744932
Transaction Id: 744932 • Contract Number: QG-215M • Work Order Id: 651580
Transaction Id
744932
Contract Number
QG-215M
Work Order Id
651580
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
744933
Transaction Id: 744933 • Contract Number: QG-215M • Work Order Id: 651580
Transaction Id
744933
Contract Number
QG-215M
Work Order Id
651580
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.0
Total Cost
220.0
Transaction Date
2015-09-08T00:00:00.000
744934
Transaction Id: 744934 • Contract Number: QG-215M • Work Order Id: 649733
Transaction Id
744934
Contract Number
QG-215M
Work Order Id
649733
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
744935
Transaction Id: 744935 • Contract Number: QG-215M • Work Order Id: 649733
Transaction Id
744935
Contract Number
QG-215M
Work Order Id
649733
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.0
Total Cost
220.0
Transaction Date
2015-09-08T00:00:00.000
744936
Transaction Id: 744936 • Contract Number: QG-215M • Work Order Id: 647807
Transaction Id
744936
Contract Number
QG-215M
Work Order Id
647807
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
744937
Transaction Id: 744937 • Contract Number: QG-215M • Work Order Id: 647807
Transaction Id
744937
Contract Number
QG-215M
Work Order Id
647807
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.0
Total Cost
220.0
Transaction Date
2015-09-08T00:00:00.000
744942
Transaction Id: 744942 • Contract Number: QG-215M • Work Order Id: 651690
Transaction Id
744942
Contract Number
QG-215M
Work Order Id
651690
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-05T00:00:00.000
744943
Transaction Id: 744943 • Contract Number: QG-215M • Work Order Id: 651690
Transaction Id
744943
Contract Number
QG-215M
Work Order Id
651690
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.0
Total Cost
220.0
Transaction Date
2015-09-22T00:00:00.000
744944
Transaction Id: 744944 • Contract Number: QG-215M • Work Order Id: 651431
Transaction Id
744944
Contract Number
QG-215M
Work Order Id
651431
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-05T00:00:00.000
744945
Transaction Id: 744945 • Contract Number: QG-215M • Work Order Id: 651431
Transaction Id
744945
Contract Number
QG-215M
Work Order Id
651431
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.0
Total Cost
220.0
Transaction Date
2015-09-22T00:00:00.000
744946
Transaction Id: 744946 • Contract Number: QG-215M • Work Order Id: 653581
Transaction Id
744946
Contract Number
QG-215M
Work Order Id
653581
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-05T00:00:00.000
744947
Transaction Id: 744947 • Contract Number: QG-215M • Work Order Id: 653581
Transaction Id
744947
Contract Number
QG-215M
Work Order Id
653581
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.0
Total Cost
220.0
Transaction Date
2015-09-22T00:00:00.000
744948
Transaction Id: 744948 • Contract Number: QG-215M • Work Order Id: 653334
Transaction Id
744948
Contract Number
QG-215M
Work Order Id
653334
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-05T00:00:00.000
744949
Transaction Id: 744949 • Contract Number: QG-215M • Work Order Id: 653334
Transaction Id
744949
Contract Number
QG-215M
Work Order Id
653334
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.0
Total Cost
220.0
Transaction Date
2015-09-22T00:00:00.000
744950
Transaction Id: 744950 • Contract Number: QG-215M • Work Order Id: 654024
Transaction Id
744950
Contract Number
QG-215M
Work Order Id
654024
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
744951
Transaction Id: 744951 • Contract Number: QG-215M • Work Order Id: 654024
Transaction Id
744951
Contract Number
QG-215M
Work Order Id
654024
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.0
Total Cost
209.0
Transaction Date
2016-01-14T00:00:00.000
744954
Transaction Id: 744954 • Contract Number: QG-215M • Work Order Id: 654028
Transaction Id
744954
Contract Number
QG-215M
Work Order Id
654028
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-05T00:00:00.000
744955
Transaction Id: 744955 • Contract Number: QG-215M • Work Order Id: 654028
Transaction Id
744955
Contract Number
QG-215M
Work Order Id
654028
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.0
Total Cost
209.0
Transaction Date
2015-09-22T00:00:00.000
744960
Transaction Id: 744960 • Contract Number: QG-215M • Work Order Id: 639845
Transaction Id
744960
Contract Number
QG-215M
Work Order Id
639845
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
744961
Transaction Id: 744961 • Contract Number: QG-215M • Work Order Id: 639845
Transaction Id
744961
Contract Number
QG-215M
Work Order Id
639845
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.8
Total Cost
195.8
Transaction Date
2015-09-08T00:00:00.000
744962
Transaction Id: 744962 • Contract Number: QG-215M • Work Order Id: 645574
Transaction Id
744962
Contract Number
QG-215M
Work Order Id
645574
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
744963
Transaction Id: 744963 • Contract Number: QG-215M • Work Order Id: 645574
Transaction Id
744963
Contract Number
QG-215M
Work Order Id
645574
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.5
Total Cost
203.5
Transaction Date
2015-09-08T00:00:00.000
744966
Transaction Id: 744966 • Contract Number: QG-215M • Work Order Id: 647772
Transaction Id
744966
Contract Number
QG-215M
Work Order Id
647772
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-28T00:00:00.000
744967
Transaction Id: 744967 • Contract Number: QG-215M • Work Order Id: 647772
Transaction Id
744967
Contract Number
QG-215M
Work Order Id
647772
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.0
Total Cost
198.0
Transaction Date
2015-12-28T00:00:00.000
744968
Transaction Id: 744968 • Contract Number: QG-215M • Work Order Id: 648732
Transaction Id
744968
Contract Number
QG-215M
Work Order Id
648732
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-28T00:00:00.000
744969
Transaction Id: 744969 • Contract Number: QG-215M • Work Order Id: 648732
Transaction Id
744969
Contract Number
QG-215M
Work Order Id
648732
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.0
Total Cost
198.0
Transaction Date
2015-12-28T00:00:00.000
744970
Transaction Id: 744970 • Contract Number: QG-215M • Work Order Id: 651284
Transaction Id
744970
Contract Number
QG-215M
Work Order Id
651284
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-05T00:00:00.000
744971
Transaction Id: 744971 • Contract Number: QG-215M • Work Order Id: 651284
Transaction Id
744971
Contract Number
QG-215M
Work Order Id
651284
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.0
Total Cost
198.0
Transaction Date
2015-09-22T00:00:00.000
744974
Transaction Id: 744974 • Contract Number: QG-215M • Work Order Id: 647813
Transaction Id
744974
Contract Number
QG-215M
Work Order Id
647813
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-20T00:00:00.000
744975
Transaction Id: 744975 • Contract Number: QG-215M • Work Order Id: 647813
Transaction Id
744975
Contract Number
QG-215M
Work Order Id
647813
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.0
Total Cost
198.0
Transaction Date
2015-09-08T00:00:00.000
744976
Transaction Id: 744976 • Contract Number: QG-215M • Work Order Id: 647815
Transaction Id
744976
Contract Number
QG-215M
Work Order Id
647815
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-20T00:00:00.000
744977
Transaction Id: 744977 • Contract Number: QG-215M • Work Order Id: 647815
Transaction Id
744977
Contract Number
QG-215M
Work Order Id
647815
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.0
Total Cost
198.0
Transaction Date
2015-09-08T00:00:00.000
744978
Transaction Id: 744978 • Contract Number: QG-215M • Work Order Id: 651175
Transaction Id
744978
Contract Number
QG-215M
Work Order Id
651175
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-20T00:00:00.000
744979
Transaction Id: 744979 • Contract Number: QG-215M • Work Order Id: 651175
Transaction Id
744979
Contract Number
QG-215M
Work Order Id
651175
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.0
Total Cost
198.0
Transaction Date
2015-09-08T00:00:00.000
744980
Transaction Id: 744980 • Contract Number: QG-215M • Work Order Id: 653326
Transaction Id
744980
Contract Number
QG-215M
Work Order Id
653326
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-28T00:00:00.000
744981
Transaction Id: 744981 • Contract Number: QG-215M • Work Order Id: 653326
Transaction Id
744981
Contract Number
QG-215M
Work Order Id
653326
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-16T00:00:00.000
744982
Transaction Id: 744982 • Contract Number: QG-215M • Work Order Id: 644801
Transaction Id
744982
Contract Number
QG-215M
Work Order Id
644801
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-24T00:00:00.000
744983
Transaction Id: 744983 • Contract Number: QG-215M • Work Order Id: 644801
Transaction Id
744983
Contract Number
QG-215M
Work Order Id
644801
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.0
Total Cost
187.0
Transaction Date
2015-09-23T00:00:00.000
744984
Transaction Id: 744984 • Contract Number: QG-215M • Work Order Id: 643704
Transaction Id
744984
Contract Number
QG-215M
Work Order Id
643704
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-24T00:00:00.000
744985
Transaction Id: 744985 • Contract Number: QG-215M • Work Order Id: 643704
Transaction Id
744985
Contract Number
QG-215M
Work Order Id
643704
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.0
Total Cost
187.0
Transaction Date
2015-09-23T00:00:00.000
744986
Transaction Id: 744986 • Contract Number: QG-215M • Work Order Id: 653162
Transaction Id
744986
Contract Number
QG-215M
Work Order Id
653162
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-21T00:00:00.000
744987
Transaction Id: 744987 • Contract Number: QG-215M • Work Order Id: 653162
Transaction Id
744987
Contract Number
QG-215M
Work Order Id
653162
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
32.7
Total Cost
359.70000000000005
Transaction Date
2015-09-15T00:00:00.000
744988
Transaction Id: 744988 • Contract Number: QG-215M • Work Order Id: 661653
Transaction Id
744988
Contract Number
QG-215M
Work Order Id
661653
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
744989
Transaction Id: 744989 • Contract Number: QG-215M • Work Order Id: 661653
Transaction Id
744989
Contract Number
QG-215M
Work Order Id
661653
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
29.0
Total Cost
287.1
Transaction Date
2015-12-31T00:00:00.000
744990
Transaction Id: 744990 • Contract Number: QG-215M • Work Order Id: 661653
Transaction Id
744990
Contract Number
QG-215M
Work Order Id
661653
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
2016-04-30T00:00:00.000
744991
Transaction Id: 744991 • Contract Number: QG-215M • Work Order Id: 649618
Transaction Id
744991
Contract Number
QG-215M
Work Order Id
649618
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
744992
Transaction Id: 744992 • Contract Number: QG-215M • Work Order Id: 649618
Transaction Id
744992
Contract Number
QG-215M
Work Order Id
649618
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
48.0
Total Cost
528.0
Transaction Date
2015-09-21T00:00:00.000
744995
Transaction Id: 744995 • Contract Number: QG-215M • Work Order Id: 823438
Transaction Id
744995
Contract Number
QG-215M
Work Order Id
823438
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-19T00:00:00.000
744996
Transaction Id: 744996 • Contract Number: QG-215M • Work Order Id: 823438
Transaction Id
744996
Contract Number
QG-215M
Work Order Id
823438
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-19T00:00:00.000