Ask NYC Browse All Data Public Safety Transportation Health Buildings

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
747992
Transaction Id: 747992 • Contract Number: BG-415M • Work Order Id: 661020
Transaction Id
747992
Contract Number
BG-415M
Work Order Id
661020
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
18.4
Total Cost
1288.0
Transaction Date
2016-04-18T00:00:00.000
747994
Transaction Id: 747994 • Contract Number: BG-415M • Work Order Id: 661016
Transaction Id
747994
Contract Number
BG-415M
Work Order Id
661016
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
20.3
Total Cost
1421.0
Transaction Date
2016-04-19T00:00:00.000
747995
Transaction Id: 747995 • Contract Number: BG-415M • Work Order Id: 664074
Transaction Id
747995
Contract Number
BG-415M
Work Order Id
664074
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
20.6
Total Cost
1442.0
Transaction Date
2016-04-19T00:00:00.000
747996
Transaction Id: 747996 • Contract Number: BG-415M • Work Order Id: 661019
Transaction Id
747996
Contract Number
BG-415M
Work Order Id
661019
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.8
Total Cost
1246.0
Transaction Date
2016-04-18T00:00:00.000
747998
Transaction Id: 747998 • Contract Number: BG-415M • Work Order Id: 674091
Transaction Id
747998
Contract Number
BG-415M
Work Order Id
674091
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
28.5
Total Cost
399.0
Transaction Date
2015-10-30T00:00:00.000
747999
Transaction Id: 747999 • Contract Number: BG-415M • Work Order Id: 674091
Transaction Id
747999
Contract Number
BG-415M
Work Order Id
674091
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-02T00:00:00.000
748000
Transaction Id: 748000 • Contract Number: BG-415M • Work Order Id: 671710
Transaction Id
748000
Contract Number
BG-415M
Work Order Id
671710
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
36.0
Total Cost
504.0
Transaction Date
2015-10-27T00:00:00.000
748003
Transaction Id: 748003 • Contract Number: QG-215M • Work Order Id: 693742
Transaction Id
748003
Contract Number
QG-215M
Work Order Id
693742
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.0
Total Cost
217.8
Transaction Date
2015-12-14T00:00:00.000
748005
Transaction Id: 748005 • Contract Number: QG-215M • Work Order Id: 650830
Transaction Id
748005
Contract Number
QG-215M
Work Order Id
650830
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
50.0
Total Cost
850.0
Transaction Date
2015-12-28T00:00:00.000
748006
Transaction Id: 748006 • Contract Number: QG-215M • Work Order Id: 780208
Transaction Id
748006
Contract Number
QG-215M
Work Order Id
780208
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
748007
Transaction Id: 748007 • Contract Number: QG-215M • Work Order Id: 780208
Transaction Id
748007
Contract Number
QG-215M
Work Order Id
780208
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
50.0
Total Cost
600.0
Transaction Date
2015-12-28T00:00:00.000
748009
Transaction Id: 748009 • Contract Number: QG-215M • Work Order Id: 780610
Transaction Id
748009
Contract Number
QG-215M
Work Order Id
780610
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
748010
Transaction Id: 748010 • Contract Number: QG-215M • Work Order Id: 780610
Transaction Id
748010
Contract Number
QG-215M
Work Order Id
780610
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
50.0
Total Cost
600.0
Transaction Date
2015-12-28T00:00:00.000
748011
Transaction Id: 748011 • Contract Number: QG-215M • Work Order Id: 780610
Transaction Id
748011
Contract Number
QG-215M
Work Order Id
780610
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
22.0
Total Cost
220.0
Transaction Date
2015-12-28T00:00:00.000
748013
Transaction Id: 748013 • Contract Number: QG-215M • Work Order Id: 783007
Transaction Id
748013
Contract Number
QG-215M
Work Order Id
783007
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
748014
Transaction Id: 748014 • Contract Number: QG-215M • Work Order Id: 783007
Transaction Id
748014
Contract Number
QG-215M
Work Order Id
783007
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
50.0
Total Cost
600.0
Transaction Date
2015-12-28T00:00:00.000
748015
Transaction Id: 748015 • Contract Number: QG-215M • Work Order Id: 783007
Transaction Id
748015
Contract Number
QG-215M
Work Order Id
783007
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
21.0
Total Cost
210.0
Transaction Date
2015-12-28T00:00:00.000
748016
Transaction Id: 748016 • Contract Number: QG-215M • Work Order Id: 1321085
Transaction Id
748016
Contract Number
QG-215M
Work Order Id
1321085
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
748017
Transaction Id: 748017 • Contract Number: QG-215M • Work Order Id: 1321085
Transaction Id
748017
Contract Number
QG-215M
Work Order Id
1321085
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.5
Total Cost
722.5
Transaction Date
2015-09-14T00:00:00.000
748018
Transaction Id: 748018 • Contract Number: QG-215M • Work Order Id: 1353078
Transaction Id
748018
Contract Number
QG-215M
Work Order Id
1353078
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
748019
Transaction Id: 748019 • Contract Number: QG-215M • Work Order Id: 1353078
Transaction Id
748019
Contract Number
QG-215M
Work Order Id
1353078
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-15T00:00:00.000
748020
Transaction Id: 748020 • Contract Number: QG-215M • Work Order Id: 1343087
Transaction Id
748020
Contract Number
QG-215M
Work Order Id
1343087
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
748021
Transaction Id: 748021 • Contract Number: QG-215M • Work Order Id: 1343087
Transaction Id
748021
Contract Number
QG-215M
Work Order Id
1343087
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-15T00:00:00.000
748022
Transaction Id: 748022 • Contract Number: CNYG-414M • Work Order Id: 679317
Transaction Id
748022
Contract Number
CNYG-414M
Work Order Id
679317
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
24.5
Total Cost
392.0
Transaction Date
2015-09-22T00:00:00.000
748023
Transaction Id: 748023 • Contract Number: CNYG-414M • Work Order Id: 679317
Transaction Id
748023
Contract Number
CNYG-414M
Work Order Id
679317
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
748024
Transaction Id: 748024 • Contract Number: CNYG-414M • Work Order Id: 698119
Transaction Id
748024
Contract Number
CNYG-414M
Work Order Id
698119
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
24.0
Total Cost
384.0
Transaction Date
2015-09-22T00:00:00.000
748025
Transaction Id: 748025 • Contract Number: CNYG-414M • Work Order Id: 698119
Transaction Id
748025
Contract Number
CNYG-414M
Work Order Id
698119
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
748029
Transaction Id: 748029 • Contract Number: CNYG-414M • Work Order Id: 680906
Transaction Id
748029
Contract Number
CNYG-414M
Work Order Id
680906
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.2
Total Cost
403.2
Transaction Date
2015-10-23T00:00:00.000
748030
Transaction Id: 748030 • Contract Number: CNYG-414M • Work Order Id: 680906
Transaction Id
748030
Contract Number
CNYG-414M
Work Order Id
680906
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
748031
Transaction Id: 748031 • Contract Number: CNYG-414M • Work Order Id: 736550
Transaction Id
748031
Contract Number
CNYG-414M
Work Order Id
736550
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-23T00:00:00.000
748032
Transaction Id: 748032 • Contract Number: CNYG-414M • Work Order Id: 736550
Transaction Id
748032
Contract Number
CNYG-414M
Work Order Id
736550
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
748033
Transaction Id: 748033 • Contract Number: CNYG-414M • Work Order Id: 678129
Transaction Id
748033
Contract Number
CNYG-414M
Work Order Id
678129
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
31.6
Total Cost
505.6
Transaction Date
2015-09-24T00:00:00.000
748034
Transaction Id: 748034 • Contract Number: CNYG-414M • Work Order Id: 678129
Transaction Id
748034
Contract Number
CNYG-414M
Work Order Id
678129
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
748035
Transaction Id: 748035 • Contract Number: CNYG-414M • Work Order Id: 680941
Transaction Id
748035
Contract Number
CNYG-414M
Work Order Id
680941
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
748036
Transaction Id: 748036 • Contract Number: CNYG-414M • Work Order Id: 680941
Transaction Id
748036
Contract Number
CNYG-414M
Work Order Id
680941
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
748037
Transaction Id: 748037 • Contract Number: CNYG-414M • Work Order Id: 678922
Transaction Id
748037
Contract Number
CNYG-414M
Work Order Id
678922
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-24T00:00:00.000
748038
Transaction Id: 748038 • Contract Number: CNYG-414M • Work Order Id: 678922
Transaction Id
748038
Contract Number
CNYG-414M
Work Order Id
678922
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
748039
Transaction Id: 748039 • Contract Number: CNYG-414M • Work Order Id: 681728
Transaction Id
748039
Contract Number
CNYG-414M
Work Order Id
681728
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-24T00:00:00.000
748040
Transaction Id: 748040 • Contract Number: CNYG-414M • Work Order Id: 681728
Transaction Id
748040
Contract Number
CNYG-414M
Work Order Id
681728
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
748041
Transaction Id: 748041 • Contract Number: CNYG-414M • Work Order Id: 682121
Transaction Id
748041
Contract Number
CNYG-414M
Work Order Id
682121
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
748042
Transaction Id: 748042 • Contract Number: CNYG-414M • Work Order Id: 682121
Transaction Id
748042
Contract Number
CNYG-414M
Work Order Id
682121
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
748043
Transaction Id: 748043 • Contract Number: CNYG-414M • Work Order Id: 675733
Transaction Id
748043
Contract Number
CNYG-414M
Work Order Id
675733
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-24T00:00:00.000
748044
Transaction Id: 748044 • Contract Number: CNYG-414M • Work Order Id: 675733
Transaction Id
748044
Contract Number
CNYG-414M
Work Order Id
675733
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
748045
Transaction Id: 748045 • Contract Number: CNYG-414M • Work Order Id: 675332
Transaction Id
748045
Contract Number
CNYG-414M
Work Order Id
675332
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-24T00:00:00.000
748046
Transaction Id: 748046 • Contract Number: CNYG-414M • Work Order Id: 675332
Transaction Id
748046
Contract Number
CNYG-414M
Work Order Id
675332
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
748047
Transaction Id: 748047 • Contract Number: CNYG-414M • Work Order Id: 674930
Transaction Id
748047
Contract Number
CNYG-414M
Work Order Id
674930
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.0
Total Cost
464.0
Transaction Date
2015-09-24T00:00:00.000
748048
Transaction Id: 748048 • Contract Number: CNYG-414M • Work Order Id: 674930
Transaction Id
748048
Contract Number
CNYG-414M
Work Order Id
674930
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
748049
Transaction Id: 748049 • Contract Number: CNYG-414M • Work Order Id: 676527
Transaction Id
748049
Contract Number
CNYG-414M
Work Order Id
676527
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-24T00:00:00.000
748050
Transaction Id: 748050 • Contract Number: CNYG-414M • Work Order Id: 676527
Transaction Id
748050
Contract Number
CNYG-414M
Work Order Id
676527
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
748051
Transaction Id: 748051 • Contract Number: CNYG-414M • Work Order Id: 678509
Transaction Id
748051
Contract Number
CNYG-414M
Work Order Id
678509
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
NYC Data AI • Public-data exploration interface