orcities/city-infrastructure-needs-iunq-sx87
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 6 years ago
Indexed 5 hours ago

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.

 
Preview
  • city_infrastructure_needs