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
746251
Transaction Id: 746251 • Contract Number: QG-215M • Work Order Id: 666932
Transaction Id
746251
Contract Number
QG-215M
Work Order Id
666932
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-03T00:00:00.000
746252
Transaction Id: 746252 • Contract Number: QG-215M • Work Order Id: 666932
Transaction Id
746252
Contract Number
QG-215M
Work Order Id
666932
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
48.3
Total Cost
821.0999999999999
Transaction Date
2015-12-03T00:00:00.000
746253
Transaction Id: 746253 • Contract Number: QG-215M • Work Order Id: 666932
Transaction Id
746253
Contract Number
QG-215M
Work Order Id
666932
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
18.0
Total Cost
1116.0
Transaction Date
2016-03-14T00:00:00.000
746254
Transaction Id: 746254 • Contract Number: QG-215M • Work Order Id: 665726
Transaction Id
746254
Contract Number
QG-215M
Work Order Id
665726
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-03T00:00:00.000
746255
Transaction Id: 746255 • Contract Number: QG-215M • Work Order Id: 665726
Transaction Id
746255
Contract Number
QG-215M
Work Order Id
665726
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
50.0
Total Cost
850.0
Transaction Date
2015-12-03T00:00:00.000
746256
Transaction Id: 746256 • Contract Number: QG-215M • Work Order Id: 665726
Transaction Id
746256
Contract Number
QG-215M
Work Order Id
665726
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
17.3
Total Cost
1072.6000000000001
Transaction Date
2016-03-14T00:00:00.000
746257
Transaction Id: 746257 • Contract Number: QG-215M • Work Order Id: 670120
Transaction Id
746257
Contract Number
QG-215M
Work Order Id
670120
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-04T00:00:00.000
746258
Transaction Id: 746258 • Contract Number: QG-215M • Work Order Id: 670120
Transaction Id
746258
Contract Number
QG-215M
Work Order Id
670120
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
47.4
Total Cost
805.8
Transaction Date
2015-12-03T00:00:00.000
746259
Transaction Id: 746259 • Contract Number: QG-215M • Work Order Id: 670120
Transaction Id
746259
Contract Number
QG-215M
Work Order Id
670120
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
17.0
Total Cost
1054.0
Transaction Date
2016-03-14T00:00:00.000
746262
Transaction Id: 746262 • Contract Number: QG-215M • Work Order Id: 730534
Transaction Id
746262
Contract Number
QG-215M
Work Order Id
730534
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
746263
Transaction Id: 746263 • Contract Number: QG-215M • Work Order Id: 730534
Transaction Id
746263
Contract Number
QG-215M
Work Order Id
730534
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
28.4
Total Cost
482.79999999999995
Transaction Date
2015-12-10T00:00:00.000
746264
Transaction Id: 746264 • Contract Number: QG-215M • Work Order Id: 729338
Transaction Id
746264
Contract Number
QG-215M
Work Order Id
729338
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
746265
Transaction Id: 746265 • Contract Number: QG-215M • Work Order Id: 729338
Transaction Id
746265
Contract Number
QG-215M
Work Order Id
729338
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
31.3
Total Cost
532.1
Transaction Date
2015-12-15T00:00:00.000
746270
Transaction Id: 746270 • Contract Number: QG-215M • Work Order Id: 728149
Transaction Id
746270
Contract Number
QG-215M
Work Order Id
728149
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
746271
Transaction Id: 746271 • Contract Number: QG-215M • Work Order Id: 728149
Transaction Id
746271
Contract Number
QG-215M
Work Order Id
728149
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
25.4
Total Cost
431.79999999999995
Transaction Date
2015-12-10T00:00:00.000
746272
Transaction Id: 746272 • Contract Number: QG-215M • Work Order Id: 728149
Transaction Id
746272
Contract Number
QG-215M
Work Order Id
728149
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
18.0
Total Cost
1116.0
Transaction Date
2016-03-14T00:00:00.000
746273
Transaction Id: 746273 • Contract Number: QG-215M • Work Order Id: 728149
Transaction Id
746273
Contract Number
QG-215M
Work Order Id
728149
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.4
Total Cost
304.79999999999995
Transaction Date
2015-12-10T00:00:00.000
746274
Transaction Id: 746274 • Contract Number: QG-215M • Work Order Id: 828635
Transaction Id
746274
Contract Number
QG-215M
Work Order Id
828635
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
746275
Transaction Id: 746275 • Contract Number: QG-215M • Work Order Id: 828635
Transaction Id
746275
Contract Number
QG-215M
Work Order Id
828635
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
44.3
Total Cost
753.0999999999999
Transaction Date
2015-12-10T00:00:00.000
746276
Transaction Id: 746276 • Contract Number: QG-215M • Work Order Id: 828635
Transaction Id
746276
Contract Number
QG-215M
Work Order Id
828635
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.7
Total Cost
1035.3999999999999
Transaction Date
2016-03-14T00:00:00.000
746283
Transaction Id: 746283 • Contract Number: QG-215M • Work Order Id: 665265
Transaction Id
746283
Contract Number
QG-215M
Work Order Id
665265
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
746284
Transaction Id: 746284 • Contract Number: QG-215M • Work Order Id: 665265
Transaction Id
746284
Contract Number
QG-215M
Work Order Id
665265
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
746285
Transaction Id: 746285 • Contract Number: QG-215M • Work Order Id: 665265
Transaction Id
746285
Contract Number
QG-215M
Work Order Id
665265
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
746287
Transaction Id: 746287 • Contract Number: QG-215M • Work Order Id: 730138
Transaction Id
746287
Contract Number
QG-215M
Work Order Id
730138
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
746288
Transaction Id: 746288 • Contract Number: QG-215M • Work Order Id: 730138
Transaction Id
746288
Contract Number
QG-215M
Work Order Id
730138
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
25.0
Total Cost
425.0
Transaction Date
2015-12-10T00:00:00.000
746289
Transaction Id: 746289 • Contract Number: QG-215M • Work Order Id: 730138
Transaction Id
746289
Contract Number
QG-215M
Work Order Id
730138
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
18.3
Total Cost
1134.6000000000001
Transaction Date
2016-03-14T00:00:00.000
746290
Transaction Id: 746290 • Contract Number: QG-215M • Work Order Id: 730138
Transaction Id
746290
Contract Number
QG-215M
Work Order Id
730138
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
746291
Transaction Id: 746291 • Contract Number: QG-215M • Work Order Id: 727747
Transaction Id
746291
Contract Number
QG-215M
Work Order Id
727747
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
746292
Transaction Id: 746292 • Contract Number: QG-215M • Work Order Id: 727747
Transaction Id
746292
Contract Number
QG-215M
Work Order Id
727747
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
33.4
Total Cost
567.8
Transaction Date
2015-12-10T00:00:00.000
746293
Transaction Id: 746293 • Contract Number: QG-215M • Work Order Id: 739323
Transaction Id
746293
Contract Number
QG-215M
Work Order Id
739323
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
746294
Transaction Id: 746294 • Contract Number: QG-215M • Work Order Id: 739323
Transaction Id
746294
Contract Number
QG-215M
Work Order Id
739323
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
44.2
Total Cost
751.4000000000001
Transaction Date
2015-12-07T00:00:00.000
746295
Transaction Id: 746295 • Contract Number: QG-215M • Work Order Id: 739323
Transaction Id
746295
Contract Number
QG-215M
Work Order Id
739323
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.5
Total Cost
1023.0
Transaction Date
2016-03-14T00:00:00.000
746296
Transaction Id: 746296 • Contract Number: QG-215M • Work Order Id: 739725
Transaction Id
746296
Contract Number
QG-215M
Work Order Id
739725
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
746297
Transaction Id: 746297 • Contract Number: QG-215M • Work Order Id: 739725
Transaction Id
746297
Contract Number
QG-215M
Work Order Id
739725
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
50.0
Total Cost
850.0
Transaction Date
2015-12-10T00:00:00.000
746298
Transaction Id: 746298 • Contract Number: QG-215M • Work Order Id: 739725
Transaction Id
746298
Contract Number
QG-215M
Work Order Id
739725
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
17.8
Total Cost
1103.6000000000001
Transaction Date
2016-03-14T00:00:00.000
746305
Transaction Id: 746305 • Contract Number: QG-215M • Work Order Id: 738931
Transaction Id
746305
Contract Number
QG-215M
Work Order Id
738931
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
746306
Transaction Id: 746306 • Contract Number: QG-215M • Work Order Id: 738931
Transaction Id
746306
Contract Number
QG-215M
Work Order Id
738931
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
50.0
Total Cost
850.0
Transaction Date
2015-12-10T00:00:00.000
746307
Transaction Id: 746307 • Contract Number: QG-215M • Work Order Id: 738931
Transaction Id
746307
Contract Number
QG-215M
Work Order Id
738931
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.9
Total Cost
1047.8
Transaction Date
2016-03-14T00:00:00.000
746308
Transaction Id: 746308 • Contract Number: QG-215M • Work Order Id: 739740
Transaction Id
746308
Contract Number
QG-215M
Work Order Id
739740
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
746309
Transaction Id: 746309 • Contract Number: QG-215M • Work Order Id: 739740
Transaction Id
746309
Contract Number
QG-215M
Work Order Id
739740
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
23.0
Total Cost
391.0
Transaction Date
2015-12-10T00:00:00.000
746310
Transaction Id: 746310 • Contract Number: QG-215M • Work Order Id: 739740
Transaction Id
746310
Contract Number
QG-215M
Work Order Id
739740
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
746311
Transaction Id: 746311 • Contract Number: QG-215M • Work Order Id: 739740
Transaction Id
746311
Contract Number
QG-215M
Work Order Id
739740
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
23.7
Total Cost
284.4
Transaction Date
2015-12-10T00:00:00.000
746312
Transaction Id: 746312 • Contract Number: QG-215M • Work Order Id: 740537
Transaction Id
746312
Contract Number
QG-215M
Work Order Id
740537
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
746313
Transaction Id: 746313 • Contract Number: QG-215M • Work Order Id: 740537
Transaction Id
746313
Contract Number
QG-215M
Work Order Id
740537
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
23.3
Total Cost
396.1
Transaction Date
2015-12-10T00:00:00.000
746314
Transaction Id: 746314 • Contract Number: QG-215M • Work Order Id: 740537
Transaction Id
746314
Contract Number
QG-215M
Work Order Id
740537
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
746315
Transaction Id: 746315 • Contract Number: QG-215M • Work Order Id: 740537
Transaction Id
746315
Contract Number
QG-215M
Work Order Id
740537
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
23.7
Total Cost
284.4
Transaction Date
2015-12-10T00:00:00.000
746316
Transaction Id: 746316 • Contract Number: QG-215M • Work Order Id: 741737
Transaction Id
746316
Contract Number
QG-215M
Work Order Id
741737
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
746317
Transaction Id: 746317 • Contract Number: QG-215M • Work Order Id: 741737
Transaction Id
746317
Contract Number
QG-215M
Work Order Id
741737
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
22.9
Total Cost
389.29999999999995
Transaction Date
2015-12-10T00:00:00.000
746318
Transaction Id: 746318 • Contract Number: QG-215M • Work Order Id: 741737
Transaction Id
746318
Contract Number
QG-215M
Work Order Id
741737
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
746319
Transaction Id: 746319 • Contract Number: QG-215M • Work Order Id: 741737
Transaction Id
746319
Contract Number
QG-215M
Work Order Id
741737
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
22.9
Total Cost
274.79999999999995
Transaction Date
2015-12-10T00:00:00.000
NYC Data AI • Public-data exploration interface