Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!newsfeed.vmunix.org!newsfeed.stueberl.de!border1.nntp.dca.giganews.com!nntp.giganews.com!news.glorb.com!prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!news03.toast.net!not-for-mail
From: "DellaCroce" <DellaCroce@toast.net>
Newsgroups: comp.databases.oracle.tools
Subject: Re: Distance Formula from Long/Lat
Date: Sat, 7 Aug 2004 22:27:29 -0500
Organization: SBC http://yahoo.sbc.com
Lines: 35
Message-ID: <41159df3@news03.toast.net>
References: <4115661c@news03.toast.net> <uMgRc.70566$T_6.67488@edtnps89>
NNTP-Posting-Host: adsl-66-73-119-130.dsl.toldoh.ameritech.net
X-Trace: newsdbm05.news.prodigy.com 1091935759 12327 66.73.119.130 (8 Aug 2004 03:29:19 GMT)
X-Complaints-To: abuse@prodigy.net
NNTP-Posting-Date: Sun, 8 Aug 2004 03:29:19 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: 02-051.144.popsite.net
X-Original-Trace: 7 Aug 2004 23:28:51 -0400, 02-051.144.popsite.net
X-Authenticated-User: dellacroce
Xref: news.f.de.plusline.net comp.databases.oracle.tools:29488

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@yahoo.net> wrote in message
news:uMgRc.70566$T_6.67488@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