ST_MakeEnvelope¶

Constructs a rectangular Polygon from minimum and maximum coordinates.

Usage¶

geometry ST_MakeEnvelope(min_x: double, min_y: double, max_x: double, max_y: double, srid: crs)

Arguments¶

min_x (double)
min_y (double)
max_x (double)
max_y (double)
srid (crs)

Description¶

Constructs a rectangular Polygon from minimum X, minimum Y, maximum X, and maximum Y coordinates. An optional SRID or CRS can be provided as a fifth argument.

Examples¶

SELECT ST_MakeEnvelope(1.234, 2.234, 3.345, 3.345);

┌──────────────────────────────────────────────────────────────────────────────┐
│ st_makeenvelope(Float64(1.234),Float64(2.234),Float64(3.345),Float64(3.345)) │
│                                   geometry                                   │
╞══════════════════════════════════════════════════════════════════════════════╡
│ POLYGON((1.234 2.234,1.234 3.345,3.345 3.345,3.345 2.234,1.234 2.234))       │
└──────────────────────────────────────────────────────────────────────────────┘

With an SRID:

SELECT ST_MakeEnvelope(1.234, 2.234, 3.345, 3.345, 4326);

┌──────────────────────────────────────────────────────────────────────────────┐
│ st_makeenvelope(Float64(1.234),Float64(2.234),Float64(3.345),Float64(3.345), │
│                                 Int64(4326))…                                │
╞══════════════════════════════════════════════════════════════════════════════╡
│ POLYGON((1.234 2.234,1.234 3.345,3.345 3.345,3.345 2.234,1.234 2.234))       │
└──────────────────────────────────────────────────────────────────────────────┘