bayareametro-gov/vital-signs-bridge-condition-bay-area-yiih-pfj5
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 5 years ago
Indexed 1 month ago

Vital Signs: Bridge Condition – Bay Area

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-bay-area-yiih-pfj5\".\"vital_signs_bridge_condition_bay_area\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • vital_signs_bridge_condition_bay_area