mysqlspatialspatial-querypoint-in-polygonmysql-spatial

Mysql: ST_Contains with borders to detect if multipolygon contains point


I use mysql spatial functions.

I have to understand if points lies withing multipolygon.
Initially I used MBRContains but it works in a strange way, so I faced the following error: Mysql function MBRContains is not accurate

enter image description here

My next step was switching to the functions ST_Contains. But I found out that if I use polygon(from multipolygon) vertex as argument - function returns false but I want to unclude all multipolygon borders.

P.S.

I found that where are function:

ST_Touches(g1, g2)

Two geometries spatially touch if their interiors do not intersect, but the boundary of one of the geometries intersects either the boundary or the interior of the other

Looks like it works like I want(in OR conditions with ST_contains) but documentation is not clear for me. Can you explain how can 2 conditions be truth together
1. Interiors do not intersects
2. Boundary intersects the interrior.

?

Question:

How can I achieve the behaviour I want?


Solution

  • This looks like a working solution:

    ST_Contains(g1,g2) || ST_Touches(g1, g2)