NYCPHP Meetup

[nycphp-talk] Radial Zip Code Search

Mark Armendariz enolists at gmail.com
Fri Jan 19 16:31:40 EST 2007


I'd posted one on this list a couple years ago.

Found it in the archive:
http://lists.nyphp.org/pipermail/talk/2003-November/006445.html

I believe someone followed up and mentioned the actual source of the
function, or at least a very similar one, but I can't seem to find that
post.

Good Luck, and have a great weekend, all.

Mark 

> -----Original Message-----
> From: talk-bounces at lists.nyphp.org 
> [mailto:talk-bounces at lists.nyphp.org] On Behalf Of Joseph Crawford
> Sent: Friday, January 19, 2007 4:15 PM
> To: NYPHP Talk
> Subject: Re: [nycphp-talk] Radial Zip Code Search
> 
> take a look here
> http://www.hotscripts.com/PHP/Scripts_and_Programs/Zip_Code_Lo
> cators/index.html
> 
> On 1/19/07, Donald J Organ IV <dorgan at optonline.net> wrote:
> > WEll i am assuming you have a postal zipcodes database with 
> longitude 
> > and latitude here is the queries you want to use, first you need to 
> > get long and lat for zipcode
> >
> > SELECT longitutde,latitude
> > FROM usa
> > WHERE zipcode=$zip
> >
> >
> > SELECT distinct zipcode,
> > ROUND((ACOS((SIN($lat/57.2958) * SIN(latitude/57.2958)) +
> > (COS($lat/57.2958) * COS(latitude/57.2958) *
> > COS(longitude/57.2958 - $long/57.2958)))) * 3963, 3) AS 
> distance FROM 
> > usa WHERE (latitude >= $lat - ($miles/111)) AND (latitude <= $lat + 
> > ($miles/111)) AND (longitude >= $long - ($miles/111)) AND 
> (longitude 
> > <= $long + ($miles/111)) ORDER BY distance
> >
> >
> >
> > Baer, Jon wrote:
> > > -----BEGIN PGP SIGNED MESSAGE-----
> > > Hash: SHA1
> > >
> > > You might want to try a new GIS topic search @ MySQL ...
> > >
> > > Here is an old one from 2004 -
> > > http://forums.mysql.com/read.php?23,3868,3868
> > >
> > > An inexpensive solution ... 
> > > http://www.myzipdb.com/zipcode_locator.php
> > >
> > > - - Jon
> > >
> > > - -----Original Message-----
> > > From: talk-bounces at lists.nyphp.org 
> > > [mailto:talk-bounces at lists.nyphp.org]
> > > On Behalf Of Donna Marie Vincent
> > > Sent: Friday, January 19, 2007 3:45 PM
> > > To: talk at lists.nyphp.org
> > > Subject: [nycphp-talk] Radial Zip Code Search
> > >
> > > Hi, all.  I am looking for a script, or a tutorial on how 
> to create 
> > > a script, that will perform a radial zip code search.  I Googled 
> > > this "radial zip code" and "radial postcode" and have 
> found nothing 
> > > about how to do this.  Can anyone point me in the right direction?
> > > Thanks in advance!
> > >
> > > -----BEGIN PGP SIGNATURE-----
> > > Version: GnuPG v1.4.3 (MingW32)
> > >
> > > iD8DBQFFsTAE99e5DI8C/rsRAmC/AKDq1EOwQO1WHnfXcXBDgmcPr3WPYwCcDrum
> > > 8bFq8+ciezOt432+x/zgDCI=
> > > =9lks
> > > -----END PGP SIGNATURE-----
> > > _______________________________________________
> > > New York PHP Community Talk Mailing List 
> > > http://lists.nyphp.org/mailman/listinfo/talk
> > >
> > > NYPHPCon 2006 Presentations Online
> > > http://www.nyphpcon.com
> > >
> > > Show Your Participation in New York PHP 
> > > http://www.nyphp.org/show_participation.php
> > >
> > >
> > _______________________________________________
> > New York PHP Community Talk Mailing List 
> > http://lists.nyphp.org/mailman/listinfo/talk
> >
> > NYPHPCon 2006 Presentations Online
> > http://www.nyphpcon.com
> >
> > Show Your Participation in New York PHP 
> > http://www.nyphp.org/show_participation.php
> >
> 
> 
> --
> Joseph Crawford Jr.
> Zend Certified Engineer
> Codebowl Solutions, Inc.
> http://www.codebowl.com/
> Blog: http://www.josephcrawford.com/
> 1-802-671-2021
> codebowl at gmail.com
> _______________________________________________
> New York PHP Community Talk Mailing List 
> http://lists.nyphp.org/mailman/listinfo/talk
> 
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
> 
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
> 




More information about the talk mailing list