Re: Points within polygons
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
Subject
Views
Written By
Posted
8165
February 18, 2010 06:50PM
3317
March 27, 2010 04:29AM
4402
April 09, 2010 01:33AM
3153
April 09, 2010 01:50AM
5455
April 30, 2010 04:43PM
Re: Points within polygons
3330
April 30, 2010 06:48PM
2921
April 30, 2010 09:38PM
4345
May 03, 2010 05:33AM
3483
May 06, 2010 08:56AM
4774
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.