[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; | pos lat | pos lat neg long | pos long | | --------------------------------------------------- | neg lat | neg lat neg long | pos long | | Sometimes the coordinates are based on positive distances (non-standard lat/long) from the prim meridian and equator, yielding a pai of positive numbers for each coordinate that would not be the same numbers as given by the standard system. Google Maps understands the standard system well, I do not know if it understands the non-standard system -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]