跳转至
Apache Sedona 1.9.0 已正式发布,新增 Spark 4.1 支持、proj4sedona 坐标系转换、Bing Tile 函数等众多特性!

ST_3DMakeBox

Introduction: Build a Box3D from two corner POINT Z geometries. Mirrors PostGIS's ST_3DMakeBox. The corners are taken verbatim — no swapping or validation of ordering — so inverted bounds are preserved as supplied. POINT inputs without a Z dimension contribute z = 0, matching PostGIS.

ST_3DMakeBox builds a cuboid from two corner POINT Z geometries

Format: ST_3DMakeBox(lowerLeft: Point, upperRight: Point)

Return type: Box3D

Since: v1.9.1

SQL Example

SELECT ST_AsText(ST_3DMakeBox(ST_PointZ(1.0, 2.0, 3.0), ST_PointZ(4.0, 5.0, 6.0)))

Output:

BOX3D(1.0 2.0 3.0, 4.0 5.0 6.0)

Throws IllegalArgumentException if either argument is not a POINT. Returns NULL if either point is NULL or empty.