Path: news.f.de.plusline.net!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!gnilink.net!newsfeed2.telusplanet.net!newsfeed.telus.net!edtnps89.POSTED!53ab2750!not-for-mail From: Hans Forbrich Subject: Re: Distance Formula from Long/Lat Newsgroups: comp.databases.oracle.tools References: <4115661c@news03.toast.net> Lines: 23 User-Agent: KNode/0.7.2 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8Bit Message-ID: Date: Sun, 08 Aug 2004 03:06:02 GMT NNTP-Posting-Host: 161.184.143.86 X-Trace: edtnps89 1091934362 161.184.143.86 (Sat, 07 Aug 2004 21:06:02 MDT) NNTP-Posting-Date: Sat, 07 Aug 2004 21:06:02 MDT Xref: news.f.de.plusline.net comp.databases.oracle.tools:29486 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