ST_MakeEnvelope()¶

Builds the axis-aligned rectangular envelope defined by two corner points.

Syntax¶

ST_MakeEnvelope(point1, point2)

Arguments¶

Argument	Description
`point1`	First POINT corner.
`point2`	Opposite POINT corner.

Return Value¶

Returns a GEOMETRY polygon.

Usage Notes¶

Examples¶

DROP DATABASE IF EXISTS geo_operation_demo;
CREATE DATABASE geo_operation_demo;
USE geo_operation_demo;

SELECT ST_AsText(ST_MakeEnvelope(ST_GeomFromText('POINT(0 0)'), ST_GeomFromText('POINT(2 3)'))) AS envelope;

DROP DATABASE geo_operation_demo;

See Also¶

Geo Functions Overview