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
747329
Transaction Id: 747329 • Contract Number: BG-315M • Work Order Id: 809849
Transaction Id
747329
Contract Number
BG-315M
Work Order Id
809849
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.3
Total Cost
1141.0
Transaction Date
2015-09-09T00:00:00.000
747330
Transaction Id: 747330 • Contract Number: BG-315M • Work Order Id: 815040
Transaction Id
747330
Contract Number
BG-315M
Work Order Id
815040
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.0
Total Cost
980.0
Transaction Date
2015-09-09T00:00:00.000
747331
Transaction Id: 747331 • Contract Number: BG-315M • Work Order Id: 827436
Transaction Id
747331
Contract Number
BG-315M
Work Order Id
827436
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.5
Total Cost
1085.0
Transaction Date
2015-10-06T00:00:00.000
747332
Transaction Id: 747332 • Contract Number: BG-315M • Work Order Id: 827835
Transaction Id
747332
Contract Number
BG-315M
Work Order Id
827835
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.8
Total Cost
1106.0
Transaction Date
2015-10-06T00:00:00.000
747333
Transaction Id: 747333 • Contract Number: BG-315M • Work Order Id: 821838
Transaction Id
747333
Contract Number
BG-315M
Work Order Id
821838
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.7
Total Cost
1239.0
Transaction Date
2015-10-06T00:00:00.000
747334
Transaction Id: 747334 • Contract Number: BG-315M • Work Order Id: 827037
Transaction Id
747334
Contract Number
BG-315M
Work Order Id
827037
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.8
Total Cost
1036.0
Transaction Date
2015-09-09T00:00:00.000
747335
Transaction Id: 747335 • Contract Number: BG-315M • Work Order Id: 818645
Transaction Id
747335
Contract Number
BG-315M
Work Order Id
818645
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.5
Total Cost
1015.0
Transaction Date
2015-09-09T00:00:00.000
747336
Transaction Id: 747336 • Contract Number: BG-315M • Work Order Id: 816241
Transaction Id
747336
Contract Number
BG-315M
Work Order Id
816241
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.9
Total Cost
1043.0
Transaction Date
2015-10-06T00:00:00.000
747337
Transaction Id: 747337 • Contract Number: BG-315M • Work Order Id: 819042
Transaction Id
747337
Contract Number
BG-315M
Work Order Id
819042
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.9
Total Cost
1183.0
Transaction Date
2015-10-06T00:00:00.000
747338
Transaction Id: 747338 • Contract Number: BG-315M • Work Order Id: 821842
Transaction Id
747338
Contract Number
BG-315M
Work Order Id
821842
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.2
Total Cost
1204.0
Transaction Date
2015-10-06T00:00:00.000
747339
Transaction Id: 747339 • Contract Number: BG-315M • Work Order Id: 822640
Transaction Id
747339
Contract Number
BG-315M
Work Order Id
822640
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.2
Total Cost
1204.0
Transaction Date
2015-10-06T00:00:00.000
747340
Transaction Id: 747340 • Contract Number: BG-315M • Work Order Id: 819446
Transaction Id
747340
Contract Number
BG-315M
Work Order Id
819446
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.5
Total Cost
1085.0
Transaction Date
2015-10-06T00:00:00.000
747341
Transaction Id: 747341 • Contract Number: BG-315M • Work Order Id: 820240
Transaction Id
747341
Contract Number
BG-315M
Work Order Id
820240
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.3
Total Cost
1071.0
Transaction Date
2015-10-06T00:00:00.000
747342
Transaction Id: 747342 • Contract Number: BG-315M • Work Order Id: 825837
Transaction Id
747342
Contract Number
BG-315M
Work Order Id
825837
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.3
Total Cost
1211.0
Transaction Date
2015-12-24T00:00:00.000
747343
Transaction Id: 747343 • Contract Number: BG-315M • Work Order Id: 828236
Transaction Id
747343
Contract Number
BG-315M
Work Order Id
828236
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.9
Total Cost
1043.0
Transaction Date
2016-07-06T00:00:00.000
747344
Transaction Id: 747344 • Contract Number: BG-315M • Work Order Id: 820241
Transaction Id
747344
Contract Number
BG-315M
Work Order Id
820241
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.8
Total Cost
1036.0
Transaction Date
2015-10-06T00:00:00.000
747345
Transaction Id: 747345 • Contract Number: BG-315M • Work Order Id: 825439
Transaction Id
747345
Contract Number
BG-315M
Work Order Id
825439
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.8
Total Cost
1036.0
Transaction Date
2015-10-06T00:00:00.000
747346
Transaction Id: 747346 • Contract Number: BG-315M • Work Order Id: 824239
Transaction Id
747346
Contract Number
BG-315M
Work Order Id
824239
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.9
Total Cost
1043.0
Transaction Date
2015-10-06T00:00:00.000
747347
Transaction Id: 747347 • Contract Number: BG-315M • Work Order Id: 818642
Transaction Id
747347
Contract Number
BG-315M
Work Order Id
818642
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.5
Total Cost
1225.0
Transaction Date
2015-09-09T00:00:00.000
747348
Transaction Id: 747348 • Contract Number: BG-315M • Work Order Id: 822636
Transaction Id
747348
Contract Number
BG-315M
Work Order Id
822636
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.4
Total Cost
1148.0
Transaction Date
2015-09-09T00:00:00.000
747349
Transaction Id: 747349 • Contract Number: BG-315M • Work Order Id: 820637
Transaction Id
747349
Contract Number
BG-315M
Work Order Id
820637
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.4
Total Cost
1078.0
Transaction Date
2015-09-09T00:00:00.000
747351
Transaction Id: 747351 • Contract Number: BG-315M • Work Order Id: 857441
Transaction Id
747351
Contract Number
BG-315M
Work Order Id
857441
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.9
Total Cost
1113.0
Transaction Date
2016-07-06T00:00:00.000
747352
Transaction Id: 747352 • Contract Number: BG-315M • Work Order Id: 862237
Transaction Id
747352
Contract Number
BG-315M
Work Order Id
862237
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.0
Total Cost
1120.0
Transaction Date
2016-07-06T00:00:00.000
747353
Transaction Id: 747353 • Contract Number: BG-315M • Work Order Id: 864636
Transaction Id
747353
Contract Number
BG-315M
Work Order Id
864636
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.0
Total Cost
1120.0
Transaction Date
2016-07-06T00:00:00.000
747354
Transaction Id: 747354 • Contract Number: BG-315M • Work Order Id: 857840
Transaction Id
747354
Contract Number
BG-315M
Work Order Id
857840
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.3
Total Cost
1001.0
Transaction Date
2015-12-24T00:00:00.000
747355
Transaction Id: 747355 • Contract Number: BG-315M • Work Order Id: 852262
Transaction Id
747355
Contract Number
BG-315M
Work Order Id
852262
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
11.8
Total Cost
826.0
Transaction Date
2015-10-06T00:00:00.000
747356
Transaction Id: 747356 • Contract Number: BG-315M • Work Order Id: 864238
Transaction Id
747356
Contract Number
BG-315M
Work Order Id
864238
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.3
Total Cost
1211.0
Transaction Date
2015-10-06T00:00:00.000
747357
Transaction Id: 747357 • Contract Number: BG-315M • Work Order Id: 862638
Transaction Id
747357
Contract Number
BG-315M
Work Order Id
862638
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.3
Total Cost
1211.0
Transaction Date
2015-10-06T00:00:00.000
747358
Transaction Id: 747358 • Contract Number: BG-315M • Work Order Id: 864639
Transaction Id
747358
Contract Number
BG-315M
Work Order Id
864639
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.6
Total Cost
1092.0
Transaction Date
2015-10-06T00:00:00.000
747359
Transaction Id: 747359 • Contract Number: BG-315M • Work Order Id: 865037
Transaction Id
747359
Contract Number
BG-315M
Work Order Id
865037
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.1
Total Cost
1057.0
Transaction Date
2016-07-06T00:00:00.000
747360
Transaction Id: 747360 • Contract Number: BG-315M • Work Order Id: 855443
Transaction Id
747360
Contract Number
BG-315M
Work Order Id
855443
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.3
Total Cost
1071.0
Transaction Date
2015-10-06T00:00:00.000
747361
Transaction Id: 747361 • Contract Number: BG-315M • Work Order Id: 867036
Transaction Id
747361
Contract Number
BG-315M
Work Order Id
867036
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.6
Total Cost
1162.0
Transaction Date
2016-07-06T00:00:00.000
747362
Transaction Id: 747362 • Contract Number: BG-315M • Work Order Id: 859840
Transaction Id
747362
Contract Number
BG-315M
Work Order Id
859840
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.8
Total Cost
1106.0
Transaction Date
2015-10-06T00:00:00.000
747363
Transaction Id: 747363 • Contract Number: BG-315M • Work Order Id: 866639
Transaction Id
747363
Contract Number
BG-315M
Work Order Id
866639
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.6
Total Cost
1162.0
Transaction Date
2015-10-06T00:00:00.000
747364
Transaction Id: 747364 • Contract Number: BG-315M • Work Order Id: 866641
Transaction Id
747364
Contract Number
BG-315M
Work Order Id
866641
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.4
Total Cost
1218.0
Transaction Date
2015-10-06T00:00:00.000
747365
Transaction Id: 747365 • Contract Number: BG-315M • Work Order Id: 863443
Transaction Id
747365
Contract Number
BG-315M
Work Order Id
863443
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.1
Total Cost
1197.0
Transaction Date
2015-10-06T00:00:00.000
747366
Transaction Id: 747366 • Contract Number: BG-315M • Work Order Id: 863442
Transaction Id
747366
Contract Number
BG-315M
Work Order Id
863442
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.3
Total Cost
1211.0
Transaction Date
2015-10-06T00:00:00.000
747369
Transaction Id: 747369 • Contract Number: BG-315M • Work Order Id: 851866
Transaction Id
747369
Contract Number
BG-315M
Work Order Id
851866
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.5
Total Cost
1225.0
Transaction Date
2016-01-21T00:00:00.000
747370
Transaction Id: 747370 • Contract Number: BG-315M • Work Order Id: 860241
Transaction Id
747370
Contract Number
BG-315M
Work Order Id
860241
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.3
Total Cost
1001.0
Transaction Date
2016-01-21T00:00:00.000
747371
Transaction Id: 747371 • Contract Number: BG-315M • Work Order Id: 861839
Transaction Id
747371
Contract Number
BG-315M
Work Order Id
861839
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.2
Total Cost
1134.0
Transaction Date
2016-01-21T00:00:00.000
747372
Transaction Id: 747372 • Contract Number: BG-315M • Work Order Id: 857447
Transaction Id
747372
Contract Number
BG-315M
Work Order Id
857447
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
13.5
Total Cost
945.0
Transaction Date
2016-01-21T00:00:00.000
747373
Transaction Id: 747373 • Contract Number: BG-315M • Work Order Id: 853447
Transaction Id
747373
Contract Number
BG-315M
Work Order Id
853447
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.8
Total Cost
1106.0
Transaction Date
2015-12-24T00:00:00.000
747374
Transaction Id: 747374 • Contract Number: BG-315M • Work Order Id: 853448
Transaction Id
747374
Contract Number
BG-315M
Work Order Id
853448
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
12.8
Total Cost
896.0
Transaction Date
2016-01-21T00:00:00.000
747375
Transaction Id: 747375 • Contract Number: BG-315M • Work Order Id: 857451
Transaction Id
747375
Contract Number
BG-315M
Work Order Id
857451
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
13.4
Total Cost
938.0
Transaction Date
2016-01-21T00:00:00.000
747376
Transaction Id: 747376 • Contract Number: BG-315M • Work Order Id: 863444
Transaction Id
747376
Contract Number
BG-315M
Work Order Id
863444
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.7
Total Cost
1169.0
Transaction Date
2016-01-21T00:00:00.000
747377
Transaction Id: 747377 • Contract Number: BG-315M • Work Order Id: 865845
Transaction Id
747377
Contract Number
BG-315M
Work Order Id
865845
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.7
Total Cost
1169.0
Transaction Date
2016-01-21T00:00:00.000
747378
Transaction Id: 747378 • Contract Number: BG-315M • Work Order Id: 865846
Transaction Id
747378
Contract Number
BG-315M
Work Order Id
865846
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.7
Total Cost
1169.0
Transaction Date
2016-01-21T00:00:00.000
747379
Transaction Id: 747379 • Contract Number: BG-315M • Work Order Id: 860242
Transaction Id
747379
Contract Number
BG-315M
Work Order Id
860242
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.3
Total Cost
1211.0
Transaction Date
2016-01-21T00:00:00.000
747380
Transaction Id: 747380 • Contract Number: BG-315M • Work Order Id: 865847
Transaction Id
747380
Contract Number
BG-315M
Work Order Id
865847
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.5
Total Cost
1015.0
Transaction Date
2015-12-24T00:00:00.000
747381
Transaction Id: 747381 • Contract Number: BG-315M • Work Order Id: 859047
Transaction Id
747381
Contract Number
BG-315M
Work Order Id
859047
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.9
Total Cost
1113.0
Transaction Date
2016-01-21T00:00:00.000