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
746030
Transaction Id: 746030 • Contract Number: QG-215M • Work Order Id: 649689
Transaction Id
746030
Contract Number
QG-215M
Work Order Id
649689
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
24.5
Total Cost
294.0
Transaction Date
2015-09-18T00:00:00.000
746031
Transaction Id: 746031 • Contract Number: QG-215M • Work Order Id: 649689
Transaction Id
746031
Contract Number
QG-215M
Work Order Id
649689
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
8.6
Total Cost
146.2
Transaction Date
2015-09-18T00:00:00.000
746032
Transaction Id: 746032 • Contract Number: QG-215M • Work Order Id: 649689
Transaction Id
746032
Contract Number
QG-215M
Work Order Id
649689
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
14.4
Total Cost
1036.8
Transaction Date
2016-03-21T00:00:00.000
746033
Transaction Id: 746033 • Contract Number: QG-215M • Work Order Id: 647749
Transaction Id
746033
Contract Number
QG-215M
Work Order Id
647749
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-10-07T00:00:00.000
746034
Transaction Id: 746034 • Contract Number: QG-215M • Work Order Id: 647749
Transaction Id
746034
Contract Number
QG-215M
Work Order Id
647749
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
23.7
Total Cost
284.4
Transaction Date
2015-09-18T00:00:00.000
746035
Transaction Id: 746035 • Contract Number: QG-215M • Work Order Id: 647749
Transaction Id
746035
Contract Number
QG-215M
Work Order Id
647749
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.3
Total Cost
549.0999999999999
Transaction Date
2015-09-18T00:00:00.000
746036
Transaction Id: 746036 • Contract Number: QG-215M • Work Order Id: 647749
Transaction Id
746036
Contract Number
QG-215M
Work Order Id
647749
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
18.5
Total Cost
1332.0
Transaction Date
2016-02-23T00:00:00.000
746037
Transaction Id: 746037 • Contract Number: QG-215M • Work Order Id: 651531
Transaction Id
746037
Contract Number
QG-215M
Work Order Id
651531
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-10-07T00:00:00.000
746038
Transaction Id: 746038 • Contract Number: QG-215M • Work Order Id: 651531
Transaction Id
746038
Contract Number
QG-215M
Work Order Id
651531
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
22.5
Total Cost
270.0
Transaction Date
2015-09-18T00:00:00.000
746039
Transaction Id: 746039 • Contract Number: QG-215M • Work Order Id: 651531
Transaction Id
746039
Contract Number
QG-215M
Work Order Id
651531
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
21.8
Total Cost
370.6
Transaction Date
2015-09-18T00:00:00.000
746040
Transaction Id: 746040 • Contract Number: QG-215M • Work Order Id: 651531
Transaction Id
746040
Contract Number
QG-215M
Work Order Id
651531
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
16.2
Total Cost
1166.3999999999999
Transaction Date
2016-02-23T00:00:00.000
746041
Transaction Id: 746041 • Contract Number: QG-215M • Work Order Id: 647649
Transaction Id
746041
Contract Number
QG-215M
Work Order Id
647649
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-10-07T00:00:00.000
746042
Transaction Id: 746042 • Contract Number: QG-215M • Work Order Id: 647649
Transaction Id
746042
Contract Number
QG-215M
Work Order Id
647649
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
27.5
Total Cost
330.0
Transaction Date
2015-09-18T00:00:00.000
746043
Transaction Id: 746043 • Contract Number: QG-215M • Work Order Id: 647649
Transaction Id
746043
Contract Number
QG-215M
Work Order Id
647649
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
27.5
Total Cost
467.5
Transaction Date
2015-09-18T00:00:00.000
746044
Transaction Id: 746044 • Contract Number: QG-215M • Work Order Id: 649580
Transaction Id
746044
Contract Number
QG-215M
Work Order Id
649580
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-10-07T00:00:00.000
746045
Transaction Id: 746045 • Contract Number: QG-215M • Work Order Id: 649580
Transaction Id
746045
Contract Number
QG-215M
Work Order Id
649580
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
26.6
Total Cost
319.20000000000005
Transaction Date
2015-09-18T00:00:00.000
746046
Transaction Id: 746046 • Contract Number: QG-215M • Work Order Id: 649580
Transaction Id
746046
Contract Number
QG-215M
Work Order Id
649580
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
26.4
Total Cost
448.79999999999995
Transaction Date
2015-09-18T00:00:00.000
746047
Transaction Id: 746047 • Contract Number: QG-215M • Work Order Id: 653323
Transaction Id
746047
Contract Number
QG-215M
Work Order Id
653323
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-10-06T00:00:00.000
746048
Transaction Id: 746048 • Contract Number: QG-215M • Work Order Id: 653323
Transaction Id
746048
Contract Number
QG-215M
Work Order Id
653323
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
37.0
Total Cost
444.0
Transaction Date
2015-09-17T00:00:00.000
746050
Transaction Id: 746050 • Contract Number: QG-215M • Work Order Id: 647628
Transaction Id
746050
Contract Number
QG-215M
Work Order Id
647628
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
746051
Transaction Id: 746051 • Contract Number: QG-215M • Work Order Id: 647628
Transaction Id
746051
Contract Number
QG-215M
Work Order Id
647628
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
24.2
Total Cost
290.4
Transaction Date
2015-09-25T00:00:00.000
746052
Transaction Id: 746052 • Contract Number: QG-215M • Work Order Id: 647628
Transaction Id
746052
Contract Number
QG-215M
Work Order Id
647628
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
24.1
Total Cost
409.70000000000005
Transaction Date
2015-09-25T00:00:00.000
746053
Transaction Id: 746053 • Contract Number: QG-215M • Work Order Id: 647628
Transaction Id
746053
Contract Number
QG-215M
Work Order Id
647628
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
17.5
Total Cost
1085.0
Transaction Date
2016-03-21T00:00:00.000
746054
Transaction Id: 746054 • Contract Number: QG-215M • Work Order Id: 647756
Transaction Id
746054
Contract Number
QG-215M
Work Order Id
647756
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-28T00:00:00.000
746055
Transaction Id: 746055 • Contract Number: QG-215M • Work Order Id: 647756
Transaction Id
746055
Contract Number
QG-215M
Work Order Id
647756
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
5.8
Total Cost
69.6
Transaction Date
2015-09-14T00:00:00.000
746056
Transaction Id: 746056 • Contract Number: QG-215M • Work Order Id: 647756
Transaction Id
746056
Contract Number
QG-215M
Work Order Id
647756
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
42.7
Total Cost
725.9000000000001
Transaction Date
2015-09-14T00:00:00.000
746057
Transaction Id: 746057 • Contract Number: QG-215M • Work Order Id: 651904
Transaction Id
746057
Contract Number
QG-215M
Work Order Id
651904
Line Item Id
342.0
Item Number
30
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
10.0
Units Used
102.5
Total Cost
1025.0
Transaction Date
2015-09-08T00:00:00.000
746058
Transaction Id: 746058 • Contract Number: QG-215M • Work Order Id: 649812
Transaction Id
746058
Contract Number
QG-215M
Work Order Id
649812
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-20T00:00:00.000
746059
Transaction Id: 746059 • Contract Number: QG-215M • Work Order Id: 649812
Transaction Id
746059
Contract Number
QG-215M
Work Order Id
649812
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.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
746060
Transaction Id: 746060 • Contract Number: QG-215M • Work Order Id: 649812
Transaction Id
746060
Contract Number
QG-215M
Work Order Id
649812
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
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
746061
Transaction Id: 746061 • Contract Number: QG-215M • Work Order Id: 651937
Transaction Id
746061
Contract Number
QG-215M
Work Order Id
651937
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-20T00:00:00.000
746062
Transaction Id: 746062 • Contract Number: QG-215M • Work Order Id: 651937
Transaction Id
746062
Contract Number
QG-215M
Work Order Id
651937
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.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
746063
Transaction Id: 746063 • Contract Number: QG-215M • Work Order Id: 651937
Transaction Id
746063
Contract Number
QG-215M
Work Order Id
651937
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
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
746064
Transaction Id: 746064 • Contract Number: QG-215M • Work Order Id: 651680
Transaction Id
746064
Contract Number
QG-215M
Work Order Id
651680
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-20T00:00:00.000
746065
Transaction Id: 746065 • Contract Number: QG-215M • Work Order Id: 651680
Transaction Id
746065
Contract Number
QG-215M
Work Order Id
651680
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.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
746066
Transaction Id: 746066 • Contract Number: QG-215M • Work Order Id: 651680
Transaction Id
746066
Contract Number
QG-215M
Work Order Id
651680
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
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
746121
Transaction Id: 746121 • Contract Number: QG-215M • Work Order Id: 733321
Transaction Id
746121
Contract Number
QG-215M
Work Order Id
733321
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
746122
Transaction Id: 746122 • Contract Number: QG-215M • Work Order Id: 733321
Transaction Id
746122
Contract Number
QG-215M
Work Order Id
733321
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
22.4
Total Cost
268.79999999999995
Transaction Date
2015-12-19T00:00:00.000
746123
Transaction Id: 746123 • Contract Number: QG-215M • Work Order Id: 733321
Transaction Id
746123
Contract Number
QG-215M
Work Order Id
733321
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
22.4
Total Cost
380.79999999999995
Transaction Date
2015-12-19T00:00:00.000
746124
Transaction Id: 746124 • Contract Number: QG-215M • Work Order Id: 728928
Transaction Id
746124
Contract Number
QG-215M
Work Order Id
728928
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
746125
Transaction Id: 746125 • Contract Number: QG-215M • Work Order Id: 728928
Transaction Id
746125
Contract Number
QG-215M
Work Order Id
728928
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
22.2
Total Cost
266.4
Transaction Date
2015-12-19T00:00:00.000
746126
Transaction Id: 746126 • Contract Number: QG-215M • Work Order Id: 728928
Transaction Id
746126
Contract Number
QG-215M
Work Order Id
728928
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
25.3
Total Cost
430.1
Transaction Date
2015-12-19T00:00:00.000
746127
Transaction Id: 746127 • Contract Number: QG-215M • Work Order Id: 730527
Transaction Id
746127
Contract Number
QG-215M
Work Order Id
730527
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
746128
Transaction Id: 746128 • Contract Number: QG-215M • Work Order Id: 730527
Transaction Id
746128
Contract Number
QG-215M
Work Order Id
730527
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
23.3
Total Cost
279.6
Transaction Date
2015-12-19T00:00:00.000
746129
Transaction Id: 746129 • Contract Number: QG-215M • Work Order Id: 730527
Transaction Id
746129
Contract Number
QG-215M
Work Order Id
730527
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
28.4
Total Cost
482.79999999999995
Transaction Date
2015-12-19T00:00:00.000
746130
Transaction Id: 746130 • Contract Number: QG-215M • Work Order Id: 661292
Transaction Id
746130
Contract Number
QG-215M
Work Order Id
661292
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
746131
Transaction Id: 746131 • Contract Number: QG-215M • Work Order Id: 661292
Transaction Id
746131
Contract Number
QG-215M
Work Order Id
661292
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
13.7
Total Cost
164.39999999999998
Transaction Date
2015-12-31T00:00:00.000
746132
Transaction Id: 746132 • Contract Number: QG-215M • Work Order Id: 661292
Transaction Id
746132
Contract Number
QG-215M
Work Order Id
661292
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
14.2
Total Cost
241.39999999999998
Transaction Date
2015-12-31T00:00:00.000
746133
Transaction Id: 746133 • Contract Number: QG-215M • Work Order Id: 688537
Transaction Id
746133
Contract Number
QG-215M
Work Order Id
688537
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
746134
Transaction Id: 746134 • Contract Number: QG-215M • Work Order Id: 688537
Transaction Id
746134
Contract Number
QG-215M
Work Order Id
688537
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
30.9
Total Cost
370.79999999999995
Transaction Date
2015-12-14T00:00:00.000