Census data is an official count of dwelling units and population within those units. The data is physically collected and may be supplemented with other information such as the periodic age/gender distribution data. This additional data allows for better interpretation of the population statistics. A community district is a fixed boundary within Calgary, created by and for the Corporation. It represents a distinct geographical area of the city that is determined through the Land Development/Subdivision Process and approved by Council.
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 \"calgary-ca/census-by-community-2017-qfna-5kbg\".\"census_by_community_2017\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.