<div><br>
</div>
<div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">For time zones I use ISO 3166 country codes and state codes.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">For some states I need a suffix like 'n' or 'w' or 's' or 'e' if the state has more than one time zone.<o:p></o:p></SPAN></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">It also can use the IATA city code, the 3 letter code on your airline luggage.<o:p></o:p></SPAN></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">It contains the time zone rules so each year it calculates the new dates for daylight.<o:p></o:p></SPAN></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">The rules can be updated on demand, when used first time each year, over the Internet. <o:p></o:p></SPAN></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">It also contains the ISO country name, state name and city name and airport name.<o:p></o:p></SPAN></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">Hope fully the lat/lon for states and countries will someday be available even if they approximate coastlines. <o:p></o:p></SPAN></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">These should be a suggestion for the Unicode <o:p></o:p></SPAN></div>
<div style="MARGIN: 0in 0in 0pt; mso-outline-level: 3" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-bidi-font-weight: bold"><o:p><STRONG><FONT size=3> </FONT></STRONG></o:p></SPAN></div>
<div style="MARGIN: 0in 0in 0pt; mso-outline-level: 3" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-bidi-font-weight: bold"><o:p><STRONG><FONT size=3> </FONT></STRONG></o:p></SPAN></div>
<div style="MARGIN: 0in 0in 0pt; mso-outline-level: 3" class=MsoNormal><A href="http://cldr.unicode.org/"><FONT color=#0000ff size=3 face="Times New Roman"><STRONG>http://cldr.unicode.org/</STRONG></FONT></A><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-bidi-font-weight: bold"><o:p></o:p></SPAN></div>
<div style="MARGIN: 0in 0in 0pt; mso-outline-level: 3" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-bidi-font-weight: bold"><STRONG><FONT size=3>CLDR Project<o:p></o:p></FONT></STRONG></SPAN></div>
<TABLE style="WIDTH: 393.85pt; mso-cellspacing: 0in; mso-yfti-tbllook: 1184" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=525>
<TBODY>
<TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
<TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 5.35pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.35pt; PADDING-RIGHT: 5.35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 5.35pt" vAlign=top>
<div style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">The Unicode CLDR provides key building blocks for software to support the world's languages, with the largest and most extensive standard repository of locale data available. This data is used by a wide spectrum of companies for their software internationalization and localization, adapting software to the conventions of different languages for such common software tasks as:<o:p></o:p></SPAN></div>
<UL type=disc>
<LI style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">formatting of dates, times, and time zones, <o:p></o:p></SPAN></LI>
<LI style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">formatting numbers and currency values<o:p></o:p></SPAN></LI>
<LI style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">sorting text<o:p></o:p></SPAN></LI>
<LI style="MARGIN: 0in 0in 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list .5in" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'">choosing languages or countries by name<o:p></o:p></SPAN></LI></UL>
<H2 style="MARGIN: 10pt 0in 0pt"><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black"><o:p><FONT size=4> </FONT></o:p></SPAN></H2>
<H2 style="MARGIN: 10pt 0in 0pt"><A href="http://cldr.unicode.org/index/process"><FONT color=#0000ff size=4 face=Cambria>http://cldr.unicode.org/index/process</FONT></A><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black"><FONT size=4>Introduction<o:p></o:p></FONT></SPAN></H2>
<div><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 8pt">This document describes the Unicode CLDR Technical Committee, and its process for data collection, resolution, public feedback and release. The process is designed to be light-weight: in particular, the meetings are frequent, short, and informal. Most of the work is by email or phone, with a database recording requested changes in data.<o:p></o:p></SPAN></div>
<div><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 8pt">When gathering data for a region and language, it is important to have multiple sources for that data to produce the most widely acceptable data. Initial versions of data were based on the best available sources, but CLDR data will be modified and improved, in successive versions, by more input from the contributors inside and outside of the Unicode Consortium.<o:p></o:p></SPAN></div>
<div><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 8pt">It is important to note that CLDR is a Repository, not a Registration. That is, contributors should not expect that their contributions will simply be adopted into the repository; instead, it will be vetted against the best available information.<o:p></o:p></SPAN></div>
</TD></TR></SPAN></TBODY></TABLE>
<div style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt; FONT-WEIGHT: normal; mso-fareast-font-family: 'Times New Roman'"><o:p> </o:p></SPAN></div>
Herman J Woudenberg<br>
</div>
-----Original Message-----<br>
From: Chris Walton <Chris.Walton@telus.com><br>
To: tz@elsie.nci.nih.gov <tz@lecserver.nci.nih.gov>; larry.ober <larry.ober@att.net><br>
Sent: Thu, Feb 3, 2011 5:37 pm<br>
Subject: RE: lat/lon to time offset database<br>
<br>
<div id=AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957>
<STYLE>#AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 td{color: black;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} #AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 p.MsoNormal,#AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 li.MsoNormal,#AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";} #AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 a:link,#AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} #AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 a:visited,#AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} #AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 span.apple-style-span {mso-style-name:apple-style-span;} #AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 span.apple-converted-space {mso-style-name:apple-converted-space;} #AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 span.EmailStyle19 {mso-style-type:personal-reply; font-family:"Arial","sans-serif"; color:blue; font-weight:normal; font-style:normal; text-decoration:none none;} #AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt;} #AOLMsgPart_1_4ad3358a-16f9-4b6b-8c0c-3dc4d2c6a957 div.WordSection1 {page:WordSection1;} </STYLE>
<div class=WordSection1>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">Larry,</SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt"> </SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">Just so you know that it is possible… some of the newer GPS units on the market today are capable of automatically determining the local time zone.</SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">This is achieved with proprietary time zone maps that are installed inside the GPS at the factory.</SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">Newer versions of the maps are bundled inside firmware images so that you automatically get the latest map when you upgrade the firmware on your GPS.</SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt"> </SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">If these built in time zone maps are not accurate (or if you find yourself in an area with disputed time zones), it is possible to turn off automatic mode and then manually enter the time zone of your choosing.</SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt"></SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">A Google search reveals that one of the GPS manufacturers stores its time zone data in a file that is approximately 600kB.</SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">I think we can assume that the data in this file is written in a very heavily compressed format; it could theoretically be many megabytes if uncompressed.</SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt"> </SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">-chris</SPAN></div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt"> </SPAN></div>
<div>
<div style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<div class=MsoNormal><B><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt" lang=EN-US>From:</SPAN></B><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt" lang=EN-US> Larry Ober [<A href="mailto:larry.ober@att.net?">mailto:larry.ober@att.net</A>] <br>
<B>Sent:</B> February 3, 2011 2:27 PM<br>
<B>To:</B> <A href="mailto:tz@lecserver.nci.nih.gov">tz@lecserver.nci.nih.gov</A><br>
<B>Subject:</B> Re: lat/lon to time offset database</SPAN></div>
</div>
</div>
<div class=MsoNormal> </div>
<div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">Hi John,</SPAN></div>
</div>
<div>
<div class=MsoNormal> </div>
</div>
<div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">Well there would be some level of accuracy question. The more accurate the polygon the larger the database. Also if the lat/lon data was provided by GPS, there is the question of signal availability.</SPAN></div>
</div>
<div>
<div class=MsoNormal> </div>
</div>
<div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">Basically it just seems dumb that I need to tell my GPS what time zone it's in. LOL</SPAN></div>
</div>
<div>
<div class=MsoNormal> </div>
</div>
<div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">Best Regards</SPAN></div>
</div>
<div>
<div class=MsoNormal> </div>
</div>
<div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">Larry</SPAN></div>
</div>
<BLOCKQUOTE style="BORDER-BOTTOM: medium none; BORDER-LEFT: black 1.5pt solid; PADDING-BOTTOM: 0cm; MARGIN: 5pt 0cm 5pt 3.75pt; PADDING-LEFT: 4pt; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0cm">
<div>
<div class=MsoNormal><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">----- Original Message ----- </SPAN></div>
</div>
<div>
<div style="BACKGROUND: #e4e4e4" class=MsoNormal><B><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">From:</SPAN></B><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt"> <A title=john.haxby@oracle.com href="mailto:john.haxby@oracle.com">John Haxby</A> </SPAN></div>
</div>
<div>
<div class=MsoNormal><B><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">To:</SPAN></B><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt"> <A title=tz@lecserver.nci.nih.gov href="mailto:tz@lecserver.nci.nih.gov">tz@lecserver.nci.nih.gov</A> </SPAN></div>
</div>
<div>
<div class=MsoNormal><B><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">Sent:</SPAN></B><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt"> Thursday, February 03, 2011 1:54 PM</SPAN></div>
</div>
<div>
<div class=MsoNormal><B><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt">Subject:</SPAN></B><SPAN style="FONT-FAMILY: ; FONT-SIZE: 10pt"> Re: lat/lon to time offset database</SPAN></div>
</div>
<div>
<div class=MsoNormal> </div>
</div>
<div class=MsoNormal> </div>
<div>
<div>
<div class=MsoNormal>On 3 Feb 2011, at 18:33, Larry Ober wrote:</div>
</div>
<div class=MsoNormal><br>
<br>
</div>
<div class=MsoNormal><SPAN class=apple-style-span><SPAN style="FONT-FAMILY: ; FONT-SIZE: 13.5pt">I am looking at building a small embedded system (No OS) that will require</SPAN></SPAN><SPAN class=apple-converted-space><SPAN style="FONT-FAMILY: ; FONT-SIZE: 13.5pt"> </SPAN></SPAN><SPAN style="FONT-FAMILY: ; FONT-SIZE: 13.5pt"><br>
<SPAN class=apple-style-span>determining the local time from the lat/lon of a location. So basically I need</SPAN><SPAN class=apple-converted-space> </SPAN><br>
<SPAN class=apple-style-span>lat/lon to time offset from "GMT".</SPAN></SPAN></div>
</div>
<div class=MsoNormal> </div>
<div>
<div class=MsoNormal>Does that work? I'm sure I can find places in Spain that are that are close to Lisbon than they are Madrid but being in Spain the timezone should be Europe/Madrid. Also, when you're on going through the channel tunnel do you go from being closer to Paris than you are to London only when you've left Calais? Or before you get to Dover?</div>
</div>
<div>
<div class=MsoNormal> </div>
</div>
<div>
<div class=MsoNormal>Or have I got hold of the wrong end of the sti </div>
</div>
</BLOCKQUOTE></div>
</div>