Just remember, there is a big difference in 5-digit ZIPs which cover a
large area (can be many miles in width and height) and 9-digit ZIP+4's
which usually cover a city block. Zip+4 lat/lngs provide greater
accuracy for accurate radius analysis of say a list of mailing
addresses for a mailing campaign on behalf of a business.
Manipulating ZIP+4 data can be time-consuming on a MySQL server
depending on what you are doing due to the 70,000,000 records.
Manipulating 5-digit ZIP data is fast and easy since there is less than
On Jun 28, 2005, at 8:30 AM, Mattias Håkansson wrote:
> This one goes for $169, and you get longitudes and latitudes.
> Mattias Håkansson
> ----- Original Message -----
> From: "Jack Lauman" <jlauman@stripped>
> To: "MySql" <mysql@stripped>
> Sent: Monday, June 27, 2005 2:29 AM
> Subject: Calculate LONG/LAT from ZIP+4
>> A couple of months ago these was a discussion about ZIP code plotting
>> this list. Does anyone know how to calculate LONG/LAT coordinates
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: