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
747382
Transaction Id: 747382 • Contract Number: BG-315M • Work Order Id: 855845
Transaction Id
747382
Contract Number
BG-315M
Work Order Id
855845
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-12-24T00:00:00.000
747383
Transaction Id: 747383 • Contract Number: BG-315M • Work Order Id: 861842
Transaction Id
747383
Contract Number
BG-315M
Work Order Id
861842
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.2
Total Cost
1064.0
Transaction Date
2015-12-24T00:00:00.000
747384
Transaction Id: 747384 • Contract Number: BG-315M • Work Order Id: 865848
Transaction Id
747384
Contract Number
BG-315M
Work Order Id
865848
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-12-24T00:00:00.000
747385
Transaction Id: 747385 • Contract Number: BG-315M • Work Order Id: 863039
Transaction Id
747385
Contract Number
BG-315M
Work Order Id
863039
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
747386
Transaction Id: 747386 • Contract Number: BG-315M • Work Order Id: 861846
Transaction Id
747386
Contract Number
BG-315M
Work Order Id
861846
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.7
Total Cost
1099.0
Transaction Date
2015-12-24T00:00:00.000
747387
Transaction Id: 747387 • Contract Number: BG-315M • Work Order Id: 867836
Transaction Id
747387
Contract Number
BG-315M
Work Order Id
867836
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.1
Total Cost
917.0
Transaction Date
2015-12-24T00:00:00.000
747388
Transaction Id: 747388 • Contract Number: BG-315M • Work Order Id: 855847
Transaction Id
747388
Contract Number
BG-315M
Work Order Id
855847
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.3
Total Cost
861.0
Transaction Date
2015-12-24T00:00:00.000
747389
Transaction Id: 747389 • Contract Number: BG-315M • Work Order Id: 857455
Transaction Id
747389
Contract Number
BG-315M
Work Order Id
857455
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
747390
Transaction Id: 747390 • Contract Number: BG-315M • Work Order Id: 857456
Transaction Id
747390
Contract Number
BG-315M
Work Order Id
857456
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-12-24T00:00:00.000
747391
Transaction Id: 747391 • Contract Number: BG-315M • Work Order Id: 853055
Transaction Id
747391
Contract Number
BG-315M
Work Order Id
853055
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
2015-12-24T00:00:00.000
747392
Transaction Id: 747392 • Contract Number: BG-315M • Work Order Id: 853450
Transaction Id
747392
Contract Number
BG-315M
Work Order Id
853450
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
747393
Transaction Id: 747393 • Contract Number: BG-315M • Work Order Id: 859051
Transaction Id
747393
Contract Number
BG-315M
Work Order Id
859051
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.9
Total Cost
833.0
Transaction Date
2015-12-24T00:00:00.000
747394
Transaction Id: 747394 • Contract Number: BG-315M • Work Order Id: 865436
Transaction Id
747394
Contract Number
BG-315M
Work Order Id
865436
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-10-06T00:00:00.000
747395
Transaction Id: 747395 • Contract Number: BG-315M • Work Order Id: 853844
Transaction Id
747395
Contract Number
BG-315M
Work Order Id
853844
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.8
Total Cost
1246.0
Transaction Date
2015-10-06T00:00:00.000
747396
Transaction Id: 747396 • Contract Number: BG-315M • Work Order Id: 853053
Transaction Id
747396
Contract Number
BG-315M
Work Order Id
853053
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
747397
Transaction Id: 747397 • Contract Number: BG-315M • Work Order Id: 816655
Transaction Id
747397
Contract Number
BG-315M
Work Order Id
816655
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.8
Total Cost
1246.0
Transaction Date
2015-10-06T00:00:00.000
747398
Transaction Id: 747398 • Contract Number: BG-315M • Work Order Id: 818251
Transaction Id
747398
Contract Number
BG-315M
Work Order Id
818251
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.0
Total Cost
840.0
Transaction Date
2015-10-06T00:00:00.000
747399
Transaction Id: 747399 • Contract Number: BG-315M • Work Order Id: 824640
Transaction Id
747399
Contract Number
BG-315M
Work Order Id
824640
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
747400
Transaction Id: 747400 • Contract Number: BG-315M • Work Order Id: 860247
Transaction Id
747400
Contract Number
BG-315M
Work Order Id
860247
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.1
Total Cost
917.0
Transaction Date
2016-07-06T00:00:00.000
747405
Transaction Id: 747405 • Contract Number: BG-315M • Work Order Id: 853045
Transaction Id
747405
Contract Number
BG-315M
Work Order Id
853045
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.8
Total Cost
1176.0
Transaction Date
2016-07-06T00:00:00.000
747406
Transaction Id: 747406 • Contract Number: BG-315M • Work Order Id: 861836
Transaction Id
747406
Contract Number
BG-315M
Work Order Id
861836
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
2016-07-06T00:00:00.000
747407
Transaction Id: 747407 • Contract Number: BG-415M • Work Order Id: 678138
Transaction Id
747407
Contract Number
BG-415M
Work Order Id
678138
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
29.2
Total Cost
408.8
Transaction Date
2015-11-02T00:00:00.000
747408
Transaction Id: 747408 • Contract Number: BG-415M • Work Order Id: 678138
Transaction Id
747408
Contract Number
BG-415M
Work Order Id
678138
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-03T00:00:00.000
747409
Transaction Id: 747409 • Contract Number: BG-415M • Work Order Id: 679324
Transaction Id
747409
Contract Number
BG-415M
Work Order Id
679324
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
37.3
Total Cost
522.1999999999999
Transaction Date
2015-11-02T00:00:00.000
747410
Transaction Id: 747410 • Contract Number: BG-415M • Work Order Id: 679324
Transaction Id
747410
Contract Number
BG-415M
Work Order Id
679324
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-01-07T00:00:00.000
747411
Transaction Id: 747411 • Contract Number: BG-415M • Work Order Id: 679725
Transaction Id
747411
Contract Number
BG-415M
Work Order Id
679725
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
36.4
Total Cost
509.59999999999997
Transaction Date
2015-10-30T00:00:00.000
747412
Transaction Id: 747412 • Contract Number: BG-415M • Work Order Id: 679725
Transaction Id
747412
Contract Number
BG-415M
Work Order Id
679725
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-20T00:00:00.000
747413
Transaction Id: 747413 • Contract Number: BG-415M • Work Order Id: 680942
Transaction Id
747413
Contract Number
BG-415M
Work Order Id
680942
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
49.7
Total Cost
695.8000000000001
Transaction Date
2015-10-30T00:00:00.000
747414
Transaction Id: 747414 • Contract Number: BG-415M • Work Order Id: 680942
Transaction Id
747414
Contract Number
BG-415M
Work Order Id
680942
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-20T00:00:00.000
747415
Transaction Id: 747415 • Contract Number: BG-415M • Work Order Id: 675738
Transaction Id
747415
Contract Number
BG-415M
Work Order Id
675738
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
23.6
Total Cost
330.40000000000003
Transaction Date
2015-10-30T00:00:00.000
747416
Transaction Id: 747416 • Contract Number: BG-415M • Work Order Id: 675738
Transaction Id
747416
Contract Number
BG-415M
Work Order Id
675738
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-21T00:00:00.000
747419
Transaction Id: 747419 • Contract Number: BG-415M • Work Order Id: 675331
Transaction Id
747419
Contract Number
BG-415M
Work Order Id
675331
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
29.3
Total Cost
410.2
Transaction Date
2015-10-30T00:00:00.000
747420
Transaction Id: 747420 • Contract Number: BG-415M • Work Order Id: 675331
Transaction Id
747420
Contract Number
BG-415M
Work Order Id
675331
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-21T00:00:00.000
747421
Transaction Id: 747421 • Contract Number: BG-415M • Work Order Id: 679316
Transaction Id
747421
Contract Number
BG-415M
Work Order Id
679316
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
37.3
Total Cost
522.1999999999999
Transaction Date
2015-11-02T00:00:00.000
747422
Transaction Id: 747422 • Contract Number: BG-415M • Work Order Id: 679316
Transaction Id
747422
Contract Number
BG-415M
Work Order Id
679316
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-02T00:00:00.000
747423
Transaction Id: 747423 • Contract Number: BG-415M • Work Order Id: 666536
Transaction Id
747423
Contract Number
BG-415M
Work Order Id
666536
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
36.7
Total Cost
513.8000000000001
Transaction Date
2015-10-29T00:00:00.000
747424
Transaction Id: 747424 • Contract Number: BG-415M • Work Order Id: 666536
Transaction Id
747424
Contract Number
BG-415M
Work Order Id
666536
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-02-09T00:00:00.000
747425
Transaction Id: 747425 • Contract Number: BG-415M • Work Order Id: 1301070
Transaction Id
747425
Contract Number
BG-415M
Work Order Id
1301070
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
44.7
Total Cost
625.8000000000001
Transaction Date
2015-10-22T00:00:00.000
747426
Transaction Id: 747426 • Contract Number: BG-415M • Work Order Id: 1301070
Transaction Id
747426
Contract Number
BG-415M
Work Order Id
1301070
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-09T00:00:00.000
747427
Transaction Id: 747427 • Contract Number: BG-415M • Work Order Id: 680523
Transaction Id
747427
Contract Number
BG-415M
Work Order Id
680523
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
42.6
Total Cost
596.4
Transaction Date
2015-10-22T00:00:00.000
747428
Transaction Id: 747428 • Contract Number: BG-415M • Work Order Id: 680523
Transaction Id
747428
Contract Number
BG-415M
Work Order Id
680523
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-09T00:00:00.000
747429
Transaction Id: 747429 • Contract Number: BG-415M • Work Order Id: 682117
Transaction Id
747429
Contract Number
BG-415M
Work Order Id
682117
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
41.5
Total Cost
581.0
Transaction Date
2015-10-22T00:00:00.000
747430
Transaction Id: 747430 • Contract Number: BG-415M • Work Order Id: 682117
Transaction Id
747430
Contract Number
BG-415M
Work Order Id
682117
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-09T00:00:00.000
747431
Transaction Id: 747431 • Contract Number: BG-415M • Work Order Id: 672494
Transaction Id
747431
Contract Number
BG-415M
Work Order Id
672494
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
48.3
Total Cost
676.1999999999999
Transaction Date
2015-10-29T00:00:00.000
747433
Transaction Id: 747433 • Contract Number: BG-415M • Work Order Id: 680519
Transaction Id
747433
Contract Number
BG-415M
Work Order Id
680519
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
43.3
Total Cost
606.1999999999999
Transaction Date
2015-10-30T00:00:00.000
747434
Transaction Id: 747434 • Contract Number: BG-415M • Work Order Id: 680519
Transaction Id
747434
Contract Number
BG-415M
Work Order Id
680519
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-04T00:00:00.000
747435
Transaction Id: 747435 • Contract Number: BG-415M • Work Order Id: 648449
Transaction Id
747435
Contract Number
BG-415M
Work Order Id
648449
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
46.4
Total Cost
649.6
Transaction Date
2015-11-12T00:00:00.000
747436
Transaction Id: 747436 • Contract Number: BG-415M • Work Order Id: 648449
Transaction Id
747436
Contract Number
BG-415M
Work Order Id
648449
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-16T00:00:00.000
747437
Transaction Id: 747437 • Contract Number: BG-415M • Work Order Id: 647683
Transaction Id
747437
Contract Number
BG-415M
Work Order Id
647683
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
49.9
Total Cost
698.6
Transaction Date
2015-11-16T00:00:00.000
747438
Transaction Id: 747438 • Contract Number: BG-415M • Work Order Id: 647683
Transaction Id
747438
Contract Number
BG-415M
Work Order Id
647683
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-16T00:00:00.000
NYC Data AI • Public-data exploration interface