Jump to content
Sign in to follow this  
hartmut77

how to script radius around a zip code or GPS?

Recommended Posts

hello- i would like to find a formula to determine all the zip codes in a radius. i have a database of zip codes and their GPS (lat/long) .

i have these fields

'zipcode',

latitude,

longitude',

zipcodesinRadius,

RadiusMiles

just trying to find out how this is done

Thanks

Dave

Share this post


Link to post
Share on other sites

Hallo harter Mann,

there recently has been a thread just about that. Do a search.

at least this should solve the calculation of the zipcodesinradius field.

The other way is to use a geoquery web service via xml. Or mapquest, see www.tekstotaal.com .

Share this post


Link to post
Share on other sites

The formula for the distance between points was given in another thread. To find all the zip codes within a certain distance from some central location, you will have to calculate all of the distances between the central location, and each of the zip code locations. Any zip code that has a distance less than or equal to the maximum allowable radius will be in the group.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.