2009 Census - Dwelling Unit By Structure Type And Occupancy (Neighbourhood)

All Census information is as of April 1, 2009.

No data on any individual residence will be released. To protect the privacy of individuals, data is compiled and presented at the city-, ward- and neighbourhood-level only.

In order to further protect the privacy of individuals, neighbourhood data is not reported for neighbourhoods with populations between 1 and 49 residents.

The designation of “No Response” includes households from which no census data could be collected or only partial data was available.

Bulk-count data from multiple-resident facilities (such as group homes, transient drop-in centres, residential hotels or criminal detention centres) may be limited when personal information can not be obtained (i.e. information is not available or can not be released by the facility administration).

“Other Residential” includes dwelling units not covered by the other categories, such as a unit attached to a non-residential structure (e.g. an apartment in a store or church) or a movable structure (e.g. recreational vehicle, tent, etc.)

An Unoccupied site is one that was vacant (i.e. no one was living in the unit on April 1), had no structure, was under construction, or was no longer in use (structure existed, but was no longer used as a residence).

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/2009-census-dwelling-unit-by-structure-type-and-qdcb-svkz\".\"2009_census_dwelling_unit_by_structure_type_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.