I'm forwarding this message from Nathan Heaivilin, who is not on the time zone mailing list. Those of you who are on the list, please direct replies appropriately. --ado From: Nathan Heaivilin [mailto:heaivilin@hotmail.com] Sent: Wednesday, October 22, 2008 10:33 To: tz@lecserver.nci.nih.gov Subject: list To Whom it May Concern, I am trying to find a world list of Time Zones by Zip Codes and/or Area Code(and their respective foreign number) in sometype of downloadable format (CSV, XML, Excel, etc). Example: USA 33647 -6:00 GST USA 95400 -9:00 GST Europe xxxxx -x:xx GST Africa xxxxx +x:00 GST Does something like this exist? If so, do you have a copy available for download? If not, do you know where I can get it. Just trying to figure out a way to tie an address or phone number anywhere in the world to a time zone. Thank you very much for all of your assistance. Sincerely, Nathan Heaivilin
Well, all the cases where an entire country is in one time zone, you're done. Same for the US when a state is within one time zone. Beyond that, it can get tricky. For example, taking the 3xxxx range of zip codes in the US, it has subranges. 300-319 and 399 are Georgia, straight Eastern. 320-349 is Florida, of which a small portion is Central and the rest Eastern. 350-369 and 386-398 are Alabama and Mississippi, respectively, straight Central. Finally, 370-385 is Tennessee, again split but this time with a majority in Central. So the fundamental problem is to first identify the place covered by a given point, then put that point in a time zone. -----Original Message----- From: Olson, Arthur David (NIH/NCI) [E] [mailto:olsona@dc37a.nci.nih.gov] Sent: Thursday 23 October 2008 10:21 To: tz@lecserver.nci.nih.gov Cc: heaivilin@hotmail.com Subject: FW: list I'm forwarding this message from Nathan Heaivilin, who is not on the time zone mailing list. Those of you who are on the list, please direct replies appropriately. --ado From: Nathan Heaivilin [mailto:heaivilin@hotmail.com] Sent: Wednesday, October 22, 2008 10:33 To: tz@lecserver.nci.nih.gov Subject: list To Whom it May Concern, I am trying to find a world list of Time Zones by Zip Codes and/or Area Code(and their respective foreign number) in sometype of downloadable format (CSV, XML, Excel, etc). Example: USA 33647 -6:00 GST USA 95400 -9:00 GST Europe xxxxx -x:xx GST Africa xxxxx +x:00 GST Does something like this exist? If so, do you have a copy available for download? If not, do you know where I can get it. Just trying to figure out a way to tie an address or phone number anywhere in the world to a time zone. Thank you very much for all of your assistance. Sincerely, Nathan Heaivilin
I'm not aware of an freely available data like you request. But there are plenty of commercially available geocoding services and software packages that include time zone in the data they output. Just do a web search for 'geocode' and 'time zone' and you should get a few good hits within the first page or two. I can't speak for the completeness or correctness of any of these products, but if your needs are limited to the United States, and you can afford to pay for geocoding, you should be able to find something that meets your needs. -Scott From: Nathan Heaivilin [mailto:heaivilin@hotmail.com]
Sent: Wednesday, October 22, 2008 10:33 To: tz@lecserver.nci.nih.gov Subject: list
To Whom it May Concern,
I am trying to find a world list of Time Zones by Zip Codes and/or Area Code(and their respective foreign number) in sometype of downloadable format (CSV, XML, Excel, etc).
Example:
USA 33647 -6:00 GST USA 95400 -9:00 GST Europe xxxxx -x:xx GST Africa xxxxx +x:00 GST
Does something like this exist? If so, do you have a copy available for download? If not, do you know where I can get it. Just trying to figure out a way to tie an address or phone number anywhere in the world to a time zone.
Thank you very much for all of your assistance.
Sincerely,
Nathan Heaivilin
-- Scott Atwood YES on 1A: Bring High Speed Rail to CA NO on 8: Equality for All NO on 4: Protect Our Children
Olson, Arthur David (NIH/NCI) [E] escribió el 23/10/08 12:20:
I am trying to find a world list of Time Zones by Zip Codes and/or Area Code(and their respective foreign number) in sometype of downloadable format (CSV, XML, Excel, etc).
Example:
USA 33647 -6:00 GST USA 95400 -9:00 GST Europe xxxxx -x:xx GST Africa xxxxx +x:00 GST
Does something like this exist? If so, do you have a copy available for download? If not, do you know where I can get it. Just trying to figure out a way to tie an address or phone number anywhere in the world to a time zone.
Thank you very much for all of your assistance.
Sincerely,
Nathan Heaivilin
I don't think you can get this data from Argentina since not many people worries about timezones (only when there are political fights about using or not DST or adhering to one or another timezone)... However, since I had already made a Province to Timezone mapping and the ZIP codes include the ISO-3166-2 Province Code, I added the ISO-3166-2 code to my table (and also Gwillim Law's Hierarchical Administrative Subdivision Code, see http://statoids.com/ihasc.html). The table is at http://wiki.clueless.com.ar/ActualizarTimezonesConTzdata#provincia_tz_baby it'll be valid when tz2008i introduces the America/Argentina/Salta timezone (before that, the Provinces that have that code were in the America/Argentina/Cordoba timezone). The ZIP Codes in Argentina are called CPA (Código Postal Argentino) and are of the form IDDDDLLL (see http://www.correoargentino.com.ar/consulta_cpa/home.php) Where I is the ISO-3166-2 code. DDDD are 4 digits (starting at 1000, have the same value as the older -pre 1998- ZIP Codes) LLL are 3 letters that identify the side of a block. The only thing you need to identify the timezone is the first character "I" which can be any English alphabet letter except the "I" or "O" (there are 23 Provinces plus the Federal "Ciudad Autónoma de Buenos Aires", historically called "Capital Federal"). HTH -- Mariano Absatz - "El Baby" baby@baby.com.ar www.clueless.com.ar -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- on top-posting...
Because it fouls the order in which people normally read text.
Why is top-posting such a bad thing?
Top-posting.
What is the most annoying thing on usenet and in e-mail?
TOPIC: Posting Etiquette -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- * TagZilla 0.066 * http://tagzilla.mozdev.org
participants (4)
-
Andy Lipscomb -
Mariano Absatz - El Baby -
Olson, Arthur David (NIH/NCI) [E] -
Scott Atwood