Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am analyzing the accuracy of the STDistance function for geographical objects in SQL Server 2008, in order to understand its behaviour better I need to find the underlying formula.

Does anyone knows which formula is used in SQL Server, haversine?

share|improve this question
may be helpful for you stackoverflow.com/questions/15975066/… –  Sunil Apr 22 '13 at 12:58

1 Answer 1

up vote 1 down vote accepted

Microsoft (due mostly to a lack of knowledge about geodesics) elected to define geographical distances along great ellipses and this is what STDistance on Geographic objects returns. For the formulas that are used see Kallay, Geometric algorithms on an ellipsoid earth model (2008), http://dx.doi.org/10.1145/1463434.1463487 Also relevant is Kallay, Defining edges on a round earth (2007), http://dx.doi.org/10.1145/1341012.1341087 (be warned that this paper contains several misstatements about geodesics).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.