# 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...

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?

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