Mysql: ST_Contains with borders to detect if multi

2019-05-08 01:58发布

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?

2条回答
在下西门庆
2楼-- · 2019-05-08 02:29

Looks like working solution:

ST_Contains(g1,g2) || ST_Touches(g1, g2)
查看更多
爷的心禁止访问
3楼-- · 2019-05-08 02:46

Looks like ST_Distance(AREA, @point)) = 0 includes border

查看更多
登录 后发表回答