ST_3DExtent

Returns the 3D bounding box of all geometries in A as a typed Box3D. Empty geometries and null values are skipped. If all inputs are empty or null, the result is null. Geometries without a Z dimension fold into z = 0. Mirrors PostGIS ST_3DExtent. ST_3DExtent is the 3D counterpart to ST_Extent, which returns a Box2D.

ST_3DExtent aggregates a column of geometries into the enclosing cuboid

Signatures

ST_3DExtent(A: geometryColumn)

Parameters

Geometry

required

The column of geometries to aggregate.

Return type

The 3D bounding box enclosing every geometry in the column.

Example

SELECT ST_AsText(ST_3DExtent(geom))
FROM VALUES
    (ST_GeomFromText('POINT Z (1 2 3)')),
    (ST_GeomFromText('POINT Z (4 5 -1)')),
    (ST_GeomFromText('LINESTRING (-3 0, 0 0)')) AS t(geom)

BOX3D(-3.0 0.0 -1.0, 4.0 5.0 3.0)

The XY-only linestring contributes z = 0, which sits between the -1 and 3 of the two POINT Z rows, so it does not move either Z bound.

ST_ShortestLine

ST_Analyze_Aggr

⌘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