On Sep 26, 4:11 am, This Guy <[EMAIL PROTECTED]> wrote: > I think this is a great circle calculation, one that googlemaps can > do. However, in order to sort a large dataset in sql for display I > need to be able to find four points (n, e, s, w) that are 10 miles > away from my center point and then find the lat and long for each of > those points.
State the problem, not your guesses! ;-) http://www.catb.org/%7Eesr/faqs/smart-questions.html#symptoms SQL for radius search http://groups.google.com/group/Google-Maps-API/browse_thread/thread/dd6255740040d317/068b6f8d8bf314c0?lnk=gst&q=another+radius#068b6f8d8bf314c0 See also this: http://maps.forum.nu/temp/gm_bearing.html and this: http://maps.forum.nu/gm_sensitive_circle2.html -- Marcelo - http://maps.forum.nu -- > > that way I can use the lat and long to sort the large dataset before > doing a radii search... > > someone else is doing most of the programing, but I think this is a > great circle calculation...would I need to put the formula below in on > some other side or is there a googlemap way to do this. > > Dollar to anyone who can help me. > > A point {lat,lon} is a distance d out on the tc radial from point 1 > if: > > lat=asin(sin(lat1)*cos(d)+cos(lat1)*sin(d)*cos(tc)) > IF (cos(lat)=0) > lon=lon1 // endpoint a pole > ELSE > lon=mod(lon1-asin(sin(tc)*sin(d)/cos(lat))+pi,2*pi)-pi > ENDIF --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
