I think I said that earlier, but the distance between two zip codes deal is
inaccurate, yet useful, for instance on a Classified Ads Web site.
As for the Zip+4, I do not know of any database that gives the latitude and
longitude for them specifically. But I am certain it has to exist.
The US Post Office sells there Zip+4 database for I think a thousand
dollars. From there I guess you could use some tool to translate these Zip+4
into their lat/lon values, but bombarding someone's Web site with tens of
thousands of requests to do that translation is not necessarily a nice thing
I know that http://www.gpsvisualizer.com/convert?form=address is a site
where you are invited to do it, by sending your CSV. You are also invited to
click on the many ads.
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 good one, because people misspell
their street addresses in so many ways, it's not even funny.
For information, the Canadian Post Office 6-character postal code is a
"zip+4" code of some sort, as the 3 first alphanumerical are the equivalent
of the 5-digit US zip code and the last 3 the equivalent or the 4-digit
From: Daevid Vincent [mailto:daevid@stripped]
Sent: Tuesday, April 25, 2006 2:19 PM
Subject: RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)
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. Since they're US zipcodes, it's not like
we're in different parts of the world or anything.
> -----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).
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1