Cross reference between First Nations reserves and the Federal Government assigned band number

223 views (2 recent)

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

Cross reference between First Nations reserves (identified by either a census subdivision id or a Canadian Lands Administrative Boundary id) and the Federal Government-assigned band number.

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

NameRobert Dubicki (custodian)
Emailrobert.dubicki@gov.bc.ca
OrganizationMinistry of Jobs, Trade and Technology
Sub-OrganizationInternational Marketing

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_FN_CSDS_CLABS_BANDS_XREF

Short Name: FN_CCB_XRF
Comments: This dataset contains a cross reference between First Nations reserves (identified by either a census subdivision id or a Canadian Lands Administrative Boundary id) and the Federal Government-assigned band number.

Column Name Short Name Data Type Data Precision Comments
FN_CSDS_CLABS_BANDS_XREF_ID FN_CSDS_ID NUMBER 10 FN CSDS CLABS BANDS XREF ID is a system generated unique identification number. e.g., 1
CENSUS_YEAR CNSS_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 CNSS_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.
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.
BAND_NUMBER BND_NMBR NUMBER 4 BAND NUMBER is the unique identifier assigned to the First Nation by the Federal Government.