Home > database >  Mysql st_contains returns the error
Mysql st_contains returns the error

Time:10-30

Project using mysql for geographic query, we use the st_contains (st_within etc methods are tried, effect equivalent) query whether Point in Polygon, but the result seems to not be accurate, if a Point is not in Polygon, st_contains still return 1

Below is my test code

https://paiza.io/projects/_awiKJL2mK1bbG5rtOIK6w

Involved in the code of polygon and the location of the point below



I have been searching for a long time, but still don't know where the problem is, what a great god can help me to see exactly where the problem is? Thank the first...
  • Related