Re: Distance Formula from Long/Lat
Date: Sat, 7 Aug 2004 22:27:29 -0500
Message-ID: <41159df3_at_news03.toast.net>
That web site was just the ticket! I really need to find a way to narrow the responses down to something reasonable. Dr.Math is cool, hadn't run across that one before!
Thanks for the reminder about the interMedia Locator.
Greg
"Hans Forbrich" <forbrich_at_yahoo.net> wrote in message
news: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:27:29 CEST
