[tz] Converting from individual cities/states/country names to Windows time zone names
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
More information about the tz