Ask NYC Browse All Data Public Safety Transportation Health Buildings

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
744190
Transaction Id: 744190 • Contract Number: MG-115M • Work Order Id: 662889
Transaction Id
744190
Contract Number
MG-115M
Work Order Id
662889
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
32.0
Total Cost
576.0
Transaction Date
2015-09-03T00:00:00.000
744191
Transaction Id: 744191 • Contract Number: MG-115M • Work Order Id: 656415
Transaction Id
744191
Contract Number
MG-115M
Work Order Id
656415
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
36.0
Total Cost
648.0
Transaction Date
2015-09-03T00:00:00.000
744192
Transaction Id: 744192 • Contract Number: MG-115M • Work Order Id: 727741
Transaction Id
744192
Contract Number
MG-115M
Work Order Id
727741
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
24.0
Total Cost
432.0
Transaction Date
2015-09-03T00:00:00.000
744193
Transaction Id: 744193 • Contract Number: MG-115M • Work Order Id: 732536
Transaction Id
744193
Contract Number
MG-115M
Work Order Id
732536
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
24.7
Total Cost
444.59999999999997
Transaction Date
2015-09-03T00:00:00.000
744194
Transaction Id: 744194 • Contract Number: MG-115M • Work Order Id: 661671
Transaction Id
744194
Contract Number
MG-115M
Work Order Id
661671
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
17.5
Total Cost
315.0
Transaction Date
2015-09-03T00:00:00.000
744195
Transaction Id: 744195 • Contract Number: MG-115M • Work Order Id: 660885
Transaction Id
744195
Contract Number
MG-115M
Work Order Id
660885
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
17.5
Total Cost
315.0
Transaction Date
2015-09-03T00:00:00.000
744196
Transaction Id: 744196 • Contract Number: MG-115M • Work Order Id: 1043039
Transaction Id
744196
Contract Number
MG-115M
Work Order Id
1043039
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
25.0
Total Cost
450.0
Transaction Date
2015-09-03T00:00:00.000
744197
Transaction Id: 744197 • Contract Number: MG-115M • Work Order Id: 1043039
Transaction Id
744197
Contract Number
MG-115M
Work Order Id
1043039
Line Item Id
312.0
Item Number
23
Line Item Description
REMOVE AND RESET METAL TREE GUARDS AND GRATES
Unit Of Measure
HR
Unit Price
75.0
Units Used
0.5
Total Cost
37.5
Transaction Date
2015-09-03T00:00:00.000
744198
Transaction Id: 744198 • Contract Number: MG-115M • Work Order Id: 1045838
Transaction Id
744198
Contract Number
MG-115M
Work Order Id
1045838
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
25.0
Total Cost
450.0
Transaction Date
2015-09-03T00:00:00.000
744199
Transaction Id: 744199 • Contract Number: MG-115M • Work Order Id: 1045838
Transaction Id
744199
Contract Number
MG-115M
Work Order Id
1045838
Line Item Id
312.0
Item Number
23
Line Item Description
REMOVE AND RESET METAL TREE GUARDS AND GRATES
Unit Of Measure
HR
Unit Price
75.0
Units Used
0.5
Total Cost
37.5
Transaction Date
2015-09-03T00:00:00.000
744200
Transaction Id: 744200 • Contract Number: MG-115M • Work Order Id: 732131
Transaction Id
744200
Contract Number
MG-115M
Work Order Id
732131
Line Item Id
289.0
Item Number
22
Line Item Description
REMOVE DEBRIS (TREE PIT AND CANOPY)
Unit Of Measure
HR
Unit Price
75.0
Units Used
0.25
Total Cost
18.75
Transaction Date
2015-09-03T00:00:00.000
744201
Transaction Id: 744201 • Contract Number: MG-115M • Work Order Id: 732131
Transaction Id
744201
Contract Number
MG-115M
Work Order Id
732131
Line Item Id
294.0
Item Number
27
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
45.0
Units Used
2.0
Total Cost
90.0
Transaction Date
2015-09-03T00:00:00.000
744204
Transaction Id: 744204 • Contract Number: MG-115M • Work Order Id: 729336
Transaction Id
744204
Contract Number
MG-115M
Work Order Id
729336
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
24.6
Total Cost
442.8
Transaction Date
2015-09-03T00:00:00.000
744205
Transaction Id: 744205 • Contract Number: MG-115M • Work Order Id: 729336
Transaction Id
744205
Contract Number
MG-115M
Work Order Id
729336
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
11.2
Total Cost
246.39999999999998
Transaction Date
2015-09-03T00:00:00.000
744206
Transaction Id: 744206 • Contract Number: MG-115M • Work Order Id: 727739
Transaction Id
744206
Contract Number
MG-115M
Work Order Id
727739
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
40.3
Total Cost
725.4
Transaction Date
2015-09-03T00:00:00.000
744207
Transaction Id: 744207 • Contract Number: MG-115M • Work Order Id: 733731
Transaction Id
744207
Contract Number
MG-115M
Work Order Id
733731
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
39.7
Total Cost
714.6
Transaction Date
2015-09-03T00:00:00.000
744208
Transaction Id: 744208 • Contract Number: MG-115M • Work Order Id: 666506
Transaction Id
744208
Contract Number
MG-115M
Work Order Id
666506
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
50.6
Total Cost
910.8000000000001
Transaction Date
2015-09-03T00:00:00.000
744209
Transaction Id: 744209 • Contract Number: MG-115M • Work Order Id: 659366
Transaction Id
744209
Contract Number
MG-115M
Work Order Id
659366
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
50.2
Total Cost
903.6
Transaction Date
2015-09-03T00:00:00.000
744210
Transaction Id: 744210 • Contract Number: MG-115M • Work Order Id: 658984
Transaction Id
744210
Contract Number
MG-115M
Work Order Id
658984
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
49.0
Total Cost
882.0
Transaction Date
2015-09-03T00:00:00.000
744211
Transaction Id: 744211 • Contract Number: MG-115M • Work Order Id: 660097
Transaction Id
744211
Contract Number
MG-115M
Work Order Id
660097
Line Item Id
286.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
175.0
Units Used
1.0
Total Cost
175.0
Transaction Date
2015-09-03T00:00:00.000
744212
Transaction Id: 744212 • Contract Number: MG-115M • Work Order Id: 734127
Transaction Id
744212
Contract Number
MG-115M
Work Order Id
734127
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
100.0
Units Used
1.0
Total Cost
100.0
Transaction Date
2015-09-03T00:00:00.000
744213
Transaction Id: 744213 • Contract Number: MG-115M • Work Order Id: 728130
Transaction Id
744213
Contract Number
MG-115M
Work Order Id
728130
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
100.0
Units Used
1.0
Total Cost
100.0
Transaction Date
2015-09-03T00:00:00.000
744214
Transaction Id: 744214 • Contract Number: MG-115M • Work Order Id: 660478
Transaction Id
744214
Contract Number
MG-115M
Work Order Id
660478
Line Item Id
286.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
175.0
Units Used
1.0
Total Cost
175.0
Transaction Date
2015-09-03T00:00:00.000
744215
Transaction Id: 744215 • Contract Number: MG-115M • Work Order Id: 643558
Transaction Id
744215
Contract Number
MG-115M
Work Order Id
643558
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
100.0
Units Used
1.0
Total Cost
100.0
Transaction Date
2015-09-03T00:00:00.000
744216
Transaction Id: 744216 • Contract Number: MG-115M • Work Order Id: 641635
Transaction Id
744216
Contract Number
MG-115M
Work Order Id
641635
Line Item Id
305.0
Item Number
06
Line Item Description
TREE REMOVAL OF OVER 8 TO 12 INCHES DBH
Unit Of Measure
EA
Unit Price
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2015-09-03T00:00:00.000
744217
Transaction Id: 744217 • Contract Number: MG-115M • Work Order Id: 640428
Transaction Id
744217
Contract Number
MG-115M
Work Order Id
640428
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
100.0
Units Used
1.0
Total Cost
100.0
Transaction Date
2015-09-03T00:00:00.000
744218
Transaction Id: 744218 • Contract Number: MG-115M • Work Order Id: 1049441
Transaction Id
744218
Contract Number
MG-115M
Work Order Id
1049441
Line Item Id
286.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
175.0
Units Used
1.0
Total Cost
175.0
Transaction Date
2015-09-03T00:00:00.000
744219
Transaction Id: 744219 • Contract Number: MG-115M • Work Order Id: 1048642
Transaction Id
744219
Contract Number
MG-115M
Work Order Id
1048642
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
100.0
Units Used
1.0
Total Cost
100.0
Transaction Date
2015-09-03T00:00:00.000
744220
Transaction Id: 744220 • Contract Number: MG-115M • Work Order Id: 1047044
Transaction Id
744220
Contract Number
MG-115M
Work Order Id
1047044
Line Item Id
286.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
175.0
Units Used
1.0
Total Cost
175.0
Transaction Date
2015-09-03T00:00:00.000
744221
Transaction Id: 744221 • Contract Number: MG-115M • Work Order Id: 1048240
Transaction Id
744221
Contract Number
MG-115M
Work Order Id
1048240
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
100.0
Units Used
1.0
Total Cost
100.0
Transaction Date
2015-09-03T00:00:00.000
744222
Transaction Id: 744222 • Contract Number: MG-115M • Work Order Id: 640462
Transaction Id
744222
Contract Number
MG-115M
Work Order Id
640462
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
100.0
Units Used
1.0
Total Cost
100.0
Transaction Date
2015-09-03T00:00:00.000
744223
Transaction Id: 744223 • Contract Number: MG-115M • Work Order Id: 639647
Transaction Id
744223
Contract Number
MG-115M
Work Order Id
639647
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
100.0
Units Used
1.0
Total Cost
100.0
Transaction Date
2015-09-03T00:00:00.000
744224
Transaction Id: 744224 • Contract Number: MG-115M • Work Order Id: 662177
Transaction Id
744224
Contract Number
MG-115M
Work Order Id
662177
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
100.0
Units Used
1.0
Total Cost
100.0
Transaction Date
2015-09-03T00:00:00.000
744225
Transaction Id: 744225 • Contract Number: MG-115M • Work Order Id: 651787
Transaction Id
744225
Contract Number
MG-115M
Work Order Id
651787
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
100.0
Units Used
1.0
Total Cost
100.0
Transaction Date
2015-09-03T00:00:00.000
744226
Transaction Id: 744226 • Contract Number: MG-115M • Work Order Id: 658909
Transaction Id
744226
Contract Number
MG-115M
Work Order Id
658909
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
100.0
Units Used
1.0
Total Cost
100.0
Transaction Date
2015-09-03T00:00:00.000
744227
Transaction Id: 744227 • Contract Number: MG-115M • Work Order Id: 733333
Transaction Id
744227
Contract Number
MG-115M
Work Order Id
733333
Line Item Id
305.0
Item Number
06
Line Item Description
TREE REMOVAL OF OVER 8 TO 12 INCHES DBH
Unit Of Measure
EA
Unit Price
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2015-09-03T00:00:00.000
744228
Transaction Id: 744228 • Contract Number: MG-115M • Work Order Id: 1047440
Transaction Id
744228
Contract Number
MG-115M
Work Order Id
1047440
Line Item Id
305.0
Item Number
06
Line Item Description
TREE REMOVAL OF OVER 8 TO 12 INCHES DBH
Unit Of Measure
EA
Unit Price
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2015-09-03T00:00:00.000
744230
Transaction Id: 744230 • Contract Number: MG-115M • Work Order Id: 661273
Transaction Id
744230
Contract Number
MG-115M
Work Order Id
661273
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
26.7
Total Cost
480.59999999999997
Transaction Date
2015-09-04T00:00:00.000
744231
Transaction Id: 744231 • Contract Number: MG-115M • Work Order Id: 662103
Transaction Id
744231
Contract Number
MG-115M
Work Order Id
662103
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
25.5
Total Cost
459.0
Transaction Date
2015-09-04T00:00:00.000
744232
Transaction Id: 744232 • Contract Number: MG-115M • Work Order Id: 662832
Transaction Id
744232
Contract Number
MG-115M
Work Order Id
662832
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
25.5
Total Cost
459.0
Transaction Date
2015-09-04T00:00:00.000
744233
Transaction Id: 744233 • Contract Number: MG-115M • Work Order Id: 1044239
Transaction Id
744233
Contract Number
MG-115M
Work Order Id
1044239
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
24.8
Total Cost
446.40000000000003
Transaction Date
2015-09-04T00:00:00.000
744234
Transaction Id: 744234 • Contract Number: MG-115M • Work Order Id: 660097
Transaction Id
744234
Contract Number
MG-115M
Work Order Id
660097
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
16.2
Units Used
20.1
Total Cost
325.62
Transaction Date
2015-09-04T00:00:00.000
744235
Transaction Id: 744235 • Contract Number: MG-115M • Work Order Id: 660097
Transaction Id
744235
Contract Number
MG-115M
Work Order Id
660097
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
19.8
Units Used
2.9
Total Cost
57.42
Transaction Date
2015-09-04T00:00:00.000
744236
Transaction Id: 744236 • Contract Number: MG-115M • Work Order Id: 664464
Transaction Id
744236
Contract Number
MG-115M
Work Order Id
664464
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
24.1
Total Cost
433.8
Transaction Date
2015-09-04T00:00:00.000
744237
Transaction Id: 744237 • Contract Number: MG-115M • Work Order Id: 664464
Transaction Id
744237
Contract Number
MG-115M
Work Order Id
664464
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
8.6
Total Cost
189.2
Transaction Date
2015-09-04T00:00:00.000
744238
Transaction Id: 744238 • Contract Number: MG-115M • Work Order Id: 831844
Transaction Id
744238
Contract Number
MG-115M
Work Order Id
831844
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
32.0
Total Cost
576.0
Transaction Date
2015-09-04T00:00:00.000
744239
Transaction Id: 744239 • Contract Number: MG-115M • Work Order Id: 661079
Transaction Id
744239
Contract Number
MG-115M
Work Order Id
661079
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
49.0
Total Cost
882.0
Transaction Date
2015-09-04T00:00:00.000
744240
Transaction Id: 744240 • Contract Number: MG-115M • Work Order Id: 663724
Transaction Id
744240
Contract Number
MG-115M
Work Order Id
663724
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
42.0
Total Cost
756.0
Transaction Date
2015-09-04T00:00:00.000
744241
Transaction Id: 744241 • Contract Number: MG-115M • Work Order Id: 661337
Transaction Id
744241
Contract Number
MG-115M
Work Order Id
661337
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
23.4
Total Cost
421.2
Transaction Date
2015-09-04T00:00:00.000
744242
Transaction Id: 744242 • Contract Number: MG-115M • Work Order Id: 661337
Transaction Id
744242
Contract Number
MG-115M
Work Order Id
661337
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
9.2
Total Cost
202.39999999999998
Transaction Date
2015-09-04T00:00:00.000
NYC Data AI • Public-data exploration interface