City of Edmonton Ward Boundary and Council Composition: Current, Historical and Future
This dataset provides the current, future, and historical geometric polygons of the City of Edmonton's civic ward boundaries and the associated Council member in office.
The associated map can be used to filter to display the ward boundaries as of a specified date. It's also possible to use the API to extract just the rows that you're interested in, for example:
See https://dev.socrata.com/docs/functions.
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 \"edmonton-ca/city-of-edmonton-ward-boundary-and-council-nydb-6rce\".\"city_of_edmonton_ward_boundary_and_council\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.