The Global Airport Database

 www.partow.net  .: Home :.   .: Links :.   .: Search :.   .: Contact :. 



Description

The Global Airport Database is a FREE online downloadable database of 9300 airports big and small from around the world. The database is presented in a simple token separated format. The database provides detailed information about the airports listed including ICAO and IATA codes, country and city, latitude-longitude coordinates and also altitude from mean sea level.

The Global Airport Database Structure

The Global Airport Database is comprised from a series of tuples. Each tuple contains exactly 14 fields of varying pieces of information. The fields depending on what they represent are either a text string, integer values or character. Some of the fields are of constant length whilst others are of varying length. The fields are separated from each other by one colon character ":" acting as a delimiter. There are no leading or trailing delimiters.

Every field must be populated by a value, in the event that a value does not exist for the particular field a string of value "N/A" or ASCII character 0 or for coordinate directions the ASCII character U will be used to represent unknown entity.

The primary key for The Global Airport Database is the airport's ICAO code which is the value in field 1.

The fields are in the following order and have the following properties and meanings:

  • Field 01 - ICAO Code: 4 character ICAO code
  • Field 02 - IATA Code: 3 character IATA code
  • Field 03 - Airport Name: string of varying length
  • Field 04 - City,Town or Suburb: string of varying length
  • Field 05 - Country: string of varying length
  • Field 06 - Latitude Degrees: 2 ASCII characters representing one numeric value
  • Field 07 - Latitude Minutes: 2 ASCII characters representing one numeric value
  • Field 08 - Latitude Seconds: 2 ASCII characters representing one numeric value
  • Field 09 - Latitude Direction: 1 ASCII character either N or S representing compass direction
  • Field 10 - Longitude Degrees: 2 ASCII characters representing one numeric value
  • Field 11 - Longitude Minutes: 2 ASCII characters representing one numeric value
  • Field 12 - Longitude Seconds: 2 ASCII characters representing one numeric value
  • Field 13 - Longitude Direction: 1 ASCII character either E or W representing compass direction
  • Field 14 - Altitude: varying sequence of ASCII characters representing a numeric value corresponding to the airport's altitude from mean sea level (ie: "123" or "-123")

The Airport Tuple Parser

This is a very simple parser demonstrating how the StringTokenizer Class can be used to parse the tuples in The Global Airport Database. Further processing of the database is left to the user.


The Global Airport Database License

Free use of The Global Airport Database and The Airport Tuple Parser are permitted under the guidelines and in accordance with the most current version of the "Common Public License."


Compatability

The Global Airport Database is in the format of a unix text file using 8-bit ASCII character coding. The C++ implementation of the airport tuple parser is compatible with the following C++ compiler:

  • GNU Compiler Collection (3.3.1-x+)
  • Intel® C++ Compiler (8.x+)
  • Borland C++ Builder (5,6)
  • Borland C++ BuilderX

Support

In order to maintain the integrity of The Global Airport Database assistance is needed from the general public for more information about new airports not already listed on the database, also information in order to fill in missing pieces from currently listed airports mainly lat-long coordinates of minor airports and other details. Any help would be very much appreciated.


Download














Copyright Arash Partow