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
745047
Transaction Id: 745047 • Contract Number: QG-215M • Work Order Id: 654079
Transaction Id
745047
Contract Number
QG-215M
Work Order Id
654079
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-27T00:00:00.000
745048
Transaction Id: 745048 • Contract Number: QG-215M • Work Order Id: 654079
Transaction Id
745048
Contract Number
QG-215M
Work Order Id
654079
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-27T00:00:00.000
745049
Transaction Id: 745049 • Contract Number: QG-215M • Work Order Id: 654081
Transaction Id
745049
Contract Number
QG-215M
Work Order Id
654081
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-27T00:00:00.000
745050
Transaction Id: 745050 • Contract Number: QG-215M • Work Order Id: 654081
Transaction Id
745050
Contract Number
QG-215M
Work Order Id
654081
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-27T00:00:00.000
745051
Transaction Id: 745051 • Contract Number: QG-215M • Work Order Id: 655295
Transaction Id
745051
Contract Number
QG-215M
Work Order Id
655295
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
745052
Transaction Id: 745052 • Contract Number: QG-215M • Work Order Id: 655295
Transaction Id
745052
Contract Number
QG-215M
Work Order Id
655295
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-16T00:00:00.000
745053
Transaction Id: 745053 • Contract Number: QG-215M • Work Order Id: 825437
Transaction Id
745053
Contract Number
QG-215M
Work Order Id
825437
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
745054
Transaction Id: 745054 • Contract Number: QG-215M • Work Order Id: 825437
Transaction Id
745054
Contract Number
QG-215M
Work Order Id
825437
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-16T00:00:00.000
745055
Transaction Id: 745055 • Contract Number: QG-215M • Work Order Id: 664526
Transaction Id
745055
Contract Number
QG-215M
Work Order Id
664526
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-27T00:00:00.000
745056
Transaction Id: 745056 • Contract Number: QG-215M • Work Order Id: 664526
Transaction Id
745056
Contract Number
QG-215M
Work Order Id
664526
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.0
Total Cost
231.0
Transaction Date
2015-11-27T00:00:00.000
745057
Transaction Id: 745057 • Contract Number: QG-215M • Work Order Id: 661063
Transaction Id
745057
Contract Number
QG-215M
Work Order Id
661063
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-27T00:00:00.000
745058
Transaction Id: 745058 • Contract Number: QG-215M • Work Order Id: 661063
Transaction Id
745058
Contract Number
QG-215M
Work Order Id
661063
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.0
Total Cost
231.0
Transaction Date
2015-11-27T00:00:00.000
745059
Transaction Id: 745059 • Contract Number: QG-215M • Work Order Id: 664524
Transaction Id
745059
Contract Number
QG-215M
Work Order Id
664524
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-27T00:00:00.000
745060
Transaction Id: 745060 • Contract Number: QG-215M • Work Order Id: 664524
Transaction Id
745060
Contract Number
QG-215M
Work Order Id
664524
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.0
Total Cost
231.0
Transaction Date
2015-11-27T00:00:00.000
745061
Transaction Id: 745061 • Contract Number: QG-215M • Work Order Id: 664106
Transaction Id
745061
Contract Number
QG-215M
Work Order Id
664106
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-27T00:00:00.000
745062
Transaction Id: 745062 • Contract Number: QG-215M • Work Order Id: 664106
Transaction Id
745062
Contract Number
QG-215M
Work Order Id
664106
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.0
Total Cost
231.0
Transaction Date
2015-11-27T00:00:00.000
745063
Transaction Id: 745063 • Contract Number: QG-215M • Work Order Id: 670125
Transaction Id
745063
Contract Number
QG-215M
Work Order Id
670125
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
745064
Transaction Id: 745064 • Contract Number: QG-215M • Work Order Id: 670125
Transaction Id
745064
Contract Number
QG-215M
Work Order Id
670125
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
18.0
Total Cost
198.0
Transaction Date
2015-12-19T00:00:00.000
745072
Transaction Id: 745072 • Contract Number: QG-215M • Work Order Id: 656826
Transaction Id
745072
Contract Number
QG-215M
Work Order Id
656826
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
745073
Transaction Id: 745073 • Contract Number: QG-215M • Work Order Id: 656826
Transaction Id
745073
Contract Number
QG-215M
Work Order Id
656826
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-09-25T00:00:00.000
745074
Transaction Id: 745074 • Contract Number: QG-215M • Work Order Id: 668899
Transaction Id
745074
Contract Number
QG-215M
Work Order Id
668899
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
745075
Transaction Id: 745075 • Contract Number: QG-215M • Work Order Id: 668899
Transaction Id
745075
Contract Number
QG-215M
Work Order Id
668899
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-25T00:00:00.000
745076
Transaction Id: 745076 • Contract Number: QG-215M • Work Order Id: 668899
Transaction Id
745076
Contract Number
QG-215M
Work Order Id
668899
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-25T00:00:00.000
745077
Transaction Id: 745077 • Contract Number: QG-215M • Work Order Id: 656512
Transaction Id
745077
Contract Number
QG-215M
Work Order Id
656512
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
745078
Transaction Id: 745078 • Contract Number: QG-215M • Work Order Id: 656512
Transaction Id
745078
Contract Number
QG-215M
Work Order Id
656512
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-09-24T00:00:00.000
745079
Transaction Id: 745079 • Contract Number: QG-215M • Work Order Id: 657222
Transaction Id
745079
Contract Number
QG-215M
Work Order Id
657222
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
745080
Transaction Id: 745080 • Contract Number: QG-215M • Work Order Id: 657222
Transaction Id
745080
Contract Number
QG-215M
Work Order Id
657222
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-09-24T00:00:00.000
745081
Transaction Id: 745081 • Contract Number: QG-215M • Work Order Id: 657223
Transaction Id
745081
Contract Number
QG-215M
Work Order Id
657223
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
745082
Transaction Id: 745082 • Contract Number: QG-215M • Work Order Id: 657223
Transaction Id
745082
Contract Number
QG-215M
Work Order Id
657223
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-09-24T00:00:00.000
745083
Transaction Id: 745083 • Contract Number: QG-215M • Work Order Id: 659283
Transaction Id
745083
Contract Number
QG-215M
Work Order Id
659283
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
745084
Transaction Id: 745084 • Contract Number: QG-215M • Work Order Id: 659283
Transaction Id
745084
Contract Number
QG-215M
Work Order Id
659283
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-09-24T00:00:00.000
745085
Transaction Id: 745085 • Contract Number: QG-215M • Work Order Id: 662455
Transaction Id
745085
Contract Number
QG-215M
Work Order Id
662455
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
745088
Transaction Id: 745088 • Contract Number: QG-215M • Work Order Id: 660118
Transaction Id
745088
Contract Number
QG-215M
Work Order Id
660118
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
745089
Transaction Id: 745089 • Contract Number: QG-215M • Work Order Id: 660118
Transaction Id
745089
Contract Number
QG-215M
Work Order Id
660118
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-31T00:00:00.000
745090
Transaction Id: 745090 • Contract Number: QG-215M • Work Order Id: 660118
Transaction Id
745090
Contract Number
QG-215M
Work Order Id
660118
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-30T00:00:00.000
745091
Transaction Id: 745091 • Contract Number: QG-215M • Work Order Id: 658810
Transaction Id
745091
Contract Number
QG-215M
Work Order Id
658810
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
745092
Transaction Id: 745092 • Contract Number: QG-215M • Work Order Id: 658810
Transaction Id
745092
Contract Number
QG-215M
Work Order Id
658810
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-09-24T00:00:00.000
745093
Transaction Id: 745093 • Contract Number: QG-215M • Work Order Id: 662459
Transaction Id
745093
Contract Number
QG-215M
Work Order Id
662459
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
745094
Transaction Id: 745094 • Contract Number: QG-215M • Work Order Id: 662459
Transaction Id
745094
Contract Number
QG-215M
Work Order Id
662459
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-09-24T00:00:00.000
745095
Transaction Id: 745095 • Contract Number: QG-215M • Work Order Id: 661312
Transaction Id
745095
Contract Number
QG-215M
Work Order Id
661312
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
745096
Transaction Id: 745096 • Contract Number: QG-215M • Work Order Id: 661312
Transaction Id
745096
Contract Number
QG-215M
Work Order Id
661312
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-09-24T00:00:00.000
745097
Transaction Id: 745097 • Contract Number: QG-215M • Work Order Id: 662005
Transaction Id
745097
Contract Number
QG-215M
Work Order Id
662005
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
745098
Transaction Id: 745098 • Contract Number: QG-215M • Work Order Id: 662005
Transaction Id
745098
Contract Number
QG-215M
Work Order Id
662005
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-09-24T00:00:00.000
745099
Transaction Id: 745099 • Contract Number: QG-215M • Work Order Id: 659213
Transaction Id
745099
Contract Number
QG-215M
Work Order Id
659213
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
745100
Transaction Id: 745100 • Contract Number: QG-215M • Work Order Id: 659213
Transaction Id
745100
Contract Number
QG-215M
Work Order Id
659213
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-09-24T00:00:00.000
745101
Transaction Id: 745101 • Contract Number: QG-215M • Work Order Id: 661210
Transaction Id
745101
Contract Number
QG-215M
Work Order Id
661210
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
745102
Transaction Id: 745102 • Contract Number: QG-215M • Work Order Id: 661210
Transaction Id
745102
Contract Number
QG-215M
Work Order Id
661210
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-09-24T00:00:00.000
745103
Transaction Id: 745103 • Contract Number: QG-215M • Work Order Id: 662008
Transaction Id
745103
Contract Number
QG-215M
Work Order Id
662008
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
745104
Transaction Id: 745104 • Contract Number: QG-215M • Work Order Id: 662008
Transaction Id
745104
Contract Number
QG-215M
Work Order Id
662008
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-09-24T00:00:00.000
745105
Transaction Id: 745105 • Contract Number: QG-215M • Work Order Id: 668492
Transaction Id
745105
Contract Number
QG-215M
Work Order Id
668492
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