Airports, Train Stations, And Ferry Terminals

Context

This is a database of airports, train stations, and ferry terminals around the world. Some of the data come from public sources and some of it comes from OpenFlights.org user contributions.

Content

• Airport ID Unique OpenFlights identifier for this airport.
• Name Name of airport. May or may not contain the City name.
• City Main city served by airport. May be spelled differently from Name.
• Country Country or territory where airport is located. See countries.dat to cross-reference to ISO 3166-1 codes.
• IATA 3-letter IATA code. Null if not assigned/unknown.
• ICAO 4-letter ICAO code.
• Null if not assigned.
• Latitude Decimal degrees, usually to six significant digits. Negative is South, positive is North.
• Longitude Decimal degrees, usually to six significant digits. Negative is West, positive is East.
• Altitude In feet.
• Timezone Hours offset from UTC. Fractional hours are expressed as decimals, eg. India is 5.5.
• DST Daylight savings time. One of E (Europe), A (US/Canada), S (South America), O (Australia), Z (New Zealand), N (None) or U (Unknown). See also: Help: Time
• Tz database time zone Timezone in "tz" (Olson) format, eg. "America/Los_Angeles".
• Type Type of the airport. Value "airport" for air terminals, "station" for train stations, "port" for ferry terminals and "unknown" if not known.
• Source Source of this data. "OurAirports" for data sourced from OurAirports, "Legacy" for old data not matched to OurAirports (mostly DAFIF), "User" for unverified user contributions. In airports.csv, only source=OurAirports is included.

Acknowledgements

This dataset was downloaded from Openflights.org under the Open Database license. This is an excellent resource and there is a lot more on their website, so check them out!