Airport Capacity and Service Information

271 views (6 recent)

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

This dataset contains capacity information (e.g., number and length of runways) and service information (e.g., cities served, number of flights per day) for airports in British Columbia. The dataset contains the location of the airports (latitude and longitude) as well as the id of the Census Subdivision in which the airport is located.

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

BC Ministry of International Trade research, 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_AIRPORTS

Short Name: ECON_AIRP
Comments: AIRPORT contains capacity information (e.g., number and length of runways) and service information (e.g., cities served, number of flights per day) for airports in or near British Columbia.

Column Name Short Name Data Type Data Precision Comments
AIRPORT_ID AIRPORT_ID NUMBER 10 AIRPORT 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 airport is located.
AIRPORT_NAME AIRPORT_NM VARCHAR2 100 AIRPORT NAME: Name of the airport, e.g., Victoria International Airport
AIRPORT_HUB_STATUS_TYPE ARPRT_HB_E VARCHAR2 20 AIRPORT HUB STATUS TYPE: Hub status of the airport, e.g., COMMERCIAL, INTERNATIONAL. This will be NULL for non-commercial airports.
AIRPORT_WEBSITE_URL ARPRT_WBSL VARCHAR2 255 AIRPORT WEBSITE URL: Airport website, e.g., http://www.victoriaairport.com/
AIRPORT_STREET_ADDRESS ARPRT_STRS VARCHAR2 100 AIRPORT STREET ADDRESS: Street address of the airport, e.g., 1640 Electra Blvd"
AIRPORT_MUNICIPALITY ARPRT_MNCY VARCHAR2 100 AIRPORT MUNICIPALITY: Municipality that the airport is located within, e.g., Sidney
NUMBER_OF_RUNWAYS NMBR_F_RNS NUMBER 2 NUMBER OF RUNWAYS: Number of runways, e.g., 4
RUNWAY_1_LENGTH_METRES RNWY_1_LNS NUMBER 5 RUNWAY 1 LENGTH METRES: Length of first runway in metres (if applicable), e.g., 3000
RUNWAY_2_LENGTH_METRES RNWY_2_LNS NUMBER 5
RUNWAY_3_LENGTH_METRES RNWY_3_LNS NUMBER 5 RUNWAY 3 LENGTH METRES: Length of third runway in metres (if applicable), e.g., 2500
RUNWAY_4_LENGTH_METRES RNWY_4_LNS NUMBER 5 RUNWAY 4 LENGTH METRES: Length of fourth runway in metres (if applicable), e.g., 2600
LARGEST_CITY_SERVED_1 LRG_CTY1 VARCHAR2 100 LARGEST CITY SERVED 1: Name of the largest city served directly by airport, e.g., Toronto
LARGEST_CITY_SERVED_2 LRG_CTY2 VARCHAR2 100 LARGEST CITY SERVED 2: Name of 2nd largest city served directly by airport, e.g., Seattle
LARGEST_CITY_SERVED_3 LRG_CTY3 VARCHAR2 100 LARGEST CITY SERVED 3: Name of 3rd largest city served directly by airport, e.g., Vancouver
LARGEST_CITY_SERVED_4 LRG_CTY4 VARCHAR2 100 LARGEST CITY SERVED 4: Name of 4th largest city served directly by airport, e.g., Calgary
LARGEST_CITY_SERVED_5 LRG_CTY5 VARCHAR2 100 LARGEST CITY SERVED 5: Name of 5th largest city served directly by airport, e.g., Edmonton
LARGEST_CITY_SERVED_6 LRG_CTY6 VARCHAR2 100 LARGEST CITY SERVED 6: Name of 6th largest city served directly by airport, e.g., Kelowna
DAILY_NONSTOP_DEPARTURES DLY_NNSTPS NUMBER 4 DAILY NONSTOP DEPARTURES: Total non-stop departures per day, e.g., 100
WEEKLY_NONSTOP_FLIGHTS_USA WKNSFUSA NUMBER 4 WEEKLY NONSTOP FLIGHTS USA: Total number of non-stop flights to USA per week, e.g., 50
WKLY_NONSTOP_FLIGHTS_ASIA WKNSF_ASIA NUMBER 4 WKLY NONSTOP FLIGHTS ASIA: Total number of non-stop flights to Asia per week, e.g., 10
WKLY_NONSTOP_FLGHTS_AUSTRALIA WKNSF_AUST NUMBER 4 WKLY NONSTOP FLGHTS AUSTRALIA: Total number of non-stop flights to Australia per week, e.g., 4
WKLY_NONSTOP_FLGHTS_EUROPE WKNSF_EURO NUMBER 4 WKLY NONSTOP FLGHTS EUROPE: Total number of non-stop flights to Europe per week, e.g., 5
WKLY_NONSTOP_FLGHTS_MEXICO WKNSF_MEX NUMBER 4 WKLY NONSTOP FLGHTS MEXICO: Total number of non-stop flights to Mexico per week, e.g., 6
WKLY_NONSTOP_FLGHTS_NEWZEALAND WKNSF_NZ NUMBER 4 WKLY NONSTOP FLGHTS NEWZEALAND: Total number of non-stop flights to New Zealand per week, e.g., 7
WKLY_NONSTOP_FLGHTS_STHAMERICA WKNSF_S_AM NUMBER 4 WKLY NONSTOP FLGHTS STHAMERICA: Total number of non-stop flights to South America per week, e.g., 1
DATA_PUBLICATION_YEAR DT_PUB_YR NUMBER 4 DATA 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