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'
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.
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: 485
Registered: February 2008
Senior Member
Could you show an example for the incorrect results?
Which ORACLE-version do you use?
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).
Previous Topic: How to determine a point is inside a polygon area?
Next Topic: SDO_RELATE Performance
Goto Forum:
  


Current Time: Thu Apr 24 19:03:23 CDT 2014

Total time taken to generate the page: 0.21071 seconds