Vital Signs: Bridge Condition – by metro
VITAL SIGNS INDICATOR
Bridge Condition (T18)
FULL MEASURE NAME
Structurally deficient share of bridge deck area
LAST UPDATED
May 2017
DESCRIPTION
Bridge condition is measured by the share of bridges and overpasses flagged as structurally deficient, weighted by bridge deck area to capture the relative size of the bridge. In short, this measure reflects the integrity of regional bridges and overpasses. Structural deficiency is identified based on the condition of the structure as assessed by engineering professionals (as opposed to just the roadway surface). The dataset includes metropolitan area, regional, county, and individual bridge tables.
DATA SOURCE
Federal Highway Administration: National Bridge Inventory (1992-2016)
http://www.fhwa.dot.gov/bridge/nbi.cfm
CONTACT INFORMATION
vitalsigns.info@mtc.ca.gov
METHODOLOGY NOTES (across all datasets for this indicator)
Regional performance was examined by summing all of the bridge deck area flagged as structurally deficient and dividing it by total bridge deck area. Metro comparisons were performed using current MSA boundaries and using the counties included to calculate past performance in those geographies; for the Bay Area, the nine-county region reflects regional performance instead of separate MSAs.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"bayareametro-gov/vital-signs-bridge-condition-by-metro-qdfc-2qjh\".\"vital_signs_bridge_condition_by_metro\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.