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
745714
Transaction Id: 745714 • Contract Number: QG-215M • Work Order Id: 744150
Transaction Id
745714
Contract Number
QG-215M
Work Order Id
744150
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
745715
Transaction Id: 745715 • Contract Number: QG-215M • Work Order Id: 747345
Transaction Id
745715
Contract Number
QG-215M
Work Order Id
747345
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
745716
Transaction Id: 745716 • Contract Number: QG-215M • Work Order Id: 747345
Transaction Id
745716
Contract Number
QG-215M
Work Order Id
747345
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
745717
Transaction Id: 745717 • Contract Number: QG-215M • Work Order Id: 747746
Transaction Id
745717
Contract Number
QG-215M
Work Order Id
747746
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
745718
Transaction Id: 745718 • Contract Number: QG-215M • Work Order Id: 747746
Transaction Id
745718
Contract Number
QG-215M
Work Order Id
747746
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
745719
Transaction Id: 745719 • Contract Number: QG-215M • Work Order Id: 749343
Transaction Id
745719
Contract Number
QG-215M
Work Order Id
749343
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
745720
Transaction Id: 745720 • Contract Number: QG-215M • Work Order Id: 749343
Transaction Id
745720
Contract Number
QG-215M
Work Order Id
749343
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
745721
Transaction Id: 745721 • Contract Number: QG-215M • Work Order Id: 745346
Transaction Id
745721
Contract Number
QG-215M
Work Order Id
745346
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
745722
Transaction Id: 745722 • Contract Number: QG-215M • Work Order Id: 745346
Transaction Id
745722
Contract Number
QG-215M
Work Order Id
745346
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
745725
Transaction Id: 745725 • Contract Number: QG-215M • Work Order Id: 746547
Transaction Id
745725
Contract Number
QG-215M
Work Order Id
746547
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
745726
Transaction Id: 745726 • Contract Number: QG-215M • Work Order Id: 746547
Transaction Id
745726
Contract Number
QG-215M
Work Order Id
746547
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
745727
Transaction Id: 745727 • Contract Number: QG-215M • Work Order Id: 744153
Transaction Id
745727
Contract Number
QG-215M
Work Order Id
744153
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
745728
Transaction Id: 745728 • Contract Number: QG-215M • Work Order Id: 744153
Transaction Id
745728
Contract Number
QG-215M
Work Order Id
744153
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
745729
Transaction Id: 745729 • Contract Number: QG-215M • Work Order Id: 748145
Transaction Id
745729
Contract Number
QG-215M
Work Order Id
748145
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
745730
Transaction Id: 745730 • Contract Number: QG-215M • Work Order Id: 748145
Transaction Id
745730
Contract Number
QG-215M
Work Order Id
748145
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
745731
Transaction Id: 745731 • Contract Number: QG-215M • Work Order Id: 746549
Transaction Id
745731
Contract Number
QG-215M
Work Order Id
746549
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
745732
Transaction Id: 745732 • Contract Number: QG-215M • Work Order Id: 746549
Transaction Id
745732
Contract Number
QG-215M
Work Order Id
746549
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
745733
Transaction Id: 745733 • Contract Number: QG-215M • Work Order Id: 746550
Transaction Id
745733
Contract Number
QG-215M
Work Order Id
746550
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
745734
Transaction Id: 745734 • Contract Number: QG-215M • Work Order Id: 746550
Transaction Id
745734
Contract Number
QG-215M
Work Order Id
746550
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
745735
Transaction Id: 745735 • Contract Number: QG-215M • Work Order Id: 700533
Transaction Id
745735
Contract Number
QG-215M
Work Order Id
700533
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
745736
Transaction Id: 745736 • Contract Number: QG-215M • Work Order Id: 700533
Transaction Id
745736
Contract Number
QG-215M
Work Order Id
700533
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-15T00:00:00.000
745758
Transaction Id: 745758 • Contract Number: QG-215M • Work Order Id: 790659
Transaction Id
745758
Contract Number
QG-215M
Work Order Id
790659
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
745759
Transaction Id: 745759 • Contract Number: QG-215M • Work Order Id: 790659
Transaction Id
745759
Contract Number
QG-215M
Work Order Id
790659
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-07T00:00:00.000
745761
Transaction Id: 745761 • Contract Number: QG-215M • Work Order Id: 697734
Transaction Id
745761
Contract Number
QG-215M
Work Order Id
697734
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-09T00:00:00.000
745762
Transaction Id: 745762 • Contract Number: QG-215M • Work Order Id: 697734
Transaction Id
745762
Contract Number
QG-215M
Work Order Id
697734
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-09T00:00:00.000
745763
Transaction Id: 745763 • Contract Number: QG-215M • Work Order Id: 699344
Transaction Id
745763
Contract Number
QG-215M
Work Order Id
699344
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
745764
Transaction Id: 745764 • Contract Number: QG-215M • Work Order Id: 699344
Transaction Id
745764
Contract Number
QG-215M
Work Order Id
699344
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
2015-12-07T00:00:00.000
745765
Transaction Id: 745765 • Contract Number: QG-215M • Work Order Id: 704130
Transaction Id
745765
Contract Number
QG-215M
Work Order Id
704130
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
745766
Transaction Id: 745766 • Contract Number: QG-215M • Work Order Id: 704130
Transaction Id
745766
Contract Number
QG-215M
Work Order Id
704130
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-08T00:00:00.000
745767
Transaction Id: 745767 • Contract Number: QG-215M • Work Order Id: 702538
Transaction Id
745767
Contract Number
QG-215M
Work Order Id
702538
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
745768
Transaction Id: 745768 • Contract Number: QG-215M • Work Order Id: 702538
Transaction Id
745768
Contract Number
QG-215M
Work Order Id
702538
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
30.0
Total Cost
297.0
Transaction Date
2015-11-06T00:00:00.000
745769
Transaction Id: 745769 • Contract Number: QG-215M • Work Order Id: 698944
Transaction Id
745769
Contract Number
QG-215M
Work Order Id
698944
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-09T00:00:00.000
745770
Transaction Id: 745770 • Contract Number: QG-215M • Work Order Id: 698944
Transaction Id
745770
Contract Number
QG-215M
Work Order Id
698944
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-09T00:00:00.000
745771
Transaction Id: 745771 • Contract Number: QG-215M • Work Order Id: 697732
Transaction Id
745771
Contract Number
QG-215M
Work Order Id
697732
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
745772
Transaction Id: 745772 • Contract Number: QG-215M • Work Order Id: 697732
Transaction Id
745772
Contract Number
QG-215M
Work Order Id
697732
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-05T00:00:00.000
745775
Transaction Id: 745775 • Contract Number: QG-215M • Work Order Id: 701334
Transaction Id
745775
Contract Number
QG-215M
Work Order Id
701334
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
745776
Transaction Id: 745776 • Contract Number: QG-215M • Work Order Id: 701334
Transaction Id
745776
Contract Number
QG-215M
Work Order Id
701334
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-05T00:00:00.000
745777
Transaction Id: 745777 • Contract Number: QG-215M • Work Order Id: 697321
Transaction Id
745777
Contract Number
QG-215M
Work Order Id
697321
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
745778
Transaction Id: 745778 • Contract Number: QG-215M • Work Order Id: 697321
Transaction Id
745778
Contract Number
QG-215M
Work Order Id
697321
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
45.0
Total Cost
445.5
Transaction Date
2015-12-16T00:00:00.000
745779
Transaction Id: 745779 • Contract Number: QG-215M • Work Order Id: 831442
Transaction Id
745779
Contract Number
QG-215M
Work Order Id
831442
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
745780
Transaction Id: 745780 • Contract Number: QG-215M • Work Order Id: 831442
Transaction Id
745780
Contract Number
QG-215M
Work Order Id
831442
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-24T00:00:00.000
745781
Transaction Id: 745781 • Contract Number: QG-215M • Work Order Id: 831442
Transaction Id
745781
Contract Number
QG-215M
Work Order Id
831442
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-24T00:00:00.000
745782
Transaction Id: 745782 • Contract Number: QG-215M • Work Order Id: 666894
Transaction Id
745782
Contract Number
QG-215M
Work Order Id
666894
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
745783
Transaction Id: 745783 • Contract Number: QG-215M • Work Order Id: 666894
Transaction Id
745783
Contract Number
QG-215M
Work Order Id
666894
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
35.0
Total Cost
346.5
Transaction Date
2015-09-24T00:00:00.000
745784
Transaction Id: 745784 • Contract Number: QG-215M • Work Order Id: 666894
Transaction Id
745784
Contract Number
QG-215M
Work Order Id
666894
Line Item Id
538.0
Item Number
07
Line Item Description
TREE REMOVAL OF OVER 12 TO 18 INCHES DBH
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2015-09-24T00:00:00.000
745785
Transaction Id: 745785 • Contract Number: QG-215M • Work Order Id: 836237
Transaction Id
745785
Contract Number
QG-215M
Work Order Id
836237
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
745786
Transaction Id: 745786 • Contract Number: QG-215M • Work Order Id: 836237
Transaction Id
745786
Contract Number
QG-215M
Work Order Id
836237
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
35.8
Total Cost
354.41999999999996
Transaction Date
2015-09-24T00:00:00.000
745787
Transaction Id: 745787 • Contract Number: QG-215M • Work Order Id: 664871
Transaction Id
745787
Contract Number
QG-215M
Work Order Id
664871
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
745788
Transaction Id: 745788 • Contract Number: QG-215M • Work Order Id: 664871
Transaction Id
745788
Contract Number
QG-215M
Work Order Id
664871
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-22T00:00:00.000
745789
Transaction Id: 745789 • Contract Number: QG-215M • Work Order Id: 664871
Transaction Id
745789
Contract Number
QG-215M
Work Order Id
664871
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-09-30T00:00:00.000