Re: database function to get distance between 2 latitude/longitude points
- From: Job Miller <jobmiller@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, rjoralist@xxxxxxxxxxxxxxxxxxxxx
- Date: Fri, 1 May 2009 08:24:22 -0700 (PDT)
Remember also, that even if the point data is stored as lat/lon instead of an
SDO_GEOMETRY object, you can still create a spatial index on it to leverage the
nearest neighbor/sdo_interact type functions that require a spatial index as a
primary filter for the operation.
That capability is highlighted here in 9.2.1
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14255/sdo_exten.htm#i1005799
--- On Thu, 4/30/09, Rich Jesse <rjoralist@xxxxxxxxxxxxxxxxxxxxx> wrote:
> From: Rich Jesse <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
> Subject: Re: database function to get distance between 2 latitude/longitude
> points
> To: oracle-l@xxxxxxxxxxxxx
> Date: Thursday, April 30, 2009, 12:00 PM
> Ahhh, my new Nugget of Oracle Licensing Nuances of the Day.
>
> Thanks, Jason!
>
> Rich
>
> > Oracle Locator is a subset of the Spatial option, and
> is included in all
> > editions of Oracle.
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
