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
746669
Transaction Id: 746669 • Contract Number: QG-215M • Work Order Id: 665705
Transaction Id
746669
Contract Number
QG-215M
Work Order Id
665705
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
746670
Transaction Id: 746670 • Contract Number: QG-215M • Work Order Id: 665705
Transaction Id
746670
Contract Number
QG-215M
Work Order Id
665705
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
40.0
Total Cost
396.0
Transaction Date
2015-12-22T00:00:00.000
746671
Transaction Id: 746671 • Contract Number: QG-215M • Work Order Id: 665705
Transaction Id
746671
Contract Number
QG-215M
Work Order Id
665705
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-03-21T00:00:00.000
746677
Transaction Id: 746677 • Contract Number: QG-215M • Work Order Id: 818657
Transaction Id
746677
Contract Number
QG-215M
Work Order Id
818657
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-10-02T00:00:00.000
746679
Transaction Id: 746679 • Contract Number: QG-215M • Work Order Id: 670123
Transaction Id
746679
Contract Number
QG-215M
Work Order Id
670123
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-10T00:00:00.000
746680
Transaction Id: 746680 • Contract Number: QG-215M • Work Order Id: 670123
Transaction Id
746680
Contract Number
QG-215M
Work Order Id
670123
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-12-10T00:00:00.000
746681
Transaction Id: 746681 • Contract Number: QG-215M • Work Order Id: 670123
Transaction Id
746681
Contract Number
QG-215M
Work Order Id
670123
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-02T00:00:00.000
746682
Transaction Id: 746682 • Contract Number: QG-215M • Work Order Id: 666118
Transaction Id
746682
Contract Number
QG-215M
Work Order Id
666118
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-10T00:00:00.000
746683
Transaction Id: 746683 • Contract Number: QG-215M • Work Order Id: 666118
Transaction Id
746683
Contract Number
QG-215M
Work Order Id
666118
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-12-10T00:00:00.000
746684
Transaction Id: 746684 • Contract Number: QG-215M • Work Order Id: 666118
Transaction Id
746684
Contract Number
QG-215M
Work Order Id
666118
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
746685
Transaction Id: 746685 • Contract Number: QG-215M • Work Order Id: 698524
Transaction Id
746685
Contract Number
QG-215M
Work Order Id
698524
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
746686
Transaction Id: 746686 • Contract Number: QG-215M • Work Order Id: 698524
Transaction Id
746686
Contract Number
QG-215M
Work Order Id
698524
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
38.9
Total Cost
420.12
Transaction Date
2015-12-22T00:00:00.000
746687
Transaction Id: 746687 • Contract Number: QG-215M • Work Order Id: 831039
Transaction Id
746687
Contract Number
QG-215M
Work Order Id
831039
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-11-02T00:00:00.000
746688
Transaction Id: 746688 • Contract Number: QG-215M • Work Order Id: 820242
Transaction Id
746688
Contract Number
QG-215M
Work Order Id
820242
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
746689
Transaction Id: 746689 • Contract Number: QG-215M • Work Order Id: 820242
Transaction Id
746689
Contract Number
QG-215M
Work Order Id
820242
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
38.5
Total Cost
415.8
Transaction Date
2015-12-22T00:00:00.000
746690
Transaction Id: 746690 • Contract Number: QG-215M • Work Order Id: 820242
Transaction Id
746690
Contract Number
QG-215M
Work Order Id
820242
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-03-21T00:00:00.000
746691
Transaction Id: 746691 • Contract Number: QG-215M • Work Order Id: 665288
Transaction Id
746691
Contract Number
QG-215M
Work Order Id
665288
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
746694
Transaction Id: 746694 • Contract Number: QG-215M • Work Order Id: 662897
Transaction Id
746694
Contract Number
QG-215M
Work Order Id
662897
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-11T00:00:00.000
746696
Transaction Id: 746696 • Contract Number: QG-215M • Work Order Id: 666920
Transaction Id
746696
Contract Number
QG-215M
Work Order Id
666920
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
746697
Transaction Id: 746697 • Contract Number: QG-215M • Work Order Id: 666920
Transaction Id
746697
Contract Number
QG-215M
Work Order Id
666920
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.2
Total Cost
649.4000000000001
Transaction Date
2015-12-30T00:00:00.000
746698
Transaction Id: 746698 • Contract Number: QG-215M • Work Order Id: 666920
Transaction Id
746698
Contract Number
QG-215M
Work Order Id
666920
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
14.5
Total Cost
899.0
Transaction Date
2016-03-14T00:00:00.000
746699
Transaction Id: 746699 • Contract Number: QG-215M • Work Order Id: 658983
Transaction Id
746699
Contract Number
QG-215M
Work Order Id
658983
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
746700
Transaction Id: 746700 • Contract Number: QG-215M • Work Order Id: 658983
Transaction Id
746700
Contract Number
QG-215M
Work Order Id
658983
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
20.0
Total Cost
220.0
Transaction Date
2015-12-30T00:00:00.000
746701
Transaction Id: 746701 • Contract Number: QG-215M • Work Order Id: 661352
Transaction Id
746701
Contract Number
QG-215M
Work Order Id
661352
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
746702
Transaction Id: 746702 • Contract Number: QG-215M • Work Order Id: 661352
Transaction Id
746702
Contract Number
QG-215M
Work Order Id
661352
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-12-30T00:00:00.000
746703
Transaction Id: 746703 • Contract Number: QG-215M • Work Order Id: 661352
Transaction Id
746703
Contract Number
QG-215M
Work Order Id
661352
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-12-30T00:00:00.000
746704
Transaction Id: 746704 • Contract Number: QG-215M • Work Order Id: 660171
Transaction Id
746704
Contract Number
QG-215M
Work Order Id
660171
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
746705
Transaction Id: 746705 • Contract Number: QG-215M • Work Order Id: 660171
Transaction Id
746705
Contract Number
QG-215M
Work Order Id
660171
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
19.6
Total Cost
194.04000000000002
Transaction Date
2015-12-30T00:00:00.000
746706
Transaction Id: 746706 • Contract Number: QG-215M • Work Order Id: 660171
Transaction Id
746706
Contract Number
QG-215M
Work Order Id
660171
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-12-30T00:00:00.000
746711
Transaction Id: 746711 • Contract Number: QG-215M • Work Order Id: 690104
Transaction Id
746711
Contract Number
QG-215M
Work Order Id
690104
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
746712
Transaction Id: 746712 • Contract Number: QG-215M • Work Order Id: 690104
Transaction Id
746712
Contract Number
QG-215M
Work Order Id
690104
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
23.3
Total Cost
256.3
Transaction Date
2016-01-13T00:00:00.000
746713
Transaction Id: 746713 • Contract Number: QG-215M • Work Order Id: 694105
Transaction Id
746713
Contract Number
QG-215M
Work Order Id
694105
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
746714
Transaction Id: 746714 • Contract Number: QG-215M • Work Order Id: 694105
Transaction Id
746714
Contract Number
QG-215M
Work Order Id
694105
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
24.0
Total Cost
264.0
Transaction Date
2016-01-13T00:00:00.000
746715
Transaction Id: 746715 • Contract Number: QG-215M • Work Order Id: 690105
Transaction Id
746715
Contract Number
QG-215M
Work Order Id
690105
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-11T00:00:00.000
746716
Transaction Id: 746716 • Contract Number: QG-215M • Work Order Id: 690105
Transaction Id
746716
Contract Number
QG-215M
Work Order Id
690105
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
24.0
Total Cost
264.0
Transaction Date
2015-12-11T00:00:00.000
746717
Transaction Id: 746717 • Contract Number: QG-1215M • Work Order Id: 664445
Transaction Id
746717
Contract Number
QG-1215M
Work Order Id
664445
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
415.0
Units Used
1.0
Total Cost
415.0
Transaction Date
2016-06-13T00:00:00.000
746718
Transaction Id: 746718 • Contract Number: QG-1215M • Work Order Id: 664445
Transaction Id
746718
Contract Number
QG-1215M
Work Order Id
664445
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
13.0
Units Used
46.7
Total Cost
607.1
Transaction Date
2016-06-10T00:00:00.000
746722
Transaction Id: 746722 • Contract Number: QG-215M • Work Order Id: 692910
Transaction Id
746722
Contract Number
QG-215M
Work Order Id
692910
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-04T00:00:00.000
746723
Transaction Id: 746723 • Contract Number: QG-215M • Work Order Id: 692910
Transaction Id
746723
Contract Number
QG-215M
Work Order Id
692910
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
21.1
Total Cost
232.10000000000002
Transaction Date
2015-12-04T00:00:00.000
746724
Transaction Id: 746724 • Contract Number: QG-215M • Work Order Id: 692507
Transaction Id
746724
Contract Number
QG-215M
Work Order Id
692507
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
746725
Transaction Id: 746725 • Contract Number: QG-215M • Work Order Id: 692507
Transaction Id
746725
Contract Number
QG-215M
Work Order Id
692507
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
24.0
Total Cost
264.0
Transaction Date
2016-01-15T00:00:00.000
746730
Transaction Id: 746730 • Contract Number: QG-215M • Work Order Id: 692914
Transaction Id
746730
Contract Number
QG-215M
Work Order Id
692914
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-11T00:00:00.000
746731
Transaction Id: 746731 • Contract Number: QG-215M • Work Order Id: 692914
Transaction Id
746731
Contract Number
QG-215M
Work Order Id
692914
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
22.0
Total Cost
242.0
Transaction Date
2015-12-11T00:00:00.000
746732
Transaction Id: 746732 • Contract Number: QG-215M • Work Order Id: 692111
Transaction Id
746732
Contract Number
QG-215M
Work Order Id
692111
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-11T00:00:00.000
746733
Transaction Id: 746733 • Contract Number: QG-215M • Work Order Id: 692111
Transaction Id
746733
Contract Number
QG-215M
Work Order Id
692111
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
22.0
Total Cost
242.0
Transaction Date
2015-12-11T00:00:00.000
746734
Transaction Id: 746734 • Contract Number: QG-215M • Work Order Id: 696905
Transaction Id
746734
Contract Number
QG-215M
Work Order Id
696905
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-11T00:00:00.000
746735
Transaction Id: 746735 • Contract Number: QG-215M • Work Order Id: 696905
Transaction Id
746735
Contract Number
QG-215M
Work Order Id
696905
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
24.0
Total Cost
264.0
Transaction Date
2015-12-11T00:00:00.000
746738
Transaction Id: 746738 • Contract Number: QG-215M • Work Order Id: 818263
Transaction Id
746738
Contract Number
QG-215M
Work Order Id
818263
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
746739
Transaction Id: 746739 • Contract Number: QG-215M • Work Order Id: 695704
Transaction Id
746739
Contract Number
QG-215M
Work Order Id
695704
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-11T00:00:00.000
746740
Transaction Id: 746740 • Contract Number: QG-215M • Work Order Id: 695704
Transaction Id
746740
Contract Number
QG-215M
Work Order Id
695704
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
24.0
Total Cost
264.0
Transaction Date
2015-12-11T00:00:00.000
NYC Data AI • Public-data exploration interface