[tz] Converting from individual cities/states/country names to Windows time zone names

Daniel White twinbee42 at skytopia.com
Mon Dec 5 18:35:46 UTC 2011


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?




More information about the tz mailing list