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
746944
Transaction Id: 746944 • Contract Number: QG-215M • Work Order Id: 700928
Transaction Id
746944
Contract Number
QG-215M
Work Order Id
700928
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.6
Total Cost
265.68
Transaction Date
2016-01-13T00:00:00.000
746947
Transaction Id: 746947 • Contract Number: QG-215M • Work Order Id: 668941
Transaction Id
746947
Contract Number
QG-215M
Work Order Id
668941
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
746948
Transaction Id: 746948 • Contract Number: QG-215M • Work Order Id: 668941
Transaction Id
746948
Contract Number
QG-215M
Work Order Id
668941
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
746949
Transaction Id: 746949 • Contract Number: QG-215M • Work Order Id: 667324
Transaction Id
746949
Contract Number
QG-215M
Work Order Id
667324
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
746950
Transaction Id: 746950 • Contract Number: QG-215M • Work Order Id: 667324
Transaction Id
746950
Contract Number
QG-215M
Work Order Id
667324
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
746953
Transaction Id: 746953 • Contract Number: QG-215M • Work Order Id: 700930
Transaction Id
746953
Contract Number
QG-215M
Work Order Id
700930
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
746954
Transaction Id: 746954 • Contract Number: QG-215M • Work Order Id: 700930
Transaction Id
746954
Contract Number
QG-215M
Work Order Id
700930
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
27.4
Total Cost
295.92
Transaction Date
2015-12-11T00:00:00.000
746955
Transaction Id: 746955 • Contract Number: QG-215M • Work Order Id: 700930
Transaction Id
746955
Contract Number
QG-215M
Work Order Id
700930
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
29.1
Total Cost
445.23
Transaction Date
2015-12-11T00:00:00.000
746956
Transaction Id: 746956 • Contract Number: QG-215M • Work Order Id: 709712
Transaction Id
746956
Contract Number
QG-215M
Work Order Id
709712
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
746957
Transaction Id: 746957 • Contract Number: QG-215M • Work Order Id: 709712
Transaction Id
746957
Contract Number
QG-215M
Work Order Id
709712
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.0
Total Cost
544.0
Transaction Date
2015-12-10T00:00:00.000
746958
Transaction Id: 746958 • Contract Number: QG-215M • Work Order Id: 702134
Transaction Id
746958
Contract Number
QG-215M
Work Order Id
702134
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
746959
Transaction Id: 746959 • Contract Number: QG-215M • Work Order Id: 702134
Transaction Id
746959
Contract Number
QG-215M
Work Order Id
702134
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-10T00:00:00.000
746960
Transaction Id: 746960 • Contract Number: QG-215M • Work Order Id: 702548
Transaction Id
746960
Contract Number
QG-215M
Work Order Id
702548
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
746961
Transaction Id: 746961 • Contract Number: QG-215M • Work Order Id: 702548
Transaction Id
746961
Contract Number
QG-215M
Work Order Id
702548
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-10T00:00:00.000
746962
Transaction Id: 746962 • Contract Number: QG-215M • Work Order Id: 698547
Transaction Id
746962
Contract Number
QG-215M
Work Order Id
698547
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
746963
Transaction Id: 746963 • Contract Number: QG-215M • Work Order Id: 698547
Transaction Id
746963
Contract Number
QG-215M
Work Order Id
698547
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.1
Total Cost
254.10000000000002
Transaction Date
2015-12-10T00:00:00.000
746970
Transaction Id: 746970 • Contract Number: QG-215M • Work Order Id: 703329
Transaction Id
746970
Contract Number
QG-215M
Work Order Id
703329
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
746971
Transaction Id: 746971 • Contract Number: QG-215M • Work Order Id: 703329
Transaction Id
746971
Contract Number
QG-215M
Work Order Id
703329
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.0
Total Cost
540.0
Transaction Date
2015-12-14T00:00:00.000
746973
Transaction Id: 746973 • Contract Number: QG-215M • Work Order Id: 704136
Transaction Id
746973
Contract Number
QG-215M
Work Order Id
704136
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
746974
Transaction Id: 746974 • Contract Number: QG-215M • Work Order Id: 704136
Transaction Id
746974
Contract Number
QG-215M
Work Order Id
704136
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
36.4
Total Cost
436.79999999999995
Transaction Date
2015-12-14T00:00:00.000
746976
Transaction Id: 746976 • Contract Number: QG-215M • Work Order Id: 700943
Transaction Id
746976
Contract Number
QG-215M
Work Order Id
700943
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
746977
Transaction Id: 746977 • Contract Number: QG-215M • Work Order Id: 700943
Transaction Id
746977
Contract Number
QG-215M
Work Order Id
700943
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-10T00:00:00.000
746978
Transaction Id: 746978 • Contract Number: QG-215M • Work Order Id: 700148
Transaction Id
746978
Contract Number
QG-215M
Work Order Id
700148
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
746979
Transaction Id: 746979 • Contract Number: QG-215M • Work Order Id: 700148
Transaction Id
746979
Contract Number
QG-215M
Work Order Id
700148
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-10T00:00:00.000
746980
Transaction Id: 746980 • Contract Number: QG-215M • Work Order Id: 701737
Transaction Id
746980
Contract Number
QG-215M
Work Order Id
701737
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
746981
Transaction Id: 746981 • Contract Number: QG-215M • Work Order Id: 701737
Transaction Id
746981
Contract Number
QG-215M
Work Order Id
701737
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-10T00:00:00.000
746982
Transaction Id: 746982 • Contract Number: QG-215M • Work Order Id: 708112
Transaction Id
746982
Contract Number
QG-215M
Work Order Id
708112
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
746983
Transaction Id: 746983 • Contract Number: QG-215M • Work Order Id: 708112
Transaction Id
746983
Contract Number
QG-215M
Work Order Id
708112
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-10T00:00:00.000
746984
Transaction Id: 746984 • Contract Number: QG-215M • Work Order Id: 707714
Transaction Id
746984
Contract Number
QG-215M
Work Order Id
707714
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-03T00:00:00.000
746985
Transaction Id: 746985 • Contract Number: QG-215M • Work Order Id: 707714
Transaction Id
746985
Contract Number
QG-215M
Work Order Id
707714
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-03T00:00:00.000
746986
Transaction Id: 746986 • Contract Number: QG-215M • Work Order Id: 706512
Transaction Id
746986
Contract Number
QG-215M
Work Order Id
706512
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-03T00:00:00.000
746987
Transaction Id: 746987 • Contract Number: QG-215M • Work Order Id: 706512
Transaction Id
746987
Contract Number
QG-215M
Work Order Id
706512
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-03T00:00:00.000
746990
Transaction Id: 746990 • Contract Number: QG-215M • Work Order Id: 666529
Transaction Id
746990
Contract Number
QG-215M
Work Order Id
666529
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
746991
Transaction Id: 746991 • Contract Number: QG-215M • Work Order Id: 666529
Transaction Id
746991
Contract Number
QG-215M
Work Order Id
666529
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.0
Total Cost
188.1
Transaction Date
2015-12-14T00:00:00.000
746995
Transaction Id: 746995 • Contract Number: QG-215M • Work Order Id: 711711
Transaction Id
746995
Contract Number
QG-215M
Work Order Id
711711
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-21T00:00:00.000
746996
Transaction Id: 746996 • Contract Number: QG-215M • Work Order Id: 711711
Transaction Id
746996
Contract Number
QG-215M
Work Order Id
711711
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-21T00:00:00.000
747025
Transaction Id: 747025 • Contract Number: QG-215M • Work Order Id: 710124
Transaction Id
747025
Contract Number
QG-215M
Work Order Id
710124
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-30T00:00:00.000
747026
Transaction Id: 747026 • Contract Number: QG-215M • Work Order Id: 710124
Transaction Id
747026
Contract Number
QG-215M
Work Order Id
710124
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-30T00:00:00.000
747027
Transaction Id: 747027 • Contract Number: QG-215M • Work Order Id: 709325
Transaction Id
747027
Contract Number
QG-215M
Work Order Id
709325
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-30T00:00:00.000
747028
Transaction Id: 747028 • Contract Number: QG-215M • Work Order Id: 709325
Transaction Id
747028
Contract Number
QG-215M
Work Order Id
709325
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-30T00:00:00.000
747029
Transaction Id: 747029 • Contract Number: QG-215M • Work Order Id: 711324
Transaction Id
747029
Contract Number
QG-215M
Work Order Id
711324
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-30T00:00:00.000
747030
Transaction Id: 747030 • Contract Number: QG-215M • Work Order Id: 711324
Transaction Id
747030
Contract Number
QG-215M
Work Order Id
711324
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-30T00:00:00.000
747031
Transaction Id: 747031 • Contract Number: QG-215M • Work Order Id: 708141
Transaction Id
747031
Contract Number
QG-215M
Work Order Id
708141
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
747032
Transaction Id: 747032 • Contract Number: QG-215M • Work Order Id: 708141
Transaction Id
747032
Contract Number
QG-215M
Work Order Id
708141
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
16.0
Total Cost
176.0
Transaction Date
2015-12-14T00:00:00.000
747034
Transaction Id: 747034 • Contract Number: QG-215M • Work Order Id: 820246
Transaction Id
747034
Contract Number
QG-215M
Work Order Id
820246
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-14T00:00:00.000
747035
Transaction Id: 747035 • Contract Number: QG-215M • Work Order Id: 708928
Transaction Id
747035
Contract Number
QG-215M
Work Order Id
708928
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
747036
Transaction Id: 747036 • Contract Number: QG-215M • Work Order Id: 708928
Transaction Id
747036
Contract Number
QG-215M
Work Order Id
708928
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
747037
Transaction Id: 747037 • Contract Number: QG-215M • Work Order Id: 708136
Transaction Id
747037
Contract Number
QG-215M
Work Order Id
708136
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
747038
Transaction Id: 747038 • Contract Number: QG-215M • Work Order Id: 708136
Transaction Id
747038
Contract Number
QG-215M
Work Order Id
708136
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
747039
Transaction Id: 747039 • Contract Number: QG-215M • Work Order Id: 706539
Transaction Id
747039
Contract Number
QG-215M
Work Order Id
706539
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