forked from jpatokal/openflights
-
Notifications
You must be signed in to change notification settings - Fork 0
/
data.html
executable file
·374 lines (300 loc) · 22.9 KB
/
data.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>OpenFlights: Airport and airline data</title>
<meta name="description" content="Free airport and airline data with IATA, ICAO, latitude, longitude, elevation, timezone, DST information">
<meta name="keywords" content="airport,airline,data,database,iata,icao,latitude,longitude,elevation,coordinates,timezone,dafif,free">
<link rel="stylesheet" href="/css/style_reset.css" type="text/css">
<link rel="stylesheet" href="/css/help.css" type="text/css">
<link rel="stylesheet" href="/openflights.css" type="text/css">
</head>
<body>
<div id="mainContainer">
<div id="sideBarContentWrapper">
<div id="contentContainer">
<div id="nonmap">
<h1>Airport, airline and route data</h1>
Navigation: <a href="#airport">Airport</a> | <a href="#airline">Airline</a> | <a href="#route">Route</a> | <a href="#schedule">Schedule</a> | <a href="#other">Other</a> | <a href="#license">License</a>
<a name="airport"></a>
<h2>Airport database</h2>
<p><center><a href="/demo/openflights-apdb-2048.png"><img src="/demo/openflights-apdb.png" width="512" height="256"></a><br>(click to enlarge)</center></p>
<p>As of January 2017, the OpenFlights Airports Database contains <b>over 10,000</b> airports, train stations and ferry terminals spanning the globe, as shown in the map above. Each entry contains the following information:</p>
<table>
<tr>
<td class="head">Airport ID</td>
<td class="data">Unique OpenFlights identifier for this airport.
</tr>
<tr>
<td class="head">Name</td>
<td class="data">Name of airport. May or may not contain the <b>City</b> name.</td>
</tr>
<tr>
<td class="head">City</td>
<td class="data">Main city served by airport. May be spelled differently from <b>Name</b>.</td>
</tr>
<tr>
<td class="head">Country</td>
<td class="data">Country or territory where airport is located. See <a href="https://raw.githubusercontent.com/jpatokal/openflights/master/data/countries.dat">countries.dat</a> to cross-reference to ISO 3166-1 codes.
</td>
</tr>
<tr>
<td class="head">IATA</td>
<td class="data">3-letter IATA code. Null if not assigned/unknown.</td>
</tr>
<tr>
<td class="head">ICAO</td>
<td class="data">4-letter ICAO code.<br>
Null if not assigned.</td>
</tr>
<tr>
<td class="head">Latitude</td>
<td class="data">Decimal degrees, usually to six significant digits. Negative is South, positive is North.</td>
</tr>
<tr>
<td class="head">Longitude</td>
<td class="data">Decimal degrees, usually to six significant digits. Negative is West, positive is East.</td>
</tr>
<tr>
<td class="head">Altitude</td>
<td class="data">In feet.</td>
</tr>
<tr>
<td class="head">Timezone</td>
<td class="data">Hours offset from UTC. Fractional hours are expressed as decimals, eg. India is 5.5.</td>
</tr>
<tr>
<td class="head">DST</td>
<td class="data">Daylight savings time. One of E (Europe), A (US/Canada), S (South America), O (Australia), Z (New Zealand), N (None) or U (Unknown). <i>See also: <a target="_blank" href="help/time.html">Help: Time</i>
</tr>
<tr>
<td class="head">Tz database time zone</td>
<td class="data">Timezone in <a href="http://en.wikipedia.org/wiki/Tz_database">"tz" (Olson) format</a>, eg. "America/Los_Angeles".
</tr>
<tr>
<td class="head">Type</td>
<td class="data">Type of the airport. Value "airport" for air terminals, "station" for train stations, "port" for
ferry terminals and "unknown" if not known. <i>In airports.csv, only type=airport is included.</i>
</tr>
<tr>
<td class="head">Source</td>
<td class="data">Source of this data. "OurAirports" for data sourced from <a href="http://ourairports.com/data/">OurAirports</a>, "Legacy" for old data not matched to OurAirports (mostly DAFIF), "User" for unverified user contributions. <i>In airports.csv, only source=OurAirports is included.</i>
</tr>
</tr>
</table>
<p>The data is UTF-8 (Unicode) encoded.</p>
<p><i>Note</i>: Rules for daylight savings time change from year to year and from country to country. The current data is an approximation for 2009, built on a country level. Most airports in DST-less regions in countries that generally observe DST (eg. AL, HI in the USA, NT, QL in Australia, parts of Canada) are marked incorrectly.</p>
<h4>Sample entries</h4>
<pre>507,"London Heathrow Airport","London","United Kingdom","LHR","EGLL",51.4706,-0.461941,83,0,"E","Europe/London","airport","OurAirports"
26,"Kugaaruk Airport","Pelly Bay","Canada","YBB","CYBB",68.534401,-89.808098,56,-7,"A","America/Edmonton","airport","OurAirports"
3127,"Pokhara Airport","Pokhara","Nepal","PKR","VNPK",28.200899124145508,83.98210144042969,2712,5.75,"N","Asia/Katmandu","airport","OurAirports"
8810,"Hamburg Hbf","Hamburg","Germany","ZMB",\N,53.552776,10.006683,30,1,"E","Europe/Berlin","station","User"
</pre>
<p style="font-size: 1.5em; padding: 10px; background-color: #ccffcc;">Try it out: <a target="_blank" href="html/apsearch">Airport Search</a> (new window)</p>
<p><i>Note</i>: The Airport Search window above is a part of <a href="http://openflights.org">OpenFlights</a>. You will not be able to add or edit airports unless you are logged in.</p>
<h4>Download</h4>
<p>To download the current data dump from <a href="https://github.com/jpatokal/openflights">GitHub</a> as a very straightforward CSV (comma-separated value) file, suitable for use in spreadsheets etc, simply click below:</p>
<p style="font-size: 1.5em; padding: 10px; background-color: #ccffcc;">Download: <a href="https://raw.githubusercontent.com/jpatokal/openflights/master/data/airports.dat">airports.dat</a> (Airports only, high quality)</p>
<p style="font-size: 1.5em; padding: 10px; background-color: #ccffcc;">Download: <a href="https://raw.githubusercontent.com/jpatokal/openflights/master/data/airports-extended.dat">airports-extended.dat</a> (Airports, train stations and ferry terminals, including user contributions)</p>
<table><tr><td>
<p>Creating and maintaining this database has required and continues to require an <i>immense amount</i> of work, which is why it would cost you <i>over one thousand dollars</i> to buy it from a commercial supplier. We need your support to keep this database up-to-date: just click on the PayPal link to the right (Visa, MasterCard, American Express and Discover also accepted). We suggest <b>US$50</b>, but any amount at all is welcome, and you may use the data for free if you feel that you are unable to pay. If you do donate, please specify in the comments if you would like a itemized receipt for business expense or tax purposes.</p>
</td><td>
<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="hosted_button_id" value="S9DFF2L4BA56L">
<table>
<tr><td><input type="hidden" name="on0" value="Support OpenFlights">Support OpenFlights</td></tr><tr><td><select name="os0">
<option value="Small Donation">Small Donation $20.00 USD</option>
<option value="Donation" selected>Donation $50.00 USD</option>
<option value="Combo Donation">Combo Donation $100.00 USD</option>
</select> </td></tr>
</table>
<input type="hidden" name="currency_code" value="USD">
<input type="image" src="https://www.paypalobjects.com/en_GB/SG/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal — The safer, easier way to pay online.">
<img alt="" border="0" src="https://www.paypalobjects.com/en_GB/i/scr/pixel.gif" width="1" height="1">
</form>
</td></tr></table>
<p>The GitHub copy is only a sporadically updated static snapshot of the live OpenFlights database (see <a href="https://github.com/jpatokal/openflights/commits/master/data/airports.dat">revision log</a>). If you would like an up-to-the-minute copy, or you would like your data filtered by any information available to us (eg. number of routes at the airport), do not hesitate to <a href="/about.html">contact us</a>.<p>
<p>If you'd like an even more thorough database, with extensive coverage of airstrips, heliports and other places of less interest for commercial airline frequent flyers, do check out <a href="http://ourairports.com">OurAirports</a>, whose public domain database covers over 40,000 places to fly from.<p>
<a name="airline"></a>
<h2>Airline database</h2>
<p>As of January 2012, the OpenFlights Airlines Database contains <b>5888</b> airlines. Each entry contains the following information:</p>
<table>
<tr>
<td class="head">Airline ID</td>
<td class="data">Unique OpenFlights identifier for this airline.
</tr>
<tr>
<td class="head">Name</td>
<td class="data">Name of the airline.
</tr>
<tr>
<td class="head">Alias</td>
<td class="data">Alias of the airline. For example, All Nippon Airways is commonly known as "ANA". </td>
</tr>
<tr>
<td class="head">IATA</td>
<td class="data">2-letter IATA code, if available.</td>
</tr>
<tr>
<td class="head">ICAO</td>
<td class="data">3-letter ICAO code, if available.<br>
</tr>
<tr>
<td class="head">Callsign</td>
<td class="data">Airline callsign.</td>
</tr>
<tr>
<td class="head">Country</td>
<td class="data">Country or territory where airline is incorporated.</td>
</tr>
<tr>
<td class="head">Active</td>
<td class="data">"Y" if the airline is or has until recently been operational, "N" if it is defunct. This field is <i>not</i> reliable: in particular, major airlines that stopped flying long ago, but have not had their IATA code reassigned (eg. Ansett/AN), will incorrectly show as "Y".</td>
</tr>
</table>
<p>The data is ISO 8859-1 (Latin-1) encoded. The special value <b>\N</b> is used for "NULL" to indicate that no value is available, and is understood automatically by MySQL if imported.</p>
<p><i>Notes</i>: Airlines with null codes/callsigns/countries generally represent user-added airlines. Since the data is intended primarily for current flights, defunct IATA codes are generally not included. For example, "Sabena" is not listed with a SN IATA code, since "SN" is presently used by its successor Brussels Airlines.</p>
<h4>Sample entries</h4>
<pre>324,"All Nippon Airways","ANA All Nippon Airways","NH","ANA","ALL NIPPON","Japan","Y"
412,"Aerolineas Argentinas",\N,"AR","ARG","ARGENTINA","Argentina","Y"
413,"Arrowhead Airways",\N,"","ARH","ARROWHEAD","United States","N"</pre>
<p style="font-size: 1.5em; padding: 10px; background-color: #ccffcc;">Try it out: <a target="_blank" href="html/alsearch">Airline Search</a> (new window)</p>
<p><i>Note</i>: The Airline Search window above is a part of <a href="http://openflights.org">OpenFlights</a>. You will not be able to view, add or edit airline details unless you are logged in.</p>
<h4>Download</h4>
<p>To download the current data dump from <a href="https://github.com/jpatokal/openflights/">GitHub</a> as a very straightforward CSV (comma-separated value) file, suitable for use in spreadsheets etc, simply click below:</p>
<p style="font-size: 1.5em; padding: 10px; background-color: #ccffcc;">Download: <a href="https://raw.githubusercontent.com/jpatokal/openflights/master/data/airlines.dat">airlines.dat</a> (~400 KB)</p>
<table><tr><td>
<p>Creating and maintaining this database has required and continues to require an <i>immense amount</i> of work. We need your support to keep this database up-to-date: just click on the PayPal link to the right (Visa, MasterCard, American Express and Discover also accepted). We suggest <b>US$50</b>, but any amount at all is welcome, and you may use the data for free if you feel that you are unable to pay. If you do donate, please specify in the comments if you would like a itemized receipt for business expense or tax purposes.</p>
</td><td>
<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="hosted_button_id" value="S9DFF2L4BA56L">
<table>
<tr><td><input type="hidden" name="on0" value="Support OpenFlights">Support OpenFlights</td></tr><tr><td><select name="os0">
<option value="Small Donation">Small Donation $20.00 USD</option>
<option value="Donation" selected>Donation $50.00 USD</option>
<option value="Combo Donation">Combo Donation $100.00 USD</option>
</table>
<input type="hidden" name="currency_code" value="USD">
<input type="image" src="https://www.paypalobjects.com/en_GB/SG/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal — The safer, easier way to pay online.">
<img alt="" border="0" src="https://www.paypalobjects.com/en_GB/i/scr/pixel.gif" width="1" height="1">
</form>
</td></tr></table>
<p>The GitHub copy is only a sporadically updated static snapshot of the live OpenFlights database (see <a href="https://github.com/jpatokal/openflights/commits/master/data/airlines.dat">revision log</a>). If you would like an up-to-the-minute copy, or you would like your data filtered by any information available to us (eg. number of flights by airline), do not hesitate to <a href="/about.html">contact us</a>.<p>
<a name="route"></a>
<h2>Route database</h2>
<p><center><a href="/demo/openflights-routedb-2048.png"><img src="/demo/openflights-routedb.png" width="512" height="256"></a><br>(click to enlarge)</center></p>
<p>As of January 2012, the OpenFlights/Airline Route Mapper Route Database contains <b>59036</b> routes between <b>3209</b> airports on <b>531</b> airlines spanning the globe, as shown in the map above. Each entry contains the following information:</p>
<table>
<tr>
<td class="head">Airline</td>
<td class="data">2-letter (IATA) or 3-letter (ICAO) code of the airline.
</tr>
<tr>
<td class="head">Airline ID</td>
<td class="data">Unique OpenFlights identifier for airline (see <a href="#airline">Airline</a>).
</tr>
<tr>
<td class="head">Source airport</td>
<td class="data">3-letter (IATA) or 4-letter (ICAO) code of the source airport.<br>
</tr>
<tr>
<td class="head">Source airport ID</td>
<td class="data">Unique OpenFlights identifier for source airport (see <a href="#airport">Airport</a>)
</tr>
<tr>
<td class="head">Destination airport</td>
<td class="data">3-letter (IATA) or 4-letter (ICAO) code of the destination airport.<br>
</tr>
<tr>
<td class="head">Destination airport ID</td>
<td class="data">Unique OpenFlights identifier for destination airport (see <a href="#airport">Airport</a>)
</tr>
<tr>
<td class="head">Codeshare</td>
<td class="data">"Y" if this flight is a codeshare (that is, not operated by <i>Airline</i>, but another carrier), empty otherwise.</td>
</tr>
<tr>
<td class="head">Stops</td>
<td class="data">Number of stops on this flight ("0" for direct)</td>
</tr>
<tr>
<td class="head">Equipment</td>
<td class="data">3-letter codes for plane type(s) generally used on this flight, separated by spaces</td>
</tr>
</table>
<p>The data is ISO 8859-1 (Latin-1) encoded. The special value <b>\N</b> is used for "NULL" to indicate that no value is available, and is understood automatically by MySQL if imported.</p>
<i>Notes</i>:
<ul>
<li>Routes are directional: if an airline operates services from A to B and from B to A, both A-B and B-A are listed separately.
<li>Routes where one carrier operates both its own and codeshare flights are listed only once.
</ul>
<h4>Sample entries</h4>
<pre>BA,1355,SIN,3316,LHR,507,,0,744 777
BA,1355,SIN,3316,MEL,3339,Y,0,744
TOM,5013,ACE,1055,BFS,465,,0,320
</pre>
<p>Route maps for airports and airlines can be viewed by <a href="http://openflights.org/blog/2009/07/15/airline-route-maps-launched-metric-distances-available/">searching for their names or code in the website's Search
box</a>; alternatively, check out the <a
href="/html/route-maps">alphabetical list of all
covered airports and airlines</a>.</p>
<h4>Download</h4>
<p>To download the current data dump from <a href="https://github.com/jpatokal/openflights">GitHub</a> as a tab-delimited file, suitable for use in spreadsheets etc, simply click below:</p>
<p style="font-size: 1.5em; padding: 10px; background-color: #ccffcc;">Download: <a href="https://raw.githubusercontent.com/jpatokal/openflights/master/data/routes.dat">routes.dat</a> (~2 MB)</p>
<table><tr><td>
<p>Creating and maintaining this database has required and continues to require an <i>immense amount</i> of work. We need your support to keep this database up-to-date: just click on the PayPal link to the right (Visa, MasterCard, American Express and Discover also accepted). We suggest <b>US$50</b>, but any amount at all is welcome, and you may use the data for free if you feel that you are unable to pay. If you do donate, please specify in the comments if you would like a itemized receipt for business expense or tax purposes.</p>
</td><td>
<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="hosted_button_id" value="S9DFF2L4BA56L">
<table>
<tr><td><input type="hidden" name="on0" value="Support OpenFlights">Support OpenFlights</td></tr><tr><td><select name="os0">
<option value="Small Donation">Small Donation $20.00 USD</option>
<option value="Donation" selected>Donation $50.00 USD</option>
<option value="Combo Donation">Combo Donation $100.00 USD</option>
</select> </td></tr>
</table>
<input type="hidden" name="currency_code" value="USD">
<input type="image" src="https://www.paypalobjects.com/en_GB/SG/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal — The safer, easier way to pay online.">
<img alt="" border="0" src="https://www.paypalobjects.com/en_GB/i/scr/pixel.gif" width="1" height="1">
</form>
</td></tr></table>
<p>The GitHub copy is only a sporadically updated static snapshot of the live OpenFlights database (see <a href="https://github.com/jpatokal/openflights/commits/master/data/routes.dat">revision log</a>). If you would like an up-to-the-minute copy, or you would like your data filtered by any information available to us (eg. number of routes by airline), do not hesitate to <a href="/about.html">contact us</a>.<p>
<a name="schedule"></a>
<h2>Schedules (Timetables)</h2>
<p>OpenFlights is currenty considering launching an airline schedule (timetable) data service. Please register your interest by <a href="https://docs.google.com/forms/d/1KadfmOED90LHtUEOxA2oYW9nrN9ibqkz0oRVVogxM8A/viewform">filling out this short survey</a>.</p>
<a name="other"></a>
<h2>Other</h2>
<p>OpenFlights can, on request, create customized versions of the images you see above. Options include higher resolution (suitable for printing), different backgrounds, filtering to highlight an airport or airline, etc. Please <a href="/about">contact us</a> for a quote.</p>
<p>OpenFlights offers only airport, airline and route data; we do <em>not</em> have any other data available. We also do not have historical data older than 2009.</p>
<p>Some alternative commercial sources of data include:</p>
<ul>
<li><a href="http://www.cleartrip.com/api/docs/air-api/">Cleartrip</a>: airfares</a>
<li><a href="http://flightaware.com/commercial/flightxml/">FlightAware</a>: flight tracking</a></li>
<li><a href="https://developer.flightstats.com/">FlightStats</a>: schedules, flight tracking, historical data</li>
<li><a href="http://flightwise.com/">FlightWise</a>: flight tracking</li>
</ul>
<p>If you or a website you know of offers any of these for free, please <a href="/about">let us know</a>!</p>
<a name="license"></a>
<h2>Licensing and disclaimer</h2>
<p>The OpenFlights Airport, Airline and Route Databases are made available under the <a href="http://opendatacommons.org/licenses/odbl/1.0/">Open Database License</a>. Any rights in individual contents of the database are licensed under the <a href="http://opendatacommons.org/licenses/dbcl/1.0/">Database Contents License</a>. In short, these mean that you are welcome to use the data as you wish, if and only if you <i>both</i> acknowledge the source <i>and</i> and license any derived works made available to the public with a free license as well.</p>
<p>Licenses for commercial use of data or derived images are available on request. Most simple cases, for example use of an image within a book or other printed publication, are granted for a flat fee of US$100. Please <a href="/about">contact us</a> for details.</p>
<p>Airport data derived <a href="http://ourairports.com">OurAirports</a> and DAFIF, as well as route data from <a href="http://arm.64hosts.com/">Airline Route Mapper</a>, is in the public domain. Airline data derived from Wikipedia may be subject to the <a href="http://www.gnu.org/copyleft/fdl.html">GNU Free Documentation License</a>. Whether these databases pass the <a href="http://en.wikipedia.org/wiki/Threshold_of_originality">threshold of originality</a> and are thus copyrightable in the United States is an open question, and Contentshare does not assert the validity or lack thereof of such a claim.</p>
<p><b>This data is not suitable for navigation.</b> OpenFlights does not assume any responsibility whatsoever for its accuracy, and consequently assumes no liability whatsoever for results obtained or loss or damage incurred as a result of application of the data. OpenFlights expressly disclaims all warranties, expressed or implied, including but not limited to implied warranties of merchantability and fitness for any particular purpose.</p>
<p>Any corrections will be <a href="/about">gratefully received</a>.
<h2>Sources</h2>
<p>Airport base data was generated by from DAFIF (October 2006 cycle) and <a href="http://ourairports.com">OurAirports</a>, plus timezone information from <a href="http://www.earthtools.org">EarthTools</a>. All DST information added manually. Significant revisions and additions made by the users of OpenFlights.</p>
<p>Airline data was extracted directly from Wikipedia's gargantuan <a href="http://en.wikipedia.org/en/List_of_airlines">List of airlines</a>. Significant revisions and additions made by the users of OpenFlights.</p>
<p>Route data is maintained by and imported directly from <a href="http://arm.64hosts.com/">Airline Route Mapper</a>. Duplicate entry removal and cross-referencing to airport/airline IDs by OpenFlights.</p>
<p><i>See also: <a target="_blank" href="help/database.html">Help: Database</i></p>
<br><br>
</div>
</div>
<div id="sideBar">
<!--#include virtual="/sidebar.html" -->
<!--#include virtual="/html/ad-sidebar.html" -->
</div>
</div> <!-- end sidebarwrapper -->
</div> <!-- end mainContainer -->
</body>
</html>