National Bridge Inventory - CSV format

National Bridge Inventory - CSV format

Source:
U.S. Department of Transportations Federal Highway Administration
File size:
407 MB (main table, 2008)
Dates covered:
Inspections 1994, 1996-2008
Costs:
Note: For special orders, like state slices, please click here for information.
  • 50-200 market or circulation below 50,000: $60.00
  • 26-50 market or circulation 50,000-100,000: $120.00
  • Top 25 market or circulation over 100,000: $160.00




The U.S. Department of Transportations Federal Highway Administration National Bridge Inventory database lists structural evaluations and codes for all bridges in the U.S. This includes bridges on highways, railroads, pedestrian-bicycle bridges, overpasses and those designated as historically significant. The most recent data includes inspections in 2008. In each data file, the records represent the most recent inspection for each bridge (which could be several years ago, or could be the current year). The data include fields showing the year the bridge was built, how many lanes it has and several key fields that can be used for an overall indication of a bridges quality. There is also a field that indicates the feature intersected, for example if the bridge goes over a body of water or if it intersects with another highway or roadway.
Please note that this database is now being kept in CSV (comma-delimited text files) format. For a walkthrough on how to import text files into Microsoft Access, click here. If you prefer to have the data in dBase format, please click here

Record layouts and samples of this database:

Hover your mouse over any of the links below to see more information about each file.

Filename/TitleSize
Main documentation (readme.txt)17.78 KB
Record Layout (reclay.xls)42 KB
Record Sample (bridges100.xls)245.77 KB
Schema in PDF format (bridges.pdf)266.6 KB
Table structure - MySQL (create_table_bridges_mysql.txt)8.55 KB

  • Story No. 16374: KOMU's "computer-assisted investigation revealed that mid-Missouri's bridges are deteriorating and placing drivers into possibly dangerous situations every day... bridges dropping large pieces of concrete into traffic lanes on Interstate 70 ... the state had no plans to fix this problem anytime within the next five years... one in three bridges in mid-Missouri is structurally deficient.... it would take 49 years to fix the problems that current bridges have with current funding even though transportation officials say that an average bridge has a lifespan of 50 years...."
  • Story No. 12972: The Post-Bulletin examines an analysis which shows that Minnesota's deteriorating bridges aren't being repaired and replaced fast enough, forcing some counties to restrict or close bridges while they wait for money needed to repair. It would take $184 million to bring deficient bridges up to the highest standards. (November 12, 1994)
  • Story No. 15293: Mike Klahr was supposed to inspect the most dangerous bridges in middle Tennessee. But during WSMV-TV's surveillance, this Department of Transportation employee never went near a bridge. Instead, he ran a private painting business on state time, watered his lawn on state time, and often worked as little as one hour a day. One in four bridges is structurally deficient, and 29 bridges are so dangerous that people shouldn't be driving over them - yet they are open to the public.
  • Story No. 21886: One third of Ventura county's bridges were built before 1965 and 28 of them have been designated as "structurally deficient." But the county is still waiting for the funds to fix or replace them. California's winter floods in 2005 washed away one bridge and left others even more weakened. Dodge examines the Federal Highway Administration's Inventory and discusses funding problems as well as the potentially fatal consequences of continuing neglect.
  • Story No. 23307: "An examination of roadway bridge ratings revealed 'Nearly 60 heavily traveled bridges in the Philadelphia region are in disrepair and rated as bad as, or worse than, the condition of the Minnesota bridge that collapsed Aug. 1, according to state and federal data.'"
  • Story No. 23304: "There are 107 structurally deficient bridges in the state of Arizona, with inspection reports showing the need for significant repairs."