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

Download NBI ASCII files 2007

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,954	1,142	254
Alaska	1,266	109	0
Arizona	7,445	1,235	55
Arkansas	12,563	509	1,094
California	24,308	7,616	3,096
Colorado	8,590	963	15
Connecticut	4,175	953	298
Delaware	858	203	93
District of Columbia	249	86	0
Florida	11,695	2,823	891
Georgia	14,600	1,895	492
Hawaii	1,145	45	0
Idaho	4,156	430	4
Illinois	26,010	3,696	267
Indiana	18,495	1,902	0
Iowa	24,782	1,130	114
Kansas	25,704	1,365	26
Kentucky	13,653	1,806	220
Louisiana	13,424	601	252
Maine	2,387	443	0
Maryland	5,149	1,044	62
Massachusetts	5,042	74	540
Michigan	10,930	3,300	7
Minnesota	19,737	2,025	846
Mississippi	17,032	185	1,176
Missouri	24,096	827	2,337
Montana	5,215	680	6
Nebraska	15,478	625	198
Nevada	1,751	342	53
New Hampshire	3,809	274	4
New Jersey	6,464	2,096	886
New Mexico	3,875	610	59
New York	17,448	4,348	1,009
North Carolina	19,013	4,524	0
North Dakota	4,464	260	1
Ohio	28,003	5,224	0
Oklahoma	23,534	2,038	81
Oregon	7,346	671	192
Pennsylvania	22,352	2,736	4,312
Puerto Rico	2,147	469	31
Rhode Island	792	225	14
South Carolina	9,255	1,052	0
South Dakota	5,926	414	60
Tennessee	20,139	2,677	285
Texas	50,330	7,903	20
Utah	2,887	916	10
Vermont	2,714	313	6
Virginia	14,167	2,547	943
Washington	7,745	881	310
West Virginia	7,021	1,163	300
Wisconsin	13,834	2,618	0
Wyoming	3,051	298	0
Totals	612,205	82,311	20,919

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 (54 mb).
Download Highway Bridges for all States (in a single file) as a zip file zip file (54 mb)

Comma Delimited
State	5a=1	5a=2	5a=A to Z
Alabama	15,954	1,142	254
Alaska	1,266	109	0
Arizona	7,445	1,235	55
Arkansas	12,563	509	1,094
California	24,308	7,616	3,096
Colorado	8,590	963	15
Connecticut	4,175	953	298
Delaware	858	203	93
District of Columbia	249	86	0
Florida	11,695	2,823	891
Georgia	14,600	1,895	492
Hawaii	1,145	45	0
Idaho	4,156	430	4
Illinois	26,010	3,696	267
Indiana	18,495	1,902	0
Iowa	24,782	1,130	114
Kansas	25,704	1,365	26
Kentucky	13,653	1,806	220
Louisiana	13,424	601	252
Maine	2,387	443	0
Maryland	5,149	1,044	62
Massachusetts	5,042	74	540
Michigan	10,930	3,300	7
Minnesota	19,737	2,025	846
Mississippi	17,032	185	1,176
Missouri	24,096	827	2,337
Montana	5,215	680	6
Nebraska	15,478	625	198
Nevada	1,751	342	53
New Hampshire	3,809	274	4
New Jersey	6,464	2,096	886
New Mexico	3,875	610	59
New York	17,448	4,348	1,009
North Carolina	19,013	4,524	0
North Dakota	4,464	260	1
Ohio	28,003	5,224	0
Oklahoma	23,534	2,038	81
Oregon	7,346	671	192
Pennsylvania	22,352	2,736	4,312
Puerto Rico	2,147	469	31
Rhode Island	792	225	14
South Carolina	9,255	1,052	0
South Dakota	5,926	414	60
Tennessee	20,139	2,677	285
Texas	50,330	7,903	20
Utah	2,887	916	10
Vermont	2,714	313	6
Virginia	14,167	2,547	943
Washington	7,745	881	310
West Virginia	7,021	1,163	300
Wisconsin	13,834	2,618	0
Wyoming	3,051	298	0
Totals	612,205	82,311	20,919