An open source SQL database for the list of towns cities by country?

sql database open-source countries
laukok picture laukok · Nov 10, 2010 · Viewed 14.1k times · Source

I am looking for a list of towns, cities by country (the countries I mean here are all countries that exist on planet Earth). Is there any open-source SQL database available online which I can download and use, or any geography social network sites APIs I can use?

Or is it something I have to make it up myself? - I hope not!

Answer

Pablo Santa Cruz picture Pablo Santa Cruz · Nov 10, 2010

There is a sample database for PostgreSQL with that information. I don't know how outdated it is, though...

It's hosted in http://pgfoundry.org/projects/dbsamples/.

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More