Customs Ports of Entry

231 views (5 recent)

Published by the Ministry of Citizens Services - Connected Communities Branch
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 2021-03-16
Resource Status completed
Spatial DataSDO_GEOMETRY

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_CUSTOMS_PORTS_OF_ENTRY_SP

Comments: Records in this table represent 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

Column Name Short Name Data Type Data Precision Comments
ECON_CPOE_SYSID NUMBER 10 A system generated unique identification number
CENSUS_YEAR NUMBER 4 The census year to which CENSUS_SUBDIVISION_ID pertains. e.g., 2006, 2011, 2016. With CENSUS SUBDIVISION ID, this forms a foreign key linking to CENSUS_YEAR + CENSUS_SUBDIVISION_ID in CEN_CENSUS_SUBDIVISIONS_SP
CENSUS_SUBDIVISION_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 VARCHAR2 100 The name of the customs port. e.g., Boundary Bay Airport, Gold River
CUSTOMS_PORT_TYPE VARCHAR2 20 Category of customs port. e.g., Air, Marine, Rail or Road
CUSTOMS_PORT_STREET_ADDRESS VARCHAR2 100 The address of the customs port location. e.g., 5533 Airport Way
CUSTOMS_PORT_MUNICIPALITY VARCHAR2 100 The municipality that the port is based in. e.g., Kelowna
DATA_PUBLICATION_YEAR NUMBER 4 The year in which the source of the information in this table was published, e.g., 2014
LATITUDE NUMBER 8 The geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the equator, e.g., 55.323653.
LONGITUDE NUMBER 9 The geographic coordinate, in decimal degrees (-ddd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544.
SHAPE SDO_GEOMETRY 1 The column used to reference the spatial coordinates defining the feature.
OBJECTID NUMBER 38 A system managed column with unique ids, required for database objects registered with the ArcGIS geodatabase.
SE_ANNO_CAD_DATA BLOB 4000 A binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.