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
746492
Transaction Id: 746492 • Contract Number: QG-215M • Work Order Id: 702111
Transaction Id
746492
Contract Number
QG-215M
Work Order Id
702111
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-10-05T00:00:00.000
746493
Transaction Id: 746493 • Contract Number: QG-215M • Work Order Id: 702111
Transaction Id
746493
Contract Number
QG-215M
Work Order Id
702111
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
20.0
Total Cost
198.0
Transaction Date
2015-09-23T00:00:00.000
746494
Transaction Id: 746494 • Contract Number: QG-215M • Work Order Id: 698116
Transaction Id
746494
Contract Number
QG-215M
Work Order Id
698116
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-10-05T00:00:00.000
746495
Transaction Id: 746495 • Contract Number: QG-215M • Work Order Id: 698116
Transaction Id
746495
Contract Number
QG-215M
Work Order Id
698116
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
21.0
Total Cost
207.9
Transaction Date
2015-09-23T00:00:00.000
746496
Transaction Id: 746496 • Contract Number: QG-215M • Work Order Id: 696551
Transaction Id
746496
Contract Number
QG-215M
Work Order Id
696551
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-10-07T00:00:00.000
746497
Transaction Id: 746497 • Contract Number: QG-215M • Work Order Id: 696551
Transaction Id
746497
Contract Number
QG-215M
Work Order Id
696551
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
28.0
Total Cost
277.2
Transaction Date
2015-09-21T00:00:00.000
746498
Transaction Id: 746498 • Contract Number: QG-215M • Work Order Id: 643755
Transaction Id
746498
Contract Number
QG-215M
Work Order Id
643755
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-10-01T00:00:00.000
746499
Transaction Id: 746499 • Contract Number: QG-215M • Work Order Id: 643755
Transaction Id
746499
Contract Number
QG-215M
Work Order Id
643755
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
45.8
Total Cost
778.5999999999999
Transaction Date
2015-09-16T00:00:00.000
746500
Transaction Id: 746500 • Contract Number: QG-215M • Work Order Id: 641830
Transaction Id
746500
Contract Number
QG-215M
Work Order Id
641830
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-10-01T00:00:00.000
746501
Transaction Id: 746501 • Contract Number: QG-215M • Work Order Id: 641830
Transaction Id
746501
Contract Number
QG-215M
Work Order Id
641830
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
38.6
Total Cost
656.2
Transaction Date
2015-09-16T00:00:00.000
746502
Transaction Id: 746502 • Contract Number: QG-215M • Work Order Id: 698914
Transaction Id
746502
Contract Number
QG-215M
Work Order Id
698914
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-10-01T00:00:00.000
746503
Transaction Id: 746503 • Contract Number: QG-215M • Work Order Id: 698914
Transaction Id
746503
Contract Number
QG-215M
Work Order Id
698914
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
44.3
Total Cost
438.57
Transaction Date
2015-10-01T00:00:00.000
746504
Transaction Id: 746504 • Contract Number: QG-215M • Work Order Id: 647745
Transaction Id
746504
Contract Number
QG-215M
Work Order Id
647745
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-10-07T00:00:00.000
746505
Transaction Id: 746505 • Contract Number: QG-215M • Work Order Id: 647745
Transaction Id
746505
Contract Number
QG-215M
Work Order Id
647745
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
49.9
Total Cost
848.3
Transaction Date
2015-09-18T00:00:00.000
746506
Transaction Id: 746506 • Contract Number: QG-215M • Work Order Id: 647745
Transaction Id
746506
Contract Number
QG-215M
Work Order Id
647745
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-21T00:00:00.000
746507
Transaction Id: 746507 • Contract Number: QG-215M • Work Order Id: 648526
Transaction Id
746507
Contract Number
QG-215M
Work Order Id
648526
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-10-07T00:00:00.000
746508
Transaction Id: 746508 • Contract Number: QG-215M • Work Order Id: 648526
Transaction Id
746508
Contract Number
QG-215M
Work Order Id
648526
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
42.0
Total Cost
714.0
Transaction Date
2015-09-18T00:00:00.000
746509
Transaction Id: 746509 • Contract Number: QG-215M • Work Order Id: 664067
Transaction Id
746509
Contract Number
QG-215M
Work Order Id
664067
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-09-24T00:00:00.000
746510
Transaction Id: 746510 • Contract Number: QG-215M • Work Order Id: 664067
Transaction Id
746510
Contract Number
QG-215M
Work Order Id
664067
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-09-24T00:00:00.000
746511
Transaction Id: 746511 • Contract Number: QG-215M • Work Order Id: 662951
Transaction Id
746511
Contract Number
QG-215M
Work Order Id
662951
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-09-24T00:00:00.000
746512
Transaction Id: 746512 • Contract Number: QG-215M • Work Order Id: 662951
Transaction Id
746512
Contract Number
QG-215M
Work Order Id
662951
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-09-24T00:00:00.000
746513
Transaction Id: 746513 • Contract Number: QG-215M • Work Order Id: 647821
Transaction Id
746513
Contract Number
QG-215M
Work Order Id
647821
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-31T00:00:00.000
746514
Transaction Id: 746514 • Contract Number: QG-215M • Work Order Id: 647821
Transaction Id
746514
Contract Number
QG-215M
Work Order Id
647821
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
54.2
Total Cost
921.4000000000001
Transaction Date
2015-12-31T00:00:00.000
746515
Transaction Id: 746515 • Contract Number: QG-215M • Work Order Id: 647821
Transaction Id
746515
Contract Number
QG-215M
Work Order Id
647821
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.1
Total Cost
1122.2
Transaction Date
2016-03-14T00:00:00.000
746516
Transaction Id: 746516 • Contract Number: QG-215M • Work Order Id: 660032
Transaction Id
746516
Contract Number
QG-215M
Work Order Id
660032
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-10-01T00:00:00.000
746517
Transaction Id: 746517 • Contract Number: QG-215M • Work Order Id: 660032
Transaction Id
746517
Contract Number
QG-215M
Work Order Id
660032
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
24.0
Total Cost
237.60000000000002
Transaction Date
2015-09-15T00:00:00.000
746518
Transaction Id: 746518 • Contract Number: QG-215M • Work Order Id: 660032
Transaction Id
746518
Contract Number
QG-215M
Work Order Id
660032
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
75.0
Units Used
1.0
Total Cost
75.0
Transaction Date
2015-09-30T00:00:00.000
746519
Transaction Id: 746519 • Contract Number: QG-215M • Work Order Id: 816240
Transaction Id
746519
Contract Number
QG-215M
Work Order Id
816240
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-09-29T00:00:00.000
746520
Transaction Id: 746520 • Contract Number: QG-215M • Work Order Id: 816240
Transaction Id
746520
Contract Number
QG-215M
Work Order Id
816240
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
24.0
Total Cost
237.60000000000002
Transaction Date
2015-09-16T00:00:00.000
746521
Transaction Id: 746521 • Contract Number: QG-215M • Work Order Id: 816240
Transaction Id
746521
Contract Number
QG-215M
Work Order Id
816240
Line Item Id
297.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
125.0
Units Used
1.0
Total Cost
125.0
Transaction Date
2015-09-16T00:00:00.000
746522
Transaction Id: 746522 • Contract Number: QG-215M • Work Order Id: 701713
Transaction Id
746522
Contract Number
QG-215M
Work Order Id
701713
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-09-18T00:00:00.000
746523
Transaction Id: 746523 • Contract Number: QG-215M • Work Order Id: 701713
Transaction Id
746523
Contract Number
QG-215M
Work Order Id
701713
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
24.0
Total Cost
237.60000000000002
Transaction Date
2015-09-16T00:00:00.000
746524
Transaction Id: 746524 • Contract Number: QG-215M • Work Order Id: 698512
Transaction Id
746524
Contract Number
QG-215M
Work Order Id
698512
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-10-07T00:00:00.000
746525
Transaction Id: 746525 • Contract Number: QG-215M • Work Order Id: 698512
Transaction Id
746525
Contract Number
QG-215M
Work Order Id
698512
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
45.0
Total Cost
445.5
Transaction Date
2015-09-21T00:00:00.000
746526
Transaction Id: 746526 • Contract Number: QG-215M • Work Order Id: 660815
Transaction Id
746526
Contract Number
QG-215M
Work Order Id
660815
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-10-06T00:00:00.000
746527
Transaction Id: 746527 • Contract Number: QG-215M • Work Order Id: 660815
Transaction Id
746527
Contract Number
QG-215M
Work Order Id
660815
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
59.2
Total Cost
1006.4000000000001
Transaction Date
2015-09-17T00:00:00.000
746528
Transaction Id: 746528 • Contract Number: QG-215M • Work Order Id: 652019
Transaction Id
746528
Contract Number
QG-215M
Work Order Id
652019
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-10-07T00:00:00.000
746529
Transaction Id: 746529 • Contract Number: QG-215M • Work Order Id: 652019
Transaction Id
746529
Contract Number
QG-215M
Work Order Id
652019
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
58.5
Total Cost
994.5
Transaction Date
2015-09-21T00:00:00.000
746530
Transaction Id: 746530 • Contract Number: QG-215M • Work Order Id: 652413
Transaction Id
746530
Contract Number
QG-215M
Work Order Id
652413
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-10-07T00:00:00.000
746531
Transaction Id: 746531 • Contract Number: QG-215M • Work Order Id: 652413
Transaction Id
746531
Contract Number
QG-215M
Work Order Id
652413
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
60.5
Total Cost
1028.5
Transaction Date
2015-09-21T00:00:00.000
746532
Transaction Id: 746532 • Contract Number: QG-215M • Work Order Id: 652059
Transaction Id
746532
Contract Number
QG-215M
Work Order Id
652059
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-09-18T00:00:00.000
746533
Transaction Id: 746533 • Contract Number: QG-215M • Work Order Id: 652059
Transaction Id
746533
Contract Number
QG-215M
Work Order Id
652059
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
49.6
Total Cost
843.2
Transaction Date
2015-09-16T00:00:00.000
746534
Transaction Id: 746534 • Contract Number: QG-215M • Work Order Id: 825036
Transaction Id
746534
Contract Number
QG-215M
Work Order Id
825036
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-09-18T00:00:00.000
746535
Transaction Id: 746535 • Contract Number: QG-215M • Work Order Id: 825036
Transaction Id
746535
Contract Number
QG-215M
Work Order Id
825036
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
24.0
Total Cost
237.60000000000002
Transaction Date
2015-09-18T00:00:00.000
746536
Transaction Id: 746536 • Contract Number: QG-215M • Work Order Id: 825036
Transaction Id
746536
Contract Number
QG-215M
Work Order Id
825036
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
95.0
Units Used
1.0
Total Cost
95.0
Transaction Date
2015-09-18T00:00:00.000
746537
Transaction Id: 746537 • Contract Number: QG-215M • Work Order Id: 701312
Transaction Id
746537
Contract Number
QG-215M
Work Order Id
701312
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-09-18T00:00:00.000
746538
Transaction Id: 746538 • Contract Number: QG-215M • Work Order Id: 701312
Transaction Id
746538
Contract Number
QG-215M
Work Order Id
701312
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
24.0
Total Cost
237.60000000000002
Transaction Date
2015-09-18T00:00:00.000
746539
Transaction Id: 746539 • Contract Number: QG-215M • Work Order Id: 694137
Transaction Id
746539
Contract Number
QG-215M
Work Order Id
694137
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-10-01T00:00:00.000
746540
Transaction Id: 746540 • Contract Number: QG-215M • Work Order Id: 694137
Transaction Id
746540
Contract Number
QG-215M
Work Order Id
694137
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
49.0
Total Cost
529.2
Transaction Date
2015-09-16T00:00:00.000
746541
Transaction Id: 746541 • Contract Number: QG-215M • Work Order Id: 961437
Transaction Id
746541
Contract Number
QG-215M
Work Order Id
961437
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-09-25T00:00:00.000
NYC Data AI • Public-data exploration interface