IRPUD - Institute of Spatial Planning, University of Dortmund

Airports - ASCII File

The IRPUD airport database is stored in one ASCII file. The following table shows the contents of the file AIRPORT.DAT:

Bytes	Length	Type	Contents
1-10	10	Real	Node-ID xxx.yyy xxx = Region-ID (see note) yyyy = Node number 0001 ... Node number in region
11-16	6	Character	ISO country code (see note)
17-22	6	Character	Region code (see note)
23-57	34	Character	Airport name
58-60	3	Character	IATA airport code
61-64	4	Character	ICAO airport code
65-68	4	Integer	TEN/TINA category (see note) 0 = No TEN Airport 1 = International connecting point 2 = Community connecting point 3 = Regional connecting and accessibility point 4 = Other airports
69-72	4	Integer	TEN/TINA airport system (see note) 0 = No part of a TEN airport system 1 = Part of a TEN airport system
73-76	4	Integer	Airport Category 0 = No airport of strategic network 1 = TEN airport 2 = TINA airport 3 = Additional airport
77-80	4	Integer	TEN priority project number (see note) 0 = No TEN priority project 10 = Airport Milan-Malpensa
81-90	10	Integer	X coordinate (m)
91-100	10	Integer	Y coordinate (m)

Notes:

The node-ID is a unique number for each airport in the database. The first three digits indicate the number of the region in which the airport is located. The region code is a four-character acronym of the name of the region. The ISO country code indicates the country in which the airport is located.

The regions are regions of the system of regions defined for the STREAMS and SASI projects. They correspond largely to NUTS-2 regions defined by Eurostat plus equivalent extensions outside the European Union. A more detailed description of the system of regions is available.

IATA and ICAO airport codes indicate unique airport identifiers used in international air traffic. However, these codes are not given for all airports. Some smaller airports with only regional importance have no IATA or ICAO code.

TEN category, TEN airport system, Rail category and TEN priority project number give information on those airports which are included in the "Trans European Transport Network Outline Plan, Section Airports" and are taken from the "Joint Decision of the European Parliament and of the Council" published in the Official Journal of the European Communities (L228, 9 September 1996) and those airports included in the TINA programme. Although the additional airports of the strategic network are not included in the TEN programme, they have been used for modelling accessibilities in a number of research projects. Information on those links which are included in the TINA networks are taken from "TINA Transport Infrastructure needs Assessment. Identification of the Network Components for a future trans-European Transport Network in Bulgaria, Cyprus, Czech Republic, Estonia, Hungary, Latvia, Lithuania, Poland, Romania, Slovakia and Slovenia" (TINA Secretariat 1999) as agreed in the European Union and the candidate countries. The TEN priority project number represents the "specific" projects adopted in 1996 (so called "Essen list") and potential "specific" projects as defined by the European Parlament and the council in 2001.