Data Dictionary for Statistics Canada 2016 Census Profile Dimensions in BCGW

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, BC's Census Divisions and BC's Census Subdivisions. Not all of the dimensions offered in the Census Profiles have been captured in the views stored in the BC Geographic Warehouse. This dataset provides a cross reference between Census Profile dimensions and the views built in the BC Geographic Warehouse.

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_DIMENSIONS

Short Name: CENCENSUSD
Comments: CEN_CENSUS_DIMENSIONS contains descriptions of the Statistics Canada Census Profile dimensions and their mapping to views in the BC Geographic Warehouse

Column Name Short Name Data Type Data Precision Comments
CEN_CCD_SYSID SYSID NUMBER 10 CEN_CCD_SYSID is a system generated unique identification number.
DIMENSION_NUM DIMENSNNUM NUMBER 10 DIMENSION_NUM is a number that uniquely identifies a DIMENSION within a CENSUS_YEAR / GEOGRAPHY_LEVEL / GEOGRAPHY_CODE combination.
DIMENSION_CATEGORY DMNSN_CTGY VARCHAR2 30 DIMENSION_CATEGORY is the category to which the dimension belongs - e.g., LANGUAGES, EDUCATION, OCCUPATION
DIMENSION_DESCRIPTION DIMENSN VARCHAR2 500 DIMENSION_DESCRIPTION is a textual description of the value being measured, e.g., Total Private Dwellings.
CENSUS_DIVISION_VIEW_NAME CENDIV_NM VARCHAR2 30 CENSUS_DIVISION_VIEW_NAME is the name of the census division (CD) view in which the value of the dimension appears.
CENSUS_SUBDIVISION_VIEW_NAME CENSBD_NM VARCHAR2 30 CENSUS_SUBDIVISION_VIEW_NAME is the name of the census subdivision (CSD) view in which the value of the dimension appears.
COLUMN_NAMES CLMN_NMS VARCHAR2 200 COLUMN_NAMES contains name(s) of the columns in which the value of the dimension appears, e.g., LABOUR_FORCE_PARTICIP_TOT_PCT, LABOUR_FORCE_PARTICIP_FM_PCT, LABOUR_FORCE_PARTICIP_ML_PCT.
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.