Strategic Measure_Infrastructure Condition_Network
This dataset describes infrastructure conditions at the network level for assets included in the 2020 Comprehensive Infrastructure Assessment (CIA). Conditions presented in this dataset are not weighted by Current Replacement Value. Data for the CIA is collected every two years.
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 an infrastructure network for the year listed.
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-conditionnetwork-5sh6-vxv8\".\"strategic_measureinfrastructure_conditionnetwork\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.