Strategic Measure_Infrastructure Condition_aggregated

This dataset provides an overall view of infrastructure condition for all assets included in the Comprehensive Infrastructure Assessment (CIA) for that year. Overall condition is calculated by multiplying condition percentages for each network by the current replacement value for that network. These values are then added up for each condition, and divided by the total current replacement value to calculate the percentage of all assets in each condition. Assets that do not have current replacement values or for which condition is unknown are excluded from these calculations.

Data comes from the survey of participating departments conducted every two years during the compilation of the CIA. Each row of the table shows the distribution of asset conditions for the CIA conducted for the year listed.

View more details and insights related to this data set on the story page: https://data.austintexas.gov/stories/s/Percentage-of-infrastructure-classified-as-poor-or/smwq-cx27/

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-measureinfrastructure-sw2t-dbu5\".\"strategic_measureinfrastructure\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.