I can't stress just how important (and how hard) it is to get a great source of data for airports, so kudos on the work! When building All the Flight Deals (<a href="https://alltheflightdeals.com" rel="nofollow">https://alltheflightdeals.com</a>) and BookWithMatrix (<a href="https://bookwithmatrix.com" rel="nofollow">https://bookwithmatrix.com</a>), airport data was essential.<p>It seems like your database covers the basics! However, timezone data and airport type/size were pretty important information for us, so we ended up getting these from:<p>- OpenFlights [1]: this dataset was great since it had timezone too, which was really helpful for calculating flight lengths, etc.<p>- OurAirports [2]: no timezone here, but the "type" and "scheduled_service" columns in this dataset are essential. "Type" lets you distinguish between small/medium/large airports, and "scheduled_service" lets you easily filter out airports without real flights (which you often might not care about).<p>- IATA tzmap [3]: this was used for filling in timezone data and is derived from the Geonames database.<p>- Random other GitHub Gist [4]: I have no idea where this data comes from, but it was surprisingly complete and has a few golden nuggets like "num_flights" and "runway_length" in addition to "timezone". The presence of a "woeid" suggests Yahoo-related origins, but it's hard to be sure.<p>Long story short, it'd be AWESOME to have one complete, updated database with all this data in one place, but part of the struggle is definitely having more data than just longitude/latitude.<p>[1] <a href="https://github.com/jpatokal/openflights/" rel="nofollow">https://github.com/jpatokal/openflights/</a><p>[2] <a href="http://ourairports.com/data/" rel="nofollow">http://ourairports.com/data/</a><p>[3] <a href="https://raw.githubusercontent.com/hroptatyr/dateutils/tzmaps/iata.tzmap;" rel="nofollow">https://raw.githubusercontent.com/hroptatyr/dateutils/tzmaps...</a> <a href="http://download.geonames.org/export/dump/" rel="nofollow">http://download.geonames.org/export/dump/</a><p>[4] <a href="https://gist.github.com/tdreyno/4278655" rel="nofollow">https://gist.github.com/tdreyno/4278655</a>
This is a small sample of airports; would be interesting to know how they were selected.<p>> airports big and small from all around the world<p>Well, presumably mostly big.<p>The CIA Facebook shows 13500 airports for the USA alone, and 6 countries with more than 1000 [0]. So, when you count smaller airports (potentially untowered, or unpaved runways), there is way more than what's listed here.<p>Most countries (ICAO members) maintain an AIP (Aeronautical Information Publication, [1]) which lists the bigger airports in a country (and definitely the international ones with immigration and customs facilities) in part AD (aerodromes) and is often readily downloadable from the pertinent national civil aviation authority [2].<p>However, information on smaller airfields is often quite hard to come by.<p>I've flown small airplanes around in southern Africa and Thailand, and relied on websites, books, and aviation clubs to find coordinates for airfields. See eg. the <i>Airfields Directory of Southern Africa</i> [3] or Tom Claytor's list at the bottom of the Thai Flying Club website [4].<p>[0] <a href="https://www.cia.gov/library/publications/the-world-factbook/rankorder/2053rank.html" rel="nofollow">https://www.cia.gov/library/publications/the-world-factbook/...</a><p>[1] <a href="https://en.wikipedia.org/wiki/Aeronautical_Information_Publication" rel="nofollow">https://en.wikipedia.org/wiki/Aeronautical_Information_Publi...</a><p>[2] <a href="https://en.wikipedia.org/wiki/List_of_civil_aviation_authorities" rel="nofollow">https://en.wikipedia.org/wiki/List_of_civil_aviation_authori...</a><p>[3] <a href="http://www.cometaviationsupplies.co.za/index.php?route=product/product&product_id=969" rel="nofollow">http://www.cometaviationsupplies.co.za/index.php?route=produ...</a><p>[4] <a href="http://www.thaiflyingclub.com" rel="nofollow">http://www.thaiflyingclub.com</a><p>EDIT: typos, clarity
Had some time today so put together a .Net client for this data [0][1] in case anyone is interested.<p>[0]: <a href="https://github.com/shrayasr/GlobalAirports.Net" rel="nofollow">https://github.com/shrayasr/GlobalAirports.Net</a>
[1]: <a href="https://www.nuget.org/packages/GlobalAirports.Net" rel="nofollow">https://www.nuget.org/packages/GlobalAirports.Net</a>
OpenFlights also has great data[0] here - and not just for airports, but also train stations, airline/carrier codes, and routes (i.e. origin/destination pairs with a carrier).<p>No sign of schedules from them yet, but there's been a request-for-interest on the site regarding those for a few years now.<p>[0] - <a href="https://openflights.org/data.html" rel="nofollow">https://openflights.org/data.html</a>
Great stuff! I was working on a project where we needed a database of all airports around the world. I used <a href="http://ourairports.com/data/" rel="nofollow">http://ourairports.com/data/</a> IIRC. Out of curiosity, what's different in your project? Also, would be good to add the type of airport (e.g. airfield, airport, etc.).<p>Best of luck!
Opentraveldata (<a href="https://github.com/opentraveldata/opentraveldata" rel="nofollow">https://github.com/opentraveldata/opentraveldata</a>) is generally a great source for travel related data, based mostly on Geobases and Wikipedia. Its OAG extract is a bit old, but all airport data (and more) can be found in <a href="https://github.com/opentraveldata/opentraveldata/blob/master/opentraveldata/optd_por_public.csv" rel="nofollow">https://github.com/opentraveldata/opentraveldata/blob/master...</a>, which is refreshed on an almost daily basis. There are other data sources in the same folder.<p>Also, <a href="https://github.com/opentraveldata/geobases" rel="nofollow">https://github.com/opentraveldata/geobases</a> is a fun way to play around with Geonames/Optd data.
From your site, "Two closest airports: At 370m apart are the Horsching International Airport and Linz Aiports in Austria."<p>From Wikipedia, "Linz Airport, also known as Blue Danube Airport Linz and formerly Hörsching Airport"<p>Are you sure they aren't one and the same?
I think China has more airports than the ones listed in the site.<p><a href="https://en.wikipedia.org/wiki/List_of_airports_in_China#/media/File:China_Airports.png" rel="nofollow">https://en.wikipedia.org/wiki/List_of_airports_in_China#/med...</a>
This site has a total of 9300 airports. The CIA lists 13513 airports in just the US - <a href="https://www.cia.gov/library/publications/the-world-factbook/fields/2053.html#us" rel="nofollow">https://www.cia.gov/library/publications/the-world-factbook/...</a>
OpenFlights is really awesome, we used it to build <a href="https://destigogo.com" rel="nofollow">https://destigogo.com</a><p>Any other tips for complete airport datasets?
It doesn't have Moscow Domodedovo. That's number ten maybe in europe's top100, with 30 mln passengers actually. What use does this DB have with holes like these? F for effort.