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 to do. 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 "plus 4". -----Original Message----- From: Daevid Vincent [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 2:19 PM To: mysql@lists.mysql.com 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:[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 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
