Re: Querying distances between two coordinates

From: Jeremy <jeremy0505_at_gmail.com>
Date: Sat, 11 Jun 2011 17:37:31 +0100
Message-ID: <MPG.285daa2ada2886a098990c_at_News.Individual.NET>

In article <ba7de41c-7ce8-465a-bc20-67c4e2484871 _at_f2g2000yqh.googlegroups.com>, hooperc2001_at_gmail.com says...
>
> On Jun 10, 12:15 pm, Jeremy <jeremy0..._at_gmail.com> wrote:
> > Hi this is a 10gR2 Standard Edition question.
> >
> > The requirement is to be able to calculate the distance between two co-
> > oordinates expressed as latitude and longitude.
> >

> I vaguely remember teaching a class how to do this calculation of
> distance around a spherical object in the early 1990s (with only a
> calculator) - I could probably search and find the lesson plan which
> is probably right next to the proof that 1=2. While I am searching
> for that lesson plan, see if the following article is helpful:
> http://www.movable-type.co.uk/scripts/latlong.html
>

Thanks. Of course what I have failed to do is actually to ask the real question I wanted to answer - ultimately we need to be able to query a table to find the rows where the lat/long defined on those rows is within a user-specified radius. Are there already functions witin Oracle 10gR2 SE that provide this capability efficiently?

-- 
jeremy

Received on Sat Jun 11 2011 - 11:37:31 CDT