GeoNames Forum

I'm creating a software calculator project, and I'd like my users to be able to convert between time zones using what they're familiar with: country, or city/county/state names.

So I need to convert from these places to the corresponding Windows time zone (gonig through TZID as an intermediate stage), and have been looking for a database online to do so, without success, until I found Geonames.org. The "cities15000.zip" file serves my needs for individual cities, but I also need to obtain the population and timezone of larger areas such as country, admin1 and admin2 names.

Is this info easily available in the database? I understand that a given country could be split into more than one timezone, but then an average, or a list of these timezones would be appropriate then.

With the countrycode and timezone fields you can easily create lists of all timezoneids with the same country (adm1, adm2 etc) codes.

Best

Marc