Geographic locations of ocean ports

329 views (8 recent)

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

This dataset contains names, website URLs, and geographic locations of ocean ports in British Columbia, as listed in the Chamber of Shipping of British Columbia's BC Ports Handbook.

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: Chamber of Shipping of British Columbia's BC Ports Handbook, 2014 http://www.cosbc.ca

Contact Information

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_OCEAN_PORTS

Short Name: E_OCN_PRTS
Comments: OCEAN PORT contains names, website URLs, and geographic locations of ocean ports in British Columbia, as listed in the Chamber of Shipping of British Columbia's BC Ports Handbook.

Column Name Short Name Data Type Data Precision Comments
OCEAN_PORT_ID OCN_PRT_ID NUMBER 10 OCEAN PORT 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 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 community in which the ocean port is located.
OCEAN_PORT_NAME OCN_PRT_NM VARCHAR2 50 OCEAN PORT NAME: Name of the ocean port, e.g., Campbell River
OCEAN_PORT_WEBSITE_URL OCN_PRT_WL VARCHAR2 255 OCEAN PORT WEBSITE URL: Ocean Port website URL, e.g., http://www.sunshinecoasteh.com/port-mellon.html
DATA_PUBLICATION_YEAR DT_PBLCTNR NUMBER 4 DATE PUBLICATION YEAR: The year in which the source of the information in this table was published, e.g., 2014
LATITUDE 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 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