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
748110
Transaction Id: 748110 • Contract Number: CNYG-414M • Work Order Id: 736943
Transaction Id
748110
Contract Number
CNYG-414M
Work Order Id
736943
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
28.5
Total Cost
456.0
Transaction Date
2015-09-21T00:00:00.000
748111
Transaction Id: 748111 • Contract Number: CNYG-414M • Work Order Id: 736943
Transaction Id
748111
Contract Number
CNYG-414M
Work Order Id
736943
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-20T00:00:00.000
748112
Transaction Id: 748112 • Contract Number: CNYG-414M • Work Order Id: 690531
Transaction Id
748112
Contract Number
CNYG-414M
Work Order Id
690531
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
25.5
Total Cost
408.0
Transaction Date
2015-09-21T00:00:00.000
748113
Transaction Id: 748113 • Contract Number: CNYG-414M • Work Order Id: 690531
Transaction Id
748113
Contract Number
CNYG-414M
Work Order Id
690531
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-20T00:00:00.000
748114
Transaction Id: 748114 • Contract Number: CNYG-414M • Work Order Id: 696919
Transaction Id
748114
Contract Number
CNYG-414M
Work Order Id
696919
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
20.5
Total Cost
328.0
Transaction Date
2015-09-21T00:00:00.000
748115
Transaction Id: 748115 • Contract Number: CNYG-414M • Work Order Id: 696919
Transaction Id
748115
Contract Number
CNYG-414M
Work Order Id
696919
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-20T00:00:00.000
748116
Transaction Id: 748116 • Contract Number: CNYG-414M • Work Order Id: 695328
Transaction Id
748116
Contract Number
CNYG-414M
Work Order Id
695328
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
25.5
Total Cost
408.0
Transaction Date
2015-09-23T00:00:00.000
748117
Transaction Id: 748117 • Contract Number: CNYG-414M • Work Order Id: 695328
Transaction Id
748117
Contract Number
CNYG-414M
Work Order Id
695328
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-20T00:00:00.000
748119
Transaction Id: 748119 • Contract Number: CNYG-414M • Work Order Id: 697730
Transaction Id
748119
Contract Number
CNYG-414M
Work Order Id
697730
Line Item Id
355.0
Item Number
11.5K
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
14.4
Units Used
27.5
Total Cost
396.0
Transaction Date
2015-09-16T00:00:00.000
748120
Transaction Id: 748120 • Contract Number: CNYG-414M • Work Order Id: 697730
Transaction Id
748120
Contract Number
CNYG-414M
Work Order Id
697730
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748121
Transaction Id: 748121 • Contract Number: CNYG-414M • Work Order Id: 697730
Transaction Id
748121
Contract Number
CNYG-414M
Work Order Id
697730
Line Item Id
286.0
Item Number
02K
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
225.0
Units Used
1.0
Total Cost
225.0
Transaction Date
2015-09-16T00:00:00.000
748122
Transaction Id: 748122 • Contract Number: CNYG-414M • Work Order Id: 709336
Transaction Id
748122
Contract Number
CNYG-414M
Work Order Id
709336
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.0
Total Cost
432.0
Transaction Date
2015-09-16T00:00:00.000
748123
Transaction Id: 748123 • Contract Number: CNYG-414M • Work Order Id: 709336
Transaction Id
748123
Contract Number
CNYG-414M
Work Order Id
709336
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748124
Transaction Id: 748124 • Contract Number: CNYG-414M • Work Order Id: 710134
Transaction Id
748124
Contract Number
CNYG-414M
Work Order Id
710134
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
28.0
Total Cost
448.0
Transaction Date
2015-09-16T00:00:00.000
748125
Transaction Id: 748125 • Contract Number: CNYG-414M • Work Order Id: 710134
Transaction Id
748125
Contract Number
CNYG-414M
Work Order Id
710134
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748128
Transaction Id: 748128 • Contract Number: CNYG-414M • Work Order Id: 709730
Transaction Id
748128
Contract Number
CNYG-414M
Work Order Id
709730
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.0
Total Cost
432.0
Transaction Date
2015-09-16T00:00:00.000
748129
Transaction Id: 748129 • Contract Number: CNYG-414M • Work Order Id: 709730
Transaction Id
748129
Contract Number
CNYG-414M
Work Order Id
709730
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748130
Transaction Id: 748130 • Contract Number: CNYG-414M • Work Order Id: 712133
Transaction Id
748130
Contract Number
CNYG-414M
Work Order Id
712133
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.0
Total Cost
432.0
Transaction Date
2015-09-16T00:00:00.000
748131
Transaction Id: 748131 • Contract Number: CNYG-414M • Work Order Id: 712133
Transaction Id
748131
Contract Number
CNYG-414M
Work Order Id
712133
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748132
Transaction Id: 748132 • Contract Number: CNYG-414M • Work Order Id: 737335
Transaction Id
748132
Contract Number
CNYG-414M
Work Order Id
737335
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.0
Total Cost
432.0
Transaction Date
2015-09-16T00:00:00.000
748133
Transaction Id: 748133 • Contract Number: CNYG-414M • Work Order Id: 737335
Transaction Id
748133
Contract Number
CNYG-414M
Work Order Id
737335
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748134
Transaction Id: 748134 • Contract Number: CNYG-414M • Work Order Id: 741324
Transaction Id
748134
Contract Number
CNYG-414M
Work Order Id
741324
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.0
Total Cost
432.0
Transaction Date
2015-09-16T00:00:00.000
748135
Transaction Id: 748135 • Contract Number: CNYG-414M • Work Order Id: 741324
Transaction Id
748135
Contract Number
CNYG-414M
Work Order Id
741324
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748136
Transaction Id: 748136 • Contract Number: CNYG-414M • Work Order Id: 740928
Transaction Id
748136
Contract Number
CNYG-414M
Work Order Id
740928
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.0
Total Cost
432.0
Transaction Date
2015-09-16T00:00:00.000
748137
Transaction Id: 748137 • Contract Number: CNYG-414M • Work Order Id: 740928
Transaction Id
748137
Contract Number
CNYG-414M
Work Order Id
740928
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748138
Transaction Id: 748138 • Contract Number: CNYG-414M • Work Order Id: 706538
Transaction Id
748138
Contract Number
CNYG-414M
Work Order Id
706538
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
26.5
Total Cost
424.0
Transaction Date
2015-09-15T00:00:00.000
748139
Transaction Id: 748139 • Contract Number: CNYG-414M • Work Order Id: 706538
Transaction Id
748139
Contract Number
CNYG-414M
Work Order Id
706538
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748140
Transaction Id: 748140 • Contract Number: CNYG-414M • Work Order Id: 704938
Transaction Id
748140
Contract Number
CNYG-414M
Work Order Id
704938
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
26.5
Total Cost
424.0
Transaction Date
2015-09-15T00:00:00.000
748141
Transaction Id: 748141 • Contract Number: CNYG-414M • Work Order Id: 704938
Transaction Id
748141
Contract Number
CNYG-414M
Work Order Id
704938
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748142
Transaction Id: 748142 • Contract Number: CNYG-414M • Work Order Id: 706133
Transaction Id
748142
Contract Number
CNYG-414M
Work Order Id
706133
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.5
Total Cost
440.0
Transaction Date
2015-09-15T00:00:00.000
748143
Transaction Id: 748143 • Contract Number: CNYG-414M • Work Order Id: 706133
Transaction Id
748143
Contract Number
CNYG-414M
Work Order Id
706133
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748145
Transaction Id: 748145 • Contract Number: CNYG-414M • Work Order Id: 711736
Transaction Id
748145
Contract Number
CNYG-414M
Work Order Id
711736
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.0
Total Cost
432.0
Transaction Date
2015-09-15T00:00:00.000
748146
Transaction Id: 748146 • Contract Number: CNYG-414M • Work Order Id: 711736
Transaction Id
748146
Contract Number
CNYG-414M
Work Order Id
711736
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748147
Transaction Id: 748147 • Contract Number: CNYG-414M • Work Order Id: 710928
Transaction Id
748147
Contract Number
CNYG-414M
Work Order Id
710928
Line Item Id
355.0
Item Number
11.5K
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
14.4
Units Used
32.7
Total Cost
470.88000000000005
Transaction Date
2015-09-15T00:00:00.000
748148
Transaction Id: 748148 • Contract Number: CNYG-414M • Work Order Id: 710928
Transaction Id
748148
Contract Number
CNYG-414M
Work Order Id
710928
Line Item Id
297.0
Item Number
03K
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
275.0
Units Used
1.0
Total Cost
275.0
Transaction Date
2015-09-15T00:00:00.000
748149
Transaction Id: 748149 • Contract Number: CNYG-414M • Work Order Id: 710928
Transaction Id
748149
Contract Number
CNYG-414M
Work Order Id
710928
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748150
Transaction Id: 748150 • Contract Number: CNYG-414M • Work Order Id: 706928
Transaction Id
748150
Contract Number
CNYG-414M
Work Order Id
706928
Line Item Id
538.0
Item Number
07K
Line Item Description
TREE REMOVAL OF OVER 12 TO 18 INCHES DBH
Unit Of Measure
EA
Unit Price
525.0
Units Used
1.0
Total Cost
525.0
Transaction Date
2015-09-15T00:00:00.000
748151
Transaction Id: 748151 • Contract Number: CNYG-414M • Work Order Id: 706928
Transaction Id
748151
Contract Number
CNYG-414M
Work Order Id
706928
Line Item Id
355.0
Item Number
11.5K
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
14.4
Units Used
46.9
Total Cost
675.36
Transaction Date
2015-09-15T00:00:00.000
748152
Transaction Id: 748152 • Contract Number: CNYG-414M • Work Order Id: 706928
Transaction Id
748152
Contract Number
CNYG-414M
Work Order Id
706928
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748153
Transaction Id: 748153 • Contract Number: CNYG-414M • Work Order Id: 710522
Transaction Id
748153
Contract Number
CNYG-414M
Work Order Id
710522
Line Item Id
329.0
Item Number
09K
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
20.0
Units Used
42.0
Total Cost
840.0
Transaction Date
2015-09-23T00:00:00.000
748154
Transaction Id: 748154 • Contract Number: CNYG-414M • Work Order Id: 710522
Transaction Id
748154
Contract Number
CNYG-414M
Work Order Id
710522
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748155
Transaction Id: 748155 • Contract Number: CNYG-414M • Work Order Id: 705326
Transaction Id
748155
Contract Number
CNYG-414M
Work Order Id
705326
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.0
Total Cost
432.0
Transaction Date
2015-09-21T00:00:00.000
748156
Transaction Id: 748156 • Contract Number: CNYG-414M • Work Order Id: 705326
Transaction Id
748156
Contract Number
CNYG-414M
Work Order Id
705326
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748157
Transaction Id: 748157 • Contract Number: CNYG-414M • Work Order Id: 706119
Transaction Id
748157
Contract Number
CNYG-414M
Work Order Id
706119
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.5
Total Cost
440.0
Transaction Date
2015-09-21T00:00:00.000
748158
Transaction Id: 748158 • Contract Number: CNYG-414M • Work Order Id: 706119
Transaction Id
748158
Contract Number
CNYG-414M
Work Order Id
706119
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748159
Transaction Id: 748159 • Contract Number: CNYG-414M • Work Order Id: 707322
Transaction Id
748159
Contract Number
CNYG-414M
Work Order Id
707322
Line Item Id
355.0
Item Number
11.5K
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
14.4
Units Used
26.3
Total Cost
378.72
Transaction Date
2015-09-21T00:00:00.000
748160
Transaction Id: 748160 • Contract Number: CNYG-414M • Work Order Id: 707322
Transaction Id
748160
Contract Number
CNYG-414M
Work Order Id
707322
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748161
Transaction Id: 748161 • Contract Number: CNYG-414M • Work Order Id: 707322
Transaction Id
748161
Contract Number
CNYG-414M
Work Order Id
707322
Line Item Id
275.0
Item Number
01K
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
175.0
Units Used
1.0
Total Cost
175.0
Transaction Date
2015-09-21T00:00:00.000
748162
Transaction Id: 748162 • Contract Number: CNYG-414M • Work Order Id: 710524
Transaction Id
748162
Contract Number
CNYG-414M
Work Order Id
710524
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.0
Total Cost
432.0
Transaction Date
2015-09-24T00:00:00.000
748163
Transaction Id: 748163 • Contract Number: CNYG-414M • Work Order Id: 710524
Transaction Id
748163
Contract Number
CNYG-414M
Work Order Id
710524
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-19T00:00:00.000