BC Geographical Names

2006 views (22 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Heritage
Licensed under Access Only

A view of the official place names associated with geographical features in the province of British Columbia. It contains the authoritative information of the BC Gazetteer [https://catalogue.data.gov.bc.ca/dataset/bc-gazetteer] and additional fields relevant for mapping.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

This is another form of the BC Gazetteer content intended to support mapping projects.

Lineage Statement

Data in some fields downloaded March 1995 from Canadian Geographical Names Database, NRCan, Ottawa. Extensive additions, corrections and updates since; addition of new data ongoing

Contact Information

NameCarla Jack (pointOfContact)
EmailCarla.Jack@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationHeritage

Access & Security

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

Metadata Information

Record Published 2013-06-19
Record Last Modified 2019-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_BASEMAPPING.GNS_GEOGRAPHICAL_NAMES_SP

Short Name: GNSGGRPHCL
Comments: GNS GEOGRAPHICAL NAMES SP is a listing of all official place names in the province of British Columbia. The listing is sourced from the BC Geographical Names Information System, which is the master database of BC place names. The listing is also known as the Gazetteer.

Column Name Short Name Data Type Data Precision Comments
GEOGRAPHICAL_NAMES_ID GEO_NM_ID NUMBER 10 GEOGRAPHICAL NAMES ID is a system generated unique identification number for a geographical name, e.g., 53996
FEATURE_ID FEATURE_ID NUMBER 10 FEATURE ID is an identifier for a geographical feature that is unique within the the BCGNIS system. For example: 54321.
FEATURE_UUID VARCHAR2 32 FEATURE UUID is a Universally Unique IDentifier for a FEATURE that conforms to the RFC 4122 specification. The FEATURE UUID is stored as 32 hexidecimal digits. For example: 72fd7cc7c73b4b8dba286fe8988ddf50. This universally unique number was introduced to promote sharing and exchange of FEATURE information between the BCGNIS system and other databases (such as Ottawa's Canadian Geographical Names Database or the BC Freshwater Atlas).
GEOGRAPHICAL_NAME GEO_NAME VARCHAR2 100 GEOGRAPHICAL NAME is the officially-designated name assigned to the geographical feature, e.g., Arctic Lake Plateau.
FEATURE_TYPE FEAT_TYPE VARCHAR2 40 FEATURE TYPE is a specific or narrow classification for a geographical feature. FEATURE TYPEs are standardized across Canada. There are approximately 1500 distinct FEATURE TYPEs identified nationally, of which approximately 350 are presently in use in British Columbia, e.g., Stream, Lake, Village.
FEATURE_TYPE_CODE FEAT_TY_CD NUMBER 10 FEATURE TYPE CODE is a system generated unique identification number that corresponds to the FEATURE TYPE. For example, the FEATURE TYPE CODE "2701" corresponds to the FEATURE TYPE "Mountain".
FEATURE_CATEGORY FEAT_CAT VARCHAR2 70 FEATURE CATEGORY is a Canada-wide, standardized classification which subdivides FEATURE CLASSes into physically-similar groups, e.g., Flowing Freshwater, Elevated Shoreline Features, Standing Water Surrounded by Land.
FEATURE_CLASS FEAT_CLASS VARCHAR2 240 FEATURE CLASS is a Canada-wide, standardized classification that separates geographical features into broad groupings based on geographical, cultural or thematic similarity, e.g., Populated, Administrative Areas, Water Features.
LATITUDE LATITUDE NUMBER 10 LATITUDE is the geographic coordinate, in decimal degrees (ddd.dddddd), of the location of the feature as measured from the equator, e.g., 55.323653
LATITUDE_DMS VARCHAR2 10 LATITUDE DMS is the latitude of the feature in degrees, minutes, seconds (DMS) format. For example: "55 17 45 N" means 55 degrees, 17 minutes and 45 seconds North of the equator.
LONGITUDE LONGITUDE NUMBER 10 LONGITUDE is the geographic coordinate, in decimal degrees (ddd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544
LONGITUDE_DMS LONG_DMS VARCHAR2 11 LONGITUDE DMS is the longitude of the feature in degrees, minutes, seconds (DMS) format. For example: "121 28 14 W" means 121 degrees, 28 minutes and 14 seconds West of the prime meridian.
DATUM DATUM VARCHAR2 5 DATUM is a set of reference points on the Earth's surface against which position measurements for LATITUDE and LONGITUDE are made, e.g., NAD27 or NAD83
POSITION_TYPE PSTN_TYPE VARCHAR2 18 POSITION TYPE is a descriptive word that explains the geographic positioning of the feature, e.g., Centre, Summit, Mouth.
NTS_MAPSHEET NTS_MAPSHT VARCHAR2 12 NTS MAPSHEET is the name of the NTS map that contains the geographical feature's coordinates, e.g., 93A/13.
RELATIVE_LOCATION REL_LOC VARCHAR2 260 RELATIVE LOCATION is a brief description of the relative position of the geographical feature, e.g., W side of Shackleton Glacier in the Clemenceau Icefield, just E of Cummins Lakes Provincial Park.
LAND_DISTRICT LND_DIST VARCHAR2 50 LAND DISTRICT is the name of the land district containing the geographical feature, as identified in Land Title records, e.g., Cassiar Land District.
MIN_SCALE_DENOMINATOR NUMBER 9 MIN SCALE DENOMINATOR is the denominator of the suggested minimum scale at which the geographical name for this feature should be visible on most maps. For example, 1000000 means the geographical name should not be displayed at scales smaller than 1/1000000.
MAX_SCALE_DENOMINATOR MAX_SCALE NUMBER 9 MAX SCALE DENOMINATOR is the denominator of the suggested maximum scale at which the geographical name for this feature should be visible on most maps. For example, 50000 means the geographical name should not be displayed at scales larger than 1/50000.
FEATURE_CODE FCODE VARCHAR2 10 FEATURE CODE contains a value based on the Canadian Council of Surveys and Mapping's (CCSM) system for classification of geographic features, e.g. FW84555210
GEOMETRY GEOMETRY SDO_GEOMETRY 1 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
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.
SE_ANNO_CAD_DATA BLOB 4000 SE ANNO CAD DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO GEOMETRY storage data type.