General Building Permits

List of issued building permits from the City of Edmonton - Urban Planning & Economy Department for the public to do construction or maintenance on a structure located in the City. Note - All records start from January 1, 2009.

Please note : the decision was made to not release applicant information on this dataset as it was seen as a potential privacy issue. For instance, if a high profile member of the public were to apply for a permit, their name (and consequently address) would show up on this table and become easily searchable by the public. We viewed this as a potential issue and decided to publish the dataset without applicant information.

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/general-building-permits-24uj-dj8v\".\"general_building_permits\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.