Home » Server Options » Spatial » Oracle Spatial Query help (Oracle 11g)
Oracle Spatial Query help [message #569739] Wed, 31 October 2012 15:48 Go to next message
Messages: 122
Registered: April 2005
Senior Member

I have a table with "shape length" and "Shape Area" column data along with other columns, however table does not have latitude or longitude columns.

I have a requirement now to query this table based on latitude and longitude values. i.e I should retrieve rows from the table based on latitude and longitude values.

Please provide the query.

- Shekar

Re: Oracle Spatial Query help [message #569768 is a reply to message #569739] Thu, 01 November 2012 04:59 Go to previous messageGo to next message
Messages: 523
Registered: February 2008
Senior Member
Did I understand you right ?
You have a table without "latitude" and "longitude", only with "shape length" and "shape area" and other (nonspatial/non geographical) data.
And now you should retrieve data based on "latitude" and "longitude"?
This seems to me a "Mission inmpossible".
Re: Oracle Spatial Query help [message #572251 is a reply to message #569739] Sat, 08 December 2012 12:57 Go to previous message
Messages: 1
Registered: December 2012
Location: Clovis, CA
Junior Member
You must have a geometry object in order to do what you want. If you have a geometry object it is simple enough to transform between one coordinate system to another.
Previous Topic: Performance Issue with the query
Next Topic: Syntax for Creating Local spatial index on Partioned table.
Goto Forum:

Current Time: Sun Feb 25 12:43:34 CST 2018

Total time taken to generate the page: 0.03860 seconds