1 of 20

2025 Roads System Condition Research Tracking File

1

2 of 20

2025 Modifications

Want to reduce components to ~10 to simplify.
Remove FAE Faulting/Rutting/Cracking. Data is not consistently reported. (Original Index accounted for data unreliability by weighting each of these at only 2%, but it’s even worse than I thought.)
Remove Functional System IRI data. It is redundant. (I thought that there may be a story to tell in how data broke down by road type, by I never got a story out of this and no one ever cared.)
Remove NHS IRI data. It is redundant with TPM data.
Add FAE Roughness Good.
Replace TPM Bridge data with NBI Bridge data.

2

Add FAE – IRI/PSR Good

Replace with NBI data.

3 of 20

Roughness (poor condition) on the Federal Aid Network

3

	State	Rural	Urban	Total	NoData	IndexScore
1	Indiana	1.8%	4.7%	2.6%	60.2%	100.0
2	South Dakota	3.3%	4.5%	3.3%	0.3%	98.3
3	Kansas	3.4%	10.2%	3.8%	45.1%	97.2
4	Wyoming	4.7%	11.4%	5.1%	1.5%	94.1
5	Vermont	2.9%	11.6%	5.1%	0.7%	94.0
6	Nebraska	4.8%	13.8%	5.9%	10.0%	92.3
7	Tennessee	2.7%	8.8%	5.9%	6.3%	92.1
8	Idaho	5.2%	14.9%	6.2%	54.7%	91.4
9	Georgia	4.9%	9.3%	6.5%	0.0%	90.8
10	North Dakota	4.3%	40.5%	6.6%	0.0%	90.4
11	New Jersey	1.7%	8.3%	7.5%	0.0%	88.5
12	West Virginia	6.2%	13.6%	8.2%	1.0%	86.6
13	Alabama	4.7%	17.0%	8.4%	18.8%	86.3
14	Iowa	6.3%	18.0%	8.8%	79.4%	85.4
15	Kentucky	5.9%	19.1%	9.1%	6.9%	84.6
16	Oregon	9.6%	8.1%	9.2%	0.6%	84.4
17	Minnesota	7.9%	14.7%	9.5%	1.9%	83.8
18	Montana	8.6%	36.2%	10.8%	0.6%	80.6
19	Utah	9.1%	18.9%	11.3%	0.3%	79.3
20	North Carolina	8.1%	20.2%	12.4%	0.8%	76.8
21	Florida	4.5%	17.3%	12.8%	0.3%	75.9
22	Ohio	4.1%	26.5%	14.4%	1.1%	72.1
23	Nevada	7.7%	27.3%	14.7%	0.0%	71.3
24	Delaware	5.2%	22.3%	15.8%	1.3%	68.8
25	Maine	15.6%	21.6%	16.6%	0.1%	66.7
26	New Hampshire	13.7%	21.9%	17.0%	0.0%	65.8
27	Virginia	14.9%	21.7%	17.3%	15.5%	65.2
28	South Carolina	17.6%	23.7%	19.5%	8.3%	59.9
29	Illinois	5.8%	37.2%	19.6%	0.0%	59.7
30	Arkansas	22.2%	14.9%	20.5%	0.4%	57.6
31	MICHIGAN	12.6%	36.1%	20.8%	2.8%	56.8
32	Alaska	19.0%	33.4%	22.5%	9.5%	52.9
33	Texas	12.3%	41.1%	23.2%	1.3%	51.1
34	Colorado	17.4%	37.1%	23.9%	0.0%	49.4
35	Missouri	20.5%	38.7%	24.5%	0.1%	48.1
36	New York	5.7%	38.3%	24.6%	1.3%	47.9
37	Wisconsin	16.2%	46.6%	24.9%	9.8%	47.1
38	Massachusetts	5.3%	29.7%	25.7%	55.0%	45.1
39	Arizona	12.2%	37.3%	25.8%	2.4%	45.1
40	Louisiana	19.2%	35.4%	26.1%	0.8%	44.3
41	Oklahoma	25.9%	33.5%	26.9%	17.2%	42.4
42	Pennsylvania	19.8%	35.7%	27.4%	5.3%	41.2
43	California	18.5%	39.7%	28.0%	1.8%	39.6
44	Maryland	7.6%	38.3%	28.7%	0.2%	38.0
45	Washington	21.7%	41.4%	29.6%	3.4%	35.9
46	Mississippi	27.4%	40.9%	29.9%	0.1%	35.3
47	Connecticut	15.6%	33.4%	30.0%	0.0%	35.1
48	New Mexico	31.1%	39.5%	33.0%	0.8%	27.9
49	Hawaii	29.9%	44.4%	39.2%	0.6%	13.1
50	Rhode Island	29.1%	48.8%	44.7%	1.4%	0.0

