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
1094865
Transaction Id: 1094865 • Contract Number: MG-1219MA • Work Order Id: 24371813
Transaction Id
1094865
Contract Number
MG-1219MA
Work Order Id
24371813
Units Used
1.0
Transaction Date
2024-10-11T00:00:00.000
1096197
Transaction Id: 1096197 • Contract Number: CNYG-1420MR • Work Order Id: 22630404
Transaction Id
1096197
Contract Number
CNYG-1420MR
Work Order Id
22630404
Line Item Id
628.0
Item Number
02
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
104.52
Units Used
16.0
Total Cost
1672.32
Transaction Date
2024-10-31T00:00:00.000
1096309
Transaction Id: 1096309 • Contract Number: XG-324M • Work Order Id: 19697304
Transaction Id
1096309
Contract Number
XG-324M
Work Order Id
19697304
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
36.0
Total Cost
936.0
Transaction Date
2025-05-20T00:00:00.000
1097842
Transaction Id: 1097842 • Contract Number: MG-1319MA • Work Order Id: 23501005
Transaction Id
1097842
Contract Number
MG-1319MA
Work Order Id
23501005
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.0
Total Cost
1600.0
Transaction Date
2024-10-30T00:00:00.000
1097986
Transaction Id: 1097986 • Contract Number: QG-523M • Work Order Id: 24470883
Transaction Id
1097986
Contract Number
QG-523M
Work Order Id
24470883
Line Item Id
293.0
Item Number
39
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
15.0
Units Used
25.5
Total Cost
382.5
Transaction Date
2024-10-24T00:00:00.000
1098050
Transaction Id: 1098050 • Contract Number: QG-523M • Work Order Id: 24654956
Transaction Id
1098050
Contract Number
QG-523M
Work Order Id
24654956
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
18.7
Total Cost
467.5
Transaction Date
2024-10-24T00:00:00.000
1098672
Transaction Id: 1098672 • Contract Number: QG-523M • Work Order Id: 25086241
Transaction Id
1098672
Contract Number
QG-523M
Work Order Id
25086241
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
44.3
Total Cost
1107.5
Transaction Date
2024-10-31T00:00:00.000
1100292
Transaction Id: 1100292 • Contract Number: XG-619M • Work Order Id: 23325567
Transaction Id
1100292
Contract Number
XG-619M
Work Order Id
23325567
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
50.0
Total Cost
1900.0
Transaction Date
2024-12-16T00:00:00.000
1100968
Transaction Id: 1100968 • Contract Number: XG-619M • Work Order Id: 24579289
Transaction Id
1100968
Contract Number
XG-619M
Work Order Id
24579289
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
25.0
Units Used
9.2
Total Cost
229.99999999999997
Transaction Date
2024-11-20T00:00:00.000
1102109
Transaction Id: 1102109 • Contract Number: QG-223M • Work Order Id: 23250635
Transaction Id
1102109
Contract Number
QG-223M
Work Order Id
23250635
Line Item Id
620.0
Item Number
14
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
36.0
Total Cost
900.0
Transaction Date
2024-11-25T00:00:00.000
1102176
Transaction Id: 1102176 • Contract Number: QG-223M • Work Order Id: 23304147
Transaction Id
1102176
Contract Number
QG-223M
Work Order Id
23304147
Line Item Id
620.0
Item Number
14
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
36.0
Total Cost
900.0
Transaction Date
2024-11-26T00:00:00.000
1102427
Transaction Id: 1102427 • Contract Number: QG-223M • Work Order Id: 23225834
Transaction Id
1102427
Contract Number
QG-223M
Work Order Id
23225834
Line Item Id
626.0
Item Number
47
Line Item Description
TOPSOIL FOR TREE BED AREAS
Unit Of Measure
CF
Unit Price
10.0
Units Used
6.0
Total Cost
60.0
Transaction Date
2024-11-27T00:00:00.000
1102933
Transaction Id: 1102933 • Contract Number: QG-223M • Work Order Id: 22793615
Transaction Id
1102933
Contract Number
QG-223M
Work Order Id
22793615
Line Item Id
620.0
Item Number
14
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
36.0
Total Cost
900.0
Transaction Date
2024-12-04T00:00:00.000
1103192
Transaction Id: 1103192 • Contract Number: BG-323M • Work Order Id: 25210247
Transaction Id
1103192
Contract Number
BG-323M
Work Order Id
25210247
Units Used
0.1
Transaction Date
2024-12-05T00:00:00.000
1103231
Transaction Id: 1103231 • Contract Number: QG-1119MR • Work Order Id: 24024121
Transaction Id
1103231
Contract Number
QG-1119MR
Work Order Id
24024121
Units Used
31.5
Transaction Date
2024-12-04T00:00:00.000
1103643
Transaction Id: 1103643 • Contract Number: QG-1119MR • Work Order Id: 25116264
Transaction Id
1103643
Contract Number
QG-1119MR
Work Order Id
25116264
Units Used
1.0
Transaction Date
2024-12-04T00:00:00.000
1103736
Transaction Id: 1103736 • Contract Number: QG-1119MR • Work Order Id: 23244159
Transaction Id
1103736
Contract Number
QG-1119MR
Work Order Id
23244159
Units Used
1.0
Transaction Date
2024-12-06T00:00:00.000
1103969
Transaction Id: 1103969 • Contract Number: QG-1119MR • Work Order Id: 24024121
Transaction Id
1103969
Contract Number
QG-1119MR
Work Order Id
24024121
Units Used
31.5
Transaction Date
2024-12-04T00:00:00.000
1106057
Transaction Id: 1106057 • Contract Number: BG-523M • Work Order Id: 23448666
Transaction Id
1106057
Contract Number
BG-523M
Work Order Id
23448666
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
34.0
Units Used
52.1
Total Cost
1771.4
Transaction Date
2024-12-13T00:00:00.000
1106575
Transaction Id: 1106575 • Contract Number: BG-523M • Work Order Id: 23420539
Transaction Id
1106575
Contract Number
BG-523M
Work Order Id
23420539
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
34.0
Units Used
26.3
Total Cost
894.2
Transaction Date
2024-12-13T00:00:00.000
1110053
Transaction Id: 1110053 • Contract Number: XG-323M • Work Order Id: 23628929
Transaction Id
1110053
Contract Number
XG-323M
Work Order Id
23628929
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
100.0
Units Used
0.59
Total Cost
59.0
Transaction Date
2025-03-03T00:00:00.000
1110858
Transaction Id: 1110858 • Contract Number: XG-323M • Work Order Id: 25975923
Transaction Id
1110858
Contract Number
XG-323M
Work Order Id
25975923
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
100.0
Units Used
0.42
Total Cost
42.0
Transaction Date
2025-03-10T00:00:00.000
1111919
Transaction Id: 1111919 • Contract Number: XG-122M • Work Order Id: 23403253
Transaction Id
1111919
Contract Number
XG-122M
Work Order Id
23403253
Line Item Id
705.0
Item Number
11
Line Item Description
PREPARING NEW TREE BEDS
Unit Of Measure
SF
Unit Price
35.0
Units Used
50.0
Total Cost
1750.0
Transaction Date
2025-05-14T00:00:00.000
1112073
Transaction Id: 1112073 • Contract Number: XG-122M • Work Order Id: 23403354
Transaction Id
1112073
Contract Number
XG-122M
Work Order Id
23403354
Line Item Id
620.0
Item Number
13
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
2025-04-28T00:00:00.000
1112823
Transaction Id: 1112823 • Contract Number: QG-524M • Work Order Id: 26037465
Transaction Id
1112823
Contract Number
QG-524M
Work Order Id
26037465
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
31.5
Total Cost
630.0
Transaction Date
2025-03-25T00:00:00.000
1113301
Transaction Id: 1113301 • Contract Number: BG-323M • Work Order Id: 24817353
Transaction Id
1113301
Contract Number
BG-323M
Work Order Id
24817353
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
58.0
Units Used
0.9
Total Cost
52.2
Transaction Date
2025-04-03T00:00:00.000
1113502
Transaction Id: 1113502 • Contract Number: QG-524M • Work Order Id: 25342165
Transaction Id
1113502
Contract Number
QG-524M
Work Order Id
25342165
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
21.0
Total Cost
420.0
Transaction Date
2025-04-03T00:00:00.000
1113655
Transaction Id: 1113655 • Contract Number: QG-524M • Work Order Id: 24967589
Transaction Id
1113655
Contract Number
QG-524M
Work Order Id
24967589
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
32.5
Units Used
26.8
Total Cost
871.0
Transaction Date
2025-04-04T00:00:00.000
1114500
Transaction Id: 1114500 • Contract Number: BG-322M • Work Order Id: 25991564
Transaction Id
1114500
Contract Number
BG-322M
Work Order Id
25991564
Line Item Id
654.0
Item Number
13 R
Line Item Description
PREPARING LAWN TREE BEDS (R)
Unit Of Measure
SF
Unit Price
24.6
Units Used
36.0
Total Cost
885.6
Transaction Date
2025-04-11T00:00:00.000
1115056
Transaction Id: 1115056 • Contract Number: QG-323M • Work Order Id: 7196438
Transaction Id
1115056
Contract Number
QG-323M
Work Order Id
7196438
Line Item Id
721.0
Item Number
45
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
700.0
Units Used
0.22
Total Cost
154.0
Transaction Date
2025-06-23T00:00:00.000
1115373
Transaction Id: 1115373 • Contract Number: QG-323M • Work Order Id: 21599100
Transaction Id
1115373
Contract Number
QG-323M
Work Order Id
21599100
Line Item Id
293.0
Item Number
39
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
14.8
Total Cost
118.4
Transaction Date
2025-06-20T00:00:00.000
1116569
Transaction Id: 1116569 • Contract Number: QG-323M • Work Order Id: 25929576
Transaction Id
1116569
Contract Number
QG-323M
Work Order Id
25929576
Line Item Id
293.0
Item Number
39
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
18.0
Total Cost
144.0
Transaction Date
2025-06-24T00:00:00.000
1116687
Transaction Id: 1116687 • Contract Number: QG-323M • Work Order Id: 25953228
Transaction Id
1116687
Contract Number
QG-323M
Work Order Id
25953228
Line Item Id
721.0
Item Number
45
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
700.0
Units Used
0.3
Total Cost
210.0
Transaction Date
2025-06-25T00:00:00.000
1117316
Transaction Id: 1117316 • Contract Number: BG-523M • Work Order Id: 23420500
Transaction Id
1117316
Contract Number
BG-523M
Work Order Id
23420500
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
34.0
Units Used
37.9
Total Cost
1288.6
Transaction Date
2025-05-05T00:00:00.000
1117798
Transaction Id: 1117798 • Contract Number: BG-523M • Work Order Id: 25747343
Transaction Id
1117798
Contract Number
BG-523M
Work Order Id
25747343
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
34.0
Units Used
39.4
Total Cost
1339.6
Transaction Date
2025-05-16T00:00:00.000
1118363
Transaction Id: 1118363 • Contract Number: BG-523M • Work Order Id: 25926437
Transaction Id
1118363
Contract Number
BG-523M
Work Order Id
25926437
Line Item Id
721.0
Item Number
45
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
2500.0
Units Used
0.13
Total Cost
325.0
Transaction Date
2025-06-05T00:00:00.000
1119198
Transaction Id: 1119198 • Contract Number: CNYG-224M • Work Order Id: 26083607
Transaction Id
1119198
Contract Number
CNYG-224M
Work Order Id
26083607
Line Item Id
293.0
Item Number
04
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
6.0
Units Used
11.5
Total Cost
69.0
Transaction Date
2025-04-17T00:00:00.000
1120201
Transaction Id: 1120201 • Contract Number: MG-224M • Work Order Id: 26390253
Transaction Id
1120201
Contract Number
MG-224M
Work Order Id
26390253
Line Item Id
705.0
Item Number
11
Line Item Description
PREPARING NEW TREE BEDS
Unit Of Measure
SF
Unit Price
42.5
Units Used
33.6
Total Cost
1428.0
Transaction Date
2025-05-07T00:00:00.000
1121573
Transaction Id: 1121573 • Contract Number: MG-224M • Work Order Id: 26388811
Transaction Id
1121573
Contract Number
MG-224M
Work Order Id
26388811
Line Item Id
705.0
Item Number
11
Line Item Description
PREPARING NEW TREE BEDS
Unit Of Measure
SF
Unit Price
42.5
Units Used
58.5
Total Cost
2486.25
Transaction Date
2025-05-02T00:00:00.000
1121829
Transaction Id: 1121829 • Contract Number: MG-224M • Work Order Id: 26408725
Transaction Id
1121829
Contract Number
MG-224M
Work Order Id
26408725
Line Item Id
611.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 8 UP TO AND INCLUDING 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2025-04-22T00:00:00.000
1121928
Transaction Id: 1121928 • Contract Number: QG-524M • Work Order Id: 26234290
Transaction Id
1121928
Contract Number
QG-524M
Work Order Id
26234290
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
15.8
Total Cost
316.0
Transaction Date
2025-04-17T00:00:00.000
1122035
Transaction Id: 1122035 • Contract Number: BG-123M • Work Order Id: 5837901
Transaction Id
1122035
Contract Number
BG-123M
Work Order Id
5837901
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
38.7
Total Cost
1006.2
Transaction Date
2025-04-18T00:00:00.000
1122317
Transaction Id: 1122317 • Contract Number: BG-123M • Work Order Id: 26176473
Transaction Id
1122317
Contract Number
BG-123M
Work Order Id
26176473
Line Item Id
292.0
Item Number
38
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
15.0
Units Used
0.92
Total Cost
13.8
Transaction Date
2025-04-24T00:00:00.000
1122436
Transaction Id: 1122436 • Contract Number: MG-1319MA • Work Order Id: 26081129
Transaction Id
1122436
Contract Number
MG-1319MA
Work Order Id
26081129
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
16.0
Total Cost
732.8
Transaction Date
2025-04-17T00:00:00.000
1123290
Transaction Id: 1123290 • Contract Number: RG-223M • Work Order Id: 20605381
Transaction Id
1123290
Contract Number
RG-223M
Work Order Id
20605381
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
175.0
Units Used
0.12
Total Cost
21.0
Transaction Date
2025-05-01T00:00:00.000
1124940
Transaction Id: 1124940 • Contract Number: BG-322M • Work Order Id: 25995991
Transaction Id
1124940
Contract Number
BG-322M
Work Order Id
25995991
Line Item Id
292.0
Item Number
39
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
5.56
Units Used
4.4
Total Cost
24.464
Transaction Date
2025-05-06T00:00:00.000
1126662
Transaction Id: 1126662 • Contract Number: MG-1319MA • Work Order Id: 24142435
Transaction Id
1126662
Contract Number
MG-1319MA
Work Order Id
24142435
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
10.0
Units Used
11.0
Total Cost
110.0
Transaction Date
2025-05-07T00:00:00.000
1127393
Transaction Id: 1127393 • Contract Number: BG-123M • Work Order Id: 26285649
Transaction Id
1127393
Contract Number
BG-123M
Work Order Id
26285649
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
24.0
Units Used
18.0
Total Cost
432.0
Transaction Date
2025-05-12T00:00:00.000
1127444
Transaction Id: 1127444 • Contract Number: QG-424M • Work Order Id: 23055981
Transaction Id
1127444
Contract Number
QG-424M
Work Order Id
23055981
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
200.0
Units Used
0.88
Total Cost
176.0
Transaction Date
2025-05-14T00:00:00.000
1127748
Transaction Id: 1127748 • Contract Number: BG-624M • Work Order Id: 26330522
Transaction Id
1127748
Contract Number
BG-624M
Work Order Id
26330522
Line Item Id
294.0
Item Number
40
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
102.0
Units Used
0.93
Total Cost
94.86
Transaction Date
2025-05-15T00:00:00.000
NYC Data AI • Public-data exploration interface