>>>I have a table of warrants with latitude and longitude, and I would like to be able to select all warrants within a given radius. I know I've seen this discussed before. Any of you math professors got a clue?
>>
>>GIYF:
http://www.google.ca/search?q=lat+long+distance+between+points>
>I didn't see anything about pulling records within a given radius....
The second link,
http://www.movable-type.co.uk/scripts/LatLong.html has the formula to calculate the distance between two points. You would have to insert the lat. + long. for the desired center of the circle, and for each of the desired data points, and do the calculations, to know which are at a distance of less than the desired amount of km.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