Data from FHWA Table HM-47i, 2023. According to the HPMS field manual, this data should cover all FAE roads except minor rural collectors.
Table provides percentage of FAE pavement in poor condition by roughness (IRI or PSC), ranging from 2.6% (Indiana) to 44.7% (Rhode Island).
Notably, Indiana did not report on 60% of the FAE network identified as reportable.
Michigan reported roughness data for 32,609 miles of FAE pavement. Michigan listed 926 miles as “not reported” (2.8%).
Of reported mileage, Michigan reported 12.6% of rural routes in poor condition, ranking 31^st. Michigan reported 36.1% of urban routes in poor condition, ranking 34^th.
With 2.8% of all reported FAE pavement in poor condition by roughness, Michigan ranks 31^st nationally with a component index score of 56.8.

Consider modifying index score to account for unreported data. First check that unreported data makes sense as a percentage of states’ FAE network.

4 of 20

Roughness (good condition) on the Federal Aid Network

4

Data from FHWA Table HM-47i, 2023. According to the HPMS field manual, this data should cover all FAE roads except minor rural collectors.
Table provides percentage of FAE pavement in good condition by roughness (IRI or PSC), ranging from 77.9% (Vermont) to 18.0% (Rhode Island).
Notably, Indiana did not report on 60% of the FAE network identified as reportable.
Michigan reported roughness data for 32,609 miles of FAE pavement. Michigan listed 926 miles as “not reported” (2.8%).
Of reported mileage, Michigan reported 56.1% of rural routes in good condition, ranking 26^th. Michigan reported 34.6% of urban routes in good condition, ranking 23^rd.
With 48.6% of all reported FAE pavement in poor condition by roughness, Michigan ranks 24^th nationally with a component index score of 51.5.

Consider modifying index score to account for unreported data. First check that unreported data makes sense as a percentage of states’ FAE network.

5 of 20

FAE Roughness

5

6 of 20

Interstate PCM Condition�(2022 Data)�*Michigan data 2021

6

7 of 20

Interstate PCM 2022

7

8 of 20

Non-Interstate PCM Condition�2022 Data�*Ohio Data 2021

8

9 of 20

Non-Interstate PCM 2022

9

10 of 20

Percentage of NHS Traffic by IRI 2023

10

11 of 20

ADT by IRI

11

12 of 20

Bridge Condition 2024

12

13 of 20

Preliminary Final System Condition Index Scores

13

14 of 20

Previous Index (for reference)

14

15 of 20

Updated Scatterplot

15

16 of 20

Alternate Scatterplot�Plots same System Condition Index against Decade Average Funding Index (not the weighted Index that emphasizes the final 3 years)�It doesn’t make much difference. The trend is basically the same. Michigan does appear less well-funded as we have been well-funded in 2020-2022.

16

17 of 20

More data:�Percentage of NHS Traffic by IRI broken down further.

17

18 of 20

Cracking (poor condition) on the Federal Aid Network

18

Data from FHWA Table HM-47h, 2023. According to the HPMS field manual, this data is only required on the NHS system, but many states report additional FAE mileage.
Table provides percentage of FAE pavement in poor condition by cracking, ranging from 0% (Vermont) to 30.8% (Alabama).
Notably, Vermont reported cracking data on only 118 miles—likely the NHS routes only.
Michigan reported cracking data for 23,569 miles of FAE pavement. Michigan listed 1,842 miles as “not reported.”
Of reported mileage, Michigan reported 19.5% of rural routes in poor condition, ranking 39^th. Michigan reported 15.4% of urban routes in poor condition, ranking 39^th.
With 2.8% of all reported FAE pavement in poor condition by cracking, Michigan ranks 39^th nationally with a component index score of 38.5

	State	Rural	Urban	Total	IndexScore
