Re: Distance Formula from Long/Lat
Date: Sun, 08 Aug 2004 03:06:02 GMT
Message-ID: <uMgRc.70566$T_6.67488_at_edtnps89>
DellaCroce wrote:
> Does anyone here have the formula for calculating distance give two pairs
> of
> Longitude/Latitude coordinates? Please share this with me if you would.
>
I usually cheat - Oracle9i (Standard and Enterprise) includes interMedia Locator which allows me to use SDO_GEOM.SDO_DISTANCE .... computes the distance in Lat/Long (as long as the 2 points are no more than 1/2 way around the earth) as well as most coord systems.
See "OracleŽ Spatial User's Guide and Reference" (Part No. A96630-01 at http://docs.oracle.com) Chapter 11 for the function, Appendix C for confirmation that it's included in the license, and Oracle Education's Online Library for how-to.
Of course, you could always Google on "compute distance from latitude and longitude" and come up with 56,300 results including the useful Dr. Math's http://mathforum.org/library/drmath/view/51818.html
/Hans Received on Sun Aug 08 2004 - 05:06:02 CEST