OraFAQ Forum: Spatial » Oracle Spatial Query help

Home » Server Options » Spatial » Oracle Spatial Query help (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Spatial Query help [message #569739]

Wed, 31 October 2012 15:48

gentleman777us
Messages: 122
Registered: April 2005

Senior Member

Hi,

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.

Thanks
- Shekar

Report message to a moderator

Re: Oracle Spatial Query help [message #569768 is a reply to message #569739]

Thu, 01 November 2012 04:59

_jum
Messages: 577
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".

Report message to a moderator

Re: Oracle Spatial Query help [message #572251 is a reply to message #569739]

Sat, 08 December 2012 12:57

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

Report message to a moderator

Previous Topic:	Performance Issue with the query
Next Topic:	Syntax for Creating Local spatial index on Partioned table.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 30 14:28:38 CST 2023