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
949299
Transaction Id: 949299 • Contract Number: BG-419M • Work Order Id: 10299838
Transaction Id
949299
Contract Number
BG-419M
Work Order Id
10299838
Line Item Id
650.0
Item Number
12
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1400.0
Units Used
1.0
Total Cost
1400.0
Transaction Date
2020-12-08T00:00:00.000
945220
Transaction Id: 945220 • Contract Number: QG-319M • Work Order Id: 10279050
Transaction Id
945220
Contract Number
QG-319M
Work Order Id
10279050
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
30.5
Units Used
32.1
Total Cost
979.0500000000001
Transaction Date
2020-10-08T00:00:00.000
952033
Transaction Id: 952033 • Contract Number: QG-321M • Work Order Id: 9939780
Transaction Id
952033
Contract Number
QG-321M
Work Order Id
9939780
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
35.5
Units Used
36.0
Total Cost
1278.0
Transaction Date
2021-12-09T00:00:00.000
958508
Transaction Id: 958508 • Contract Number: QG-321M • Work Order Id: 14829122
Transaction Id
958508
Contract Number
QG-321M
Work Order Id
14829122
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
35.5
Units Used
36.3
Total Cost
1288.6499999999999
Transaction Date
2022-02-03T00:00:00.000
963390
Transaction Id: 963390 • Contract Number: QG-321M • Work Order Id: 10097509
Transaction Id
963390
Contract Number
QG-321M
Work Order Id
10097509
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
35.5
Units Used
47.5
Total Cost
1686.25
Transaction Date
2022-02-11T00:00:00.000
961110
Transaction Id: 961110 • Contract Number: QG-422M • Work Order Id: 10440196
Transaction Id
961110
Contract Number
QG-422M
Work Order Id
10440196
Line Item Id
613.0
Item Number
05
Line Item Description
STUMP REMOVALS OF OVER 24 UP TO AND INCLUDING 30 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
1400.0
Units Used
1.0
Total Cost
1400.0
Transaction Date
2023-04-20T00:00:00.000
958705
Transaction Id: 958705 • Contract Number: QG-1119M • Work Order Id: 9991584
Transaction Id
958705
Contract Number
QG-1119M
Work Order Id
9991584
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
34.7
Total Cost
1457.4
Transaction Date
2022-10-24T00:00:00.000
959121
Transaction Id: 959121 • Contract Number: QG-1119M • Work Order Id: 9939825
Transaction Id
959121
Contract Number
QG-1119M
Work Order Id
9939825
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.0
Units Used
0.0
Total Cost
0.0
Transaction Date
2022-10-19T00:00:00.000
961731
Transaction Id: 961731 • Contract Number: BG-1219M • Work Order Id: 12850026
Transaction Id
961731
Contract Number
BG-1219M
Work Order Id
12850026
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
29.3
Total Cost
1230.6000000000001
Transaction Date
2021-11-01T00:00:00.000
961172
Transaction Id: 961172 • Contract Number: QG-1119M • Work Order Id: 10460483
Transaction Id
961172
Contract Number
QG-1119M
Work Order Id
10460483
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.0
Units Used
35.0
Total Cost
1575.0
Transaction Date
2022-10-28T00:00:00.000
965307
Transaction Id: 965307 • Contract Number: BG-1319M • Work Order Id: 11114180
Transaction Id
965307
Contract Number
BG-1319M
Work Order Id
11114180
Line Item Id
624.0
Item Number
23
Line Item Description
REMOVE BLOCK AND/OR STONE PAVEMENT
Unit Of Measure
SF
Unit Price
37.0
Units Used
5.5
Total Cost
203.5
Transaction Date
2021-11-03T00:00:00.000
965308
Transaction Id: 965308 • Contract Number: BG-1319M • Work Order Id: 11114180
Transaction Id
965308
Contract Number
BG-1319M
Work Order Id
11114180
Line Item Id
626.0
Item Number
26
Line Item Description
TOPSOIL FOR TREE BED AREAS
Unit Of Measure
CF
Unit Price
27.0
Units Used
2.14
Total Cost
57.78
Transaction Date
2021-11-03T00:00:00.000
966960
Transaction Id: 966960 • Contract Number: BG-1219M • Work Order Id: 14460711
Transaction Id
966960
Contract Number
BG-1219M
Work Order Id
14460711
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.0
Units Used
22.5
Total Cost
1057.5
Transaction Date
2021-11-12T00:00:00.000
966961
Transaction Id: 966961 • Contract Number: BG-1219M • Work Order Id: 14460711
Transaction Id
966961
Contract Number
BG-1219M
Work Order Id
14460711
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
22.5
Total Cost
945.0
Transaction Date
2021-11-12T00:00:00.000
958323
Transaction Id: 958323 • Contract Number: BG-319MA • Work Order Id: 14020878
Transaction Id
958323
Contract Number
BG-319MA
Work Order Id
14020878
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
50.0
Units Used
46.7
Total Cost
2335.0
Transaction Date
2021-08-25T00:00:00.000
972579
Transaction Id: 972579 • Contract Number: BG-1519M • Work Order Id: 7934379
Transaction Id
972579
Contract Number
BG-1519M
Work Order Id
7934379
Line Item Id
652.0
Item Number
33
Line Item Description
CONCRETE PAVEMENT W/O BASE - 7"
Unit Of Measure
SF
Unit Price
55.0
Units Used
0.0
Total Cost
0.0
Transaction Date
2022-01-13T00:00:00.000
967408
Transaction Id: 967408 • Contract Number: QG-1219M • Work Order Id: 14662089
Transaction Id
967408
Contract Number
QG-1219M
Work Order Id
14662089
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
30.9
Total Cost
1143.3
Transaction Date
2021-12-08T00:00:00.000
967409
Transaction Id: 967409 • Contract Number: QG-1219M • Work Order Id: 14662089
Transaction Id
967409
Contract Number
QG-1219M
Work Order Id
14662089
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
1200.0
Units Used
1.0
Total Cost
1200.0
Transaction Date
2021-12-14T00:00:00.000
967410
Transaction Id: 967410 • Contract Number: QG-1219M • Work Order Id: 14662936
Transaction Id
967410
Contract Number
QG-1219M
Work Order Id
14662936
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
30.9
Total Cost
1143.3
Transaction Date
2021-12-08T00:00:00.000
967411
Transaction Id: 967411 • Contract Number: QG-1219M • Work Order Id: 14662936
Transaction Id
967411
Contract Number
QG-1219M
Work Order Id
14662936
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
1200.0
Units Used
1.0
Total Cost
1200.0
Transaction Date
2021-12-14T00:00:00.000
967412
Transaction Id: 967412 • Contract Number: QG-1219M • Work Order Id: 14662937
Transaction Id
967412
Contract Number
QG-1219M
Work Order Id
14662937
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
30.9
Total Cost
1143.3
Transaction Date
2021-12-08T00:00:00.000
967413
Transaction Id: 967413 • Contract Number: QG-1219M • Work Order Id: 14662937
Transaction Id
967413
Contract Number
QG-1219M
Work Order Id
14662937
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
1200.0
Units Used
1.0
Total Cost
1200.0
Transaction Date
2021-12-14T00:00:00.000
977559
Transaction Id: 977559 • Contract Number: QG-321M • Work Order Id: 14197048
Transaction Id
977559
Contract Number
QG-321M
Work Order Id
14197048
Line Item Id
294.0
Item Number
20
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
200.0
Units Used
3.58
Total Cost
716.0
Transaction Date
2022-01-26T00:00:00.000
977560
Transaction Id: 977560 • Contract Number: QG-321M • Work Order Id: 14197048
Transaction Id
977560
Contract Number
QG-321M
Work Order Id
14197048
Line Item Id
293.0
Item Number
19
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
22.0
Units Used
39.56
Total Cost
870.32
Transaction Date
2022-01-26T00:00:00.000
987818
Transaction Id: 987818 • Contract Number: QG-1119M • Work Order Id: 17026381
Transaction Id
987818
Contract Number
QG-1119M
Work Order Id
17026381
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.0
Units Used
46.7
Total Cost
2101.5
Transaction Date
2022-04-29T00:00:00.000
988424
Transaction Id: 988424 • Contract Number: BG-1219M • Work Order Id: 16916738
Transaction Id
988424
Contract Number
BG-1219M
Work Order Id
16916738
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.0
Units Used
49.6
Total Cost
2331.2000000000003
Transaction Date
2022-05-04T00:00:00.000
980058
Transaction Id: 980058 • Contract Number: XG-221M • Work Order Id: 15233543
Transaction Id
980058
Contract Number
XG-221M
Work Order Id
15233543
Line Item Id
720.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS WITH AMENDED EXISTING SOIL
Unit Of Measure
SF
Unit Price
23.0
Units Used
24.0
Total Cost
552.0
Transaction Date
1902-12-09T00:00:00.000
984147
Transaction Id: 984147 • Contract Number: BG-1519M • Work Order Id: 12135563
Transaction Id
984147
Contract Number
BG-1519M
Work Order Id
12135563
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
40.0
Transaction Date
2021-12-29T00:00:00.000
990186
Transaction Id: 990186 • Contract Number: BG-1219M • Work Order Id: 16916738
Transaction Id
990186
Contract Number
BG-1219M
Work Order Id
16916738
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
15.0
Units Used
29.8
Total Cost
447.0
Transaction Date
2022-05-04T00:00:00.000
993090
Transaction Id: 993090 • Contract Number: BG-1219M • Work Order Id: 16241392
Transaction Id
993090
Contract Number
BG-1219M
Work Order Id
16241392
Line Item Id
652.0
Item Number
33
Line Item Description
CONCRETE PAVEMENT W/O BASE - 7"
Unit Of Measure
SF
Unit Price
30.0
Units Used
3.5
Total Cost
105.0
Transaction Date
2022-05-27T00:00:00.000
993091
Transaction Id: 993091 • Contract Number: BG-1219M • Work Order Id: 17331779
Transaction Id
993091
Contract Number
BG-1219M
Work Order Id
17331779
Line Item Id
652.0
Item Number
33
Line Item Description
CONCRETE PAVEMENT W/O BASE - 7"
Unit Of Measure
SF
Unit Price
30.0
Units Used
5.0
Total Cost
150.0
Transaction Date
2022-05-27T00:00:00.000
983536
Transaction Id: 983536 • Contract Number: QG-1119M • Work Order Id: 9725967
Transaction Id
983536
Contract Number
QG-1119M
Work Order Id
9725967
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.0
Units Used
30.7
Total Cost
1381.5
Transaction Date
2022-05-03T00:00:00.000
993880
Transaction Id: 993880 • Contract Number: XG-121M • Work Order Id: 13246752
Transaction Id
993880
Contract Number
XG-121M
Work Order Id
13246752
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
550.0
Units Used
1.0
Total Cost
550.0
Transaction Date
2022-06-28T00:00:00.000
990872
Transaction Id: 990872 • Contract Number: BG-1219M • Work Order Id: 16563514
Transaction Id
990872
Contract Number
BG-1219M
Work Order Id
16563514
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
41.1
Total Cost
1726.2
Transaction Date
2022-05-09T00:00:00.000
992221
Transaction Id: 992221 • Contract Number: BG-1219M • Work Order Id: 16563514
Transaction Id
992221
Contract Number
BG-1219M
Work Order Id
16563514
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.0
Units Used
10.2
Total Cost
479.4
Transaction Date
2022-05-09T00:00:00.000
1001770
Transaction Id: 1001770 • Contract Number: QG-1119M • Work Order Id: 19015840
Transaction Id
1001770
Contract Number
QG-1119M
Work Order Id
19015840
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.0
Units Used
31.1
Total Cost
1399.5
Transaction Date
2022-10-28T00:00:00.000
1003801
Transaction Id: 1003801 • Contract Number: BG-1419M • Work Order Id: 18698709
Transaction Id
1003801
Contract Number
BG-1419M
Work Order Id
18698709
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
43.0
Units Used
58.3
Total Cost
2506.9
Transaction Date
2022-12-06T00:00:00.000
1003802
Transaction Id: 1003802 • Contract Number: BG-1419M • Work Order Id: 18698709
Transaction Id
1003802
Contract Number
BG-1419M
Work Order Id
18698709
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
1200.0
Units Used
1.0
Total Cost
1200.0
Transaction Date
2022-12-06T00:00:00.000
1001130
Transaction Id: 1001130 • Contract Number: BG-1319M • Work Order Id: 18845752
Transaction Id
1001130
Contract Number
BG-1319M
Work Order Id
18845752
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.0
Units Used
36.0
Total Cost
1656.0
Transaction Date
2022-11-02T00:00:00.000
1001748
Transaction Id: 1001748 • Contract Number: QG-1119M • Work Order Id: 19082928
Transaction Id
1001748
Contract Number
QG-1119M
Work Order Id
19082928
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.0
Units Used
22.2
Total Cost
1021.1999999999999
Transaction Date
2022-10-27T00:00:00.000
1003194
Transaction Id: 1003194 • Contract Number: RG-619M • Work Order Id: 1635512
Transaction Id
1003194
Contract Number
RG-619M
Work Order Id
1635512
Line Item Id
294.0
Item Number
31
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
100.0
Units Used
0.25
Total Cost
25.0
Transaction Date
2022-11-02T00:00:00.000
997651
Transaction Id: 997651 • Contract Number: MG-1319MA • Work Order Id: 18987817
Transaction Id
997651
Contract Number
MG-1319MA
Work Order Id
18987817
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
2022-10-28T00:00:00.000
1008328
Transaction Id: 1008328 • Contract Number: XG-619M • Work Order Id: 10665837
Transaction Id
1008328
Contract Number
XG-619M
Work Order Id
10665837
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
1175.0
Units Used
1.0
Total Cost
1175.0
Transaction Date
2022-10-29T00:00:00.000
998665
Transaction Id: 998665 • Contract Number: QG-219MA • Work Order Id: 16827905
Transaction Id
998665
Contract Number
QG-219MA
Work Order Id
16827905
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
27.5
Units Used
36.0
Total Cost
990.0
Transaction Date
2022-10-22T00:00:00.000
1001434
Transaction Id: 1001434 • Contract Number: BG-1419M • Work Order Id: 18697491
Transaction Id
1001434
Contract Number
BG-1419M
Work Order Id
18697491
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
28.5
Total Cost
228.0
Transaction Date
2022-10-26T00:00:00.000
1002115
Transaction Id: 1002115 • Contract Number: MG-1219MA • Work Order Id: 16433324
Transaction Id
1002115
Contract Number
MG-1219MA
Work Order Id
16433324
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
1691.0
Units Used
1.0
Total Cost
1691.0
Transaction Date
2023-05-04T00:00:00.000
1002639
Transaction Id: 1002639 • Contract Number: XG-619M • Work Order Id: 18663803
Transaction Id
1002639
Contract Number
XG-619M
Work Order Id
18663803
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
38.0
Units Used
39.2
Total Cost
1489.6000000000001
Transaction Date
2022-10-25T00:00:00.000
1008544
Transaction Id: 1008544 • Contract Number: RG-619M • Work Order Id: 10264784
Transaction Id
1008544
Contract Number
RG-619M
Work Order Id
10264784
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
31.9
Total Cost
797.5
Transaction Date
2022-12-05T00:00:00.000
1011572
Transaction Id: 1011572 • Contract Number: BG-1119M • Work Order Id: 18234284
Transaction Id
1011572
Contract Number
BG-1119M
Work Order Id
18234284
Line Item Id
295.0
Item Number
38
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
175.0
Units Used
1.54
Total Cost
269.5
Transaction Date
2023-01-09T00:00:00.000
1011573
Transaction Id: 1011573 • Contract Number: BG-1119M • Work Order Id: 18234284
Transaction Id
1011573
Contract Number
BG-1119M
Work Order Id
18234284
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
1550.0
Units Used
1.0
Total Cost
1550.0
Transaction Date
2023-01-09T00:00:00.000
NYC Data AI • Public-data exploration interface