Statistics Canada 2016 Census - Selected Fields Stored in the BC Geographic Warehouse

0 views (0 recent)

Published by the Ministry of Jobs, Economic Development and Competitiveness - BC Stats
Licensed under Statistics Canada Open Licence

The Census Profiles present information from the 2016 Census of Population for various levels of geography, including the Province of BC, the BC's Census Divisions and BC's Census Subdivisions. This dataset contains a complete set of the Census Profile data for those levels of geography.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Data Quality

See About the data, Census Profile, 2016 Census

More Information

Contact Information

NameSébastien Lavoie (pointOfContact)
EmailSebastien.Lavoie@gov.bc.ca
OrganizationMinistry of Jobs, Economic Development and Competitiveness
Sub-OrganizationBC Stats

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2020-04-27
Record Last Modified 2020-05-04
Resource Status completed
Spatial DataSDO_GEOMETRY

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.CEN_CENSUS_PROFILES

Short Name: CENCENSUSP
Comments: CEN_CENSUS_PROFILES is a copy of Statistics Canada's Census Profiles, presenting information from the Census of Population for a particular census year (e.g., 2011, 2016) for various geographic areas. The CEN_CENSUS_PROFILES table stores values for over 2000 dimensions (e.g., number of people aged 15-19) for each census year (starting with 2016), the Province of BC as a whole, each BC census division, and each BC census subdivision.

Column Name Short Name Data Type Data Precision Comments
CEN_CCP_SYSID SYSID NUMBER 10 CEN_CCP_SYSID is a system generated unique identification number.
CENSUS_YEAR CENSUSYR NUMBER 4 CENSUS_YEAR is the year in which the census was conducted. In Canada, censuses are conducted every 5 years.
GEOGRAPHIC_CODE GEOCODE NUMBER 12 GEOGRAPHIC_CODE is a numerical identifier assigned to a geographic area. Every kind of geographic area in Canada has its own type of geographic code. For example, the geographic code assigned to a town makes it possible to distinguish that town from any other towns with the same name that are located in a different province. The code is used to identify and access standard geographic areas for the purposes of data storage, retrieval and display.
GEOGRAPHIC_LEVEL GEOLEVEL NUMBER 10 GEOGRAPHIC_LEVEL identifies the administrative level to which these dimension values pertain, i.e. 1 (Province), 2 (Census Division), 3 (Census Subdivision).
GEOGRAPHY_NAME GEONAME VARCHAR2 200 GEOGRAPHY_NAME is the name of the geographic area to which these dimension values pertain. For Province entries, the GEOGRAPHY_NAME is British Coplumbia. For census divisions, the GEOGRAPHY_NAME is the regional district name, e.g., East Kootenay. For census subdivisions, the GEOGRAPHY_NAME is the municipality name, name of the Federal Indian Reserve or Indian Settlement, or the name of the regional district electoral area, e.g., Victoria, South Saanich 1, Okanagan-Similkameen D.
GLOBAL_NONRESP_SF_PCT GNR_SF NUMBER 4 GLOBAL_NONRESP_SF_PCT is the Global non-response rate for the short form census, described in the document http://www12.statcan.gc.ca/census-recensement/2016/ref/98-304/chap11-eng.cfm.
GLOBAL_NONRESP_LF_PCT GNR_LF NUMBER 4 GLOBAL_NONRESP_LF_PCT is the Global non-response rate for the long form census, described in the document http://www12.statcan.gc.ca/census-recensement/2016/ref/98-304/chap11-eng.cfm.
DATA_QUALITY_FLAG QUAL_FLAG CHAR 5 DATA_QUALITY_FLAG is a 5 digit encoding of data quality flags for the short and long forms based on non-response rates.
CSD_TYPE_NAME CSDTYPE VARCHAR2 10 CSD_TYPE_NAME identifies the type of census subdivision this record pertains to, or blank if this record does not pertain to a census subdivision record, e.g., Possible values are CY (city), DM (district municipality), IGD (Indian government district), IM (Island municipality), IRI (Indian reserve), NL (Nisga'a land), RDA (regional district electoral area), RGM (Regional municipality), S-É (Indian Settlement), T (Town) and VL(Village).
DIMENSION_DESCRIPTION DIMENSN VARCHAR2 500 DIMENSION_DESCRIPTION is a textual description of the value being measured, e.g., Total Private Dwellings.
DIMENSION_CATEGORY DMNSN_CTGY VARCHAR2 30 DIMENSION_CATEGORY is the category to which the dimension belongs - e.g., LANGUAGES, EDUCATION, OCCUPATION
DIMENSION_NUM DIMENSNNUM NUMBER 10 DIMENSION_NUM is a number that uniquely identifies a DIMENSION within a CENSUS_YEAR / GEOGRAPHY_LEVEL / GEOGRAPHY_CODE combination.
FOOTNOTE_NUMBER NOTENUM NUMBER 10 FOOTNOTE_NUMBER identifies a footnote in the 98-401-X2016055_English_meta.txt resource, providing additional information about the dimension.
VALUE_TOTAL_CODE VALTOTCD VARCHAR2 10 VALUE_TOTAL_CODE is a code explaining why VALUE_TOTAL has been suppressed for this dimension and geographic unit, i.e., .. (not available, … (not applicable), F (too unreliable to be published), X (suppressed for confidentiality reasons).
VALUE_MALE_CODE VALMALECD VARCHAR2 10 VALUE_MALE_CODE is a code explaining why VALUE_MALE has been suppressed for this dimension and geographic unit, i.e., .. (not available, … (not applicable), F (too unreliable to be published), X (suppressed for confidentiality reasons).
VALUE_FEMALE_CODE VALFEMALCD VARCHAR2 10 VALUE_FEMALE_CODE is a code explaining why VALUE_FEMALE has been suppressed for this dimension and geographic unit, i.e., .. (not available, … (not applicable), F (too unreliable to be published), X (suppressed for confidentiality reasons).
VALUE_TOTAL VALTOTAL NUMBER 15 VALUE_TOTAL is the dimension value (if it hasn`t been suppressed) for all respondents.
VALUE_MALE VALMALE NUMBER 15 VALUE_MALE is the dimension value (if it hasn`t been suppressed) for male respondents.
VALUE_FEMALE VALFEMALE NUMBER 15 VALUE_FEMALE is the dimension value (if it hasn`t been suppressed) for female respondents.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.