Re: [PHP] zip codes and lat/longs

2007-12-06 Thread Robert Cummings
Welcome back Richard :) Cheers, Rob. On Thu, 2007-12-06 at 10:43 -0600, Richard Lynch wrote: > On Thu, December 6, 2007 9:49 am, Jason Pruim wrote: > > > > On Dec 6, 2007, at 10:29 AM, Daniel Brown wrote: > > > >> On Dec 5, 2007 8:58 PM, tedd <[EMAIL PROTECTED]> wrote: > >>> Hi gang: > >>> > >>>

Re: [PHP] zip codes and lat/longs

2007-12-06 Thread Daniel Brown
On Dec 6, 2007 11:43 AM, Richard Lynch <[EMAIL PROTECTED]> wrote: > The free one is from an OLD US census, paid for by taxpayers, and > therefore Public Domain. > > $1,000 ones (should) include new zips (lots) and up-to-date population > info etc. Yeah, mine actually does. It's from 2006 and

Re: [PHP] zip codes and lat/longs

2007-12-06 Thread Richard Lynch
On Thu, December 6, 2007 9:49 am, Jason Pruim wrote: > > On Dec 6, 2007, at 10:29 AM, Daniel Brown wrote: > >> On Dec 5, 2007 8:58 PM, tedd <[EMAIL PROTECTED]> wrote: >>> Hi gang: >>> >>> I'm entertaining how to determine what zip codes fall within a 50 >>> mile radius of another zip code. >>> >>>

Re: [PHP] zip codes and lat/longs

2007-12-06 Thread Daniel Brown
On Dec 6, 2007 11:12 AM, mike <[EMAIL PROTECTED]> wrote: > You can use the formula to figure out how many zip codes are within the radius Or you can stop shooting me in the ass by showing me things that make me wonder why I wasted all that time! ;-P -- Daniel P. Brown [Phone Numbers Go Here

Re: [PHP] zip codes and lat/longs

2007-12-06 Thread mike
You can use the formula to figure out how many zip codes are within the radius Here's a snippet of old code that did that: $radius = 50; // in miles $uchk = db_query("SELECT uz.zip FROM user_zip WHERE uid=$visitor[uid]"); if(db_numrows($uchk) == 1) { list($vz) = d

RE: [PHP] zip codes and lat/longs

2007-12-06 Thread Jay Blanchard
[snip] I'm entertaining how to determine what zip codes fall within a 50 mile radius of another zip code. Anyone done this before? Also, does anyone have any sources for zip codes and lat/long databases? TIA for any help/suggestions. [/snip] Here is a code snip that I use to determine things w

Re: [PHP] zip codes and lat/longs

2007-12-06 Thread Daniel Brown
On Dec 6, 2007 11:02 AM, mike <[EMAIL PROTECTED]> wrote: [snip!] > 1) download ZCTA (the text version) from > http://www.census.gov/geo/www/gazetteer/places2k.html [snip!] How you say? Son of the bitch. Well, my database still has more information, including nearby ZIP codes, et cetera.

Re: [PHP] zip codes and lat/longs

2007-12-06 Thread mike
After reading this I decided to figure out what the issue was. It was the MySQL result set. Somehow the columns changed and messed up the float values. So I just whipped this up quick to reload the data (and possibly update it too) Here's the quick-and-dirty: 1) download ZCTA (the text version)

Re: [PHP] zip codes and lat/longs

2007-12-06 Thread Daniel Brown
On Dec 6, 2007 10:49 AM, Jason Pruim <[EMAIL PROTECTED]> wrote: > > On Dec 6, 2007, at 10:29 AM, Daniel Brown wrote: > > > On Dec 5, 2007 8:58 PM, tedd <[EMAIL PROTECTED]> wrote: > >> Hi gang: > >> > >> I'm entertaining how to determine what zip codes fall within a 50 > >> mile radius of another zi

Re: [PHP] zip codes and lat/longs

2007-12-06 Thread Jason Pruim
On Dec 6, 2007, at 10:29 AM, Daniel Brown wrote: On Dec 5, 2007 8:58 PM, tedd <[EMAIL PROTECTED]> wrote: Hi gang: I'm entertaining how to determine what zip codes fall within a 50 mile radius of another zip code. Anyone done this before? Also, does anyone have any sources for zip codes and

Re: [PHP] zip codes and lat/longs

2007-12-06 Thread Daniel Brown
On Dec 5, 2007 8:58 PM, tedd <[EMAIL PROTECTED]> wrote: > Hi gang: > > I'm entertaining how to determine what zip codes fall within a 50 > mile radius of another zip code. > > Anyone done this before? > > Also, does anyone have any sources for zip codes and lat/long databases? Tedd, I hav

Re: [PHP] zip codes and lat/longs

2007-12-05 Thread mike
Here's code I had, but it recently stopped working It takes the zip code for the user and the user you're viewing, looks them up from the data table (z_data_zips) and does the calculation. The formula is in a handful of places - I converted mine from a MySQL example (I think, or vice versa) You c

RE: [PHP] zip codes and lat/longs

2007-12-05 Thread Bastien Koert
hate to say it,but there is lots on google like http://www.code322.com/zipcode_locator.php bastien> Date: Wed, 5 Dec 2007 20:58:52 -0500> To: php-general@lists.php.net> From: [EMAIL PROTECTED]> Subject: [PHP] zip codes and lat/longs> > Hi gang:> > I'm entertain

[PHP] zip codes and lat/longs

2007-12-05 Thread tedd
Hi gang: I'm entertaining how to determine what zip codes fall within a 50 mile radius of another zip code. Anyone done this before? Also, does anyone have any sources for zip codes and lat/long databases? TIA for any help/suggestions. Cheers, tedd -- --- http://sperling.com http://an