City Infrastructure Needs
Information provided by respondent cities through the 2016 LOC Infrastructure Survey. Data is and aggregation of capital projects needs for the next 20 years.
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 \"orcities/city-infrastructure-needs-iunq-sx87\".\"city_infrastructure_needs\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.