OraFAQ Forum: Spatial » Results from outside an SDO_FILTER

Home » Server Options » Spatial » Results from outside an SDO_FILTER (10g, Win XP Pro)

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

Results from outside an SDO_FILTER [message #517071]

Fri, 22 July 2011 06:00

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

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 14 05:29:49 CDT 2025