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
746863
Transaction Id: 746863 • Contract Number: QG-215M • Work Order Id: 702917
Transaction Id
746863
Contract Number
QG-215M
Work Order Id
702917
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
746864
Transaction Id: 746864 • Contract Number: QG-215M • Work Order Id: 702917
Transaction Id
746864
Contract Number
QG-215M
Work Order Id
702917
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.8
Total Cost
309.6
Transaction Date
2015-12-14T00:00:00.000
746871
Transaction Id: 746871 • Contract Number: QG-215M • Work Order Id: 703315
Transaction Id
746871
Contract Number
QG-215M
Work Order Id
703315
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
746872
Transaction Id: 746872 • Contract Number: QG-215M • Work Order Id: 703315
Transaction Id
746872
Contract Number
QG-215M
Work Order Id
703315
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
746873
Transaction Id: 746873 • Contract Number: QG-215M • Work Order Id: 698130
Transaction Id
746873
Contract Number
QG-215M
Work Order Id
698130
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
746874
Transaction Id: 746874 • Contract Number: QG-215M • Work Order Id: 698130
Transaction Id
746874
Contract Number
QG-215M
Work Order Id
698130
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
746877
Transaction Id: 746877 • Contract Number: QG-215M • Work Order Id: 703319
Transaction Id
746877
Contract Number
QG-215M
Work Order Id
703319
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
746878
Transaction Id: 746878 • Contract Number: QG-215M • Work Order Id: 703319
Transaction Id
746878
Contract Number
QG-215M
Work Order Id
703319
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
746879
Transaction Id: 746879 • Contract Number: QG-215M • Work Order Id: 697332
Transaction Id
746879
Contract Number
QG-215M
Work Order Id
697332
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
746880
Transaction Id: 746880 • Contract Number: QG-215M • Work Order Id: 697332
Transaction Id
746880
Contract Number
QG-215M
Work Order Id
697332
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
746881
Transaction Id: 746881 • Contract Number: QG-215M • Work Order Id: 698934
Transaction Id
746881
Contract Number
QG-215M
Work Order Id
698934
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
746882
Transaction Id: 746882 • Contract Number: QG-215M • Work Order Id: 698934
Transaction Id
746882
Contract Number
QG-215M
Work Order Id
698934
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
746883
Transaction Id: 746883 • Contract Number: QG-215M • Work Order Id: 698937
Transaction Id
746883
Contract Number
QG-215M
Work Order Id
698937
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
746884
Transaction Id: 746884 • Contract Number: QG-215M • Work Order Id: 698937
Transaction Id
746884
Contract Number
QG-215M
Work Order Id
698937
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
746885
Transaction Id: 746885 • Contract Number: QG-215M • Work Order Id: 703726
Transaction Id
746885
Contract Number
QG-215M
Work Order Id
703726
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
746886
Transaction Id: 746886 • Contract Number: QG-215M • Work Order Id: 703726
Transaction Id
746886
Contract Number
QG-215M
Work Order Id
703726
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
746891
Transaction Id: 746891 • Contract Number: QG-215M • Work Order Id: 700534
Transaction Id
746891
Contract Number
QG-215M
Work Order Id
700534
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
746892
Transaction Id: 746892 • Contract Number: QG-215M • Work Order Id: 700534
Transaction Id
746892
Contract Number
QG-215M
Work Order Id
700534
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
746893
Transaction Id: 746893 • Contract Number: QG-215M • Work Order Id: 701732
Transaction Id
746893
Contract Number
QG-215M
Work Order Id
701732
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
746894
Transaction Id: 746894 • Contract Number: QG-215M • Work Order Id: 701732
Transaction Id
746894
Contract Number
QG-215M
Work Order Id
701732
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
746895
Transaction Id: 746895 • Contract Number: QG-215M • Work Order Id: 704128
Transaction Id
746895
Contract Number
QG-215M
Work Order Id
704128
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
746896
Transaction Id: 746896 • Contract Number: QG-215M • Work Order Id: 704128
Transaction Id
746896
Contract Number
QG-215M
Work Order Id
704128
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-31T00:00:00.000
746905
Transaction Id: 746905 • Contract Number: QG-215M • Work Order Id: 829044
Transaction Id
746905
Contract Number
QG-215M
Work Order Id
829044
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
746906
Transaction Id: 746906 • Contract Number: QG-215M • Work Order Id: 829044
Transaction Id
746906
Contract Number
QG-215M
Work Order Id
829044
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
2016-01-13T00:00:00.000
746907
Transaction Id: 746907 • Contract Number: QG-215M • Work Order Id: 829045
Transaction Id
746907
Contract Number
QG-215M
Work Order Id
829045
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
746908
Transaction Id: 746908 • Contract Number: QG-215M • Work Order Id: 829045
Transaction Id
746908
Contract Number
QG-215M
Work Order Id
829045
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
2016-01-13T00:00:00.000
746915
Transaction Id: 746915 • Contract Number: QG-215M • Work Order Id: 698540
Transaction Id
746915
Contract Number
QG-215M
Work Order Id
698540
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
746916
Transaction Id: 746916 • Contract Number: QG-215M • Work Order Id: 698540
Transaction Id
746916
Contract Number
QG-215M
Work Order Id
698540
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
746917
Transaction Id: 746917 • Contract Number: QG-215M • Work Order Id: 698542
Transaction Id
746917
Contract Number
QG-215M
Work Order Id
698542
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
746918
Transaction Id: 746918 • Contract Number: QG-215M • Work Order Id: 698542
Transaction Id
746918
Contract Number
QG-215M
Work Order Id
698542
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
33.3
Total Cost
399.59999999999997
Transaction Date
2015-12-22T00:00:00.000
746919
Transaction Id: 746919 • Contract Number: QG-215M • Work Order Id: 698542
Transaction Id
746919
Contract Number
QG-215M
Work Order Id
698542
Line Item Id
288.0
Item Number
21
Line Item Description
REMOVE AND SALVAGE BLOCK AND/OR STONE PAVEMENT
Unit Of Measure
SF
Unit Price
10.0
Units Used
2.0
Total Cost
20.0
Transaction Date
2015-12-22T00:00:00.000
746921
Transaction Id: 746921 • Contract Number: QG-215M • Work Order Id: 697338
Transaction Id
746921
Contract Number
QG-215M
Work Order Id
697338
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
746922
Transaction Id: 746922 • Contract Number: QG-215M • Work Order Id: 697338
Transaction Id
746922
Contract Number
QG-215M
Work Order Id
697338
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-22T00:00:00.000
746923
Transaction Id: 746923 • Contract Number: QG-215M • Work Order Id: 699345
Transaction Id
746923
Contract Number
QG-215M
Work Order Id
699345
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
746924
Transaction Id: 746924 • Contract Number: QG-215M • Work Order Id: 699345
Transaction Id
746924
Contract Number
QG-215M
Work Order Id
699345
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
746925
Transaction Id: 746925 • Contract Number: QG-215M • Work Order Id: 703326
Transaction Id
746925
Contract Number
QG-215M
Work Order Id
703326
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
746926
Transaction Id: 746926 • Contract Number: QG-215M • Work Order Id: 703326
Transaction Id
746926
Contract Number
QG-215M
Work Order Id
703326
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
746927
Transaction Id: 746927 • Contract Number: QG-215M • Work Order Id: 700141
Transaction Id
746927
Contract Number
QG-215M
Work Order Id
700141
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
746928
Transaction Id: 746928 • Contract Number: QG-215M • Work Order Id: 700141
Transaction Id
746928
Contract Number
QG-215M
Work Order Id
700141
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.8
Total Cost
324.71999999999997
Transaction Date
2015-11-30T00:00:00.000
746929
Transaction Id: 746929 • Contract Number: QG-215M • Work Order Id: 698546
Transaction Id
746929
Contract Number
QG-215M
Work Order Id
698546
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
746930
Transaction Id: 746930 • Contract Number: QG-215M • Work Order Id: 698546
Transaction Id
746930
Contract Number
QG-215M
Work Order Id
698546
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
746931
Transaction Id: 746931 • Contract Number: QG-215M • Work Order Id: 697340
Transaction Id
746931
Contract Number
QG-215M
Work Order Id
697340
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
746932
Transaction Id: 746932 • Contract Number: QG-215M • Work Order Id: 697340
Transaction Id
746932
Contract Number
QG-215M
Work Order Id
697340
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
746933
Transaction Id: 746933 • Contract Number: QG-215M • Work Order Id: 703328
Transaction Id
746933
Contract Number
QG-215M
Work Order Id
703328
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
746934
Transaction Id: 746934 • Contract Number: QG-215M • Work Order Id: 703328
Transaction Id
746934
Contract Number
QG-215M
Work Order Id
703328
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
746935
Transaction Id: 746935 • Contract Number: QG-215M • Work Order Id: 699350
Transaction Id
746935
Contract Number
QG-215M
Work Order Id
699350
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
746936
Transaction Id: 746936 • Contract Number: QG-215M • Work Order Id: 699350
Transaction Id
746936
Contract Number
QG-215M
Work Order Id
699350
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
746939
Transaction Id: 746939 • Contract Number: QG-215M • Work Order Id: 699352
Transaction Id
746939
Contract Number
QG-215M
Work Order Id
699352
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
746940
Transaction Id: 746940 • Contract Number: QG-215M • Work Order Id: 699352
Transaction Id
746940
Contract Number
QG-215M
Work Order Id
699352
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-14T00:00:00.000
746943
Transaction Id: 746943 • Contract Number: QG-215M • Work Order Id: 700928
Transaction Id
746943
Contract Number
QG-215M
Work Order Id
700928
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