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

[Derick Rethans]

On Mon, 5 Dec 2011, Daniel White wrote:

> > There is one at http://download.geonames.org/export/dump/ (by country, 
> > it's a lot of data).
> 
> Certainly. I only want the most famous places, something closer to around 
> 100k-200k filesize at the most (as my calc is only around 300k itself). If it 
> means I have to filter yet another stage, then so be it, but then I would need 
> to hunt for a list of the '1000 most well known places' (or similar) in the 
> world. 

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

cheers,
Derick