Edmonton Catholic School Board Ward Boundaries: Current, Historical, and Future

This dataset provides the Current, Historical, and Future geometric polygons of the Edmonton Catholic Separate School Division ward boundaries and the associated board trustee in office.

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/dhek-mfcx.geojson?$where=effdt_type='Future'

• The ward boundaries as they were in 2013: https://data.edmonton.ca/resource/dhek-mfcx.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/edmonton-catholic-school-board-ward-boundaries-dhek-mfcx\".\"edmonton_catholic_school_board_ward_boundaries\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.