1	Vermont	0.0%	0.0%	0.0%	100.0
2	North Dakota	0.4%	0.3%	0.4%	98.7
3	Virginia	0.6%	0.9%	0.7%	97.8
4	Texas	0.6%	3.0%	1.1%	96.3
5	South Dakota	1.6%	0.0%	1.6%	94.9
6	Montana	1.6%	7.9%	1.7%	94.4
7	Ohio	2.2%	1.4%	2.1%	93.3
8	Idaho	2.4%	1.2%	2.3%	92.6
9	Nevada	2.2%	3.5%	2.3%	92.5
10	Washington	2.4%	4.1%	2.7%	91.2
11	Minnesota	2.9%	6.1%	3.1%	90.1
12	Alaska	5.1%	1.1%	4.8%	84.4
13	Utah	4.6%	7.7%	5.1%	83.5
14	Pennsylvania	5.5%	5.2%	5.5%	82.3
15	New Jersey	5.4%	6.1%	5.9%	80.8
16	New Mexico	5.7%	13.0%	6.2%	80.0
17	Hawaii	5.9%	6.5%	6.2%	80.0
18	Nebraska	5.5%	14.3%	6.2%	80.0
19	Kansas	6.0%	15.8%	6.5%	79.0
20	California	3.6%	11.3%	6.6%	78.5
21	Wyoming	7.1%	6.0%	7.1%	77.1
22	Connecticut	10.7%	6.0%	8.3%	73.1
23	Massachusetts	11.3%	8.2%	8.9%	71.1
24	Indiana	10.9%	9.9%	10.8%	65.1
25	Delaware	15.9%	2.1%	11.0%	64.3
26	Maryland	11.3%	11.5%	11.4%	63.0
27	Maine	11.8%	4.4%	11.4%	62.9
28	Wisconsin	12.1%	10.9%	11.9%	61.2
29	Kentucky	12.4%	7.3%	12.0%	61.2
30	Iowa	11.9%	12.6%	12.0%	61.0
31	Colorado	13.2%	8.0%	12.4%	59.6
32	West Virginia	14.1%	9.7%	13.1%	57.5
33	North Carolina	13.8%	9.9%	13.3%	57.0
34	Georgia	15.5%	9.7%	14.6%	52.7
35	Oregon	15.5%	23.1%	16.2%	47.5
36	Arkansas	16.4%	17.5%	16.6%	46.3
37	Florida	21.7%	8.7%	17.1%	44.5
38	Rhode Island	15.7%	19.9%	18.1%	41.3
39	Michigan	19.5%	15.4%	19.0%	38.5
40	New Hampshire	21.5%	9.1%	19.4%	37.2
41	Oklahoma	19.8%	12.0%	19.4%	37.1
42	Missouri	20.9%	13.2%	20.3%	34.3
43	Tennessee	18.5%	22.8%	20.7%	32.9
44	Arizona	21.2%	19.1%	20.9%	32.2
45	South Carolina	23.4%	5.6%	21.8%	29.3
46	New York	28.0%	17.6%	24.8%	19.6
47	Illinois	26.4%	25.0%	26.1%	15.4
48	Mississippi	26.2%	32.0%	26.6%	13.6
49	Louisiana	31.2%	17.4%	28.3%	8.3
50	Alabama	31.8%	22.4%	30.8%	0.0

19 of 20

Rutting and Faulting on FAE

19

	State	Rural	Urban	Total	IndexScore
