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" <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
>> 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/mysql?unsub=1
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
