MySQL Forums
Forum List  »  GIS

Re: MySQL 8: ST_Interects works very strange
Posted by: David Stokes
Date: August 31, 2020 04:17PM

It looks you are creating a one degree wide box around the antimeridian. MySQL will assume the shortest path between long -179 and long 180, so it doesn't intersect with his point.

Also, the shortest path between the south and north poles could go along any degree of longitude, so he really should use a third point to make it follow the longitude you want. It seems to work by accident in this case.

Thirdly, Boost Geometry and MySQL doesn't guarantee that polygons covering more than half the globe will work as expected. There's no guarantee that the query would work as expected even if you got the box right.

Options: ReplyQuote

Written By
Re: MySQL 8: ST_Interects works very strange
August 31, 2020 04:17PM

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.