From: Peter Brawley Date: April 26 2006 1:47am Subject: Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) List-Archive: http://lists.mysql.com/mysql/197360 Message-Id: <444ED12E.50905@earthlink.net> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=======AVGMAIL-444ED12E4910=======" --=======AVGMAIL-444ED12E4910======= Content-Type: multipart/alternative; boundary=------------050301060807000700010804 --------------050301060807000700010804 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Daevid Vincent wrote: > My confusion is that I have some formulas to plug in these values, but it > seems to me that if I use the wrong set of data, my zipcodes will be wrong > too. I also don't understand why there is even such a difference. I can > understand a few decimal points being different, but I don't understand how > they are positive and negative, when it's supposed to be based upon the > equator and the prime meridian. Hasn't that already been explained here? Sign is entirely a matter of convenience and convention. PB > >> -----Original Message----- >> From: Gmail User [mailto:nowuknow@stripped] >> Sent: Tuesday, April 25, 2006 6:03 AM >> To: mysql@stripped >> Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. >> negative longitude) >> >> On Tue, 2006-04-25 at 00:43 -0700, Daevid Vincent wrote: >> >>> So for a sanity check, I decided to look "online" and punch >>> >> in some to see >> >>> what the "real" lat/long should be. Well, different sites >>> >> give different >> >>> values, and not only are they "slightly" off, but sometimes they're >>> _positive_ or _negative_!? UGH! >>> >> Not sure what your confusion is. It is a matter of notation. The >> negative value represents West where it is negative (as would be the >> East; note how there is no W mentioned there). >> > > > --------------050301060807000700010804 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
Daevid Vincent wrote:Hasn't that already been explained here? Sign is entirely a matter of convenience and convention.My confusion is that I have some formulas to plug in these values, but it seems to me that if I use the wrong set of data, my zipcodes will be wrong too. I also don't understand why there is even such a difference. I can understand a few decimal points being different, but I don't understand how they are positive and negative, when it's supposed to be based upon the equator and the prime meridian.
--------------050301060807000700010804-- --=======AVGMAIL-444ED12E4910======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.6/323 - Release Date: 4/24/2006 --=======AVGMAIL-444ED12E4910=======-------Original Message----- From: Gmail User [mailto:nowuknow@stripped] Sent: Tuesday, April 25, 2006 6:03 AM To: mysql@stripped Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) On Tue, 2006-04-25 at 00:43 -0700, Daevid Vincent wrote:So for a sanity check, I decided to look "online" and punchin some to seewhat the "real" lat/long should be. Well, different sitesgive differentvalues, and not only are they "slightly" off, but sometimes they're _positive_ or _negative_!? UGH!Not sure what your confusion is. It is a matter of notation. The negative value represents West where it is negative (as would be the East; note how there is no W mentioned there).