Census Region Hierarchy

0 views (0 recent)

Published by the Ministry of Agriculture, Food and Fisheries - Corporate Policy and Priorities
Licensed under Statistics Canada Open Licence

This dataset describes the topological relationship between Census Subdivisions and the census regions in which they are contained:

Data and Resources

Dataset Extent

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

Additional Information

Purpose

This dataset assists with aggregating data for regions into the larger regions that contain them.

Contact Information

NameKatie Fraser (businessExpert)
EmailKatie.Fraser@gov.bc.ca
OrganizationMinistry of Agriculture, Food and Fisheries
Sub-OrganizationCorporate Policy and Priorities

Access & Security

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

Metadata Information

Record Published 2020-06-02
Record Last Modified 2021-01-15
Resource Status completed
Spatial DataSDO_GEOMETRY

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.CEN_CENSUS_HIERARCHY

Short Name: CENCENSUSH
Comments: Geographic regions used for Statistics Canada have a hierarchy. The Province is made up of Economic Regions (equivalent to Census Agriculture Regions), which are composed of adjacent Census Divisions, composed of adjacent Census Consolidated Subdivisions, composed of adjacent Census Subdivisions. This table describes that hierarchy.

Column Name Short Name Data Type Data Precision Comments
CEN_CH_SYSID SYSID NUMBER 10 A system generated unique identification number.
CENSUS_YEAR CENSUS_YR NUMBER 4 The year in which the census was conducted.
CENSUS_AGRICULTURE_REGION_ID CAR_ID CHAR 4 The 4 digit numeric code assigned to the Census Agriculture Region by Statistics Canada, e.g., 5901.
CENSUS_AGRICULTURE_REGION_NAME CAR_NAME VARCHAR2 100 The name of the Census Agriculture Region, e.g., Nechako.
ECONOMIC_REGION_ID ER_ID CHAR 4 The 4 digit numeric code assigned by Statistics Canada to the Economic Region associated with this census agriculture region.
ECONOMIC_REGION_NAME ER_NAME VARCHAR2 100 The name of the Economic Region associated with this Census Agriculture Region.
CENSUS_DIVISION_ID CD_ID CHAR 4 The 4 digit numeric code assigned to the Census Division by Statistics Canada, e.g., 5901.
CENSUS_DIVISION_NAME CD_NAME VARCHAR2 100 The name of the Census Division, e.g., Kitimat-Stikine.
CENSUS_CONSOLIDATED_ID CCSD_ID CHAR 7 The 7 digit numeric code assigned to the Census Consolidated Subdivision by Statistics Canada, e.g., 5909052.
CENSUS_CONSOLIDATED_NAME CCSD_NAME VARCHAR2 100 The name of the Census Consolidated Subdivision, e.g., Abbotsford.
CENSUS_SUBDIVISION_ID CSD_ID CHAR 7 The 7 digit numeric code assigned to the Census Subdivision by Statistics Canada, e.g., 5909052.
CENSUS_SUBDIVISION_NAME CSD_NAME VARCHAR2 100 The name of the Census Subdivision, e.g., Victoria.
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.