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
747225
Transaction Id: 747225 • Contract Number: QG-215M • Work Order Id: 644412
Transaction Id
747225
Contract Number
QG-215M
Work Order Id
644412
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
5.0
Units Used
30.0
Total Cost
150.0
Transaction Date
2015-09-14T00:00:00.000
747226
Transaction Id: 747226 • Contract Number: QG-215M • Work Order Id: 1224665
Transaction Id
747226
Contract Number
QG-215M
Work Order Id
1224665
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
747227
Transaction Id: 747227 • Contract Number: QG-215M • Work Order Id: 1224665
Transaction Id
747227
Contract Number
QG-215M
Work Order Id
1224665
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-12-28T00:00:00.000
747228
Transaction Id: 747228 • Contract Number: QG-215M • Work Order Id: 1224665
Transaction Id
747228
Contract Number
QG-215M
Work Order Id
1224665
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
33.3
Total Cost
329.66999999999996
Transaction Date
2015-12-28T00:00:00.000
747229
Transaction Id: 747229 • Contract Number: QG-215M • Work Order Id: 1224664
Transaction Id
747229
Contract Number
QG-215M
Work Order Id
1224664
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
747230
Transaction Id: 747230 • Contract Number: QG-215M • Work Order Id: 1224664
Transaction Id
747230
Contract Number
QG-215M
Work Order Id
1224664
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
2016-01-14T00:00:00.000
747233
Transaction Id: 747233 • Contract Number: QG-215M • Work Order Id: 649742
Transaction Id
747233
Contract Number
QG-215M
Work Order Id
649742
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-09-09T00:00:00.000
747234
Transaction Id: 747234 • Contract Number: MG-115M • Work Order Id: 662494
Transaction Id
747234
Contract Number
MG-115M
Work Order Id
662494
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
16.0
Total Cost
288.0
Transaction Date
2015-09-08T00:00:00.000
747235
Transaction Id: 747235 • Contract Number: MG-115M • Work Order Id: 662494
Transaction Id
747235
Contract Number
MG-115M
Work Order Id
662494
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
16.8
Total Cost
369.6
Transaction Date
2015-09-08T00:00:00.000
747236
Transaction Id: 747236 • Contract Number: MG-115M • Work Order Id: 1046638
Transaction Id
747236
Contract Number
MG-115M
Work Order Id
1046638
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
5.6
Total Cost
100.8
Transaction Date
2015-09-08T00:00:00.000
747237
Transaction Id: 747237 • Contract Number: MG-115M • Work Order Id: 1046638
Transaction Id
747237
Contract Number
MG-115M
Work Order Id
1046638
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
26.2
Total Cost
576.4
Transaction Date
2015-09-08T00:00:00.000
747238
Transaction Id: 747238 • Contract Number: MG-115M • Work Order Id: 661334
Transaction Id
747238
Contract Number
MG-115M
Work Order Id
661334
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
41.9
Total Cost
754.1999999999999
Transaction Date
2015-09-08T00:00:00.000
747239
Transaction Id: 747239 • Contract Number: MG-115M • Work Order Id: 660074
Transaction Id
747239
Contract Number
MG-115M
Work Order Id
660074
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-08T00:00:00.000
747240
Transaction Id: 747240 • Contract Number: MG-115M • Work Order Id: 669691
Transaction Id
747240
Contract Number
MG-115M
Work Order Id
669691
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.5
Total Cost
729.0
Transaction Date
2015-09-08T00:00:00.000
747241
Transaction Id: 747241 • Contract Number: MG-115M • Work Order Id: 666507
Transaction Id
747241
Contract Number
MG-115M
Work Order Id
666507
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
29.8
Total Cost
536.4
Transaction Date
2015-09-08T00:00:00.000
747242
Transaction Id: 747242 • Contract Number: MG-115M • Work Order Id: 669296
Transaction Id
747242
Contract Number
MG-115M
Work Order Id
669296
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-08T00:00:00.000
747243
Transaction Id: 747243 • Contract Number: MG-115M • Work Order Id: 667298
Transaction Id
747243
Contract Number
MG-115M
Work Order Id
667298
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
41.6
Total Cost
748.8000000000001
Transaction Date
2015-09-08T00:00:00.000
747244
Transaction Id: 747244 • Contract Number: MG-115M • Work Order Id: 668097
Transaction Id
747244
Contract Number
MG-115M
Work Order Id
668097
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.9
Total Cost
736.1999999999999
Transaction Date
2015-09-08T00:00:00.000
747245
Transaction Id: 747245 • Contract Number: MG-115M • Work Order Id: 664108
Transaction Id
747245
Contract Number
MG-115M
Work Order Id
664108
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
30.0
Total Cost
660.0
Transaction Date
2015-09-08T00:00:00.000
747246
Transaction Id: 747246 • Contract Number: MG-115M • Work Order Id: 664907
Transaction Id
747246
Contract Number
MG-115M
Work Order Id
664907
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
29.9
Total Cost
538.1999999999999
Transaction Date
2015-09-08T00:00:00.000
747247
Transaction Id: 747247 • Contract Number: MG-115M • Work Order Id: 664907
Transaction Id
747247
Contract Number
MG-115M
Work Order Id
664907
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
2.0
Total Cost
44.0
Transaction Date
2015-09-08T00:00:00.000
747248
Transaction Id: 747248 • Contract Number: MG-115M • Work Order Id: 660864
Transaction Id
747248
Contract Number
MG-115M
Work Order Id
660864
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
29.6
Total Cost
532.8000000000001
Transaction Date
2015-09-08T00:00:00.000
747249
Transaction Id: 747249 • Contract Number: MG-115M • Work Order Id: 660864
Transaction Id
747249
Contract Number
MG-115M
Work Order Id
660864
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
2.0
Total Cost
44.0
Transaction Date
2015-09-08T00:00:00.000
747250
Transaction Id: 747250 • Contract Number: MG-115M • Work Order Id: 660459
Transaction Id
747250
Contract Number
MG-115M
Work Order Id
660459
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.7
Total Cost
588.6
Transaction Date
2015-09-08T00:00:00.000
747251
Transaction Id: 747251 • Contract Number: MG-115M • Work Order Id: 660459
Transaction Id
747251
Contract Number
MG-115M
Work Order Id
660459
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
2.2
Total Cost
48.400000000000006
Transaction Date
2015-09-08T00:00:00.000
747252
Transaction Id: 747252 • Contract Number: MG-115M • Work Order Id: 662060
Transaction Id
747252
Contract Number
MG-115M
Work Order Id
662060
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
33.0
Total Cost
594.0
Transaction Date
2015-09-08T00:00:00.000
747253
Transaction Id: 747253 • Contract Number: MG-115M • Work Order Id: 662060
Transaction Id
747253
Contract Number
MG-115M
Work Order Id
662060
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
2.2
Total Cost
48.400000000000006
Transaction Date
2015-09-08T00:00:00.000
747254
Transaction Id: 747254 • Contract Number: MG-115M • Work Order Id: 662055
Transaction Id
747254
Contract Number
MG-115M
Work Order Id
662055
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-08T00:00:00.000
747255
Transaction Id: 747255 • Contract Number: MG-115M • Work Order Id: 662055
Transaction Id
747255
Contract Number
MG-115M
Work Order Id
662055
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
1.6
Total Cost
35.2
Transaction Date
2015-09-08T00:00:00.000
747258
Transaction Id: 747258 • Contract Number: MG-115M • Work Order Id: 731337
Transaction Id
747258
Contract Number
MG-115M
Work Order Id
731337
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.4
Total Cost
439.2
Transaction Date
2015-09-09T00:00:00.000
747259
Transaction Id: 747259 • Contract Number: MG-115M • Work Order Id: 731337
Transaction Id
747259
Contract Number
MG-115M
Work Order Id
731337
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
6.1
Total Cost
134.2
Transaction Date
2015-09-09T00:00:00.000
747260
Transaction Id: 747260 • Contract Number: MG-115M • Work Order Id: 731337
Transaction Id
747260
Contract Number
MG-115M
Work Order Id
731337
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.25
Total Cost
18.75
Transaction Date
2015-09-09T00:00:00.000
747261
Transaction Id: 747261 • Contract Number: MG-115M • Work Order Id: 727743
Transaction Id
747261
Contract Number
MG-115M
Work Order Id
727743
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
28.7
Total Cost
516.6
Transaction Date
2015-09-09T00:00:00.000
747262
Transaction Id: 747262 • Contract Number: MG-115M • Work Order Id: 727743
Transaction Id
747262
Contract Number
MG-115M
Work Order Id
727743
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
4.6
Total Cost
101.19999999999999
Transaction Date
2015-09-09T00:00:00.000
747263
Transaction Id: 747263 • Contract Number: MG-115M • Work Order Id: 662439
Transaction Id
747263
Contract Number
MG-115M
Work Order Id
662439
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
41.3
Total Cost
743.4
Transaction Date
2015-09-09T00:00:00.000
747264
Transaction Id: 747264 • Contract Number: MG-115M • Work Order Id: 1047038
Transaction Id
747264
Contract Number
MG-115M
Work Order Id
1047038
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
15.9
Total Cost
286.2
Transaction Date
2015-09-09T00:00:00.000
747265
Transaction Id: 747265 • Contract Number: MG-115M • Work Order Id: 1047038
Transaction Id
747265
Contract Number
MG-115M
Work Order Id
1047038
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
12.4
Total Cost
272.8
Transaction Date
2015-09-09T00:00:00.000
747266
Transaction Id: 747266 • Contract Number: MG-115M • Work Order Id: 731330
Transaction Id
747266
Contract Number
MG-115M
Work Order Id
731330
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
33.3
Total Cost
599.4
Transaction Date
2015-09-09T00:00:00.000
747267
Transaction Id: 747267 • Contract Number: MG-115M • Work Order Id: 632595
Transaction Id
747267
Contract Number
MG-115M
Work Order Id
632595
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.0
Total Cost
414.0
Transaction Date
2015-09-09T00:00:00.000
747268
Transaction Id: 747268 • Contract Number: MG-115M • Work Order Id: 632595
Transaction Id
747268
Contract Number
MG-115M
Work Order Id
632595
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-09T00:00:00.000
747269
Transaction Id: 747269 • Contract Number: MG-115M • Work Order Id: 1049438
Transaction Id
747269
Contract Number
MG-115M
Work Order Id
1049438
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.0
Total Cost
414.0
Transaction Date
2015-09-09T00:00:00.000
747270
Transaction Id: 747270 • Contract Number: MG-115M • Work Order Id: 1049438
Transaction Id
747270
Contract Number
MG-115M
Work Order Id
1049438
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
6.7
Total Cost
147.4
Transaction Date
2015-09-09T00:00:00.000
747271
Transaction Id: 747271 • Contract Number: MG-115M • Work Order Id: 1049438
Transaction Id
747271
Contract Number
MG-115M
Work Order Id
1049438
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-09T00:00:00.000
747272
Transaction Id: 747272 • Contract Number: MG-115M • Work Order Id: 731335
Transaction Id
747272
Contract Number
MG-115M
Work Order Id
731335
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
43.5
Total Cost
957.0
Transaction Date
2015-09-09T00:00:00.000
747273
Transaction Id: 747273 • Contract Number: MG-115M • Work Order Id: 728145
Transaction Id
747273
Contract Number
MG-115M
Work Order Id
728145
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-09T00:00:00.000
747274
Transaction Id: 747274 • Contract Number: MG-115M • Work Order Id: 728145
Transaction Id
747274
Contract Number
MG-115M
Work Order Id
728145
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
15.0
Total Cost
330.0
Transaction Date
2015-09-09T00:00:00.000
747275
Transaction Id: 747275 • Contract Number: MG-115M • Work Order Id: 1047438
Transaction Id
747275
Contract Number
MG-115M
Work Order Id
1047438
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.4
Total Cost
727.1999999999999
Transaction Date
2015-09-09T00:00:00.000
747276
Transaction Id: 747276 • Contract Number: MG-115M • Work Order Id: 733735
Transaction Id
747276
Contract Number
MG-115M
Work Order Id
733735
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-09T00:00:00.000
747277
Transaction Id: 747277 • Contract Number: MG-115M • Work Order Id: 733735
Transaction Id
747277
Contract Number
MG-115M
Work Order Id
733735
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
15.0
Total Cost
330.0
Transaction Date
2015-09-09T00:00:00.000
747278
Transaction Id: 747278 • Contract Number: MG-115M • Work Order Id: 687320
Transaction Id
747278
Contract Number
MG-115M
Work Order Id
687320
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
16.0
Total Cost
288.0
Transaction Date
2015-09-09T00:00:00.000
NYC Data AI • Public-data exploration interface