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
746542
Transaction Id: 746542 • Contract Number: QG-215M • Work Order Id: 961437
Transaction Id
746542
Contract Number
QG-215M
Work Order Id
961437
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
38.8
Total Cost
384.12
Transaction Date
2015-09-25T00:00:00.000
746543
Transaction Id: 746543 • Contract Number: QG-215M • Work Order Id: 696149
Transaction Id
746543
Contract Number
QG-215M
Work Order Id
696149
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
746544
Transaction Id: 746544 • Contract Number: QG-215M • Work Order Id: 696149
Transaction Id
746544
Contract Number
QG-215M
Work Order Id
696149
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-11T00:00:00.000
746545
Transaction Id: 746545 • Contract Number: QG-215M • Work Order Id: 669698
Transaction Id
746545
Contract Number
QG-215M
Work Order Id
669698
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-13T00:00:00.000
746546
Transaction Id: 746546 • Contract Number: QG-215M • Work Order Id: 669698
Transaction Id
746546
Contract Number
QG-215M
Work Order Id
669698
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
23.6
Total Cost
254.88000000000002
Transaction Date
2015-09-18T00:00:00.000
746547
Transaction Id: 746547 • Contract Number: QG-215M • Work Order Id: 669698
Transaction Id
746547
Contract Number
QG-215M
Work Order Id
669698
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-30T00:00:00.000
746548
Transaction Id: 746548 • Contract Number: QG-215M • Work Order Id: 669698
Transaction Id
746548
Contract Number
QG-215M
Work Order Id
669698
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
23.7
Total Cost
362.61
Transaction Date
2015-09-18T00:00:00.000
746549
Transaction Id: 746549 • Contract Number: QG-215M • Work Order Id: 655605
Transaction Id
746549
Contract Number
QG-215M
Work Order Id
655605
Line Item Id
342.0
Item Number
30
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
10.0
Units Used
24.5
Total Cost
245.0
Transaction Date
2015-11-13T00:00:00.000
746551
Transaction Id: 746551 • Contract Number: QG-215M • Work Order Id: 655601
Transaction Id
746551
Contract Number
QG-215M
Work Order Id
655601
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-09T00:00:00.000
746552
Transaction Id: 746552 • Contract Number: QG-215M • Work Order Id: 655588
Transaction Id
746552
Contract Number
QG-215M
Work Order Id
655588
Line Item Id
342.0
Item Number
30
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
10.0
Units Used
47.0
Total Cost
470.0
Transaction Date
2015-09-10T00:00:00.000
746553
Transaction Id: 746553 • Contract Number: QG-215M • Work Order Id: 655588
Transaction Id
746553
Contract Number
QG-215M
Work Order Id
655588
Line Item Id
335.0
Item Number
05
Line Item Description
STUMP REMOVALS OF OVER 30 TO 36 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2015-09-09T00:00:00.000
746556
Transaction Id: 746556 • Contract Number: QG-215M • Work Order Id: 790628
Transaction Id
746556
Contract Number
QG-215M
Work Order Id
790628
Line Item Id
342.0
Item Number
30
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
10.0
Units Used
74.0
Total Cost
740.0
Transaction Date
2015-09-08T00:00:00.000
746557
Transaction Id: 746557 • Contract Number: QG-215M • Work Order Id: 698114
Transaction Id
746557
Contract Number
QG-215M
Work Order Id
698114
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-21T00:00:00.000
746558
Transaction Id: 746558 • Contract Number: QG-215M • Work Order Id: 698114
Transaction Id
746558
Contract Number
QG-215M
Work Order Id
698114
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
746559
Transaction Id: 746559 • Contract Number: QG-215M • Work Order Id: 995439
Transaction Id
746559
Contract Number
QG-215M
Work Order Id
995439
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-11-02T00:00:00.000
746560
Transaction Id: 746560 • Contract Number: QG-215M • Work Order Id: 995839
Transaction Id
746560
Contract Number
QG-215M
Work Order Id
995839
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-10-02T00:00:00.000
746561
Transaction Id: 746561 • Contract Number: QG-215M • Work Order Id: 1067845
Transaction Id
746561
Contract Number
QG-215M
Work Order Id
1067845
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
2016-04-30T00:00:00.000
746562
Transaction Id: 746562 • Contract Number: QG-215M • Work Order Id: 662472
Transaction Id
746562
Contract Number
QG-215M
Work Order Id
662472
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-09-30T00:00:00.000
746563
Transaction Id: 746563 • Contract Number: QG-215M • Work Order Id: 669690
Transaction Id
746563
Contract Number
QG-215M
Work Order Id
669690
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-09-30T00:00:00.000
746564
Transaction Id: 746564 • Contract Number: QG-215M • Work Order Id: 665700
Transaction Id
746564
Contract Number
QG-215M
Work Order Id
665700
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-11-02T00:00:00.000
746565
Transaction Id: 746565 • Contract Number: QG-215M • Work Order Id: 670093
Transaction Id
746565
Contract Number
QG-215M
Work Order Id
670093
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-11-06T00:00:00.000
746566
Transaction Id: 746566 • Contract Number: QG-215M • Work Order Id: 667309
Transaction Id
746566
Contract Number
QG-215M
Work Order Id
667309
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
2016-04-30T00:00:00.000
746567
Transaction Id: 746567 • Contract Number: QG-215M • Work Order Id: 661014
Transaction Id
746567
Contract Number
QG-215M
Work Order Id
661014
Line Item Id
335.0
Item Number
05
Line Item Description
STUMP REMOVALS OF OVER 30 TO 36 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2016-04-30T00:00:00.000
746568
Transaction Id: 746568 • Contract Number: QG-215M • Work Order Id: 666539
Transaction Id
746568
Contract Number
QG-215M
Work Order Id
666539
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-10-02T00:00:00.000
746572
Transaction Id: 746572 • Contract Number: QG-215M • Work Order Id: 655200
Transaction Id
746572
Contract Number
QG-215M
Work Order Id
655200
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
746573
Transaction Id: 746573 • Contract Number: QG-215M • Work Order Id: 655200
Transaction Id
746573
Contract Number
QG-215M
Work Order Id
655200
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-23T00:00:00.000
746574
Transaction Id: 746574 • Contract Number: QG-215M • Work Order Id: 655200
Transaction Id
746574
Contract Number
QG-215M
Work Order Id
655200
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
746575
Transaction Id: 746575 • Contract Number: QG-215M • Work Order Id: 654059
Transaction Id
746575
Contract Number
QG-215M
Work Order Id
654059
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
746576
Transaction Id: 746576 • Contract Number: QG-215M • Work Order Id: 654059
Transaction Id
746576
Contract Number
QG-215M
Work Order Id
654059
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
746577
Transaction Id: 746577 • Contract Number: QG-215M • Work Order Id: 697313
Transaction Id
746577
Contract Number
QG-215M
Work Order Id
697313
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
746579
Transaction Id: 746579 • Contract Number: QG-215M • Work Order Id: 698912
Transaction Id
746579
Contract Number
QG-215M
Work Order Id
698912
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
746580
Transaction Id: 746580 • Contract Number: QG-215M • Work Order Id: 698912
Transaction Id
746580
Contract Number
QG-215M
Work Order Id
698912
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
23.3
Total Cost
230.67000000000002
Transaction Date
2015-09-21T00:00:00.000
746581
Transaction Id: 746581 • Contract Number: QG-215M • Work Order Id: 698917
Transaction Id
746581
Contract Number
QG-215M
Work Order Id
698917
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
746582
Transaction Id: 746582 • Contract Number: QG-215M • Work Order Id: 698917
Transaction Id
746582
Contract Number
QG-215M
Work Order Id
698917
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
24.9
Total Cost
268.92
Transaction Date
2015-09-18T00:00:00.000
746583
Transaction Id: 746583 • Contract Number: QG-215M • Work Order Id: 698917
Transaction Id
746583
Contract Number
QG-215M
Work Order Id
698917
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
31.5
Total Cost
481.95000000000005
Transaction Date
2015-09-18T00:00:00.000
746584
Transaction Id: 746584 • Contract Number: QG-215M • Work Order Id: 698917
Transaction Id
746584
Contract Number
QG-215M
Work Order Id
698917
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
18.8
Total Cost
1353.6000000000001
Transaction Date
2016-02-23T00:00:00.000
746585
Transaction Id: 746585 • Contract Number: QG-215M • Work Order Id: 651482
Transaction Id
746585
Contract Number
QG-215M
Work Order Id
651482
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
746586
Transaction Id: 746586 • Contract Number: QG-215M • Work Order Id: 651482
Transaction Id
746586
Contract Number
QG-215M
Work Order Id
651482
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.3
Total Cost
566.0999999999999
Transaction Date
2015-09-16T00:00:00.000
746587
Transaction Id: 746587 • Contract Number: QG-215M • Work Order Id: 696546
Transaction Id
746587
Contract Number
QG-215M
Work Order Id
696546
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
746588
Transaction Id: 746588 • Contract Number: QG-215M • Work Order Id: 696546
Transaction Id
746588
Contract Number
QG-215M
Work Order Id
696546
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
23.6
Total Cost
233.64000000000001
Transaction Date
2015-09-22T00:00:00.000
746590
Transaction Id: 746590 • Contract Number: QG-215M • Work Order Id: 656388
Transaction Id
746590
Contract Number
QG-215M
Work Order Id
656388
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
746591
Transaction Id: 746591 • Contract Number: QG-215M • Work Order Id: 656388
Transaction Id
746591
Contract Number
QG-215M
Work Order Id
656388
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
52.4
Total Cost
890.8
Transaction Date
2015-09-23T00:00:00.000
746592
Transaction Id: 746592 • Contract Number: QG-215M • Work Order Id: 656388
Transaction Id
746592
Contract Number
QG-215M
Work Order Id
656388
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-21T00:00:00.000
746593
Transaction Id: 746593 • Contract Number: QG-215M • Work Order Id: 700911
Transaction Id
746593
Contract Number
QG-215M
Work Order Id
700911
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
746594
Transaction Id: 746594 • Contract Number: QG-215M • Work Order Id: 700911
Transaction Id
746594
Contract Number
QG-215M
Work Order Id
700911
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
37.5
Total Cost
371.25
Transaction Date
2015-09-15T00:00:00.000
746595
Transaction Id: 746595 • Contract Number: QG-215M • Work Order Id: 994639
Transaction Id
746595
Contract Number
QG-215M
Work Order Id
994639
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
746599
Transaction Id: 746599 • Contract Number: QG-215M • Work Order Id: 697713
Transaction Id
746599
Contract Number
QG-215M
Work Order Id
697713
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
746600
Transaction Id: 746600 • Contract Number: QG-215M • Work Order Id: 697713
Transaction Id
746600
Contract Number
QG-215M
Work Order Id
697713
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
17.5
Total Cost
173.25
Transaction Date
2015-09-08T00:00:00.000
746601
Transaction Id: 746601 • Contract Number: QG-215M • Work Order Id: 655219
Transaction Id
746601
Contract Number
QG-215M
Work Order Id
655219
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
746602
Transaction Id: 746602 • Contract Number: QG-215M • Work Order Id: 655219
Transaction Id
746602
Contract Number
QG-215M
Work Order Id
655219
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.3
Total Cost
566.0999999999999
Transaction Date
2015-09-08T00:00:00.000
NYC Data AI • Public-data exploration interface