accessors

CORE

This module contains functions that provide information about internal geometries.

ST_ENVELOPE

ST_ENVELOPE(geog)

Description

Takes any number of features and returns a rectangular Polygon that encompasses all vertices.

• geog: ARRAY<GEOGRAPHY> input features.

Return type

GEOGRAPHY

Example

carto-un

SELECT `carto-un`.carto.ST_ENVELOPE([ST_GEOGPOINT(-75.833, 39.284), ST_GEOGPOINT(-75.6, 39.984), ST_GEOGPOINT(-75.221, 39.125)]);
-- POLYGON((-75.833 39.125, -75.68 39.125 ...

carto-un-eu

SELECT `carto-un-eu`.carto.ST_ENVELOPE([ST_GEOGPOINT(-75.833, 39.284), ST_GEOGPOINT(-75.6, 39.984), ST_GEOGPOINT(-75.221, 39.125)]);
-- POLYGON((-75.833 39.125, -75.68 39.125 ...

carto-os

SELECT `carto-os`.carto.ST_ENVELOPE([ST_GEOGPOINT(-75.833, 39.284), ST_GEOGPOINT(-75.6, 39.984), ST_GEOGPOINT(-75.221, 39.125)]);
-- POLYGON((-75.833 39.125, -75.68 39.125 ...

manual

SELECT carto.ST_ENVELOPE([ST_GEOGPOINT(-75.833, 39.284), ST_GEOGPOINT(-75.6, 39.984), ST_GEOGPOINT(-75.221, 39.125)]);
-- POLYGON((-75.833 39.125, -75.68 39.125 ...

This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 960401.