Re: Point Within Multipolygon
Hi,
Have you tried using the two functions together?
SELECT * FROM arhiv WHERE Within(GEOMFROMTEXT( 'Point(120 10)' ) , field) and GISWithin(GEOMFROMTEXT( 'Point(120 10)' ) , field) AND obsdate BETWEEN '2010-01-01' AND '2013-01-01' ORDER BY obsdate ASC
Within will use spatial index but will return a superset and GISWithin will filter this superset and return only valid results.
Subject
Views
Written By
Posted
5774
January 15, 2013 04:29AM
Re: Point Within Multipolygon
3066
January 28, 2013 05:43PM
2438
March 21, 2013 09:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.