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
7857
February 18, 2010 06:50PM
3186
March 27, 2010 04:29AM
4199
April 09, 2010 01:33AM
3016
April 09, 2010 01:50AM
5280
April 30, 2010 04:43PM
Re: Points within polygons
3178
April 30, 2010 06:48PM
2760
April 30, 2010 09:38PM
4187
May 03, 2010 05:33AM
3345
May 06, 2010 08:56AM
4615
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.