Menu
I am looking for an open source flat file (comma separated values for example) of the major cities in this world, together with their latitude longitudes and timezone. The first 1000 or more is fine. Is such a resource available?
Eventually, a combination of two flats files (lat/long & timezone) is fine too.
994
To search for a place, enter the latitude and longitude GPS coordinates on Google Maps. You can also find the coordinates of the places you previously found. Besides longitude and latitude, you can use plus codes to share a place without an address.
Null Island is the point on the Earth's surface at zero degrees latitude and zero degrees longitude ( 0°N 0°E), i.e., where the prime meridian and the equator intersect. Null Island is located in international waters in the Atlantic Ocean, roughly 600 km off the coast of West Africa, in the Gulf of Guinea.
38° 54' N 77° 02' W Example: Washington D.C. 40° 16' N 76° 53' W 1.
You can take a look at this
http://www.partow.net/miscellaneous/airportdatabase/#Download
tells you the lat-long info of all major cities with airports
149
Have a look at: http://www.maxmind.com/app/worldcities
here is also a free version: http://www.maxmind.com/app/geolitecity
35
Building on Parapura's answer (+1 for the great idea of using airport lists):
Here is another much more complete airport database (46325 airports as of today and apparently actively maintained).
To hopefully save other's time, here are the few command lines I used to get it all:
wget ourairports.com/data/airports.csv
wget ourairports.com/data/airport-frequencies.csv
wget ourairports.com/data/runways.csv
wget ourairports.com/data/navaids.csv
wget ourairports.com/data/countries.csv
wget ourairports.com/data/regions.csv
To get major cities, I would use the airports qualified as "large_airport".
32
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
