(mysql.info) relations-on-geometry-mbr
Info Catalog
(mysql.info) functions-for-testing-spatial-relations-between-geometric-objects
(mysql.info) analysing-spatial-information
(mysql.info) functions-that-test-spatial-relationships-between-geometries
16.5.5 Relations on Geometry Minimal Bounding Rectangles (MBRs)
---------------------------------------------------------------
MySQL provides several functions that test relations between minimal
bounding rectangles of two geometries `g1' and `g2'. The return values
1 and 0 indicate true and false, respectively.
* `MBRContains(G1,G2)'
Returns 1 or 0 to indicate whether the Minimum Bounding Rectangle
of G1 contains the Minimum Bounding Rectangle of G2.
mysql> SET @g1 = GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))');
mysql> SET @g2 = GeomFromText('Point(1 1)');
mysql> SELECT MBRContains(@g1,@g2), MBRContains(@g2,@g1);
----------------------+----------------------+
| MBRContains(@g1,@g2) | MBRContains(@g2,@g1) |
+----------------------+----------------------+
| 1 | 0 |
+----------------------+----------------------+
* `MBRDisjoint(G1,G2)'
Returns 1 or 0 to indicate whether the Minimum Bounding Rectangles
of the two geometries G1 and G2 are disjoint (do not intersect).
* `MBREqual(G1,G2)'
Returns 1 or 0 to indicate whether the Minimum Bounding Rectangles
of the two geometries G1 and G2 are the same.
* `MBRIntersects(G1,G2)'
Returns 1 or 0 to indicate whether the Minimum Bounding Rectangles
of the two geometries G1 and G2 intersect.
* `MBROverlaps(G1,G2)'
Returns 1 or 0 to indicate whether the Minimum Bounding Rectangles
of the two geometries G1 and G2 overlap.
* `MBRTouches(G1,G2)'
Returns 1 or 0 to indicate whether the Minimum Bounding Rectangles
of the two geometries G1 and G2 touch.
* `MBRWithin(G1,G2)'
Returns 1 or 0 to indicate whether the Minimum Bounding Rectangle
of G1 is within the Minimum Bounding Rectangle of G2.
mysql> SET @g1 = GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))');
mysql> SET @g2 = GeomFromText('Polygon((0 0,0 5,5 5,5 0,0 0))');
mysql> SELECT MBRWithin(@g1,@g2), MBRWithin(@g2,@g1);
+--------------------+--------------------+
| MBRWithin(@g1,@g2) | MBRWithin(@g2,@g1) |
+--------------------+--------------------+
| 1 | 0 |
+--------------------+--------------------+
Info Catalog
(mysql.info) functions-for-testing-spatial-relations-between-geometric-objects
(mysql.info) analysing-spatial-information
(mysql.info) functions-that-test-spatial-relationships-between-geometries
automatically generated byinfo2html