RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

I haven't personally done a store locator, but... Store locators are relatively crude, yet useful. It is unlikely that exacting math will make one less crude in such a way as to make it significantly more useful. They usually just display a list of locations that *might* be convenient, and that's

Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

On 2006-04-26, at 20:53, Nicolas Verhaeghe wrote: Also, in order to do the Zip+4 translation, you need a good CASS certification script. Most of these products are expensive. You could program your own, but from talking to a programmer who created such a product, it takes years to come with a g

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

]; Daevid Vincent Cc: mysql@lists.mysql.com Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) You could further explain the lats and longs being "slightly off" by the use of a different datum. There are many many datums utilised by different geographical/geological a

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

r anything. > -Original Message- > From: Gmail User [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 25, 2006 6:03 AM > To: mysql@lists.mysql.com > Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. > negative longitude) > > On Tue, 2006-04-25 at 00:43 -0700, D

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

To: Daevid Vincent Cc: mysql@lists.mysql.com Subject: Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) 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 wil

Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

--- From: Gmail User [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 25, 2006 6:03 AM To: mysql@lists.mysql.com 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 loo

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

[snip] Thanks for the graph. So are you saying that I should use the database that has the negative values, and not the one that uses positive values? I'm in the USA. I don't care about anywhere else (for my location needs that is). [/snip] Yes, that would be using the proper notation for lat

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

ROTECTED] > Sent: Tuesday, April 25, 2006 6:03 AM > To: mysql@lists.mysql.com > 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

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

Thanks for the graph. So are you saying that I should use the database that has the negative values, and not the one that uses positive values? I'm in the USA. I don't care about anywhere else (for my location needs that is). > -Original Message- > From: Jay Blanchard [mailto:[EMAIL PR

Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

Hello, Not wanting to "hijack" this thread, but what is the best source for a zip code database? The "best" free one I could find was from census data from the last census. Sometimes it won't recognize all the zips from large cities. Thanks, R -- MySQL General Mailing List For list archiv

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

[snip] I procured myself some zip/lat/long databases from various places. Then I noticed that for the same zip code, I got different values in different databases??!!! [/snip] Latitudes and longitudes are often represented based on their location relative to the equator and the prime meridian;

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

I'm so confused. I'm finally getting around to needing to do a 'store locator' thing. I procured myself some zip/lat/long databases from various places. Then I noticed that for the same zip code, I got different values in different databases??!!! So for a sanity check, I decided to look "online

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

from ZIP+4 (positve vs. negative longitude) ... err, as would be South... N+, S-, E+, W- Ed :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

... err, as would be South... N+, S-, E+, W- Ed :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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 _neg

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

I'm so confused. I'm finally getting around to needing to do a 'store locator' thing. I procured myself some zip/lat/long databases from various places. Then I noticed that for the same zip code, I got different values in different databases??!!! So for a sanity check, I decided to look "online"