ST_Extent

Returns the planar bounding box of all geometries in A as a typed Box2D. Empty geometries and null values are skipped. If all inputs are empty or null, the result is null. Mirrors PostGIS ST_Extent. ST_Extent is the typed counterpart to ST_Envelope_Agg. ST_Envelope_Agg returns the envelope as a Geometry; ST_Extent returns it as a Box2D value that serializes to a struct of four doubles.

Signatures

ST_Extent(A: geometryColumn)

Parameters

Geometry

required

The column of geometries to aggregate.

Return type

The planar bounding box enclosing every geometry in the column.

Example

SELECT ST_AsText(ST_Extent(geom))
FROM VALUES
    (ST_GeomFromText('POINT (1 1)')),
    (ST_GeomFromText('POINT (5 7)')),
    (ST_GeomFromText('LINESTRING (3 2, 6 4)')) AS t(geom)

BOX(1.0 1.0, 6.0 7.0)

ST_Envelope_Agg

ST_Intersection_Agg

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Example

​Signatures

​Parameters

​Return type

​Example

Signatures

Parameters

Return type

Example