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.