MySQL Forums
Forum List  »  GIS

Re: Point Within Multipolygon
Posted by: Albert Rovira
Date: January 28, 2013 05:43PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
4467
January 15, 2013 04:29AM
Re: Point Within Multipolygon
2530
January 28, 2013 05:43PM
1995
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.