Driven distances between pairs of selected features stored in the BC Geographic Data Warehouse

138 views (3 recent)

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

Driven distances (km) (computed using the Digital Road Atlas (DRA) between pairs of selected features (e.g., communities, ports, schools, etc.) stored in the BC Geographic Data Warehouse.

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

Metadata Information

Record Published 2016-06-27
Record Last Modified 2019-09-05
Resource Status completed

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_DISTANCE_MATRIX

Comments: DISTANCE MATRIX represents distances (km) between features (e.g., communities, ports, schools, etc.) stored in the BC Geographic Data Warehouse.

Column Name Short Name Data Type Data Precision Comments
DISTANCE_MATRIX_ID NUMBER 10 DISTANCE MATRIX ID is a system generated unique identification number.
SOURCE_FEATURE_ID VARCHAR2 20 SOURCE FEATURE ID is the unique id of the feature from which DISTANCE is measured. It corresponds to a (possibly concatenated) unique key in another BCGW table that describes the feature, e.g., '20115905' (concatenation of CENSUS YEAR and CENSUS DIVISION ID)
SOURCE_FEATURE_NAME VARCHAR2 500 SOURCE FEATURE NAME is the name by which the feature identified by SOURCE FEATURE ID is known, e.g., 'Okanagan-Similkameen'
SOURCE_CLASS VARCHAR2 30 SOURCE CLASS: Type of source feature, e.g., 'REGIONAL DISTRICT'
SOURCE_SUBCLASS VARCHAR2 50 SOURCE SUBCLASS: Sub-type of source feature, e.g., 'TEACHING' for a case where the SOURCE CLASS = 'POST SECONDARY'
DESTINATION_FEATURE_ID VARCHAR2 20 DESTINATION FEATURE ID is the unique id of the feature to which DISTANCE is measured. It corresponds to a (possibly concatenated) unique key in another BCGW table that describes the feature, e.g., '20115905' (concatenation of CENSUS YEAR and CENSUS DIVISION ID)
DESTINATION_FEATURE_NAME VARCHAR2 500 DESTINATION FEATURE NAME is the name by which the feature identified by DESTINATION FEATURE ID is known, e.g., 'Okanagan-Similkameen'
DESTINATION_CLASS VARCHAR2 30 DESTINATION CLASS: Type of destination feature, e.g., 'REGIONAL DISTRICT'
DESTINATION_SUBCLASS VARCHAR2 50 DESTINATION SUBCLASS: Sub-type of destination feature, e.g., 'TEACHING' for a case where the DESTINATION CLASS = 'POST SECONDARY'
DISTANCE NUMBER 5 DISTANCE: The Euclidian (direct) distance between the source feature identified by SOURCE FEATURE ID and the destination feature identified by DESTINATION FEATURE ID, measured in km, e.g., 543
DISTANCE_RANK NUMBER 3 DISTANCE RANK represents the rank of the distance of this destination feature from this source feature, with respect to all pairs of source features/destination features in this source feature class,subclass and destination feature class,subclass combination. ‘1’ is the closest, e.g., 5