List of major cities with latitude longitude and timezone

Question

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.

See also [this community wiki entry](http://stackoverflow.com/q/16086962/634824) — Matt Johnson-Pint, Apr 18 '13 at 16:29

score 21 · Answer 1 · answered Aug 23 '11 at 03:24

21

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

answered Aug 23 '11 at 03:24

parapura rajkumar

24,045
1
55
85

7

The following command converts the database to "City, Country:LatDecimal:LonDecimal" format. `cat GlobalAirportDatabase.txt | grep -v "00:00:00" | awk -F':' '{print $4", "$5":"$9""($6+$7/60+$8/3600)":"$13""($10+$11/60+$12/3600)}' | sed 's/:S/:-/' | sed 's/:U/:-/' | sed 's/:N/:/' | sed 's/:E/:/' > WorldCities` – Richard Sep 16 '14 at 23:32
Nice! Despite the name, it contains not the airport coordinates. There are 7322 cities in that CSV right now. The coordinates, however, seem rather arbitrary to me. For Augsburg (Germany), for example, it is definitily not an important part of the city where the coordinates point to. – Martin Thoma Mar 19 '18 at 11:15

score 10 · Accepted Answer · answered Aug 23 '11 at 03:18

10

Have a look at: http://www.maxmind.com/app/worldcities

here is also a free version: http://www.maxmind.com/app/geolitecity

answered Aug 23 '11 at 03:18

stewe

41,820
13
79
75

This one has a lot of duplicate entries in it, which are different by one letter and etc. – saganas Jun 16 '16 at 16:33
Have a look at `pt,Porto` entries (yes, there are duplicates for the same city) to estimate the quality of that dataset. – Martin Thoma Mar 19 '18 at 10:19
The worldcities link doesn't work anymore, and "GeoLite Legacy databases were discontinued on January 2, 2019" – Nico May 16 '19 at 14:13

score 1 · Answer 3 · edited May 23 '17 at 12:26

1

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".

edited May 23 '17 at 12:26

Community

1
1

answered Apr 22 '15 at 00:43

Pierre D

24,012
7
60
96

This assumes that every major city has an airport. – Rolf Dec 24 '17 at 12:28
3

@Rolf Could you give a counter example? – Martin Thoma Mar 19 '18 at 11:16
This dataset includes 616 large airports, 4500 medium airports, and 35000 small airports. That should cover anything most people describe as a major city. – DanB Dec 28 '20 at 20:55

score 1 · Answer 4 · answered Dec 24 '17 at 12:35

1

I had this problem - I needed it to place markers on a map. Here is the procedure that I followed:

https://gist.github.com/rolfen/cdaf1895b44659c1c4d2b90970af443e

The data is provided by Wikipedia:
https://en.wikipedia.org/w/index.php?title=List_of_cities_by_longitude&printable=yes

I do some processing on that using the browser debugging console.

The output is a JSON object. If you can work with JavaScript, it should be easy to tweak.

answered Dec 24 '17 at 12:35

Rolf

5,550
5
41
61

1

Replacing `"#mw-content-text > table.wikitable tbody tr"` by `"table.wikitable tbody tr"` and it works for me. – Martin Thoma Mar 19 '18 at 10:58
Thank you @MartinThoma . It seems the markup has changed, I'm updating the gist. – Rolf Mar 19 '18 at 17:57

score 1 · Answer 5 · answered Aug 22 '22 at 23:32

I've found one that's still on the web and kept reasonably up-to-date: https://simplemaps.com/data/world-cities

The Basic version (approx. 41 thousand locations) is available free under Creative Commons licensing in CSV or Excel formats. Lat, long, and population are all included. I've just downloaded it, so no quality testing yet.

score 0 · Answer 6 · answered Apr 22 '15 at 01:17

0

This one ships as CSV files http://www.geobytes.com/geoworldmap/ and contians latitude longitudes and timezones.

answered Apr 22 '15 at 01:17

herzo

11
1

score 0 · Answer 7 · answered Sep 23 '22 at 14:19

I would recommend NaturalEarth where you can download files with major cities including their names in different languages and their population. Country borders and time zones are provided as well. The download formats include SHP, SQLite and GeoPackage; no CSV though, but all are easy to read in QGIS (where you can convert them to CSV) or e.g. Python.

If you need smaller cities as well have a look at https://www.geonames.org/ - at that site CSV downloads of cities are provided (with coordinates, names and other properties).

List of major cities with latitude longitude and timezone

7 Answers7