ST_AsText

Introduction: Return the PostGIS-style text representation of a Box3D: BOX3D(xmin ymin zmin, xmax ymax zmax). This is the Box3D overload of ST_AsText; the Geometry variant emits standard WKT.

The bounds are emitted exactly as stored — ST_AsText does not normalize or reorder the corners. The text is not WKT (WKT has no BOX3D type), so it lives outside the asWKT family.

Format: ST_AsText(box: Box3D)

Return type: String

Since: v1.9.1

SQL Example

SELECT ST_AsText(ST_3DMakeBox(ST_PointZ(0.0, 0.0, -3.0), ST_PointZ(5.0, 10.0, 7.0)))

Output:

BOX3D(0.0 0.0 -3.0, 5.0 10.0 7.0)

Returns NULL on NULL input.