Robert is correct, it just takes a little math. One thing to remember is that these databases usually measure from the center of the zip code to the center of the zip code as opposed to "perimeter to perimeter". So it is possible to actually have a portion of a zip code area within your radius, but because the center is outside the radius, it will not show in your results.
Thanks, Joe Kelly On 7/7/05, Robert Shaw <[EMAIL PROTECTED]> wrote: > For the future, this is pretty simple code to write. All you need is the > longitude and latitude of each zip and there are several databases with this > info on the web. After you have that, the formula for calculating the > distance is pretty straight forward, especially if the database is in a SQL > server. The formula we use is accurate for zip within 1500 miles since we > did not add the cosign for the curvature of the earth. > > Robert. > > ----- Original Message ----- > From: "Dave Shuck" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Thursday, July 07, 2005 10:58 AM > Subject: Re: Looking for a zipcode web service > > > I may have found one that will work. If anyone is intersted, this one > seems like a decent solution: > > http://www.bindingpoint.com/service.aspx?skey=bf43fb5e-7048-4c5d-8687-89959970f3fd > > Example and returned XML here: > http://tinyurl.com/b8zx7 > > Thanks for the suggestions. > > ~Dave > > > On 7/7/05, Daniel Elmore <[EMAIL PROTECTED]> wrote: > > I've used MelissaData for things like this. > > > > http://www.melissadata.com/lookups/zipradius.asp > > > > I don't know if this feature is supported in their web services, you'll > > have > > to click around. > > > > - Daniel > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Behalf Of Dave Shuck > > Sent: Thursday, July 07, 2005 10:16 AM > > To: [email protected] > > Subject: Looking for a zipcode web service > > > > > > I am looking for a web service in which I can pass a zipcode and a > > radius distance in miles and return all zipcodes within that radius. > > I have searched on www.xmethods.com and found some that will return > > distances between zips, but will not do exactly what I am looking for. > > Is anyone aware if one exists? > > > > Thanks, > > > > ~Dave > > ---------------------------------------------------------- > > To post, send email to [email protected] > > To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > > To subscribe: > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > > > > > > > ---------------------------------------------------------- > > To post, send email to [email protected] > > To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > > To subscribe: > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
