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
746603
Transaction Id: 746603 • Contract Number: QG-215M • Work Order Id: 655617
Transaction Id
746603
Contract Number
QG-215M
Work Order Id
655617
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
746604
Transaction Id: 746604 • Contract Number: QG-215M • Work Order Id: 655617
Transaction Id
746604
Contract Number
QG-215M
Work Order Id
655617
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
34.7
Total Cost
589.9000000000001
Transaction Date
2015-09-08T00:00:00.000
746605
Transaction Id: 746605 • Contract Number: QG-215M • Work Order Id: 656395
Transaction Id
746605
Contract Number
QG-215M
Work Order Id
656395
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
746606
Transaction Id: 746606 • Contract Number: QG-215M • Work Order Id: 656395
Transaction Id
746606
Contract Number
QG-215M
Work Order Id
656395
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
32.4
Total Cost
550.8
Transaction Date
2015-09-08T00:00:00.000
746607
Transaction Id: 746607 • Contract Number: QG-215M • Work Order Id: 700116
Transaction Id
746607
Contract Number
QG-215M
Work Order Id
700116
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
746608
Transaction Id: 746608 • Contract Number: QG-215M • Work Order Id: 700116
Transaction Id
746608
Contract Number
QG-215M
Work Order Id
700116
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
32.0
Total Cost
316.8
Transaction Date
2015-09-21T00:00:00.000
746609
Transaction Id: 746609 • Contract Number: QG-215M • Work Order Id: 655232
Transaction Id
746609
Contract Number
QG-215M
Work Order Id
655232
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
746610
Transaction Id: 746610 • Contract Number: QG-215M • Work Order Id: 655232
Transaction Id
746610
Contract Number
QG-215M
Work Order Id
655232
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-22T00:00:00.000
746611
Transaction Id: 746611 • Contract Number: QG-215M • Work Order Id: 655627
Transaction Id
746611
Contract Number
QG-215M
Work Order Id
655627
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
746612
Transaction Id: 746612 • Contract Number: QG-215M • Work Order Id: 655627
Transaction Id
746612
Contract Number
QG-215M
Work Order Id
655627
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-22T00:00:00.000
746613
Transaction Id: 746613 • Contract Number: QG-215M • Work Order Id: 653331
Transaction Id
746613
Contract Number
QG-215M
Work Order Id
653331
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
746614
Transaction Id: 746614 • Contract Number: QG-215M • Work Order Id: 653331
Transaction Id
746614
Contract Number
QG-215M
Work Order Id
653331
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-22T00:00:00.000
746615
Transaction Id: 746615 • Contract Number: QG-215M • Work Order Id: 666926
Transaction Id
746615
Contract Number
QG-215M
Work Order Id
666926
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
746616
Transaction Id: 746616 • Contract Number: QG-215M • Work Order Id: 666926
Transaction Id
746616
Contract Number
QG-215M
Work Order Id
666926
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-09-21T00:00:00.000
746617
Transaction Id: 746617 • Contract Number: QG-215M • Work Order Id: 666926
Transaction Id
746617
Contract Number
QG-215M
Work Order Id
666926
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
27.6
Total Cost
1987.2
Transaction Date
2016-04-30T00:00:00.000
746618
Transaction Id: 746618 • Contract Number: QG-215M • Work Order Id: 667339
Transaction Id
746618
Contract Number
QG-215M
Work Order Id
667339
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
746619
Transaction Id: 746619 • Contract Number: QG-215M • Work Order Id: 667339
Transaction Id
746619
Contract Number
QG-215M
Work Order Id
667339
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
24.1
Total Cost
368.73
Transaction Date
2015-09-21T00:00:00.000
746620
Transaction Id: 746620 • Contract Number: QG-215M • Work Order Id: 667339
Transaction Id
746620
Contract Number
QG-215M
Work Order Id
667339
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
16.7
Total Cost
180.36
Transaction Date
2015-09-21T00:00:00.000
746621
Transaction Id: 746621 • Contract Number: QG-215M • Work Order Id: 667339
Transaction Id
746621
Contract Number
QG-215M
Work Order Id
667339
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-09T00:00:00.000
746624
Transaction Id: 746624 • Contract Number: QG-215M • Work Order Id: 667339
Transaction Id
746624
Contract Number
QG-215M
Work Order Id
667339
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
26.3
Total Cost
1893.6000000000001
Transaction Date
2016-04-30T00:00:00.000
746625
Transaction Id: 746625 • Contract Number: QG-215M • Work Order Id: 659417
Transaction Id
746625
Contract Number
QG-215M
Work Order Id
659417
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
746626
Transaction Id: 746626 • Contract Number: QG-215M • Work Order Id: 659417
Transaction Id
746626
Contract Number
QG-215M
Work Order Id
659417
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
41.0
Total Cost
697.0
Transaction Date
2015-12-19T00:00:00.000
746627
Transaction Id: 746627 • Contract Number: QG-215M • Work Order Id: 659417
Transaction Id
746627
Contract Number
QG-215M
Work Order Id
659417
Line Item Id
353.0
Item Number
37
Line Item Description
STEEL TREE PIT GUARD - C
Unit Of Measure
LF
Unit Price
69.0
Units Used
16.0
Total Cost
1104.0
Transaction Date
2016-03-21T00:00:00.000
746631
Transaction Id: 746631 • Contract Number: QG-215M • Work Order Id: 664876
Transaction Id
746631
Contract Number
QG-215M
Work Order Id
664876
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
746632
Transaction Id: 746632 • Contract Number: QG-215M • Work Order Id: 664876
Transaction Id
746632
Contract Number
QG-215M
Work Order Id
664876
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
41.0
Total Cost
697.0
Transaction Date
2015-12-19T00:00:00.000
746633
Transaction Id: 746633 • Contract Number: QG-215M • Work Order Id: 664876
Transaction Id
746633
Contract Number
QG-215M
Work Order Id
664876
Line Item Id
353.0
Item Number
37
Line Item Description
STEEL TREE PIT GUARD - C
Unit Of Measure
LF
Unit Price
69.0
Units Used
16.0
Total Cost
1104.0
Transaction Date
2016-03-21T00:00:00.000
746637
Transaction Id: 746637 • Contract Number: QG-215M • Work Order Id: 786630
Transaction Id
746637
Contract Number
QG-215M
Work Order Id
786630
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-15T00:00:00.000
746638
Transaction Id: 746638 • Contract Number: QG-215M • Work Order Id: 786630
Transaction Id
746638
Contract Number
QG-215M
Work Order Id
786630
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
45.8
Total Cost
549.5999999999999
Transaction Date
2016-01-15T00:00:00.000
746642
Transaction Id: 746642 • Contract Number: QG-215M • Work Order Id: 703715
Transaction Id
746642
Contract Number
QG-215M
Work Order Id
703715
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
746643
Transaction Id: 746643 • Contract Number: QG-215M • Work Order Id: 703715
Transaction Id
746643
Contract Number
QG-215M
Work Order Id
703715
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
48.4
Total Cost
522.72
Transaction Date
2015-12-19T00:00:00.000
746644
Transaction Id: 746644 • Contract Number: QG-215M • Work Order Id: 697722
Transaction Id
746644
Contract Number
QG-215M
Work Order Id
697722
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
746645
Transaction Id: 746645 • Contract Number: QG-215M • Work Order Id: 697722
Transaction Id
746645
Contract Number
QG-215M
Work Order Id
697722
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
45.3
Total Cost
489.24
Transaction Date
2016-01-13T00:00:00.000
746648
Transaction Id: 746648 • Contract Number: QG-215M • Work Order Id: 664097
Transaction Id
746648
Contract Number
QG-215M
Work Order Id
664097
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-16T00:00:00.000
746649
Transaction Id: 746649 • Contract Number: QG-215M • Work Order Id: 664097
Transaction Id
746649
Contract Number
QG-215M
Work Order Id
664097
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
40.0
Total Cost
480.0
Transaction Date
2015-12-16T00:00:00.000
746650
Transaction Id: 746650 • Contract Number: QG-215M • Work Order Id: 664103
Transaction Id
746650
Contract Number
QG-215M
Work Order Id
664103
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-16T00:00:00.000
746651
Transaction Id: 746651 • Contract Number: QG-215M • Work Order Id: 664103
Transaction Id
746651
Contract Number
QG-215M
Work Order Id
664103
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
40.0
Total Cost
480.0
Transaction Date
2015-12-16T00:00:00.000
746654
Transaction Id: 746654 • Contract Number: QG-215M • Work Order Id: 1067051
Transaction Id
746654
Contract Number
QG-215M
Work Order Id
1067051
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
49.4
Total Cost
494.0
Transaction Date
2015-09-10T00:00:00.000
746655
Transaction Id: 746655 • Contract Number: QG-215M • Work Order Id: 659297
Transaction Id
746655
Contract Number
QG-215M
Work Order Id
659297
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
746656
Transaction Id: 746656 • Contract Number: QG-215M • Work Order Id: 659297
Transaction Id
746656
Contract Number
QG-215M
Work Order Id
659297
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
25.0
Total Cost
247.5
Transaction Date
2015-12-31T00:00:00.000
746657
Transaction Id: 746657 • Contract Number: QG-215M • Work Order Id: 659297
Transaction Id
746657
Contract Number
QG-215M
Work Order Id
659297
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
2016-03-21T00:00:00.000
746658
Transaction Id: 746658 • Contract Number: QG-215M • Work Order Id: 658806
Transaction Id
746658
Contract Number
QG-215M
Work Order Id
658806
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
746659
Transaction Id: 746659 • Contract Number: QG-215M • Work Order Id: 658806
Transaction Id
746659
Contract Number
QG-215M
Work Order Id
658806
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
28.7
Total Cost
344.4
Transaction Date
2015-12-31T00:00:00.000
746660
Transaction Id: 746660 • Contract Number: QG-215M • Work Order Id: 658923
Transaction Id
746660
Contract Number
QG-215M
Work Order Id
658923
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
746661
Transaction Id: 746661 • Contract Number: QG-215M • Work Order Id: 658923
Transaction Id
746661
Contract Number
QG-215M
Work Order Id
658923
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
32.3
Total Cost
355.29999999999995
Transaction Date
2015-12-31T00:00:00.000
746663
Transaction Id: 746663 • Contract Number: QG-215M • Work Order Id: 660405
Transaction Id
746663
Contract Number
QG-215M
Work Order Id
660405
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
746664
Transaction Id: 746664 • Contract Number: QG-215M • Work Order Id: 660405
Transaction Id
746664
Contract Number
QG-215M
Work Order Id
660405
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
26.6
Total Cost
319.20000000000005
Transaction Date
2015-12-31T00:00:00.000
746665
Transaction Id: 746665 • Contract Number: QG-215M • Work Order Id: 660015
Transaction Id
746665
Contract Number
QG-215M
Work Order Id
660015
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-30T00:00:00.000
746666
Transaction Id: 746666 • Contract Number: QG-215M • Work Order Id: 660015
Transaction Id
746666
Contract Number
QG-215M
Work Order Id
660015
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
37.5
Total Cost
637.5
Transaction Date
2015-12-30T00:00:00.000
746667
Transaction Id: 746667 • Contract Number: QG-215M • Work Order Id: 660821
Transaction Id
746667
Contract Number
QG-215M
Work Order Id
660821
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-22T00:00:00.000
746668
Transaction Id: 746668 • Contract Number: QG-215M • Work Order Id: 660821
Transaction Id
746668
Contract Number
QG-215M
Work Order Id
660821
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
31.9
Total Cost
382.79999999999995
Transaction Date
2015-12-22T00:00:00.000
NYC Data AI • Public-data exploration interface