Customs Ports of Entry

231 views (5 recent)

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

Places where someone may lawfully enter Canada. This dataset contains the addresses and geographic locations of road, railway, air, and marine Canada Customs Ports of Entry in 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: Canada Border Services Agency, 2015

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_CUSTOMS_PORTS_OF_ENTRY

Short Name: E_CUST_PRT
Comments: CUSTOMS PORT OF ENTRY represents a place where someone may lawfully enter Canada. This dataset contains the addresses and geographic locations of road, railway, air, and marine Canada Customs Ports of Entry in British Columbia

Column Name Short Name Data Type Data Precision Comments
CUSTOMS_PORT_OF_ENTRY_ID CSTMS_P_ID NUMBER 10 CUSTOMS PORT OF ENTRY 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 customs port of entry is located.
CUSTOMS_PORT_NAME CSTMS_PRTM VARCHAR2 100 CUSTOMS PORT NAME: The name of the customs port. e.g., Boundary Bay Airport, Gold River
CUSTOMS_PORT_TYPE CSTMS_PRTE VARCHAR2 20 CUSTOMS PORT TYPE: Category of customs port. e.g., Air, Marine, Rail or Road
CUSTOMS_PORT_STREET_ADDRESS CSTMS_PRTS VARCHAR2 100 CUSTOMS PORT STREET ADDRESS: The address of the customs port location. e.g., 5533 Airport Way
CUSTOMS_PORT_MUNICIPALITY CSTMS_PRTY VARCHAR2 100 CUSTOMS PORT MUNICIPALITY: The municipality that the port is based in. e.g., Kelowna
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