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
1011999
Transaction Id: 1011999 • Contract Number: RG-619M • Work Order Id: 662983
Transaction Id
1011999
Contract Number
RG-619M
Work Order Id
662983
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-01-04T00:00:00.000
1012000
Transaction Id: 1012000 • Contract Number: RG-619M • Work Order Id: 18993863
Transaction Id
1012000
Contract Number
RG-619M
Work Order Id
18993863
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-01-04T00:00:00.000
1012003
Transaction Id: 1012003 • Contract Number: RG-619M • Work Order Id: 19084794
Transaction Id
1012003
Contract Number
RG-619M
Work Order Id
19084794
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-01-04T00:00:00.000
1012006
Transaction Id: 1012006 • Contract Number: RG-619M • Work Order Id: 13882491
Transaction Id
1012006
Contract Number
RG-619M
Work Order Id
13882491
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-01-04T00:00:00.000
1012007
Transaction Id: 1012007 • Contract Number: RG-619M • Work Order Id: 13882100
Transaction Id
1012007
Contract Number
RG-619M
Work Order Id
13882100
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-01-04T00:00:00.000
1012008
Transaction Id: 1012008 • Contract Number: RG-619M • Work Order Id: 19084797
Transaction Id
1012008
Contract Number
RG-619M
Work Order Id
19084797
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-01-04T00:00:00.000
1012010
Transaction Id: 1012010 • Contract Number: RG-619M • Work Order Id: 19084801
Transaction Id
1012010
Contract Number
RG-619M
Work Order Id
19084801
Line Item Id
651.0
Item Number
16
Line Item Description
PLANTING PROCURED STREET TREES, 3.5 – 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
1650.0
Units Used
1.0
Total Cost
1650.0
Transaction Date
2023-01-04T00:00:00.000
1012011
Transaction Id: 1012011 • Contract Number: RG-619M • Work Order Id: 19087134
Transaction Id
1012011
Contract Number
RG-619M
Work Order Id
19087134
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-01-04T00:00:00.000
1012012
Transaction Id: 1012012 • Contract Number: RG-619M • Work Order Id: 17164637
Transaction Id
1012012
Contract Number
RG-619M
Work Order Id
17164637
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-01-04T00:00:00.000
1012013
Transaction Id: 1012013 • Contract Number: RG-619M • Work Order Id: 19145314
Transaction Id
1012013
Contract Number
RG-619M
Work Order Id
19145314
Line Item Id
651.0
Item Number
16
Line Item Description
PLANTING PROCURED STREET TREES, 3.5 – 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
1650.0
Units Used
1.0
Total Cost
1650.0
Transaction Date
2023-01-04T00:00:00.000
1012014
Transaction Id: 1012014 • Contract Number: RG-619M • Work Order Id: 19145309
Transaction Id
1012014
Contract Number
RG-619M
Work Order Id
19145309
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-01-04T00:00:00.000
1012015
Transaction Id: 1012015 • Contract Number: RG-619M • Work Order Id: 19145310
Transaction Id
1012015
Contract Number
RG-619M
Work Order Id
19145310
Line Item Id
651.0
Item Number
16
Line Item Description
PLANTING PROCURED STREET TREES, 3.5 – 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
1650.0
Units Used
1.0
Total Cost
1650.0
Transaction Date
2023-01-04T00:00:00.000
1012016
Transaction Id: 1012016 • Contract Number: RG-619M • Work Order Id: 18991778
Transaction Id
1012016
Contract Number
RG-619M
Work Order Id
18991778
Line Item Id
651.0
Item Number
16
Line Item Description
PLANTING PROCURED STREET TREES, 3.5 – 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
1650.0
Units Used
1.0
Total Cost
1650.0
Transaction Date
2023-01-04T00:00:00.000
1012017
Transaction Id: 1012017 • Contract Number: RG-619M • Work Order Id: 18991789
Transaction Id
1012017
Contract Number
RG-619M
Work Order Id
18991789
Line Item Id
651.0
Item Number
16
Line Item Description
PLANTING PROCURED STREET TREES, 3.5 – 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
1650.0
Units Used
1.0
Total Cost
1650.0
Transaction Date
2023-01-04T00:00:00.000
1012018
Transaction Id: 1012018 • Contract Number: RG-619M • Work Order Id: 18991777
Transaction Id
1012018
Contract Number
RG-619M
Work Order Id
18991777
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-01-04T00:00:00.000
1012019
Transaction Id: 1012019 • Contract Number: RG-619M • Work Order Id: 18991783
Transaction Id
1012019
Contract Number
RG-619M
Work Order Id
18991783
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-01-04T00:00:00.000
1012367
Transaction Id: 1012367 • Contract Number: MG-1319MA • Work Order Id: 18264118
Transaction Id
1012367
Contract Number
MG-1319MA
Work Order Id
18264118
Line Item Id
611.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 UP TO AND INCLUDING 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
850.0
Units Used
1.0
Total Cost
850.0
Transaction Date
2023-01-04T00:00:00.000
1008183
Transaction Id: 1008183 • Contract Number: RG-619M • Work Order Id: 15873747
Transaction Id
1008183
Contract Number
RG-619M
Work Order Id
15873747
Line Item Id
611.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 UP TO AND INCLUDING 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2022-11-29T00:00:00.000
1014507
Transaction Id: 1014507 • Contract Number: MG-1319MA • Work Order Id: 18987818
Transaction Id
1014507
Contract Number
MG-1319MA
Work Order Id
18987818
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1117.0
Units Used
0.0
Total Cost
0.0
Transaction Date
2022-10-28T00:00:00.000
1008389
Transaction Id: 1008389 • Contract Number: MG-1319MA • Work Order Id: 16202479
Transaction Id
1008389
Contract Number
MG-1319MA
Work Order Id
16202479
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.8
Units Used
6.7
Total Cost
306.86
Transaction Date
2022-12-01T00:00:00.000
1008390
Transaction Id: 1008390 • Contract Number: MG-1319MA • Work Order Id: 16202479
Transaction Id
1008390
Contract Number
MG-1319MA
Work Order Id
16202479
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
50.0
Units Used
32.3
Total Cost
1614.9999999999998
Transaction Date
2022-12-01T00:00:00.000
1010646
Transaction Id: 1010646 • Contract Number: RG-519M • Work Order Id: 18549651
Transaction Id
1010646
Contract Number
RG-519M
Work Order Id
18549651
Line Item Id
659.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS WITH AMENDED EXISTING SOIL
Unit Of Measure
SF
Unit Price
20.0
Units Used
36.0
Total Cost
720.0
Transaction Date
2023-01-23T00:00:00.000
1010647
Transaction Id: 1010647 • Contract Number: RG-519M • Work Order Id: 18549651
Transaction Id
1010647
Contract Number
RG-519M
Work Order Id
18549651
Line Item Id
700.0
Item Number
18
Line Item Description
PLANTING PROCURED TREES, 2.5 – 3.0 INCH CALIPER
Unit Of Measure
EA
Unit Price
1250.0
Units Used
1.0
Total Cost
1250.0
Transaction Date
2023-01-23T00:00:00.000
1017059
Transaction Id: 1017059 • Contract Number: CNYG-922M • Work Order Id: 19303159
Transaction Id
1017059
Contract Number
CNYG-922M
Work Order Id
19303159
Line Item Id
743.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS WITH CITY-PROCURED SOIL
Unit Of Measure
SF
Unit Price
30.0
Units Used
21.9
Total Cost
657.0
Transaction Date
2023-05-13T00:00:00.000
1017060
Transaction Id: 1017060 • Contract Number: CNYG-922M • Work Order Id: 19303159
Transaction Id
1017060
Contract Number
CNYG-922M
Work Order Id
19303159
Line Item Id
650.0
Item Number
13
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1200.0
Units Used
1.0
Total Cost
1200.0
Transaction Date
2023-05-13T00:00:00.000
1017062
Transaction Id: 1017062 • Contract Number: CNYG-922M • Work Order Id: 19303159
Transaction Id
1017062
Contract Number
CNYG-922M
Work Order Id
19303159
Line Item Id
744.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS WITH CITY-PROCURED SOIL
Unit Of Measure
SF
Unit Price
28.0
Units Used
25.0
Total Cost
700.0
Transaction Date
2023-05-13T00:00:00.000
1017063
Transaction Id: 1017063 • Contract Number: CNYG-922M • Work Order Id: 19303159
Transaction Id
1017063
Contract Number
CNYG-922M
Work Order Id
19303159
Line Item Id
625.0
Item Number
14
Line Item Description
REMOVE DEBRIS (TREE BED AND TREE CANOPY)
Unit Of Measure
HR
Unit Price
125.0
Units Used
0.25
Total Cost
31.25
Transaction Date
2023-05-13T00:00:00.000
1014393
Transaction Id: 1014393 • Contract Number: MG-1319MA • Work Order Id: 19715068
Transaction Id
1014393
Contract Number
MG-1319MA
Work Order Id
19715068
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
50.0
Units Used
47.5
Total Cost
2375.0
Transaction Date
2023-01-16T00:00:00.000
1020207
Transaction Id: 1020207 • Contract Number: RG-619M • Work Order Id: 13882089
Transaction Id
1020207
Contract Number
RG-619M
Work Order Id
13882089
Line Item Id
729.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1.0
Total Cost
1300.0
Transaction Date
2023-04-03T00:00:00.000
1020595
Transaction Id: 1020595 • Contract Number: QG-1019MR • Work Order Id: 19981662
Transaction Id
1020595
Contract Number
QG-1019MR
Work Order Id
19981662
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
30.16
Units Used
38.2
Total Cost
1152.112
Transaction Date
2023-04-05T00:00:00.000
1022544
Transaction Id: 1022544 • Contract Number: QG-1019MR • Work Order Id: 19785339
Transaction Id
1022544
Contract Number
QG-1019MR
Work Order Id
19785339
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
29.12
Units Used
25.0
Total Cost
728.0
Transaction Date
2023-04-06T00:00:00.000
1013886
Transaction Id: 1013886 • Contract Number: MG-1319MA • Work Order Id: 16789518
Transaction Id
1013886
Contract Number
MG-1319MA
Work Order Id
16789518
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1117.0
Units Used
1.0
Total Cost
1117.0
Transaction Date
2023-06-13T00:00:00.000
1019912
Transaction Id: 1019912 • Contract Number: MG-1319MA • Work Order Id: 19983752
Transaction Id
1019912
Contract Number
MG-1319MA
Work Order Id
19983752
Line Item Id
312.0
Item Number
25
Line Item Description
REMOVE AND RESET METAL TREE GUARDS AND GRATES
Unit Of Measure
HR
Unit Price
279.0
Units Used
0.2
Total Cost
55.800000000000004
Transaction Date
2023-05-05T00:00:00.000
1019913
Transaction Id: 1019913 • Contract Number: MG-1319MA • Work Order Id: 19983752
Transaction Id
1019913
Contract Number
MG-1319MA
Work Order Id
19983752
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
50.0
Units Used
40.2
Total Cost
2010.0000000000002
Transaction Date
2023-05-05T00:00:00.000
1022278
Transaction Id: 1022278 • Contract Number: QG-1219M • Work Order Id: 20024352
Transaction Id
1022278
Contract Number
QG-1219M
Work Order Id
20024352
Line Item Id
624.0
Item Number
23
Line Item Description
REMOVE BLOCK AND/OR STONE PAVEMENT
Unit Of Measure
SF
Unit Price
30.0
Units Used
2.0
Total Cost
60.0
Transaction Date
2023-04-28T00:00:00.000
1023436
Transaction Id: 1023436 • Contract Number: XG-519M • Work Order Id: 19724998
Transaction Id
1023436
Contract Number
XG-519M
Work Order Id
19724998
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.0
Units Used
55.0
Total Cost
2475.0
Transaction Date
2023-04-06T00:00:00.000
1024877
Transaction Id: 1024877 • Contract Number: BG-1619MR • Work Order Id: 19588084
Transaction Id
1024877
Contract Number
BG-1619MR
Work Order Id
19588084
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.32
Units Used
20.0
Total Cost
166.4
Transaction Date
2023-04-13T00:00:00.000
1027353
Transaction Id: 1027353 • Contract Number: BG-1619MR • Work Order Id: 19715555
Transaction Id
1027353
Contract Number
BG-1619MR
Work Order Id
19715555
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.32
Units Used
19.0
Total Cost
158.08
Transaction Date
2023-04-25T00:00:00.000
1024618
Transaction Id: 1024618 • Contract Number: MG-1219M • Work Order Id: 19970836
Transaction Id
1024618
Contract Number
MG-1219M
Work Order Id
19970836
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
52.0
Units Used
41.9
Total Cost
2178.7999999999997
Transaction Date
2023-04-17T00:00:00.000
1029368
Transaction Id: 1029368 • Contract Number: BG-222M • Work Order Id: 19463453
Transaction Id
1029368
Contract Number
BG-222M
Work Order Id
19463453
Line Item Id
312.0
Item Number
29
Line Item Description
REMOVE AND RESET METAL TREE GUARDS AND GRATES
Unit Of Measure
HR
Unit Price
100.0
Units Used
0.25
Total Cost
25.0
Transaction Date
2023-12-05T00:00:00.000
1029039
Transaction Id: 1029039 • Contract Number: BG-222M • Work Order Id: 19764466
Transaction Id
1029039
Contract Number
BG-222M
Work Order Id
19764466
Line Item Id
625.0
Item Number
28
Line Item Description
REMOVE DEBRIS (TREE BED AND TREE CANOPY)
Unit Of Measure
HR
Unit Price
100.0
Units Used
0.1
Total Cost
10.0
Transaction Date
2023-06-01T00:00:00.000
1030887
Transaction Id: 1030887 • Contract Number: RG-519M • Work Order Id: 20245090
Transaction Id
1030887
Contract Number
RG-519M
Work Order Id
20245090
Line Item Id
283.0
Item Number
28
Line Item Description
RANGE FENCE 4’-0” HEIGHT
Unit Of Measure
LF
Unit Price
10.0
Transaction Date
1900-08-27T00:00:00.000
1029417
Transaction Id: 1029417 • Contract Number: MG-1219MA • Work Order Id: 20273366
Transaction Id
1029417
Contract Number
MG-1219MA
Work Order Id
20273366
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
52.0
Units Used
18.7
Total Cost
972.4
Transaction Date
2023-04-26T00:00:00.000
1033740
Transaction Id: 1033740 • Contract Number: MG-1319MA • Work Order Id: 19536075
Transaction Id
1033740
Contract Number
MG-1319MA
Work Order Id
19536075
Line Item Id
625.0
Item Number
24
Line Item Description
REMOVE DEBRIS (TREE BED AND TREE CANOPY)
Unit Of Measure
HR
Unit Price
205.0
Units Used
0.2
Total Cost
41.0
Transaction Date
2023-06-29T00:00:00.000
1034027
Transaction Id: 1034027 • Contract Number: MG-1319MA • Work Order Id: 13907526
Transaction Id
1034027
Contract Number
MG-1319MA
Work Order Id
13907526
Line Item Id
625.0
Item Number
24
Line Item Description
REMOVE DEBRIS (TREE BED AND TREE CANOPY)
Unit Of Measure
HR
Unit Price
205.0
Units Used
0.2
Total Cost
41.0
Transaction Date
2023-06-29T00:00:00.000
1033038
Transaction Id: 1033038 • Contract Number: RG-519M • Work Order Id: 19741347
Transaction Id
1033038
Contract Number
RG-519M
Work Order Id
19741347
Line Item Id
620.0
Item Number
12
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
30.0
Units Used
36.0
Total Cost
1080.0
Transaction Date
2023-06-09T00:00:00.000
1033039
Transaction Id: 1033039 • Contract Number: RG-519M • Work Order Id: 19741347
Transaction Id
1033039
Contract Number
RG-519M
Work Order Id
19741347
Line Item Id
704.0
Item Number
17
Line Item Description
PLANTING PROCURED TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1175.0
Units Used
1.0
Total Cost
1175.0
Transaction Date
2023-06-09T00:00:00.000
1033785
Transaction Id: 1033785 • Contract Number: BG-1119M • Work Order Id: 19918778
Transaction Id
1033785
Contract Number
BG-1119M
Work Order Id
19918778
Line Item Id
701.0
Item Number
19
Line Item Description
PLANTING PROCURED TREES, 3.5 – 4.0 INCH CALIPER
Unit Of Measure
EA
Unit Price
1900.0
Units Used
1.0
Total Cost
1900.0
Transaction Date
2023-06-21T00:00:00.000
1033786
Transaction Id: 1033786 • Contract Number: BG-1119M • Work Order Id: 19918778
Transaction Id
1033786
Contract Number
BG-1119M
Work Order Id
19918778
Line Item Id
659.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS WITH AMENDED EXISTING SOIL
Unit Of Measure
SF
Unit Price
30.0
Units Used
36.0
Total Cost
1080.0
Transaction Date
2023-06-21T00:00:00.000
1033861
Transaction Id: 1033861 • Contract Number: BG-1119M • Work Order Id: 20441182
Transaction Id
1033861
Contract Number
BG-1119M
Work Order Id
20441182
Line Item Id
659.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS WITH AMENDED EXISTING SOIL
Unit Of Measure
SF
Unit Price
30.0
Units Used
36.0
Total Cost
1080.0
Transaction Date
2023-06-08T00:00:00.000