The National Bridge Inventory (NBI) captures the location and condition of our nation’s bridges. Below is a mashup with the NBI displayed within Google Maps. The NBI data is being stored in a Google Fusion Table.
Additional spatial information was pulled from ESRI’s county dataset. Spatial errors in the NBI (one of Louisiana’s bridges is in Bermuda?!?) and scaling issues in the county boundaries result in some odd errors. Most of these are found around the borders of the state, but there are few NBI locations sitting where they shouldn’t be – in the woods, in a building, in a lake (with no bridge in sight). Despite these problems, the dataset does let us visualize the distribution of infrastructure in desperate need of repair.
The marker style is driven by the condition:
0-25% – Large Red Marker;
25-50% – Small Red Marker;
50-75% – Small Yellow Marker;
75-100% – Small Green Marker.