MBROverlaps¶
TL;DR¶
MBROverlaps 返回两个最小外接矩形是否部分重叠。
语法¶
MBROverlaps(geom1, geom2)
参数说明¶
geom1 和 geom2 为 GEOMETRY 值。
返回值¶
返回 BOOL。
使用说明¶
包含关系和仅边界接触不算重叠。该谓词只计算最小外接矩形。
示例¶
DROP DATABASE IF EXISTS geo_mbroverlaps_demo;
CREATE DATABASE geo_mbroverlaps_demo;
USE geo_mbroverlaps_demo;
SELECT MBROverlaps(ST_GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0))'), ST_GeomFromText('POLYGON((5 5,15 5,15 15,5 15,5 5))')) AS overlaps_mbr;
DROP DATABASE geo_mbroverlaps_demo;