描述

一个聚合函数，它返回 方框3d (包括Z坐标)边界一组几何图形的边界框。

边界框坐标位于输入几何图形的空间参考系中。

	归来的人 box3d 值不包括SRID。使用 ST_SetSRID 将其转换为具有SRID元数据的几何体。SRID与输入几何图形相同。

增强：2.0.0引入了对多面体曲面、三角形和三角网的支持。

已更改：2.0.0在以前的版本中，这通常称为ST_Extent3D

This function supports 3d and will not drop the z-index.

This method supports Circular Strings and Curves

This function supports Polyhedral surfaces.

This function supports Triangles and Triangulated Irregular Network Surfaces (TIN).

示例

SELECT ST_3DExtent(foo.geom) As b3extent
FROM (SELECT ST_MakePoint(x,y,z) As geom
        FROM generate_series(1,3) As x
                CROSS JOIN generate_series(1,2) As y
                CROSS JOIN generate_series(0,2) As Z) As foo;
          b3extent
--------------------
 BOX3D(1 1 0,3 2 2)

--Get the extent of various elevated circular strings
SELECT ST_3DExtent(foo.geom) As b3extent
FROM (SELECT ST_Translate(ST_Force_3DZ(ST_LineToCurve(ST_Buffer(ST_Point(x,y),1))),0,0,z) As geom
        FROM generate_series(1,3) As x
                CROSS JOIN generate_series(1,2) As y
                CROSS JOIN generate_series(0,2) As Z) As foo;

        b3extent
--------------------
 BOX3D(1 0 0,4 2 2)
                

另请参阅

ST_Extent, ST_Force3DZ, ST_SetSRID