Skip to content

Repo containing sql scripts to process Statistics Canada census 2021 data.

License

Notifications You must be signed in to change notification settings

wkhchow/census_canada_2021

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

census_canada_2021

Current processed data up to August 17, 2022 Linguistic diversity and use of English and French in Canada

Current processed data up to September 21, 2022 First Nations people, Métis and Inuit in Canada, Canada's housing portrait

Current processed data up to November 30, 2022 Education in Canada, The changing dynamics of the Canadian labour force and how people get to work, and Instruction in the minority official language

Repo containing sql scripts, links to source and processed data for census 2021 data dissemination. Source data is imported into a PostgresSQL database with PostGIS, and tablefunc extension. Then it is processed and attached with census boundaries exported into GeoPackage for GIS use.

Census Profile data is released in stages, and is downloaded to be processed when new data becomes available.

You can find the download page here.

Release schedule can be found here.

Scripts are stored in the script folder in GitHub whereas source / processed data is stored on OneDrive.

  • census_profile_lut_legend.xlsx - Census profile lookup table. The CHARACTERISTIC_ID corresponds to the columns in the processed geopackages.

scripts

  • Scripts to process census data in PostgreSQL after import from QGIS.

Link to OneDrive for stored and processed data

All data compressed in 7zip. 7-Zip can be downloaded and installed at https://www.7-zip.org/

  • boundaries - boundary geometries / reference table
    • Census_Boundaries_2021_Cartographic.7z
    • Census_Boundaries_2021_Digital.7z
    • DGUID_Reference.7z - DGUID lookup table to reference to various census geometry levels
  • db_backup - database dumps
    • census_2021_db_aug.7z (up to August 17, 2002 census release)
    • census_2021_db_sept.7z (up to Sept 21, 2002 census release)
    • census_2021_db_nov.7z (up to Nov 30, 2002 census release)
  • processed - processed GeoPackages
    • census_profile_august_da_canada.7z - August census release, dissemination area geometry
    • census_profile_sept_da_canada.7z - Sept census release, dissemination area geometry
    • census_profile_nov_processed.7z - Nov census release, dissemination area geometry
    • census_profile_july2022.7z - July census release, in dissemination area, and aggregated to census subdivision, census division, and province/territorial geometries
    • population_db.7z - population, dissemination block geometry
  • source data - source data compiled from Statistics Canada
    • census profile july.7z - July data release
    • census profile august.7z - August data release
    • census profile sept.7z - Sept data release
    • census profile nov.7z - Nov data release
    • population_dwelling_db.7z - population at disseimation block level

About

Repo containing sql scripts to process Statistics Canada census 2021 data.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published