dbTalk Databases Forums  

Looking for a lat/lon to timezone database

comp.databases comp.databases


Discuss Looking for a lat/lon to timezone database in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jims
 
Posts: n/a

Default Looking for a lat/lon to timezone database - 09-04-2007 , 05:12 PM






Hi.

I'm looking for this for north america. I've seen loads of databases
with zip, city name, lat, lon, timezone, etc. but I need something
that's more of a grid where I can look up a lat/lon and get a timezone
back.

I'm willing to pay for it, but I can't find anything via various
google searches.

I suppose that I could take a zip code db with lat/lon and reverse
engineer it knowing that it's resolution will be that of the US
+Canadian zip code map.

Thanks,

Jim


Reply With Quote
  #2  
Old   
Ronnie Chee
 
Posts: n/a

Default Re: Looking for a lat/lon to timezone database - 09-04-2007 , 09:57 PM






"jims" <jim (AT) asrc (DOT) cestm.albany.edu> wrote

Quote:
Hi.

I'm looking for this for north america. I've seen loads of databases
with zip, city name, lat, lon, timezone, etc. but I need something
that's more of a grid where I can look up a lat/lon and get a timezone
back.

I'm willing to pay for it, but I can't find anything via various
google searches.

I suppose that I could take a zip code db with lat/lon and reverse
engineer it knowing that it's resolution will be that of the US
+Canadian zip code map.

Thanks,

Jim

A half-baked answer for you.
Have a look at http://www.geonames.org/export/
Scroll to the bottom of the page to "Timezone"
Click on the example which returns a browser window with an XML result file.
Timezone names are odd (to me at least) but follow an IANA (proposed?)
standard http://www.hermetic.ch/cal_stud/newman.htm 6.6 - might be better
documention elsewhere.
Not sure how they are doing it exactly but maybe they can point you at their
datasource or you could piggyback on their service.




Reply With Quote
  #3  
Old   
jims
 
Posts: n/a

Default Re: Looking for a lat/lon to timezone database - 09-05-2007 , 11:28 AM



Thanks, Ronnie. I'll have a look.

-jim


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.