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
747040
Transaction Id: 747040 • Contract Number: QG-215M • Work Order Id: 706539
Transaction Id
747040
Contract Number
QG-215M
Work Order Id
706539
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
22.2
Total Cost
244.2
Transaction Date
2015-09-24T00:00:00.000
747041
Transaction Id: 747041 • Contract Number: QG-215M • Work Order Id: 706136
Transaction Id
747041
Contract Number
QG-215M
Work Order Id
706136
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-25T00:00:00.000
747042
Transaction Id: 747042 • Contract Number: QG-215M • Work Order Id: 706136
Transaction Id
747042
Contract Number
QG-215M
Work Order Id
706136
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-24T00:00:00.000
747043
Transaction Id: 747043 • Contract Number: QG-215M • Work Order Id: 705344
Transaction Id
747043
Contract Number
QG-215M
Work Order Id
705344
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-25T00:00:00.000
747044
Transaction Id: 747044 • Contract Number: QG-215M • Work Order Id: 705344
Transaction Id
747044
Contract Number
QG-215M
Work Order Id
705344
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-24T00:00:00.000
747045
Transaction Id: 747045 • Contract Number: QG-215M • Work Order Id: 709340
Transaction Id
747045
Contract Number
QG-215M
Work Order Id
709340
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
747046
Transaction Id: 747046 • Contract Number: QG-215M • Work Order Id: 709340
Transaction Id
747046
Contract Number
QG-215M
Work Order Id
709340
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
28.0
Total Cost
308.0
Transaction Date
2015-12-31T00:00:00.000
747047
Transaction Id: 747047 • Contract Number: QG-215M • Work Order Id: 706936
Transaction Id
747047
Contract Number
QG-215M
Work Order Id
706936
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-10T00:00:00.000
747048
Transaction Id: 747048 • Contract Number: QG-215M • Work Order Id: 706936
Transaction Id
747048
Contract Number
QG-215M
Work Order Id
706936
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-10T00:00:00.000
747049
Transaction Id: 747049 • Contract Number: QG-215M • Work Order Id: 706937
Transaction Id
747049
Contract Number
QG-215M
Work Order Id
706937
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-10T00:00:00.000
747050
Transaction Id: 747050 • Contract Number: QG-215M • Work Order Id: 706937
Transaction Id
747050
Contract Number
QG-215M
Work Order Id
706937
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-10T00:00:00.000
747051
Transaction Id: 747051 • Contract Number: QG-215M • Work Order Id: 706139
Transaction Id
747051
Contract Number
QG-215M
Work Order Id
706139
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-10T00:00:00.000
747052
Transaction Id: 747052 • Contract Number: QG-215M • Work Order Id: 706139
Transaction Id
747052
Contract Number
QG-215M
Work Order Id
706139
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-10T00:00:00.000
747053
Transaction Id: 747053 • Contract Number: QG-215M • Work Order Id: 705731
Transaction Id
747053
Contract Number
QG-215M
Work Order Id
705731
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
747054
Transaction Id: 747054 • Contract Number: QG-215M • Work Order Id: 705731
Transaction Id
747054
Contract Number
QG-215M
Work Order Id
705731
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
16.0
Total Cost
176.0
Transaction Date
2015-12-14T00:00:00.000
747055
Transaction Id: 747055 • Contract Number: QG-215M • Work Order Id: 708140
Transaction Id
747055
Contract Number
QG-215M
Work Order Id
708140
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
747056
Transaction Id: 747056 • Contract Number: QG-215M • Work Order Id: 708140
Transaction Id
747056
Contract Number
QG-215M
Work Order Id
708140
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
16.0
Total Cost
176.0
Transaction Date
2015-12-14T00:00:00.000
747057
Transaction Id: 747057 • Contract Number: QG-215M • Work Order Id: 705349
Transaction Id
747057
Contract Number
QG-215M
Work Order Id
705349
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
747058
Transaction Id: 747058 • Contract Number: QG-215M • Work Order Id: 705349
Transaction Id
747058
Contract Number
QG-215M
Work Order Id
705349
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
22.0
Total Cost
242.0
Transaction Date
2015-12-14T00:00:00.000
747059
Transaction Id: 747059 • Contract Number: QG-215M • Work Order Id: 704944
Transaction Id
747059
Contract Number
QG-215M
Work Order Id
704944
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
747060
Transaction Id: 747060 • Contract Number: QG-215M • Work Order Id: 704944
Transaction Id
747060
Contract Number
QG-215M
Work Order Id
704944
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
22.0
Total Cost
242.0
Transaction Date
2015-12-14T00:00:00.000
747061
Transaction Id: 747061 • Contract Number: QG-215M • Work Order Id: 710138
Transaction Id
747061
Contract Number
QG-215M
Work Order Id
710138
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
747062
Transaction Id: 747062 • Contract Number: QG-215M • Work Order Id: 710138
Transaction Id
747062
Contract Number
QG-215M
Work Order Id
710138
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.0
Total Cost
253.0
Transaction Date
2015-12-14T00:00:00.000
747063
Transaction Id: 747063 • Contract Number: QG-215M • Work Order Id: 700135
Transaction Id
747063
Contract Number
QG-215M
Work Order Id
700135
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-15T00:00:00.000
747064
Transaction Id: 747064 • Contract Number: QG-215M • Work Order Id: 700135
Transaction Id
747064
Contract Number
QG-215M
Work Order Id
700135
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
10.8
Units Used
28.2
Total Cost
304.56
Transaction Date
2015-12-10T00:00:00.000
747065
Transaction Id: 747065 • Contract Number: QG-215M • Work Order Id: 700135
Transaction Id
747065
Contract Number
QG-215M
Work Order Id
700135
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
15.3
Units Used
10.9
Total Cost
166.77
Transaction Date
2015-12-10T00:00:00.000
747067
Transaction Id: 747067 • Contract Number: QG-215M • Work Order Id: 733727
Transaction Id
747067
Contract Number
QG-215M
Work Order Id
733727
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-15T00:00:00.000
747068
Transaction Id: 747068 • Contract Number: QG-215M • Work Order Id: 733727
Transaction Id
747068
Contract Number
QG-215M
Work Order Id
733727
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
10.8
Units Used
36.6
Total Cost
395.28000000000003
Transaction Date
2015-12-10T00:00:00.000
747069
Transaction Id: 747069 • Contract Number: QG-215M • Work Order Id: 733727
Transaction Id
747069
Contract Number
QG-215M
Work Order Id
733727
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
15.3
Units Used
25.4
Total Cost
388.62
Transaction Date
2015-12-10T00:00:00.000
747070
Transaction Id: 747070 • Contract Number: QG-215M • Work Order Id: 730130
Transaction Id
747070
Contract Number
QG-215M
Work Order Id
730130
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-15T00:00:00.000
747071
Transaction Id: 747071 • Contract Number: QG-215M • Work Order Id: 730130
Transaction Id
747071
Contract Number
QG-215M
Work Order Id
730130
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
36.6
Total Cost
439.20000000000005
Transaction Date
2015-12-10T00:00:00.000
747072
Transaction Id: 747072 • Contract Number: QG-215M • Work Order Id: 734125
Transaction Id
747072
Contract Number
QG-215M
Work Order Id
734125
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
747073
Transaction Id: 747073 • Contract Number: QG-215M • Work Order Id: 734125
Transaction Id
747073
Contract Number
QG-215M
Work Order Id
734125
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
25.0
Total Cost
300.0
Transaction Date
2015-12-10T00:00:00.000
747074
Transaction Id: 747074 • Contract Number: QG-215M • Work Order Id: 734125
Transaction Id
747074
Contract Number
QG-215M
Work Order Id
734125
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
15.0
Total Cost
255.0
Transaction Date
2015-12-10T00:00:00.000
747075
Transaction Id: 747075 • Contract Number: QG-215M • Work Order Id: 697336
Transaction Id
747075
Contract Number
QG-215M
Work Order Id
697336
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
747076
Transaction Id: 747076 • Contract Number: QG-215M • Work Order Id: 697336
Transaction Id
747076
Contract Number
QG-215M
Work Order Id
697336
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
10.8
Units Used
20.1
Total Cost
217.08000000000004
Transaction Date
2015-12-10T00:00:00.000
747077
Transaction Id: 747077 • Contract Number: QG-215M • Work Order Id: 697336
Transaction Id
747077
Contract Number
QG-215M
Work Order Id
697336
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
15.3
Units Used
18.7
Total Cost
286.11
Transaction Date
2015-12-10T00:00:00.000
747078
Transaction Id: 747078 • Contract Number: QG-215M • Work Order Id: 734126
Transaction Id
747078
Contract Number
QG-215M
Work Order Id
734126
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
747079
Transaction Id: 747079 • Contract Number: QG-215M • Work Order Id: 734126
Transaction Id
747079
Contract Number
QG-215M
Work Order Id
734126
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
35.8
Total Cost
429.59999999999997
Transaction Date
2015-12-14T00:00:00.000
747081
Transaction Id: 747081 • Contract Number: QG-215M • Work Order Id: 732542
Transaction Id
747081
Contract Number
QG-215M
Work Order Id
732542
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
747082
Transaction Id: 747082 • Contract Number: QG-215M • Work Order Id: 732542
Transaction Id
747082
Contract Number
QG-215M
Work Order Id
732542
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-10T00:00:00.000
747083
Transaction Id: 747083 • Contract Number: QG-215M • Work Order Id: 732542
Transaction Id
747083
Contract Number
QG-215M
Work Order Id
732542
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
16.8
Total Cost
1041.6000000000001
Transaction Date
2016-03-14T00:00:00.000
747086
Transaction Id: 747086 • Contract Number: QG-215M • Work Order Id: 698946
Transaction Id
747086
Contract Number
QG-215M
Work Order Id
698946
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
747087
Transaction Id: 747087 • Contract Number: QG-215M • Work Order Id: 698946
Transaction Id
747087
Contract Number
QG-215M
Work Order Id
698946
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
10.8
Units Used
21.4
Total Cost
231.12
Transaction Date
2015-12-10T00:00:00.000
747088
Transaction Id: 747088 • Contract Number: QG-215M • Work Order Id: 698946
Transaction Id
747088
Contract Number
QG-215M
Work Order Id
698946
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
15.3
Units Used
19.1
Total Cost
292.23
Transaction Date
2015-12-10T00:00:00.000
747089
Transaction Id: 747089 • Contract Number: QG-215M • Work Order Id: 700136
Transaction Id
747089
Contract Number
QG-215M
Work Order Id
700136
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
747090
Transaction Id: 747090 • Contract Number: QG-215M • Work Order Id: 700136
Transaction Id
747090
Contract Number
QG-215M
Work Order Id
700136
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
10.8
Units Used
25.0
Total Cost
270.0
Transaction Date
2015-12-10T00:00:00.000
747091
Transaction Id: 747091 • Contract Number: QG-215M • Work Order Id: 700136
Transaction Id
747091
Contract Number
QG-215M
Work Order Id
700136
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
15.3
Units Used
25.0
Total Cost
382.5
Transaction Date
2015-12-10T00:00:00.000
747093
Transaction Id: 747093 • Contract Number: QG-215M • Work Order Id: 740520
Transaction Id
747093
Contract Number
QG-215M
Work Order Id
740520
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
747094
Transaction Id: 747094 • Contract Number: QG-215M • Work Order Id: 740520
Transaction Id
747094
Contract Number
QG-215M
Work Order Id
740520
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
31.3
Total Cost
375.6
Transaction Date
2015-12-07T00:00:00.000