Home » Server Options » Spatial » Results from outside an SDO_FILTER (10g, Win XP Pro)
Results from outside an SDO_FILTER [message #517071] Fri, 22 July 2011 06:00 Go to next message
demmith
Messages: 3
Registered: January 2011
Location: USA
Junior Member
When I submit an SDO_FILTER I get back results that lie outside the specified SDO_ORDINATE_ARRAY. Has anyone experienced that problem? If so, how did you correct it?

The WHERE clause of my SELECT statement contains...
SDO_FILTER([mytable].[mycolumn], SDO_GEOMETRY(2003,8307,NULL,
SDO_ORDINATE_ARRAY(sw_lon,sw_lat,ne_lon,ne_lat))) = 'TRUE'

Report message to a moderator

Re: Results from outside an SDO_FILTER [message #517101 is a reply to message #517071] Fri, 22 July 2011 09:25 Go to previous messageGo to next message
demmith
Messages: 3
Registered: January 2011
Location: USA
Junior Member
I was using the wrong spatial operator. I changed SDO_FILTER to SDO_INSIDE and it works as expected.

Report message to a moderator

Re: Results from outside an SDO_FILTER [message #517102 is a reply to message #517071] Fri, 22 July 2011 09:26 Go to previous messageGo to next message
_jum
Messages: 453
Registered: February 2008
Senior Member
Could you show an example for the incorrect results?
Which ORACLE-version do you use?

Report message to a moderator

Re: Results from outside an SDO_FILTER [message #517140 is a reply to message #517102] Fri, 22 July 2011 21:51 Go to previous message
demmith
Messages: 3
Registered: January 2011
Location: USA
Junior Member
Check the reply to my post - I should've been using SDO_INSIDE (which works fine now).

Report message to a moderator

Previous Topic: How to determine a point is inside a polygon area?
Next Topic: SDO_RELATE Performance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 24 03:24:55 CDT 2013

Total time taken to generate the page: 0.16893 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.