MySQL Forums
Forum List  »  GIS

Re: Points within polygons
Posted by: Mike McCutcheon
Date: April 30, 2010 06:48PM

Hello Francine.

My use of the distance function seemed to put about 15,980 out of 16,000 points in the correct polygons. The 20 miscreants are all in high latitudes, which may be interesting as your example is a long way south too.

I don't use within() because I think it's only an MBR function until MySQL 6. Are your polygons simple enough for you to only require an MBR function ?

Putting polygon coords in anti-clockwise sequence definitely solved problems.

I had to remove altitudes from my polygon coordinates to make distance() work but you don't have any in your examples.

Please let us know whether high latitudes are the cause of the problem - or however else you solve it.

Mike

Options: ReplyQuote


Subject
Views
Written By
Posted
7760
February 18, 2010 06:50PM
3137
March 27, 2010 04:29AM
4123
April 09, 2010 01:33AM
2968
April 09, 2010 01:50AM
5189
April 30, 2010 04:43PM
Re: Points within polygons
3123
April 30, 2010 06:48PM
2715
April 30, 2010 09:38PM
4130
May 03, 2010 05:33AM
3284
May 06, 2010 08:56AM
4565
May 07, 2010 03:46AM


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.