June 2, 2014
8:55 a.m.
On Sun, 1 Jun 2014, Joris Van den Bogaert wrote:
Hi Angel,
Matching geo data to a timezone is a bit fuzzy. On the other hand, you state that correct calculation is critical.
We’re working with old protocols that don’t include TZ information in the data that is sent to us, so we have to get thet TZ info through geo mapping tables. We’ve been looking at geopostcodes.com.
If you have lat/lon, have a look at what I did here: http://derickrethans.nl/what-time-is-it.html There is also a (free) dataset at http://download.geonames.org/export/dump/ linking nearly every city in the world with a TZiD -- in case you need to cover more than just the US. cheers, Derick