ST_ENVELOPE(g) ENVELOPE(g)
Returns the Minimum Bounding Rectangle (MBR) for the geometry value g
. The result is returned as a Polygon value.
The polygon is defined by the corner points of the bounding box:
POLYGON((MINX MINY, MAXX MINY, MAXX MAXY, MINX MAXY, MINX MINY))
ST_ENVELOPE()
and ENVELOPE()
are synonyms.
SELECT AsText(ST_ENVELOPE(GeomFromText('LineString(1 1,4 4)'))); +----------------------------------------------------------+ | AsText(ST_ENVELOPE(GeomFromText('LineString(1 1,4 4)'))) | +----------------------------------------------------------+ | POLYGON((1 1,4 1,4 4,1 4,1 1)) | +----------------------------------------------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/envelope/