List:General Discussion« Previous MessageNext Message »
From:Kieran Kelleher Date:June 28 2005 2:52pm
Subject:Re: Calculate LONG/LAT from ZIP+4
View as plain text  
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
>

Thread
Calculate LONG/LAT from ZIP+4Jack Lauman27 Jun
  • Re: Calculate LONG/LAT from ZIP+4Scott Gifford27 Jun
    • Re: Calculate LONG/LAT from ZIP+4Brian Dunning27 Jun
      • Re: Calculate LONG/LAT from ZIP+4Scott Gifford27 Jun
        • Re: Calculate LONG/LAT from ZIP+4Brian Dunning27 Jun
          • Re: Calculate LONG/LAT from ZIP+4Scott Gifford27 Jun
            • Re: Calculate LONG/LAT from ZIP+4Brian Dunning27 Jun
  • Re: Calculate LONG/LAT from ZIP+4Kieran Kelleher28 Jun
  • Re: Calculate LONG/LAT from ZIP+4Mattias HÃ¥kansson28 Jun
    • Re: Calculate LONG/LAT from ZIP+4Kieran Kelleher28 Jun
      • Re: Calculate LONG/LAT from ZIP+4Brian Dunning28 Jun
        • Re: Calculate LONG/LAT from ZIP+4Kieran Kelleher28 Jun
    • Re: Calculate LONG/LAT from ZIP+4Brian Dunning28 Jun
      • RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Daevid Vincent25 Apr
RE: Calculate LONG/LAT from ZIP+4Dirk Bremer28 Jun
RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Gmail User25 Apr
  • RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Daevid Vincent25 Apr
RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Gmail User25 Apr
  • RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Tim Lucia25 Apr
RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Nicolas Verhaeghe25 Apr
RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Jay Blanchard25 Apr
  • Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Webmaster25 Apr
  • RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Daevid Vincent25 Apr
RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Jay Blanchard26 Apr
Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Peter Brawley26 Apr
  • RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)SST - Adelaide)26 Apr
    • RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Nicolas Verhaeghe26 Apr
RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Nicolas Verhaeghe26 Apr
  • Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude) \"Adam i Agnieszka GÄ…siorowski FNORD aka ALinkA aka symbol '( { .A. } )'' ||~> { A.A }\" 2 May
    • RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)Gary M. Allen3 May