1. Home
  2. Organizations
  3. Ministry of Forests, Lands,...
  4. GeoBC

BC Airports

1295 views (18 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - GeoBC
Licensed under Open Government Licence - British Columbia

BC Airports identifies locations where aircraft may take-off and land. No guarantee is given that an identified point will be maintained to sufficient standards for landing and take-off of any/all aircraft. It includes airports, aerodromes, water aerodromes, heliports, and airstrips.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°
View in iMapBC

Additional Information

Purpose

This dataset has been compiled to provide a complete and detailed dataset of British Columbia's air transport features.
Data Quality

This dataset was derived from a review of existing point and polygon feature classes within the BCGW that contained features pertinent to air transport. Additionally, a considerable amount of information was pulled from the Canadian Flight Supplement. Where individual features resided in multiple datasets, including the Canadian Flight Supplement, the Canadian Flight Supplement was taken to be the authoritative source. All points not listing the Canadian Flight Supplement as DATA_SOURCE had their positions verified against aerial imagery to ensure accurate locations. Coordinates were subsequently derived from these locations. Points listing the Canadian Flight Supplement as DATA_SOURCE were generated from their published coordinates.
Lineage Statement

The following datasets and data sources were used in the creation of this feature class:

WHSE_ENVIRONMENTAL_MONITORING.CHRA_AIRPORTS_POINT REG_IMAGERY_AND_BASEMAPS.AIRPORTS_AIRFIELDS_SBC_POINT WHSE_BASEMAPPING.TRIM_EBM_AIRFIELDS WHSE_IMAGERY_AND_BASE_MAPS.GSR_APRVD_ATTRACTIONS_ISP WHSE_BASEMAPPING.NTS_BC_TRANSPORT_POINTS_125M Digital Road Atlas Sites Digital Road Atlas Localites Canadian Flight Supplement (February 6, 2014 - April 3, 2014)

Contact Information

NameJoy Sinnett (pointOfContact)
Emailjoy.sinnett@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationGeoBC

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2016-05-12
Record Last Modified 2020-09-30
Resource Status onGoing

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.GSR_AIRPORTS_SVW

Short Name: ARPRTS
Comments: GSR_AIRPORTS_SVW is a spatially enabled layer comprising AIRPORTS is a point dataset identifying locations where aircraft can take-off and land. No guarantee is given that an identified point will be maintained to sufficient standards for landing and take-off of any/all aircraft. It includes airports, aerodromes, water aerodromes, heliports, and airstrips.

Column Name Short Name Data Type Data Precision Comments
CUSTODIAN_ORG_DESCRIPTION CUST_ORG VARCHAR2 200 CUSTODIAN_ORG_DESCRIPTION contains the name or description of the custodial organization (usually Ministry and Branch)
BUSINESS_CATEGORY_CLASS BUS_CAT_CL VARCHAR2 1000 BUSINESS_CATEGORY_CLASS designates the category of business, i.e., airTransportation
BUSINESS_CATEGORY_DESCRIPTION BUS_CAT_DS VARCHAR2 1000 BUSINESS_CATEGORY_DESCRIPTION describes the category of business, i.e., Air Transportation
OCCUPANT_TYPE_DESCRIPTION OCCPNT_TYP VARCHAR2 500 OCCUPANT_TYPE_DESCRIPTION contains the description of the occupant type, e.g. Hospital
SOURCE_DATA_ID SRCDATA_ID VARCHAR2 20 SOURCE_DATA_ID is a unique occupant id either supplied by the source data system or produced by GSR, depending on the value of SUPPLIED_SOURCE_ID_IND
SUPPLIED_SOURCE_ID_IND SRC_ID_IND VARCHAR2 1 SUPPLIED_SOURCE_ID_IND is an indicator of whether the source data id was supplied by the supplier (Y) or DataBC (N)
AIRPORT_NAME NAME VARCHAR2 500 AIRPORT_NAME is a business name that can identify the occupant who provides the BC Government or BC Government related services to public, e.g., Burnaby General Hospital, Golden Food Bank
DESCRIPTION DESCRIPTN VARCHAR2 4000 DESCRIPTION describes the Occupant in more detail, e.g., aerodrome.
PHYSICAL_ADDRESS ADDRESS VARCHAR2 1000 PHYSICAL_ADDRESS contains the civic or non-civic address as a single string, structured according to the specification of the Physical Address and Geocoding Standard, e.g., 420 GORGE RD E, VICTORIA, BC.
ALIAS_ADDRESS ALIAS_ADDR VARCHAR2 1000 ALIAS_ADDRESS contains an address string, not a parsed address. It is the address that will be displayed for presentation purposes, e.g., 32900 Marshall Road, Abbotsford, BC
STREET_ADDRESS ST_ADDRESS VARCHAR2 200 STREET_ADDRESS is a free form expression of the site descriptor (e.g., unit) and the civic building number / street / street indicator portion of an address, e.g., Unit 1, 123 Main Street East.
POSTAL_CODE POSTAL_CD VARCHAR2 10 POSTAL_CODE is the Canadian Postal code value associated with the physical address, e.g., V9Z 2K1
LOCALITY LOCALITY VARCHAR2 100 LOCALITY is the name of the municipality, community, Federal Indian Reserve (IR), subdivision, regional district, indigenous land or natural feature the occupant site is located in, e.g., Victoria, Saanich IR 1, Capital Regional District.
CONTACT_PHONE CONT_PHONE VARCHAR2 50 CONTACT PHONE contains the general office phone number of the Occupant, e.g., (250) 555-1234 or 250-555-1234
CONTACT_EMAIL CONT_EMAIL VARCHAR2 100 CONTACT_EMAIL contains the "general office" email address of the Occupant.
CONTACT_FAX CONT_FAX VARCHAR2 50 CONTACT FAX contains the general office fax number of the Occupant, e.g., (250) 555-1234 or 250-555-1234
WEBSITE_URL WEBSITE VARCHAR2 500 WEBSITE_URL contains the link to the Home page of the Occupant's Website
IMAGE_URL IMAGE_URL VARCHAR2 500 IMAGE_URL contains a full URL link to a picture of the Occupant's Location.
LATITUDE LATITUDE NUMBER 9 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 10 LONGITUDE is the geographic coordinate, in decimal degrees (-ddd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544
KEYWORDS KEYWORDS VARCHAR2 1000 KEYWORDS contains text strings supplied by the Custodian, to be used for search/query purposes. Keywords are separated by the ; delimiter.
DATE_UPDATED DT_UPDATE DATE 7 DATE_UPDATED contains the date that the Occupant data was updated in the Occupant structure (system-generated)
SITE_GEOCODED_IND GEOCD_IND VARCHAR2 1 SITE_GEOCODED_IND contains a Flag/indicator (Y/N) that the Occupant Physical Address has been geo-coded by the DataBC Address Geocoder and the results provide a valid site address, e.g., Y, N
AERODROME_STATUS AER_STATUS VARCHAR2 100 AERODROME STATUS identifies if the facility is certified or registered according to Transport Canada standards, or a derived status from other sources, i.e., Certified, Registered, Decommissioned, Null (unknown).
AIRCRAFT_ACCESS_IND AIRCR_ACS VARCHAR2 1 AIRCRAFT ACCESS IND indicates whether fixed wing aircraft, not including seaplanes, can land at this aerodrome, i.e., Y, N, Null (unknown).
DATA_SOURCE DATA_SRCE VARCHAR2 50 DATA_SOURCE is the project or resource from which the aerodrome data was derived, e.g., Canadian Flight Supplement.
DATA_SOURCE_YEAR DATASRC_YR VARCHAR2 50 DATA SOURCE YEAR is the year of the project or resource containing the listed aerodrome data, e.g., 2014.
ELEVATION ELEVATION NUMBER 10 ELEVATION is the published elevation (in metres) of an aerodrome, or if not published, elevation taken from Google Earth (in metres), e.g., 10
FUEL_AVAILABILITY_IND FUEL_AVAIL VARCHAR2 1 FUEL_AVAILABILITY_IND indicates whether fuel is available at this aerodrome, i.e., Y, N, Null (unknown)
HELICOPTER_ACCESS_IND HELI_ACS VARCHAR2 1 HELICOPTER_ACCESS_IND indicates whether helicopters can land at this aerodrome, i.e., Y, N, Null (unknown).
IATA_CODE IATA VARCHAR2 4 IATA_CODE is the International Air Transport Associations's unique identifier code, e.g., YYJ.
ICAO_CODE ICAO VARCHAR2 4 ICAO_CODE is the International Civil Aviation Organizations's unique identifier code, e.g., CYYJ.
MAX_RUNWAY_LENGTH MX_RWAY_LN NUMBER 10 MAX_RUNWAY_LENGTH is the length of the longest runway at an aerodrome in metres, e.g., 700
NUMBER_OF_RUNWAYS NUM_RWAY NUMBER 10 NUMBER_OF_RUNWAYS is the total number of runways at an aerodrome, e.g., 5
OIL_AVAILABILITY_IND OIL_AVAIL VARCHAR2 1 OIL_AVAILABILITY_IND indicates whether fuel oil is available at this aerodrome, i.e., Y, N, Null (unknown)
RUNWAY_SURFACE RWAY_SURF VARCHAR2 50 RUNWAY_SURFACE identifies the material used in a runway or helipad's construction, e.g., gravel, asphalt, Null (unknown).
SEAPLANE_ACCESS_IND SEAPLN_ACC VARCHAR2 1 SEAPLANE_ACCESS_IND indicates whether seaplanes can land at this aerodrome, i.e., Y, N, Null (unknown).
TC_LID_CODE TC_LID VARCHAR2 4 TC_LID_CODE is the Transport Canada Location Identifier unique code, e.g., CAP5.
SHAPE SHAPE SDO_GEOMETRY 64 SHAPE is the column used to reference the spatial coordinates defining the feature.
SEQUENCE_ID SEQ_ID NUMBER 10 SEQUENCE_ID contains a value to distinguish occupant instances. Where a single occupant can have multiple instances (representing different services, for example), this field distinguishes this occupant instance from other instances of the same or different occupants.
SE_ANNO_CAD_DATA BLOB 4000 SE_ANNO_CAD_DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.