pavement quality forecasting - wordpress.com...for implementing custom databases and models to meet...
TRANSCRIPT
PAVEMENT QUALITY FORECASTINGUsing dTIMS to forecast pavement
conditions in the MPO
January 2015
IntroductionWith the addition of performance measures to the long-range transportation planning process, the need to forecast pavement conditions in greater Des Moines has become necessary as infrastructure deteriorates and funding opportunities become limited. The Des Moines Area Metropolitan Planning Organization (MPO) purchased a pavement forecasting software to determine the funding needed to reach a target of maintaining existing conditions in the region. This report first summarizes the funding need for the entire MPO planning area, then goes into further detail on how each member city is performing based on their current maintenance budgets. This analysis used 2013 Pavement Condition Index data and Deighton Total Infrastructure Management System to forecast the quality of the region’s pavement out to the year 2023.
Pavement Condition IndexEach year, the Institute for Transportation at Iowa State University (InTrans), collects pavement condition data for non-DOT roads in Iowa. As part of this data collection, InTrans records the Pavement Condition Index (PCI), which gives users the level of quality they should expect when driving on the roadways. The PCI ranges from zero to one hundred, with one hundred being the best possible score a roadway can receive. A breakdown of PCI classifications is as follows:
• Excellent (81-100)• Good (61-80)• Fair (41-60)• Poor (21-40)• Very Poor (0-20)
Deighton Total Infrastructure Management SystemDeighton Total Infrastructure Management System (dTIMSTM) is a pavement forecasting software that offers a set of tools for implementing custom databases and models to meet an agency’s pavement and asset management needs. dTIMSTM allows the user to create budget scenarios to forecast their effect on pavement conditions into the future, helping jurisdictions determine the funding need to maintain pavement conditions at a certain level. Various budget scenarios were ran at the regional level, as well as the local level, to determine the amount of funding needed to reach a regional target.
dTIMSTM uses various pavement treatment types that are applied to roads for each year the analysis is run for. MPO staff chose general pavement treatment types that could represent as best as it can what is currently being done by member jurisdictions. These treatment types are as follows:
• Concrete Pavement Restoration• Mill and Overlay for HMA and COM• 3” Overlay for HMA and COM• Replacement for PCC• Crack Sealing
Page 2
Pavement Treatment Types
COM Composite
HMA Hot Mix Asphalt
PCC Portland Cement Concrete
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f All
Road
s
Year
$40 Million
Excellent
Good
Fair
Poor
Very Poor
2050 TARGET: MAINTAIN CURRENT PAVEMENT QUALITY
Very Poor
Excellent
Goo
d
Fair
Poor
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
$40M$30M
$20M
AVERAGE CONDITION (PCI) BY BUDGET SCENARIO
$13.5M
REGIONAL Pavement Quality
January 2015
percent of roads in the MPO are classified as being in poor or very poor condition118
is the amount of funding needed each year to maintain current pavement
conditions in the region
$40 million
Average PCI for the region: 60
Currently, the region spends about $30 million2
Data Sources: 1. 2012 Iowa Pavement Management Program, Pavement Management Information System 2. Street Financial Reports, Iowa DOT
*Numbers above represent all roads, including DOT roads
I 35
I 235
W AV
E
2ND A
VE
NE 46
STNE 94 AVE
U AVE
360TH ST
GRAN
D AVE
HICKMAN RD
63RD
STASHWORTH RD
NE 96
ST
US 65
SE 6 AVE
UTE A
VE
FLEU
R DR
NE 29
ST
SW 9T
H ST
NE 56
ST
NW BEAVER DR
NW 6 DR
SE 14
TH ST
NE 46 AVE
NE 10
8 ST
DOUGLAS AVE
PARK AVE
NE 78 AVE
NW 16
ST
6TH A
VE
US 6
NW 12
1 ST
240TH ST
UNIVERSITY AVE
NE 70 AVE
MERL
E HAY
RD
NW 26
ST
NE 80
ST
120TH ST
NE 62 AVE
IOWA 5
70TH
ST
W 1ST ST
NW 70 AVE
NW 118 AVE
NE 64
ST
SE 5T
H ST
86TH
ST
HICKMAN AVE
INDI
ANOL
A AVE
300TH ST
VINE ST
335TH ST
NE 126 AVE
NE 3
ST
ADAMS ST
NE 11
2 ST
E 38T
H ST
NE 22
ST
NE 72
ST
SE VANDALIA DR
HWY R
57
SE 72
ST
128T
H ST
E EUCLID AVE
NW 18TH ST
NE 38 AVE
PROPOSED RD
60TH
ST
50TH
ST
E HULL AVE
HWY G14
SE DIAGONAL
E 29T
H ST
FOREST AVE
E P TRUE PKWY
E 14T
H ST
E UNIVERSITY AVE
DEAN AVE
IOWA
28
SE 68
ST
ARMY POST RD
MAURY ST
1ST ST
AURORA AVE
EASTON BLVD
E ARMY POST RD
30TH
ST
NW 66 AVE
1ST A
VE S
HUBBELL AVE
8TH ST SW
S JAM
ES ST
BEAV
ER AV
E
WESTOWN PKWY8T
H ST
S UNI
ON ST
73RDST
NW 44
ST
DIXO
N ST
113T
H AVE
40TH
AVE
NW 110 AVE
30TH
AVE
FULLER RD
NW 86
TH ST
VANDALIA RD
N 14
TH ST
S 50T
H ST
MILLS CIVIC PKWY
SCOTCH RID G E RD
ALIC
ES R
D
CUMMING RD
48TH
ST
INGERSOLL AVE
SWST
ATE S
T
NE 66 AVE
E 33R
D ST
GRAN
T ST S
S 60T
H ST
SCOTT AVE98TH
ST
E 1ST ST
NW 54 AVE
NE 14
TH ST
MLK JRPKW
Y
S 35 TH ST
NW AS
H DR
88TH
ST
NE 82 AVE
NE 27 AVE
E PARK AVE
35TH
ST
9TH
ST
NE 11
6 ST
156T
H ST
42ND
ST
72ND
ST
ADVENTURELAND DR
SE 6T
H ST
31ST
ST
E PINE AVE
DAKOTA ST
7TH
ST
URBANDALE AVE
S 88T
H ST
33RD
AVE
NW ST
ATE S
T
NE 88
ST
SE 37TH ST
DELA
WARE
AVE
56TH
ST
MEREDITH DR
E OAKWOOD DR
E CO LINE RD
165T
H PL
EUCLID AVE
SW ORALABOR RD
NW 58
ST
NE 23 AVE
NW 37
ST
NE 36TH STNW 112 AVE
SE D
ELAW
ARE A
VE
22ND
ST
19TH
ST
PROPO
SED SW DIAGONAL
GUTHRIE AVE
CO LINE RD
NORTH AVE
N JA
MES S
T
SW 14
TH ST
NW 106 AVE
S ANK
ENY B
LVD
NW 36TH ST
HWY R63
E 42N
D ST
JORD
AN C
REEK
PKWY
NW 62ND AVE
VETE
RA
NS PKWY
E 6TH ST
E HARTFORD AVESU
NSET DR
PORTER AVE
NE M
ORGA
N DR
6TH
ST
SAGE ST
VINTA
GE AV
E
34TH
AVE S
W
E DOUGLAS AVE
NW 54TH AVE
142N
D ST
S 5TH
ST
W MLK JR PKWY
SE 36
TH ST
104T
H ST
E 46T
H ST
FRANKLIN AVE
TABO
R RD
105TH ST
E GRAND AVE
NW 10
7 ST
NE D
ELAW
ARE A
VE
MCKINLEY AVE
KINGMAN BLVD
E MCKINLEY AVE
NE 54 AVE
SW IRVINEDALE DR
NE 70
ST
MC KIN LEY A VE
5TH AVE
68TH
ST
EASTER LAKE DR
NE 91
ST
DO U GLAS PKWY
LOCUST ST
95TH AVE
55TH
ST
WATROUS AVE
RAILROAD AVE
CORN
ELL S
T
NE 86 AVE
NE 58 AVE
S 42N
D ST
E COURT AVE
NE 18TH ST
MADISON AVE
WILL
IAMSS
T
SE 22
ND ST
POLK
BLVD
N 3RD
ST
NW 10
0TH
ST
1ST A
VE N
SE 30
TH ST
BELL AVE
NE 60 AVE
2ND ST NE
15TH ST
NW 11
4 ST
NE 80
TH ST
E BORDER ST
100T
H ST
NW TONI DR
GEORGE FLAGG PKWY
US 69
SW 19TH ST
E WALNUT ST
NW 16
TH ST
E 30T
H ST
BRONZE ST
CLEVELAND ST
PLUM DR
50TH
AVE
NWSH
ELDAHL DR
NW 10
0 ST
WARR
IOR
LN
12TH
ST
9TH ST NW
NW 12
8TH
ST
5TH
ST
45TH
AVE
NE 56
TH ST
LOWER BEAVERRD
NE 11
0 ST
SE ORALABOR RD
N 1S
T ST
E WATROUS AVE
NW 14
2ND
ST
ASHWORTH DR
43RD
PL
8TH ST SE
32ND ST SW
EVERGREEN AVE
NW LAKE DRNW SAYLORVILL
E DR
MAFFITT LAKE RD
NW URBANDALE DR
109T
H ST
NW11 4TH ST
NW 15
6TH
ST
PIONEER
PKWY
NE 118 AVE
SWANSON BLVD
PROP
OSED
ALIC
ES R
D
SE AVON DR
SW 7TH ST
N BR OADWAY ST W
HIGH ST
SW
RAMP
PARKRIDGE AVE
SW ORDNANCE RD
NE BERWICK DR
E 56T
H ST
SE 64 AVE
CLARKE ST
E 18T
H ST
KEOSAUQUA WAY
41ST
STTHOMAS BECK RD322ND RD
SE RAMP
SAYLOR RD
SE64S T
SE MAGAZINE RD
SE 80
ST
NW 94 AVE
RACCOON RIVER DR
N ANK
ENY B
LVD
NW MEREDITH DR
SE 1S
T ST
SP LEAS ANT HILL BLVDE BROADWAY AVE
15TH ST SE
4TH
ST
93RD AVE
GRANT ST N
NW IR
VINED
ALE D
R
NW MORNINGSTAR DR
E WASHINGTON AVE
NWFISHER LN
PROP COUNTY LINE RDS 20T
H ST
E AURORA AVE
NE RAMP
S 22N
D ST
S 19TH ST
NE 78TH AVE 2ND ST NW
6TH ST NW
112TH ST
NW RA
MP
JOHNSTON DR
W BRIDGE RD
FREDERICK M HUBBELL AVE
NE 110 AVE
SE 90TH ST
SE 34
TH ST
PROPOSED
NE 102 AVE
32ND ST SE
17TH
A VEN
W
E NORTHSIDE DR
X AVE
SE 64TH AVE
CORPORATE WOODS DR
E 15TH ST
BORDER ST
COTTAGE GROVE AVE
COUNTY LINE RD
NW 60 AVE
43RD
AVE
CHERRY PKWY
NW AB
BIE D
R
SE60
ST
10TH
ST
PROP
OSED
MLK
PKWY
S EN ECA AVE
CHERRY ST
UNIVERSITY BLVD
14TH
AVE S
E
PROPOSED NW 50TH AVE
E 4TH ST
NW 82 AVE
VERM
ILLIO
N CT
S 1ST
ST
CUMMING AVE
BASSPRO DR NW
E 21ST ST
PROP UNIVERSITY AVE
35TH
ST/VA
LLEY
WES
T DR
SP EC C ASE
280TH ST
NW 72
ST
NE BROADWAY AVE
PROPOSED S 50TH ST
NW 65 LN
36TH ST SE
SUTTON DR
NE LOOP
MTA LN
NW 98 AVE
24TH ST SE
3RD S
T
CENT
ER AV
E S
NW 42ND AVE
NW 115 AVE
LEADO AVE
17TH ST W 14TH ST
E 22ND ST
NW RA
MP
NE RAMP
SW RAMP
MAFFITT LAKE RD
NE RAMP
SW RAM P
SE RAMP
SW RAMP
SW RAMP
E 1ST ST
NE RAMP
SE RA
MP
NE 80
ST
NW 70 AVE
NE 14
TH ST
NW RA
MP
NE 11
2 ST
8TH
ST
ARMY POST RD
NW RAMPSW RAMP
E 46T
H ST
NW RAMP
SE RAMP
NE 29
ST
CUMMING AVE
SW RAMP
SW RAMP
100T
H ST
NW RAMP
19TH
ST
NE 54 AVE
IOWA 5
ARMY POST RD
NE 78 AVE
SE RA
MP
NW RAMP
NW RA
MP
N ANK
ENY B
LVD
NW RA
MP
E WATROUS AVE
NE 29
ST
72ND
ST
142N
D ST
SE RA
MP
NW R
AMP
SE RA
MP
SE RAM
P
MEREDITH DR
SW RAMP
SW R
AMP
SE RA
MP
I 80
MEREDITH DR
SE RAMP NW RAMP
DAKOTA ST
35TH
ST
NE 58 AVE
SE RAMP
NE RAMP
3RD ST
HUBBELL AVE
NE 72
ST
NE 54 AVE
NE 56
ST
IOWA
28
SE RAMP
SCOTT AVE
UNIVERSITY AVE
NE 27 AVE
NE 29
ST
E ARMY POST RDNE RAMP
SE RAMP
NE RAMP
NE 64
ST
NE 29
ST
SW RAMP
NW 70 AVE
NW100TH
ST
HWY G14
NE RAMP
NW RAMP
SW RAMP
E 14TH ST
CO LINE RD
NW R
AMP
N E2 9 ST
CO LINE RD
SW RAMP
100T
H ST
NE RAMP
SW RAMP
NW RAMP
1ST A
VE S
SW RAMP
NE 62 AVE
NE 46 AVE
NE 38 AVE
SE RA
MP
NW RA
MP
NW 54 AVE
SWRAMP
SW RAMP
NE 29
ST
NW 16
ST
PLUM DR NW RAMP
SCOTT AVE
DOUGLAS PKWY
HWY G14
SPEC CASE
MPO Planning AreaPavement Condition (PCI)
Very Poor 0 - 20Poor 21 - 40Fair 41 - 60Good 61 - 80Excellent 81 - 100
°0 2.5 51.25
MilesDate: 11/25/2014
§̈¦35§̈¦80
§̈¦35
§̈¦35
§̈¦80
§̈¦80
§̈¦235
§̈¦235
£¤69
£¤69
£¤6
£¤6
£¤65
£¤65
¬«5
¬«141
¬«410
¬«163
£¤65
¬«28
¬«5
2013 Iowa Local Road Assessment
Page 5
Windsor Heights
Des Moines
Grimes
Carlisle
Pleasant Hill
Johnston
Norwalk
Waukee
Bondurant
Clive
Polk City
Altoona
Urbandale
Ankeny
West Des Moines
Cumming
Mitchellville
64
61
60
59
58
57
55
53
53
53
52
52
52
52
51
39
39
31
44
61
52
55
57
50
59
59
50
57
53
49
56
55
64
57
20232012
AVERAGE PCI WITH CURRENT FUNDING LEVELS
LOCAL Conditions
PERCENT POOR OR WORSE WITH CURRENT FUNDING LEVELS, 2023
Windsor Heights
Grimes
Pleasant Hill
Carlisle
Des Moines
Clive
Johnston
Norwalk
AltoonaWest Des Moines
Ankeny
Waukee
Polk City
Urbandale
Bondurant
Cumming
Mitchellville
10
20
30
40
50
60
70
80
Regiona
l Tar
ge
t
Using current funding levels, just 3 cities maintain their pavement conditions under the regional target through 2023.
All non-DOT roads were used when forecasting
future conditions
Page 6
LOCAL Conditions
2013 (ACTUAL)
0 20 40 60 80 100
Altoona
Ankeny
Bondurant
Carlisle
Clive
Cumming
Des Moines
Grimes
Johnston
Mitchellville
Norwalk
Pleasant Hill
Polk City
Urbandale
Waukee
West Des Moines
Windsor Heights
0 20 40 60 80 100
2023 (FORECAST)
PCI RATING: PERCENT OF TOTAL MILES
Poor or Very Poor Fair Good or Excellent
Current funding levels were used to forecast 2023
conditions
Page 7
ENVIRONMENTAL JUSTICE Areas
43Environmental Justice Area
Non-Environmental Justice Area
AVER
AG
E PC
I
53ENVIRONMENTAL JUSTICE AREAS
44Environmental Justice Area
Non-Environmental Justice Area
POO
R O
R W
ORS
E RO
AD
S (%
)
26About 14% of local roads in the
region lie within EJ areas.
The MPO receives federal funding and may not discriminate against anyone on the basis of race, color, or national origin, according to Title VI of the Civil Rights Act of 1964.
ENVIRONMENTAL JUSTICE AREAConcentrated area of
traditionally underserved populations. Groups used to define EJ areas include:
Limited English Proficiency (LEP)Non-White Population
Persons in PovertyCarless Households
Single Heads of Households with ChildrenPersons Over 65
Persons with a DisabilityAll non-DOT roads were used for Environmental
Justice comparisons
Local InvestmentsTo maintain the regional average of 18 percent of roads in poor or worse condition, each jurisdiction will need to invest in their local system to meet the regional goal. To determine if cities are currently on the right track to do so, dTIMSTM was used to run scenarios based on current annual maintenance budgets. Street Financial Reports (SFR) were used to determine annual maintenance budgets for each member, based on a 6-year average for the amount spent on maintenance needs. Results from those scenarios determined which cities have a need to increase their maintenance budgets in order to reach the regional goal. The Annual Maintenance chart shows the additional funds needed for those cities that are not currently reaching the regional goal.
City ReportsThe remaining pages of this report go into further detail on each member city of the MPO. Included on each page is a map of the 2013 Local Road Assessment, the annual maintenance budget used for the analysis, total miles of roadway measured for pavement quality, and multiple charts forecasting future pavement conditions within each city. The Pavement Quality and Average Condition (PCI) charts provide a detailed breakdown of the city’s future conditions if they were to continue spending the current amount on maintenance needs.
City Current Annual Funding
Total Annual Funding Needed
Additional Funding Needed
Altoona $696,106 $1,500,000 $803,894
Ankeny $1,544,627 $5,000,000 $3,455,373
Bondurant $256,328 $400,000 $143,672
Carlisle $343,530 $450,000 $106,470
Clive $1,662,341 $2,500,000 $837,659
Cumming $27,451 $175,000 $147,549
Des Moines $15,551,818 $16,500,000 $948,182
Grimes $913,603 - -
Johnston $1,218,221 $3,000,000 $1,781,779
Mitchellville $58,568 $275,000 $216,432
Norwalk $679,457 $1,300,000 $620,543
Pleasant Hill $579,915 - -
Polk City $253,022 $400,000 $146,978
Urbandale $2,042,375 $4,000,000 $1,957,625
Waukee $559,356 $1,500,000 $940,644
West Des Moines $2,237,219 $4,000,000 $1,762,781
Windsor Heights $498,948 - -
Total $29,122,885 $41,000,000 $11,877,115
*Cities with a ‘-’ currently achieve the regional average with their maintenance budgets. Therefore, no additional funding is needed.
ANNUAL MAINTENANCE
Page 8
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Altoona ($696,106)
Excellent
Good
Fair
Poor
Very Poor
58.1 57.2 56.8 56.5 56.6 55.7 55.2 54.5 53.4 52.3
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF ALTOONAAnnual Maintenance (6-Year Average): $696,106
Miles of Road Measured: 71
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
15.9 19.9 20.3 20.7 20.2 21.4 22.0 22.1 23.9 25.9
2013 LOCAL ROAD ASSESSMENT
Page 9
CITY OF ANKENYAnnual Maintenance (6-Year Average): $1,544,627
Miles of Road Measured: 207
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
16.7 14.6 12.3 13.4 13.7 15.3 17.4 21.5 24.9 26.9
2013 LOCAL ROAD ASSESSMENT
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Ankeny ($1,544,627)
Excellent
Good
Fair
Poor
Very Poor
60.8 60.7 60.2 58.8 57.9 56.4 55.3 54.1 52.7 51.5
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
Page 10
CITY OF BONDURANTAnnual Maintenance (6-Year Average): $256,328
Miles of Road Measured: 26
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
10.0 12.0 22.0 23.2 24.5 24.4 29.2 32.2 29.5 30.3
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Bondurant ($256,328)
Excellent
Good
Fair
Poor
Very Poor
2013 LOCAL ROAD ASSESSMENT
59.0 57.5 56.7 55.9 55.5 55.2 54.5 54.1 53.7 53.3
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
Page 11
CITY OF CARLISLEAnnual Maintenance (6-Year Average): $343,530
Miles of Road Measured: 23
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
16.8 17.8 20.7 16.4 19.3 21.1 21.2 23.6 20.3 20.0
2013 LOCAL ROAD ASSESSMENT
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Carlisle ($343,530)
Excellent
Good
Fair
Poor
Very Poor
59.6 59.8 59.3 60.2 60.5 60.1 59.7 60.0 60.0 59.4
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
Page 12
CITY OF CLIVEAnnual Maintenance (6-Year Average): $1,662,341
Miles of Road Measured: 78
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
21.8 24.7 24.2 22.7 20.1 18.8 16.9 17.5 20.8 23.6
2013 LOCAL ROAD ASSESSMENT
Page 13
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Clive ($1,662,341)
Excellent
Good
Fair
Poor
Very Poor
55.2 54.7 54.3 54.3 54.9 54.4 54.1 54.1 53.4 52.8
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF CUMMINGAnnual Maintenance (6-Year Average): $27,451
Miles of Road Measured: 4
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
0.0 3.2 3.2 11.8 20.1 34.3 36.4 43.4 42.6 46.3
2013 LOCAL ROAD ASSESSMENT
Page 14
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Cumming ($27,451)
Excellent
Good
Fair
Poor
Very Poor
64.9 62.1 59.5 56.8 54.1 50.4 47.2 44.5 41.7 39.2
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF DES MOINESAnnual Maintenance (6-Year Average): $15,551,818
Miles of Road Measured: 852
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
29.8 30.8 28.7 28.3 26.3 26.0 23.8 22.4 20.9 20.4
2013 LOCAL ROAD ASSESSMENT
Page 15
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Des Moines ($15,551,818)
Excellent
Good
Fair
Poor
Very Poor
50.2 52.5 54.6 56.1 58.1 59.2 60.1 61.0 61.2 60.8
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF GRIMESAnnual Maintenance (6-Year Average): $913,603
Miles of Road Measured: 49
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
16.2 15.7 16.2 14.4 11.0 11.4 9.8 12.3 13.7 15.2
2013 LOCAL ROAD ASSESSMENT
Page 16
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Grimes ($913,603)
Excellent
Good
Fair
Poor
Very Poor
62.8 61.3 59.3 58.3 58.9 59.4 60.1 60.2 60.4 60.4
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF JOHNSTONAnnual Maintenance (6-Year Average): $1,218,221
Miles of Road Measured: 97
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
11.7 13.0 15.2 18.3 17.6 17.0 16.8 18.0 22.3 24.1
2013 LOCAL ROAD ASSESSMENT
Page 17
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Johnston ($1,218,221)
Excellent
Good
Fair
Poor
Very Poor
60.4 58.8 56.9 55.4 56.0 56.1 56.5 56.8 56.8 56.9
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF MITCHELLVILLEAnnual Maintenance (6-Year Average): $58,568
Miles of Road Measured: 13
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
6.9 6.9 9.0 12.9 23.0 37.8 44.0 53.7 58.3 62.6
2013 LOCAL ROAD ASSESSMENT
Page 18
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Mitchellville ($58,568)
Excellent
Good
Fair
Poor
Very Poor
58.7 61.5 59.4 56.4 53.4 50.6 47.6 44.6 41.9 39.0
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF NORWALKAnnual Maintenance (6-Year Average): $679,457
Miles of Road Measured: 44
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
16.9 19.5 22.9 20.2 23.5 21.3 21.3 25.7 27.0 24.5
2013 LOCAL ROAD ASSESSMENT
Page 19
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Norwalk ($679,457)
Excellent
Good
Fair
Poor
Very Poor
56.4 55.0 54.2 54.7 55.0 55.9 55.8 56.3 55.7 55.2
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF PLEASANT HILLAnnual Maintenance (6-Year Average): $579,915
Miles of Road Measured: 46
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
12.7 18.1 16.5 19.5 19.0 19.8 23.9 21.9 21.3 16.1
2013 LOCAL ROAD ASSESSMENT
Page 20
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Pleasant Hill ($579,915)
Excellent
Good
Fair
Poor
Very Poor
58.7 58.1 58.8 57.8 58.5 58.4 58.2 58.3 58.0 58.0
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF POLK CITYAnnual Maintenance (6-Year Average): $253,022
Miles of Road Measured: 22
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
13.7 19.5 19.7 19.0 18.9 18.9 19.6 26.3 28.1 28.6
2013 LOCAL ROAD ASSESSMENT
Page 21
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Polk City ($253,022)
Excellent
Good
Fair
Poor
Very Poor
59.9 59.2 57.9 57.2 57.5 56.7 55.5 55.0 53.5 52.4
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF URBANDALEAnnual Maintenance (6-Year Average): $2,042,375
Miles of Road Measured: 190
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
16.4 20.2 18.4 18.8 18.5 23.0 24.8 27.8 29.1 29.4
2013 LOCAL ROAD ASSESSMENT
Page 22
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Urbandale ($2,042,375)
Excellent
Good
Fair
Poor
Very Poor
55.7 54.3 54.6 54.1 54.7 53.5 53.1 53.0 52.5 51.8
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF WAUKEEAnnual Maintenance (6-Year Average): $559,356
Miles of Road Measured: 62
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
9.7 12.4 12.3 14.3 11.0 14.5 17.4 25.2 23.9 27.0
2013 LOCAL ROAD ASSESSMENT
Page 23
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Waukee ($559,356)
Excellent
Good
Fair
Poor
Very Poor
62.5 60.8 59.0 57.5 57.4 56.2 55.3 54.3 53.8 53.4
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF WEST DES MOINESAnnual Maintenance (6-Year Average): $2,237,219
Miles of Road Measured: 275
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
14.9 20.0 20.9 22.1 22.1 23.8 25.6 25.8 26.8 26.4
2013 LOCAL ROAD ASSESSMENT
Page 24
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
West Des Moines ($2,237,219)
Excellent
Good
Fair
Poor
Very Poor
58.7 57.8 56.8 55.7 55.4 54.4 53.6 52.9 52.0 51.2
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
CITY OF WINDSOR HEIGHTSAnnual Maintenance (6-Year Average): $498,948
Miles of Road Measured: 22
PAVEMENT QUALITY
AVERAGE CONDITION (PCI)
Percent of Roads in Poor or Worse Condition2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
49.0 55.9 51.3 45.7 32.2 25.8 19.4 16.2 13.2 11.5
2013 LOCAL ROAD ASSESSMENT
Page 25
0
10
20
30
40
50
60
70
80
90
100
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
% o
f all
road
s
Year
Windsor Heights ($498,948)
Excellent
Good
Fair
Poor
Very Poor
40.444.5
48.452.5
58.6 62.2 64.9 66.2 64.7 63.8
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Aver
age
PCI
Year
Average Condition (PCI)
TABLES BY JURISDICTION
The following tables break down pavement conditions for each member community by year and condition using current maintenance budgets. Numbers in the chart represent the percent of all roads within the community.
ALTOONA ($696,106)
Year Very Poor Poor Fair Good Excellent2014 0.8 15.2 38.2 31.9 13.92015 1.3 18.6 38.3 30.3 11.52016 0.3 20.0 39.2 29.0 11.52017 0.1 20.6 38.8 28.3 12.22018 0.1 20.1 39.0 28.8 12.02019 0.3 21.2 39.6 26.1 12.82020 0.3 21.7 41.1 24.2 12.82021 0.5 21.7 45.2 22.7 10.02022 1.2 22.7 44.0 23.8 8.22023 1.5 24.3 43.1 24.1 6.9
ANKENY ($1,544,627)
Year Very Poor Poor Fair Good Excellent2014 4.6 12.2 26.0 38.6 18.62015 1.2 13.4 33.6 36.5 15.32016 0.6 11.7 37.7 37.1 12.82017 0.3 13.0 41.0 32.7 12.92018 0.1 13.6 44.8 30.2 11.32019 0.0 15.3 48.7 25.1 10.92020 0.0 17.4 48.3 24.5 9.72021 0.0 21.4 48.2 22.1 8.32022 0.3 24.6 45.3 22.0 7.82023 0.9 26.0 43.2 23.7 6.3
BONDURANT ($256,328)
Year Very Poor Poor Fair Good Excellent2014 0.0 10.0 46.7 32.4 10.92015 0.0 12.0 52.4 23.1 12.52016 0.0 22.0 43.7 20.9 13.42017 0.0 23.2 40.4 21.6 14.92018 0.0 24.5 39.8 19.1 16.62019 0.0 24.4 38.2 20.8 16.62020 0.0 29.2 34.7 20.3 15.92021 5.0 27.2 30.5 23.2 14.12022 5.0 24.6 33.0 24.2 13.22023 5.4 24.9 29.3 28.3 12.2
CARLISLE ($343,530)
Year Very Poor Poor Fair Good Excellent2014 1.2 15.6 34.9 27.3 21.02015 0.5 17.3 40.3 21.2 20.62016 0.0 20.7 35.0 24.7 19.62017 0.0 16.4 36.2 27.3 20.02018 0.0 19.3 32.7 25.9 22.02019 0.0 21.1 30.3 23.5 25.12020 0.0 21.2 35.1 18.4 25.32021 0.0 23.6 33.4 19.2 23.82022 0.0 20.3 31.8 26.2 21.82023 0.9 19.1 30.0 28.6 21.4
CLIVE ($1,662,341)
Year Very Poor Poor Fair Good Excellent2014 4.1 17.7 34.0 33.5 10.82015 5.5 19.2 33.4 32.4 9.42016 4.7 19.5 36.5 30.8 8.52017 3.9 18.8 38.9 29.5 8.92018 3.2 17.0 42.1 29.0 8.82019 2.4 16.4 44.5 27.5 9.22020 1.7 15.2 48.8 25.7 8.62021 1.1 16.4 51.5 23.3 7.72022 0.5 20.4 49.9 22.3 7.02023 0.0 23.6 47.5 22.1 6.8
CUMMING ($27,451)
Year Very Poor Poor Fair Good Excellent2014 0.0 0.0 43.1 51.3 5.62015 0.0 3.2 46.9 42.6 7.32016 0.0 3.2 45.1 45.5 6.12017 0.0 11.8 39.2 43.9 5.12018 0.0 20.1 40.3 32.9 6.72019 0.0 34.3 40.0 19.1 6.72020 3.2 33.2 51.3 4.2 8.02021 3.2 40.1 45.5 4.2 7.02022 11.8 30.8 45.0 6.0 6.42023 18.3 28.0 38.4 9.8 5.5
DES MOINES ($15,551,818)
Year Very Poor Poor Fair Good Excellent2014 7.0 22.8 40.0 21.7 8.42015 4.7 26.1 37.8 19.4 12.02016 1.0 27.7 37.7 17.1 16.62017 0.7 27.7 35.5 14.5 21.72018 1.6 24.7 32.8 15.7 25.12019 2.3 23.7 29.9 14.9 29.12020 3.1 20.7 27.2 18.2 30.92021 4.0 18.5 27.1 21.4 29.12022 4.9 16.0 24.7 27.3 27.12023 5.3 15.1 23.6 30.9 25.1
GRIMES ($913,603)
Year Very Poor Poor Fair Good Excellent2014 1.1 15.2 20.6 45.9 17.32015 2.1 13.6 24.4 47.1 12.72016 2.0 14.2 28.6 47.9 7.32017 2.5 11.9 31.8 45.8 8.02018 0.3 10.7 40.8 37.8 10.42019 0.0 11.4 49.0 25.6 14.02020 0.0 9.8 53.4 18.3 18.42021 0.0 12.3 49.7 16.2 21.82022 0.0 13.7 49.1 11.8 25.42023 0.0 15.2 43.0 13.7 28.0
JOHNSTON ($1,218,221)
Year Very Poor Poor Fair Good Excellent2014 0.1 11.5 34.6 40.1 13.62015 0.2 12.8 38.2 37.6 11.22016 0.4 14.8 43.7 31.6 9.62017 0.0 18.3 45.7 26.5 9.52018 0.0 17.6 50.0 23.0 9.42019 0.0 17.0 50.0 20.8 12.32020 0.0 16.8 47.5 21.5 14.12021 0.0 18.0 45.9 20.4 15.62022 0.0 22.3 38.3 22.1 17.42023 0.0 24.1 34.4 23.4 18.1
Page 26
MITCHELLVILLE ($58,568)
Year Very Poor Poor Fair Good Excellent2014 0.0 6.9 49.3 40.2 3.62015 0.0 6.9 46.7 31.8 14.62016 0.0 9.0 50.8 25.0 15.22017 0.0 12.9 51.9 19.9 15.32018 0.0 23.0 50.3 13.3 13.42019 0.0 37.8 35.0 14.2 13.02020 2.2 41.8 33.4 11.9 10.72021 4.4 49.3 24.9 14.0 7.52022 8.5 49.9 19.1 14.3 8.22023 18.2 44.4 16.0 12.7 8.6
NORWALK ($679,457)
Year Very Poor Poor Fair Good Excellent2014 0.8 16.1 39.3 35.0 8.82015 0.8 18.7 42.4 33.1 4.92016 0.3 22.6 46.1 24.5 6.52017 0.0 20.2 44.7 26.0 9.02018 0.0 23.5 41.1 24.2 11.22019 0.0 21.3 41.9 23.9 12.92020 0.0 21.3 42.5 20.5 15.72021 0.0 25.7 38.1 19.1 17.12022 1.3 25.7 38.2 17.8 17.12023 1.7 22.9 38.9 20.2 16.4
PLEASANT HILL ($579,915)
Year Very Poor Poor Fair Good Excellent2014 3.7 9.0 41.7 31.2 14.42015 3.0 15.1 41.5 24.5 15.92016 0.0 16.5 44.7 23.1 15.72017 0.0 19.5 39.4 23.0 18.12018 0.0 19.0 37.1 25.6 18.42019 0.0 19.8 37.0 23.5 19.82020 0.0 23.9 31.4 25.3 19.42021 0.0 21.9 34.8 27.1 16.32022 0.0 21.3 36.0 28.0 14.82023 0.0 16.1 38.1 32.7 13.1
POLK CITY ($253,022)
Year Very Poor Poor Fair Good Excellent2014 1.8 11.9 35.1 35.9 15.22015 0.3 19.3 34.4 34.8 11.32016 0.0 19.7 35.9 33.3 11.12017 0.0 19.0 38.4 29.2 13.52018 0.0 18.9 34.4 32.0 14.72019 0.0 18.9 42.5 21.5 17.12020 0.0 19.6 46.4 16.9 17.12021 0.0 26.3 43.2 16.5 13.92022 1.2 26.9 40.8 17.9 13.32023 2.4 26.2 37.2 21.9 12.3
URBANDALE ($2,042,375)
Year Very Poor Poor Fair Good Excellent2014 3.2 13.3 41.0 34.8 7.72015 3.5 16.7 44.1 29.4 6.42016 1.3 17.1 48.8 25.1 7.72017 1.0 17.8 48.9 23.6 8.72018 0.2 18.4 49.2 23.1 9.22019 0.2 22.9 45.2 22.0 9.82020 0.2 24.6 43.3 21.2 10.72021 0.3 27.5 42.7 19.2 10.32022 0.7 28.5 38.9 23.7 8.32023 1.1 28.3 37.5 25.4 7.7
WAUKEE ($559,356)
Year Very Poor Poor Fair Good Excellent2014 0.4 9.3 30.3 44.6 15.42015 0.2 12.2 35.6 41.7 10.32016 0.1 12.2 40.1 38.2 9.42017 0.0 14.3 44.4 31.5 9.82018 0.0 11.0 52.9 25.0 11.12019 0.0 14.5 51.3 21.9 12.32020 0.0 17.4 48.9 21.3 12.42021 0.0 25.2 47.4 14.2 13.22022 0.0 23.9 45.2 18.7 12.22023 0.0 27.0 39.9 22.3 10.8
WEST DES MOINES ($2,237,219)
Year Very Poor Poor Fair Good Excellent2014 1.2 13.8 39.2 30.2 15.72015 1.2 18.7 36.8 30.8 12.42016 0.5 20.5 37.9 29.1 12.12017 0.4 21.6 38.9 26.1 12.92018 1.0 21.0 38.3 27.9 11.82019 1.9 21.9 37.0 27.3 11.82020 2.3 23.3 36.9 26.7 10.82021 3.3 22.6 41.4 25.2 7.52022 3.1 23.7 40.9 26.3 6.02023 3.9 22.5 40.5 28.6 4.5
WINDSOR HEIGHTS ($498,948)
Year Very Poor Poor Fair Good Excellent2014 21.1 27.8 35.9 7.4 7.72015 19.0 36.9 24.5 4.4 15.22016 13.6 37.7 20.4 6.0 22.32017 12.0 33.7 17.3 8.1 28.82018 12.6 19.6 14.3 20.2 33.32019 10.0 15.8 11.9 22.9 39.42020 6.6 12.8 13.2 28.7 38.72021 5.0 11.2 23.0 25.1 35.62022 4.5 8.8 27.7 28.1 31.02023 3.0 8.4 29.4 32.5 26.7
Page 27
TABLES BY JURISDICTION (CONT’D)