All geek questions in one place

An open source SQL database for a list of city cities by country?

I am looking for a list of cities, cities by country (the countries that I mean are all countries that exist on planet Earth). Is there any open source SQL database available on the Internet that I can download and use, or any social networking site APIs that I can use?

Or is it something I have to do myself? - I hope no!

0
source share
3 answers

There is an example database for PostgreSQL with this information. I don’t know how old it is, though ...

It is available at http://pgfoundry.org/projects/dbsamples/ .

+2
source

Try the following:

The download file contains a list of all cities, administrative units and metropolitan areas with their current population, their English name (if not equal to the international name) and the parent country. International names are displayed in UTF-8 format, which means that special characters that are not displayed using a normal text editor are displayed as two characters. A free text editor that can read UTF-8 characters is UniRed. When opening a UniRed file, you must specify the UTF-8 encoding.

http://www.world-gazetteer.com/wg.php?x=1129163518&men=stdl&lng=en&gln=xx&dat=32&srt=npan&col=aohdq

+1
source

This gives SQL to insert a list of countries into the table - 239 of them:

http://www.sqldumpster.com/databases/geographic/

Search for "Countries (and ISO Codes)"

I did not find anything obvious for cities and towns. Perhaps you can use the list of countries to find the finder, to find them.

0
source

Source: https://habr.com/ru/post/1398463/

More articles:


All Articles