Open repository in Console
Readme
Updated 2 days ago
‧ Indexed 39 minutes ago
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:
- Whatever the "future" ward boundaries are (if any): https://data.edmonton.ca/resource/nydb-6rce.geojson?$where=effdt_type='Future'
- The ward boundaries as they were in 2013: https://data.edmonton.ca/resource/nydb-6rce.geojson?$where=date_trunc_y(effective_start_date)='2013'
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.
Upstream Metadata