Strategic Measure_Percentage of Major Bridges in Good to Excellent Condition

This table contains aggregated bridge condition data for each fiscal year beginning in FY2015. The major structures having openings of 20 feet or greater are inspected every other year by Texas Department of Transportation (TxDOT). Inspection of the smaller minor structures is not mandated by the Federal government and is managed entirely by the City.

View more details and insights related to this data set on the story page: https://data.austintexas.gov/stories/s/ajuu-uvjm.

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 \"datahub-austintexas-gov/strategic-measurepercentage-of-major-bridges-in-tymk-z6zh\".\"strategic_measurepercentage_of_major_bridges_in\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.