Community Census Subdivisions

324 views (3 recent)

Published by the Ministry of Jobs, Trade and Technology - International Marketing
Licensed under Access Only

BC community place names, associated with their 7-digit CSD codes for a particular census year. Some of these places are incorporated, in which case the community name and the census subdivision name for the associated CSD code will be the same. Others are unincorporated communities with no official boundaries, in which the CSD code is the code for the census subdivision in which the community is located.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Application-specific for the Trade and Invest British Columbia website (https://www.britishcolumbia.ca/)

Contact Information

Access & Security

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

Metadata Information

Record Published 2016-06-17
Record Last Modified 2019-09-05
Resource Status completed

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_COMMUNITY_CENSUS_SUBDIVS

Comments: The table contains a list of BC community place names, associated with their 7-digit CSD codes for a particular census year. Some of these places are incorporated, in which case the community name and the census subdivision name for the associated CSD code will be the same. Others are unincorporated communities with no official boundaries, in which the CSD code is the code for the census subdivision in which the community is located.

Column Name Short Name Data Type Data Precision Comments
COMMUNITY_CENSUS_SUBDIV_ID NUMBER 10 COMMUNITY CENSUS SUBDIV ID is a system generated unique identification number. e.g., 1
COMMUNITY_PLACE_NAME VARCHAR2 100 COMMUNITY PLACE NAME is name of the community. e.g., 108 Mile House
COMMUNITY_PLACE_TYPE VARCHAR2 100 COMMUNITY PLACE TYPE is the classification of the community. For incorporated communities, this is the census subdivision type desc, e.g., "City", "District Municipality". For unincorporated communities, this is the BCGNIS feature category, e.g., "Unincorporated Rural"
CENSUS_YEAR NUMBER 4 CENSUS YEAR is the census year to which CENSUS SUBDIVISION ID pertains. e.g., 2006, 2011. With CENSUS SUBDIVISION ID, this forms a foreign key linking to CENSUS YEAR + CENSUS SUBDIVISION ID in CEN CENSUS SUBDIVISIONS SP
CENSUS_SUBDIVISION_ID VARCHAR2 7 CENSUS SUBDIVISION ID: With CENSUS YEAR, this forms a foreign Key, linking to CENSUS YEAR + CENSUS SUBDIVISION ID in CEN CENSUS SUBDIVISIONS SP, e.g., 5901022. With CENSUS YEAR, this identifies the census subdivision in which the community is located.