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
747095
Transaction Id: 747095 • Contract Number: QG-215M • Work Order Id: 740520
Transaction Id
747095
Contract Number
QG-215M
Work Order Id
740520
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
13.5
Total Cost
837.0
Transaction Date
2016-03-14T00:00:00.000
747096
Transaction Id: 747096 • Contract Number: QG-215M • Work Order Id: 735727
Transaction Id
747096
Contract Number
QG-215M
Work Order Id
735727
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-07T00:00:00.000
747097
Transaction Id: 747097 • Contract Number: QG-215M • Work Order Id: 735727
Transaction Id
747097
Contract Number
QG-215M
Work Order Id
735727
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
44.8
Total Cost
537.5999999999999
Transaction Date
2015-12-07T00:00:00.000
747098
Transaction Id: 747098 • Contract Number: QG-215M • Work Order Id: 735727
Transaction Id
747098
Contract Number
QG-215M
Work Order Id
735727
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
16.7
Total Cost
1035.3999999999999
Transaction Date
2016-03-14T00:00:00.000
747099
Transaction Id: 747099 • Contract Number: QG-215M • Work Order Id: 738529
Transaction Id
747099
Contract Number
QG-215M
Work Order Id
738529
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
747100
Transaction Id: 747100 • Contract Number: QG-215M • Work Order Id: 738529
Transaction Id
747100
Contract Number
QG-215M
Work Order Id
738529
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
25.0
Total Cost
300.0
Transaction Date
2015-12-10T00:00:00.000
747101
Transaction Id: 747101 • Contract Number: QG-215M • Work Order Id: 738529
Transaction Id
747101
Contract Number
QG-215M
Work Order Id
738529
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
25.0
Total Cost
425.0
Transaction Date
2015-12-10T00:00:00.000
747102
Transaction Id: 747102 • Contract Number: QG-215M • Work Order Id: 738529
Transaction Id
747102
Contract Number
QG-215M
Work Order Id
738529
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.8
Total Cost
1103.6000000000001
Transaction Date
2016-03-14T00:00:00.000
747103
Transaction Id: 747103 • Contract Number: QG-215M • Work Order Id: 698139
Transaction Id
747103
Contract Number
QG-215M
Work Order Id
698139
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-14T00:00:00.000
747104
Transaction Id: 747104 • Contract Number: QG-215M • Work Order Id: 698139
Transaction Id
747104
Contract Number
QG-215M
Work Order Id
698139
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
37.1
Total Cost
400.68000000000006
Transaction Date
2015-12-14T00:00:00.000
747105
Transaction Id: 747105 • Contract Number: QG-215M • Work Order Id: 741325
Transaction Id
747105
Contract Number
QG-215M
Work Order Id
741325
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-15T00:00:00.000
747106
Transaction Id: 747106 • Contract Number: QG-215M • Work Order Id: 741325
Transaction Id
747106
Contract Number
QG-215M
Work Order Id
741325
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
25.0
Total Cost
300.0
Transaction Date
2015-12-10T00:00:00.000
747107
Transaction Id: 747107 • Contract Number: QG-215M • Work Order Id: 741325
Transaction Id
747107
Contract Number
QG-215M
Work Order Id
741325
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
25.0
Total Cost
425.0
Transaction Date
2015-12-10T00:00:00.000
747108
Transaction Id: 747108 • Contract Number: QG-215M • Work Order Id: 740535
Transaction Id
747108
Contract Number
QG-215M
Work Order Id
740535
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
747109
Transaction Id: 747109 • Contract Number: QG-215M • Work Order Id: 740535
Transaction Id
747109
Contract Number
QG-215M
Work Order Id
740535
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.5
Total Cost
378.0
Transaction Date
2015-12-10T00:00:00.000
747111
Transaction Id: 747111 • Contract Number: QG-215M • Work Order Id: 740535
Transaction Id
747111
Contract Number
QG-215M
Work Order Id
740535
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
16.8
Total Cost
285.6
Transaction Date
2015-12-10T00:00:00.000
747113
Transaction Id: 747113 • Contract Number: QG-215M • Work Order Id: 752542
Transaction Id
747113
Contract Number
QG-215M
Work Order Id
752542
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-11-21T00:00:00.000
747114
Transaction Id: 747114 • Contract Number: QG-215M • Work Order Id: 752542
Transaction Id
747114
Contract Number
QG-215M
Work Order Id
752542
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-11-06T00:00:00.000
747115
Transaction Id: 747115 • Contract Number: QG-215M • Work Order Id: 754556
Transaction Id
747115
Contract Number
QG-215M
Work Order Id
754556
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-15T00:00:00.000
747116
Transaction Id: 747116 • Contract Number: QG-215M • Work Order Id: 754556
Transaction Id
747116
Contract Number
QG-215M
Work Order Id
754556
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
22.9
Total Cost
274.79999999999995
Transaction Date
2015-12-15T00:00:00.000
747117
Transaction Id: 747117 • Contract Number: QG-215M • Work Order Id: 754556
Transaction Id
747117
Contract Number
QG-215M
Work Order Id
754556
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
23.7
Total Cost
402.9
Transaction Date
2015-12-15T00:00:00.000
747118
Transaction Id: 747118 • Contract Number: QG-215M • Work Order Id: 745740
Transaction Id
747118
Contract Number
QG-215M
Work Order Id
745740
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-11-21T00:00:00.000
747119
Transaction Id: 747119 • Contract Number: QG-215M • Work Order Id: 745740
Transaction Id
747119
Contract Number
QG-215M
Work Order Id
745740
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-11-06T00:00:00.000
747120
Transaction Id: 747120 • Contract Number: QG-215M • Work Order Id: 664534
Transaction Id
747120
Contract Number
QG-215M
Work Order Id
664534
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-08T00:00:00.000
747121
Transaction Id: 747121 • Contract Number: QG-215M • Work Order Id: 664534
Transaction Id
747121
Contract Number
QG-215M
Work Order Id
664534
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
50.0
Total Cost
600.0
Transaction Date
2015-11-06T00:00:00.000
747122
Transaction Id: 747122 • Contract Number: QG-215M • Work Order Id: 664553
Transaction Id
747122
Contract Number
QG-215M
Work Order Id
664553
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-08T00:00:00.000
747123
Transaction Id: 747123 • Contract Number: QG-215M • Work Order Id: 664553
Transaction Id
747123
Contract Number
QG-215M
Work Order Id
664553
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
50.0
Total Cost
600.0
Transaction Date
2015-11-06T00:00:00.000
747124
Transaction Id: 747124 • Contract Number: QG-215M • Work Order Id: 661085
Transaction Id
747124
Contract Number
QG-215M
Work Order Id
661085
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-08T00:00:00.000
747125
Transaction Id: 747125 • Contract Number: QG-215M • Work Order Id: 661085
Transaction Id
747125
Contract Number
QG-215M
Work Order Id
661085
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
50.0
Total Cost
600.0
Transaction Date
2015-11-06T00:00:00.000
747126
Transaction Id: 747126 • Contract Number: QG-215M • Work Order Id: 664556
Transaction Id
747126
Contract Number
QG-215M
Work Order Id
664556
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-08T00:00:00.000
747127
Transaction Id: 747127 • Contract Number: QG-215M • Work Order Id: 664556
Transaction Id
747127
Contract Number
QG-215M
Work Order Id
664556
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
50.0
Total Cost
600.0
Transaction Date
2015-11-06T00:00:00.000
747132
Transaction Id: 747132 • Contract Number: QG-215M • Work Order Id: 690935
Transaction Id
747132
Contract Number
QG-215M
Work Order Id
690935
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
747133
Transaction Id: 747133 • Contract Number: QG-215M • Work Order Id: 690935
Transaction Id
747133
Contract Number
QG-215M
Work Order Id
690935
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
27.0
Total Cost
267.3
Transaction Date
2015-12-28T00:00:00.000
747136
Transaction Id: 747136 • Contract Number: QG-215M • Work Order Id: 691335
Transaction Id
747136
Contract Number
QG-215M
Work Order Id
691335
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-14T00:00:00.000
747137
Transaction Id: 747137 • Contract Number: QG-215M • Work Order Id: 691335
Transaction Id
747137
Contract Number
QG-215M
Work Order Id
691335
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.1
Total Cost
238.59000000000003
Transaction Date
2016-01-14T00:00:00.000
747142
Transaction Id: 747142 • Contract Number: QG-215M • Work Order Id: 655277
Transaction Id
747142
Contract Number
QG-215M
Work Order Id
655277
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-11-23T00:00:00.000
747143
Transaction Id: 747143 • Contract Number: QG-215M • Work Order Id: 655277
Transaction Id
747143
Contract Number
QG-215M
Work Order Id
655277
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-11-04T00:00:00.000
747144
Transaction Id: 747144 • Contract Number: QG-215M • Work Order Id: 655277
Transaction Id
747144
Contract Number
QG-215M
Work Order Id
655277
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
747145
Transaction Id: 747145 • Contract Number: QG-215M • Work Order Id: 693737
Transaction Id
747145
Contract Number
QG-215M
Work Order Id
693737
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
747146
Transaction Id: 747146 • Contract Number: QG-215M • Work Order Id: 693737
Transaction Id
747146
Contract Number
QG-215M
Work Order Id
693737
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.7
Total Cost
254.43
Transaction Date
2015-09-22T00:00:00.000
747147
Transaction Id: 747147 • Contract Number: QG-215M • Work Order Id: 692540
Transaction Id
747147
Contract Number
QG-215M
Work Order Id
692540
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-11-24T00:00:00.000
747148
Transaction Id: 747148 • Contract Number: QG-215M • Work Order Id: 692540
Transaction Id
747148
Contract Number
QG-215M
Work Order Id
692540
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-11-24T00:00:00.000
747152
Transaction Id: 747152 • Contract Number: QG-215M • Work Order Id: 655608
Transaction Id
747152
Contract Number
QG-215M
Work Order Id
655608
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
747153
Transaction Id: 747153 • Contract Number: QG-215M • Work Order Id: 655608
Transaction Id
747153
Contract Number
QG-215M
Work Order Id
655608
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-28T00:00:00.000
747154
Transaction Id: 747154 • Contract Number: QG-215M • Work Order Id: 655608
Transaction Id
747154
Contract Number
QG-215M
Work Order Id
655608
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
747155
Transaction Id: 747155 • Contract Number: QG-215M • Work Order Id: 817035
Transaction Id
747155
Contract Number
QG-215M
Work Order Id
817035
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
747156
Transaction Id: 747156 • Contract Number: QG-215M • Work Order Id: 817035
Transaction Id
747156
Contract Number
QG-215M
Work Order Id
817035
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.9
Total Cost
286.11
Transaction Date
2015-12-28T00:00:00.000
747157
Transaction Id: 747157 • Contract Number: QG-215M • Work Order Id: 817035
Transaction Id
747157
Contract Number
QG-215M
Work Order Id
817035
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-11-02T00:00:00.000
747158
Transaction Id: 747158 • Contract Number: QG-215M • Work Order Id: 669315
Transaction Id
747158
Contract Number
QG-215M
Work Order Id
669315
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
747159
Transaction Id: 747159 • Contract Number: QG-215M • Work Order Id: 669315
Transaction Id
747159
Contract Number
QG-215M
Work Order Id
669315
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
22.2
Total Cost
219.78
Transaction Date
2016-01-15T00:00:00.000
NYC Data AI • Public-data exploration interface