opendata-maryland-gov/mdta-structurally-deficient-bridges-2011-to-2014-g2ds-rrjk
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 5 years ago
Indexed 2 hours ago

MDTA Structurally Deficient Bridges - 2011 to 2014

This measure provides the number of structurally deficient bridges and number of total bridges owned by MDTA. The latitude and longitude is also provided for the structurally deficient bridges.

The MDTA's Annual Inspection Report consists of a walk/climb through physical inspection resulting in a thorough hands-on inspection of all structures, roadways, tunnels and tunnel ventilation buildings (including the mechanical and electrical systems), drainage structures, toll plazas, Variable Message Signs (VMS), incident detection equipment housings and structures, retaining walls, noise barriers, traffic and safety equipment, and truck weigh scales under the jurisdiction of the Maryland Transportation Authority at the following facilities: I-95 (John F. Kennedy Memorial Highway), I-895 (Baltimore Harbor Tunnel Thruway), Seagirt Marine Terminal, Thomas J. Hatem Memorial Bridge, I-395 and I-95 in Baltimore City (Fort McHenry Tunnel), I-695 (Francis Scott Key Bridge), Harry W. Nice Memorial Bridge, the Bay Bridge (twin structures) and the Intercounty Connector (ICC/MD200). The annual inspection process includes the development of a Structural Inventory and Appraisal (SI&A) assessment that is submitted to the Federal Highway Administration each April for the preceding calendar year.The data for this measure is collected from the SI&A assessment that is performed yearly by the MDTA's facilities inspection consultant.

The MDTA continued to be successful in having 100 percent of its bridges fully operational and functioning (no weight restrictions), allowing all emergency vehicles, school buses, vehicles serving the economy of an area, and legally loaded vehicles to safely traverse. Bridges are considered structurally deficient if significant load carrying elements are found to be in a poor (or worse) condition due to deterioration and/or damage, or have a low weight restriction. The fact that a bridge is structurally deficient does not imply that it is unsafe.

Data submitted for the CY are provided in February, but the data is not provided to FHWA until April. In some cases, the number could change if repairs are made to a structurally deficient bridge.

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 \"opendata-maryland-gov/mdta-structurally-deficient-bridges-2011-to-2014-g2ds-rrjk\".\"mdta_structurally_deficient_bridges_2011_to_2014\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • mdta_structurally_deficient_bridges_2011_to_2014
     
     
     
     
     
Upstream Metadata