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
748052
Transaction Id: 748052 • Contract Number: CNYG-414M • Work Order Id: 678509
Transaction Id
748052
Contract Number
CNYG-414M
Work Order Id
678509
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-23T00:00:00.000
748053
Transaction Id: 748053 • Contract Number: CNYG-414M • Work Order Id: 678509
Transaction Id
748053
Contract Number
CNYG-414M
Work Order Id
678509
Line Item Id
275.0
Item Number
01K
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
175.0
Units Used
1.0
Total Cost
175.0
Transaction Date
2015-09-24T00:00:00.000
748054
Transaction Id: 748054 • Contract Number: CNYG-414M • Work Order Id: 681726
Transaction Id
748054
Contract Number
CNYG-414M
Work Order Id
681726
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.5
Total Cost
440.0
Transaction Date
2015-09-24T00:00:00.000
748055
Transaction Id: 748055 • Contract Number: CNYG-414M • Work Order Id: 681726
Transaction Id
748055
Contract Number
CNYG-414M
Work Order Id
681726
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-20T00:00:00.000
748056
Transaction Id: 748056 • Contract Number: CNYG-414M • Work Order Id: 676129
Transaction Id
748056
Contract Number
CNYG-414M
Work Order Id
676129
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
30.0
Total Cost
480.0
Transaction Date
2015-09-24T00:00:00.000
748057
Transaction Id: 748057 • Contract Number: CNYG-414M • Work Order Id: 676129
Transaction Id
748057
Contract Number
CNYG-414M
Work Order Id
676129
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-20T00:00:00.000
748059
Transaction Id: 748059 • Contract Number: CNYG-414M • Work Order Id: 680912
Transaction Id
748059
Contract Number
CNYG-414M
Work Order Id
680912
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.5
Total Cost
440.0
Transaction Date
2015-10-23T00:00:00.000
748060
Transaction Id: 748060 • Contract Number: CNYG-414M • Work Order Id: 680912
Transaction Id
748060
Contract Number
CNYG-414M
Work Order Id
680912
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-23T00:00:00.000
748062
Transaction Id: 748062 • Contract Number: CNYG-414M • Work Order Id: 698533
Transaction Id
748062
Contract Number
CNYG-414M
Work Order Id
698533
Line Item Id
355.0
Item Number
11.5K
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
14.4
Units Used
45.1
Total Cost
649.44
Transaction Date
2015-09-16T00:00:00.000
748063
Transaction Id: 748063 • Contract Number: CNYG-414M • Work Order Id: 698533
Transaction Id
748063
Contract Number
CNYG-414M
Work Order Id
698533
Line Item Id
297.0
Item Number
03K
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
275.0
Units Used
1.0
Total Cost
275.0
Transaction Date
2015-09-16T00:00:00.000
748064
Transaction Id: 748064 • Contract Number: CNYG-414M • Work Order Id: 698533
Transaction Id
748064
Contract Number
CNYG-414M
Work Order Id
698533
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748065
Transaction Id: 748065 • Contract Number: CNYG-414M • Work Order Id: 700129
Transaction Id
748065
Contract Number
CNYG-414M
Work Order Id
700129
Line Item Id
355.0
Item Number
11.5K
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
14.4
Units Used
28.0
Total Cost
403.2
Transaction Date
2015-09-24T00:00:00.000
748066
Transaction Id: 748066 • Contract Number: CNYG-414M • Work Order Id: 700129
Transaction Id
748066
Contract Number
CNYG-414M
Work Order Id
700129
Line Item Id
297.0
Item Number
03K
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
275.0
Units Used
1.0
Total Cost
275.0
Transaction Date
2015-09-24T00:00:00.000
748067
Transaction Id: 748067 • Contract Number: CNYG-414M • Work Order Id: 700129
Transaction Id
748067
Contract Number
CNYG-414M
Work Order Id
700129
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748068
Transaction Id: 748068 • Contract Number: CNYG-414M • Work Order Id: 695728
Transaction Id
748068
Contract Number
CNYG-414M
Work Order Id
695728
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.5
Total Cost
440.0
Transaction Date
2015-09-21T00:00:00.000
748069
Transaction Id: 748069 • Contract Number: CNYG-414M • Work Order Id: 695728
Transaction Id
748069
Contract Number
CNYG-414M
Work Order Id
695728
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748070
Transaction Id: 748070 • Contract Number: CNYG-414M • Work Order Id: 700130
Transaction Id
748070
Contract Number
CNYG-414M
Work Order Id
700130
Line Item Id
355.0
Item Number
11.5K
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
14.4
Units Used
28.0
Total Cost
403.2
Transaction Date
2015-09-16T00:00:00.000
748071
Transaction Id: 748071 • Contract Number: CNYG-414M • Work Order Id: 700130
Transaction Id
748071
Contract Number
CNYG-414M
Work Order Id
700130
Line Item Id
275.0
Item Number
01K
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
175.0
Units Used
1.0
Total Cost
175.0
Transaction Date
2015-09-16T00:00:00.000
748072
Transaction Id: 748072 • Contract Number: CNYG-414M • Work Order Id: 700130
Transaction Id
748072
Contract Number
CNYG-414M
Work Order Id
700130
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748073
Transaction Id: 748073 • Contract Number: CNYG-414M • Work Order Id: 698137
Transaction Id
748073
Contract Number
CNYG-414M
Work Order Id
698137
Line Item Id
355.0
Item Number
11.5K
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
14.4
Units Used
28.0
Total Cost
403.2
Transaction Date
2015-09-16T00:00:00.000
748074
Transaction Id: 748074 • Contract Number: CNYG-414M • Work Order Id: 698137
Transaction Id
748074
Contract Number
CNYG-414M
Work Order Id
698137
Line Item Id
297.0
Item Number
03K
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
275.0
Units Used
1.0
Total Cost
275.0
Transaction Date
2015-09-16T00:00:00.000
748075
Transaction Id: 748075 • Contract Number: CNYG-414M • Work Order Id: 698137
Transaction Id
748075
Contract Number
CNYG-414M
Work Order Id
698137
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748077
Transaction Id: 748077 • Contract Number: CNYG-414M • Work Order Id: 700531
Transaction Id
748077
Contract Number
CNYG-414M
Work Order Id
700531
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
28.0
Total Cost
448.0
Transaction Date
2015-09-16T00:00:00.000
748078
Transaction Id: 748078 • Contract Number: CNYG-414M • Work Order Id: 700531
Transaction Id
748078
Contract Number
CNYG-414M
Work Order Id
700531
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748079
Transaction Id: 748079 • Contract Number: CNYG-414M • Work Order Id: 699343
Transaction Id
748079
Contract Number
CNYG-414M
Work Order Id
699343
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
28.0
Total Cost
448.0
Transaction Date
2015-09-16T00:00:00.000
748080
Transaction Id: 748080 • Contract Number: CNYG-414M • Work Order Id: 699343
Transaction Id
748080
Contract Number
CNYG-414M
Work Order Id
699343
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748081
Transaction Id: 748081 • Contract Number: CNYG-414M • Work Order Id: 690933
Transaction Id
748081
Contract Number
CNYG-414M
Work Order Id
690933
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
28.5
Total Cost
456.0
Transaction Date
2015-09-16T00:00:00.000
748082
Transaction Id: 748082 • Contract Number: CNYG-414M • Work Order Id: 690933
Transaction Id
748082
Contract Number
CNYG-414M
Work Order Id
690933
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748084
Transaction Id: 748084 • Contract Number: CNYG-414M • Work Order Id: 698948
Transaction Id
748084
Contract Number
CNYG-414M
Work Order Id
698948
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
28.0
Total Cost
448.0
Transaction Date
2015-09-16T00:00:00.000
748085
Transaction Id: 748085 • Contract Number: CNYG-414M • Work Order Id: 698948
Transaction Id
748085
Contract Number
CNYG-414M
Work Order Id
698948
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748088
Transaction Id: 748088 • Contract Number: CNYG-414M • Work Order Id: 698541
Transaction Id
748088
Contract Number
CNYG-414M
Work Order Id
698541
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
26.5
Total Cost
424.0
Transaction Date
2015-09-16T00:00:00.000
748089
Transaction Id: 748089 • Contract Number: CNYG-414M • Work Order Id: 698541
Transaction Id
748089
Contract Number
CNYG-414M
Work Order Id
698541
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748090
Transaction Id: 748090 • Contract Number: CNYG-414M • Work Order Id: 700137
Transaction Id
748090
Contract Number
CNYG-414M
Work Order Id
700137
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
25.5
Total Cost
408.0
Transaction Date
2015-09-16T00:00:00.000
748091
Transaction Id: 748091 • Contract Number: CNYG-414M • Work Order Id: 700137
Transaction Id
748091
Contract Number
CNYG-414M
Work Order Id
700137
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748094
Transaction Id: 748094 • Contract Number: CNYG-414M • Work Order Id: 695727
Transaction Id
748094
Contract Number
CNYG-414M
Work Order Id
695727
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.0
Total Cost
432.0
Transaction Date
2015-09-16T00:00:00.000
748095
Transaction Id: 748095 • Contract Number: CNYG-414M • Work Order Id: 695727
Transaction Id
748095
Contract Number
CNYG-414M
Work Order Id
695727
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748096
Transaction Id: 748096 • Contract Number: CNYG-414M • Work Order Id: 710532
Transaction Id
748096
Contract Number
CNYG-414M
Work Order Id
710532
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
28.0
Total Cost
448.0
Transaction Date
2015-09-16T00:00:00.000
748097
Transaction Id: 748097 • Contract Number: CNYG-414M • Work Order Id: 710532
Transaction Id
748097
Contract Number
CNYG-414M
Work Order Id
710532
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-15T00:00:00.000
748098
Transaction Id: 748098 • Contract Number: CNYG-414M • Work Order Id: 727723
Transaction Id
748098
Contract Number
CNYG-414M
Work Order Id
727723
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
26.5
Total Cost
424.0
Transaction Date
2015-09-15T00:00:00.000
748099
Transaction Id: 748099 • Contract Number: CNYG-414M • Work Order Id: 727723
Transaction Id
748099
Contract Number
CNYG-414M
Work Order Id
727723
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-14T00:00:00.000
748100
Transaction Id: 748100 • Contract Number: CNYG-414M • Work Order Id: 741326
Transaction Id
748100
Contract Number
CNYG-414M
Work Order Id
741326
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
28.3
Total Cost
452.8
Transaction Date
2015-09-15T00:00:00.000
748101
Transaction Id: 748101 • Contract Number: CNYG-414M • Work Order Id: 741326
Transaction Id
748101
Contract Number
CNYG-414M
Work Order Id
741326
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-13T00:00:00.000
748102
Transaction Id: 748102 • Contract Number: CNYG-414M • Work Order Id: 710114
Transaction Id
748102
Contract Number
CNYG-414M
Work Order Id
710114
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.5
Total Cost
440.0
Transaction Date
2015-09-14T00:00:00.000
748103
Transaction Id: 748103 • Contract Number: CNYG-414M • Work Order Id: 710114
Transaction Id
748103
Contract Number
CNYG-414M
Work Order Id
710114
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-13T00:00:00.000
748104
Transaction Id: 748104 • Contract Number: CNYG-414M • Work Order Id: 710914
Transaction Id
748104
Contract Number
CNYG-414M
Work Order Id
710914
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
29.5
Total Cost
472.0
Transaction Date
2015-09-14T00:00:00.000
748105
Transaction Id: 748105 • Contract Number: CNYG-414M • Work Order Id: 710914
Transaction Id
748105
Contract Number
CNYG-414M
Work Order Id
710914
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-13T00:00:00.000
748106
Transaction Id: 748106 • Contract Number: CNYG-414M • Work Order Id: 710913
Transaction Id
748106
Contract Number
CNYG-414M
Work Order Id
710913
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
28.0
Total Cost
448.0
Transaction Date
2015-09-21T00:00:00.000
748107
Transaction Id: 748107 • Contract Number: CNYG-414M • Work Order Id: 710913
Transaction Id
748107
Contract Number
CNYG-414M
Work Order Id
710913
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-20T00:00:00.000
748108
Transaction Id: 748108 • Contract Number: CNYG-414M • Work Order Id: 710113
Transaction Id
748108
Contract Number
CNYG-414M
Work Order Id
710113
Line Item Id
276.0
Item Number
11K
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
32.5
Total Cost
520.0
Transaction Date
2015-09-21T00:00:00.000
748109
Transaction Id: 748109 • Contract Number: CNYG-414M • Work Order Id: 710113
Transaction Id
748109
Contract Number
CNYG-414M
Work Order Id
710113
Line Item Id
520.0
Item Number
13K
Line Item Description
PLANT PROCURED STREET TREES, 3.5 - 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2015-10-20T00:00:00.000