2009 - Download NBI ASCII files - National Bridge Inventory - Bridge Inspection - Safety - Bridges & Structures

Download NBI ASCII files 2009

These are prior data that apply a cancelled agency policy known as the 10-year rule. When applied, the '10-year rule' excluded bridges built or reconstructed within the prior 10 years since they were not generally eligible for Highway Bridge Program funding.

Instructions for importing the data into excel can be found here: Importing the data into MS Excel

Download Highway Bridges for all States (individual state files) as a zip file (51 mb).

No Delimiters
State	5a=1	5a=2	5a=A to Z
Alabama	15,989	1,140	254
Alaska	1,162	115	0
Arizona	7,529	1,242	50
Arkansas	12,579	507	1,117
California	24,481	7,436	3,018
Colorado	8,661	988	21
Connecticut	4,187	953	312
Delaware	862	212	84
District of Columbia	250	86	0
Florida	11,840	2,814	1,107
Georgia	14,712	1,937	502
Hawaii	1,165	48	0
Idaho	4,106	434	14
Illinois	26,285	3,742	284
Indiana	18,549	1,907	0
Iowa	24,799	1,133	124
Kansas	25,779	1,375	46
Kentucky	13,771	1,795	284
Louisiana	13,405	599	254
Maine	2,395	441	1
Maryland	5,202	1,090	120
Massachusetts	5,055	74	536
Michigan	10,906	3,296	9
Minnesota	13,132	2,065	868
Mississippi	17,056	189	1,183
Missouri	24,182	833	2,355
Montana	5,196	680	8
Nebraska	15,438	618	188
Nevada	1,794	355	54
New Hampshire	3,840	280	4
New Jersey	6,501	2,103	943
New Mexico	3,905	616	73
New York	17,457	4,505	703
North Carolina	19,199	4,968	0
North Dakota	4,445	262	1
Ohio	28,134	5,293	0
Oklahoma	23,719	2,042	95
Oregon	7,239	731	199
Pennsylvania	22,330	2,706	4,322
Puerto Rico	2,181	484	35
Rhode Island	768	229	38
South Carolina	9,253	1,056	0
South Dakota	5,921	432	60
Tennessee	20,215	2,693	296
Texas	51,173	8,244	19
Utah	2,910	839	8
Vermont	2,707	314	6
Virginia	14,272	2,554	1,079
Washington	7,717	822	313
West Virginia	7,056	1,174	302
Wisconsin	13,954	2,657	0
Wyoming	3,056	299	0
Totals	608,419	83,407	21,289

files are comma separated and the single quote is the text qualifier.

Download Highway Bridges for all States (individual state files) as a zip file (55 mb).
Download Highway Bridges for all States (in a single file) as a zip file zip file (55 mb)

Comma Delimited
State	5a=1	5a=2	5a=A to Z
Alabama	15,989	1,140	254
Alaska	1,162	115	0
Arizona	7,529	1,242	50
Arkansas	12,579	507	1,117
California	24,481	7,436	3,018
Colorado	8,661	988	21
Connecticut	4,187	953	312
Delaware	862	212	84
District of Columbia	250	86	0
Florida	11,840	2,814	1,107
Georgia	14,712	1,937	502
Hawaii	1,165	48	0
Idaho	4,106	434	14
Illinois	26,285	3,742	284
Indiana	18,549	1,907	0
Iowa	24,799	1,133	124
Kansas	25,779	1,375	46
Kentucky	13,771	1,795	284
Louisiana	13,405	599	254
Maine	2,395	441	1
Maryland	5,202	1,090	120
Massachusetts	5,055	74	536
Michigan	10,906	3,296	9
Minnesota	13,132	2,065	868
Mississippi	17,056	189	1,183
Missouri	24,182	833	2,355
Montana	5,196	680	8
Nebraska	15,438	618	188
Nevada	1,794	355	54
New Hampshire	3,840	280	4
New Jersey	6,501	2,103	943
New Mexico	3,905	616	73
New York	17,457	4,505	703
North Carolina	19,199	4,968	0
North Dakota	4,445	262	1
Ohio	28,134	5,293	0
Oklahoma	23,719	2,042	95
Oregon	7,239	731	199
Pennsylvania	22,330	2,706	4,322
Puerto Rico	2,181	484	35
Rhode Island	768	229	38
South Carolina	9,253	1,056	0
South Dakota	5,921	432	60
Tennessee	20,215	2,693	296
Texas	51,173	8,244	19
Utah	2,910	839	8
Vermont	2,707	314	6
Virginia	14,272	2,554	1,079
Washington	7,717	822	313
West Virginia	7,056	1,174	302
Wisconsin	13,954	2,657	0
Wyoming	3,056	299	0
Totals	608,419	83,407	21,289