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
75,000 records
-Kieran
________________________________________________________________
Blog: http://webobjects.webhop.org/
On Jun 28, 2005, at 8:30 AM, Mattias Håkansson wrote:
This one goes for $169, and you get longitudes and latitudes.
http://www.buyzips.com/platinum-expanded.htm
Regards,
Mattias Håkansson
----- Original Message -----
From: "Jack Lauman" <[EMAIL PROTECTED]>
To: "MySql" <mysql@lists.mysql.com>
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
on
this list. Does anyone know how to calculate LONG/LAT coordinates
from
ZIP+4?
Thanks,
Jack
--
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
