MBRDisjoint(g1,g2)
Returns 1 or 0 to indicate whether the Minimum Bounding Rectangles of the two geometries g1 and g2 are disjoint. Two geometries are disjoint if they do not intersect, that is touch or overlap.
SET @g1 = GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))'); SET @g2 = GeomFromText('Polygon((4 4,4 7,7 7,7 4,4 4))'); SELECTmbrdisjoint(@g1,@g2); +----------------------+ | mbrdisjoint(@g1,@g2) | +----------------------+ | 1 | +----------------------+ SET @g1 = GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))'); SET @g2 = GeomFromText('Polygon((3 3,3 6,6 6,6 3,3 3))'); SELECT mbrdisjoint(@g1,@g2); +----------------------+ | mbrdisjoint(@g1,@g2) | +----------------------+ | 0 | +----------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mbrdisjoint/