Derick Rethans <tz <at> derickrethans.nl> writes:
Population information is also in that database btw. There is a file "cities15000.txt" which lists as: cities15000.zip : all cities with a population > 15000 (ca 20.000), see 'geoname' table for columns
I've just realized - one thing sadly lacking from this database is the country each city is based in. That means clashes like 'Bedford' would have 2+ corresponding countries, but I can't easily list the specific country on top. Also if people want to search for a time zone by country name, I can't use that (and yes, for countries with multiple time zones, I'd at least average them out, which is better than nothing). Is there yet another database I can use to map these city names to their corresponding countries?