Thanks Will. I just got this formula. But I need to convert this into SQL syntax: 2*asin(sqrt((sin((lat1-lat2)/2))^2 + cos(lat1)*cos(lat2)*(sin((lon1-lon2)/2))^2))
The POWER function of SQL is confusing. This formula uses the "curved earth" formula. - K On 12/2/05, Will Tomlinson <[EMAIL PROTECTED]> wrote: > > >Thanks Will. Can you tell if the formula that you used to calculate the > >distance between 2 latitutdes and longitudes is the "flat-earth" formula > or > >the "spherical earth" formula? I am talking about: > >ROUND((ACOS((SIN(#passedzip.latitude#/57.2958) * SIN(latitude/57.2958)) + > >(COS(#passedzip.latitude#/57.2958) * COS(latitude/57.2958) * > >COS(longitude/57.2958 - #passedzip.longitude#/57.2958)))) * 3963) > > > > I don't know what it is. I think I found it through google a while back. I > DO know that it seems to give fairly accurate results. And it also displays > the distance in the results, which is nice. > > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226003 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
