Geographic locations of major population centres

293 views (4 recent)

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

This dataset contains names and approximate geographic locations of major population centres in, or close to, British Columbia.

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/).

Lineage Statement

Data source: Statistics Canada, Census and National Household Survey, 2011

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 2017-10-16
Resource Status completed

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_MAJOR_CENTRES

Comments: MAJOR CENTRE contains the names and approximate geographic locations of major population centers in, or close to, British Columbia.

Column Name Short Name Data Type Data Precision Comments
MAJOR_CENTRE_ID NUMBER 10 MAJOR CENTRE ID is a system generated unique identification number, e.g., 1
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 together with CENSUS YEAR is used to form 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 corresponding to the major centre, if any.
MAJOR_CENTRE_NAME VARCHAR2 100 MAJOR CENTRE NAME: The name of the major centre, e.g., Edmonton
DATA_PUBLICATION_YEAR NUMBER 4 DATE PUBLICATION YEAR: The year in which the source of the information in this table was published, e.g., 2014
LATITUDE NUMBER 8 LATITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the equator, e.g., 55.323653
LONGITUDE NUMBER 9 LONGITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544