311 Explorer

311 Explorer is a web-based mapping tool that uses the City’s open data information to search, filter, and display 311 service requests on public property. You will be able to:

View the various types of service requests on public property that have been generated in a neighborhood, ward or across the city, see the status of service requests, use the map or charts for analysis of neighbourhoods

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/311-explorer-ukww-xkmj\".\"311_explorer\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.