Names used to identify First Nations reserves, associated with specific census subdivisions or Canadian Lands Administrative Boundaries

305 views (7 recent)

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

Primary and Secondary names used to identify First Nations reserves, that are in turn associated with specific census subdivisions or Canadian Lands Administrative Boundaries records.

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?Public

Metadata Information

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

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_FIRST_NATION_CMTY_NAMES

Short Name: FN_CMTY_NM
Comments: FIRST NATION CMTY NAME contains Primary and Secondary names used to identify First Nations reserves, that are in turn associated with specific census subdivisions or Canadian Lands Administrative Boundaries records.

Column Name Short Name Data Type Data Precision Comments
FIRST_NATION_CMTY_NAME_ID FN_C_NM_ID NUMBER 10 FIRST NATION CMTY NAME ID is a system generated unique identification number. e.g., 1
CENSUS_YEAR CEN_YR 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 CEN_SB_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 First Nations reserve, if it coincides with a census subdivision.
CENSUS_DIVISION_ID CEN_DV_ID VARCHAR2 4 CENSUS DIVISION ID - Uniquely identifies a census division (SGC code - composed of the 2-digit province/territory code and the 2-digit census division code).
ECONOMIC_REGION_ID ECON_R_ID VARCHAR2 4 ECONOMIC REGION ID - Uniquely identifies an economic region (composed of the 2-digit province/territory code and the 2-digit economic region code).
CLAB_ID CLAB_ID VARCHAR2 14 CLAB ID is a Canada Lands Administrative Boundary (CLAB) unique identifier. e.g., 00009. This is a foreign key to WHSE ADMIN BOUNDARIES.CLAB INDIAN RESERVES. This identifies the First Nations reserve in the situations where it does not coincide with a census subdivision.
FIRST_NATION FRST_NAT VARCHAR2 100 FIRST NATION is the First Nation with which this First Nation community (reserve) is associated. e.g., Caska Dena
FN_COMMUNITY_NAME_PRIMARY FN_CM_NM_P VARCHAR2 100 FN COMMUNITY NAME PRIMARY is the primary name used by First Nation to identify this First Nations reserve. e.g., Lower Post First Nation
FN_COMMUNITY_NAME_SECONDARY FN_CM_NM_S VARCHAR2 100 FN COMMUNITY NAME SECONDARY is the secondary name used by First Nation to identify this First Nations reserve. e.g., Lower Post First Nation
DATA_NOTES DATA_NOTES VARCHAR2 250 DATA NOTES are notes related to matching First Nation to appropriate Census Subdivision. e.g., AANDC First Nation Profiles includes this nation in Yukon, not BC. Population is for entire Liard First Nation.