1	Georgia	0.0%	0.2%	0.1%	100.0
2	Minnesota	0.1%	0.2%	0.1%	99.9
3	Connecticut	0.2%	0.2%	0.2%	99.5
4	Virginia	0.1%	0.5%	0.2%	99.1
5	California	0.2%	0.4%	0.3%	99.0
6	Indiana	0.3%	0.2%	0.3%	98.8
7	Kentucky	0.3%	0.2%	0.3%	98.8
8	Nevada	0.3%	0.4%	0.3%	98.7
9	Delaware	0.8%	0.1%	0.4%	98.4
10	Colorado	0.3%	0.6%	0.4%	98.2
11	New Jersey	0.4%	0.4%	0.4%	98.2
12	North Carolina	0.5%	0.4%	0.4%	98.0
13	Tennessee	0.0%	0.9%	0.5%	97.8
14	South Dakota	0.5%	1.7%	0.5%	97.7
15	Oklahoma	0.4%	1.5%	0.5%	97.7
16	Arizona	0.6%	0.4%	0.5%	97.6
17	Kansas	0.5%	1.0%	0.5%	97.5
18	Texas	0.4%	1.0%	0.6%	97.3
19	North Dakota	0.5%	2.0%	0.6%	97.1
20	Nebraska	0.7%	0.1%	0.7%	96.7
21	Wyoming	0.6%	1.3%	0.7%	96.7
22	Hawaii	0.9%	0.6%	0.7%	96.3
23	Vermont	0.0%	100.0%	0.7%	96.3
24	Illinois	0.5%	1.2%	0.8%	96.0
25	Missouri	1.3%	0.4%	1.1%	94.1
26	Ohio	0.7%	1.7%	1.2%	93.9
27	West Virginia	0.5%	3.2%	1.2%	93.6
28	Utah	1.5%	0.9%	1.4%	92.6
29	Florida	1.8%	1.2%	1.4%	92.5
30	Pennsylvania	1.8%	1.0%	1.4%	92.4
31	Iowa	1.5%	1.2%	1.5%	92.1
32	New York	0.9%	2.0%	1.5%	91.9
33	Alabama	1.8%	1.1%	1.6%	91.2
34	MICHIGAN	1.3%	2.8%	1.7%	90.9
35	South Carolina	2.1%	2.1%	2.1%	88.3
36	Arkansas	2.7%	1.5%	2.5%	85.9
37	Wisconsin	3.0%	1.2%	2.6%	85.6
38	Washington	3.2%	4.0%	3.6%	80.0
39	Massachusetts	0.8%	4.3%	3.7%	79.2
40	New Hampshire	4.3%	3.2%	3.8%	78.4
41	New Mexico	4.2%	3.5%	4.0%	77.3
42	Rhode Island	2.1%	4.7%	4.2%	76.4
43	Maryland	2.2%	5.8%	4.7%	73.6
44	Montana	5.0%	13.0%	5.7%	67.9
45	Oregon	5.6%	6.4%	5.8%	67.0
46	Idaho	6.0%	6.8%	6.1%	65.2
47	Maine	6.8%	10.8%	7.5%	57.4
48	Alaska	6.9%	14.7%	8.8%	49.9
49	Mississippi	9.8%	7.8%	9.5%	45.9
50	Louisiana	19.3%	14.3%	17.4%	0.0

	State	Total	IndexScore
1	Tennessee	5.2%	NA
2	Maryland	10.2%	NA
3	Alabama	0.2%	NA
4	South Carolina	3.0%	NA
5	Connecticut	0.0%	NA
6	Alaska	#DIV/0!	NA
7	Maine	#DIV/0!	NA
8	Massachusetts	#DIV/0!	NA
9	New Hampshire	#DIV/0!	NA
10	Rhode Island	#DIV/0!	NA
11	Vermont	#DIV/0!	NA
12	Montana	0.0%	100.0
13	Ohio	0.0%	99.9
14	West Virginia	0.0%	99.9
15	Indiana	0.1%	99.6
16	South Dakota	0.2%	99.0
17	Idaho	0.4%	98.4
18	Pennsylvania	0.4%	98.3
19	Arizona	0.4%	98.2
20	Minnesota	0.5%	98.1
21	Kansas	0.5%	97.7
22	Missouri	0.6%	97.3
23	North Dakota	0.7%	97.1
24	Nevada	1.0%	95.8
25	Georgia	1.0%	95.7
26	New Mexico	1.3%	94.6
27	Washington	1.4%	94.2
28	Florida	1.5%	93.8
29	Kentucky	1.7%	93.0
30	California	1.9%	91.8
31	Arkansas	2.0%	91.5
32	Nebraska	2.1%	91.2
33	Iowa	2.2%	90.9
34	Hawaii	2.9%	87.9
35	Colorado	3.0%	87.5
36	Oklahoma	3.6%	84.6
37	Virginia	3.9%	83.7
38	Wyoming	4.5%	81.2
39	Oregon	4.9%	79.5
40	Illinois	5.3%	77.6
41	MICHIGAN	6.3%	73.6
42	Mississippi	6.6%	72.2
43	Utah	6.6%	72.1
44	Wisconsin	7.1%	70.1
45	Louisiana	7.4%	68.8
46	North Carolina	7.6%	67.8
47	Delaware	8.9%	62.7
48	Texas	13.4%	43.4
49	New York	16.1%	31.9
50	New Jersey	23.7%	0.0

Investigation into reported data suggests that reporting is very inconsistent. Data includes many FAE miles optionally submitted by states.
This was used in the first version of the Index score, yet each component contributed only 2% of the final Index.
Given greater understanding of the nature of this data, this will not be used in the updated index score.

The only somewhat meaningful data on the entire FAE network is the roughness data. All other metrics are reliable only when applied to the NHS.

Rutting (poor)

Faulting (poor)

20 of 20

50

41

19

29

36

49

42