Reference point locations for particular regional districts

103 views (2 recent)

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

This dataset represents representative (reference) point locations for particular census divisions (Regional Districts). These point locations are used in calculating distances between a regional district and another feature (such as a port or educational institution)

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

Data Quality
Lineage Statement

Contact Information

Access & Security

Who can view this dataset? Named users
Who can download this dataset?Named users

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_REG_DIST_REF_POINTS

Comments: ECON_REG_DIST_REF_POINTS represents representative (reference) point locations for particular CENSUS DIVISIONs (Regional Districts). These point locations are used in calculating distances between a regional district and a resource (such as a port or educational institution)

Column Name Short Name Data Type Data Precision Comments
REG_DIST_REF_POINT_ID NUMBER 10 REG DIST REF POINT ID is a system generated unique identification number.
REGIONAL_DISTRICT_NAME VARCHAR2 100 REGIONAL DISTRICT NAME is a name of the regional district represented. e.g., Capital
CENSUS_YEAR NUMBER 4 CENSUS YEAR is the census year to which CENSUS DIVISION ID pertains. e.g., 2006, 2011. With CENSUS DIVISION ID, this forms a foreign key linking to CENSUS YEAR + CENSUS DIVISION ID in CEN CENSUS_DIVISIONS SP
CENSUS_DIVISION_ID VARCHAR2 7 CENSUS DIVISION ID together with CENSUS YEAR is used to form a foreign Key, linking to CENSUS YEAR + CENSUS DIVISION ID in CEN CENSUS DIVISIONS SP, e.g., 5901.
REFERENCE_POINT_LATITUDE NUMBER 8 REFERENCE POINT LATITUDE: The geographic coordinate, in decimal degrees (dd.dddddd), of the reference point for the regional district identified by CENSUS YEAR+CENSUS DIVISION ID, as measured from the equator, e.g., 55.323653
REFERENCE_POINT_LONGITUDE NUMBER 9 REFERENCE POINT LONGITUDE: The geographic coordinate, in decimal degrees (edd.dddddd), of the reference point for the regional district identified by CENSUS YEAR+CENSUS DIVISION ID, as measured from the Greenwich meridian e.g., 123.323653
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.

Comments

No comments have been posted yet.