ST_3DPerimeter — 返回多边形几何体的3D周长。
float ST_3DPerimeter(
geometry geomA)
;
返回几何体的三维周长(如果它是一个多边形或多个多边形)。如果几何图形是二维的,则返回二维周长。
This function supports 3d and will not drop the z-index.
已更改:2.0.0在以前的版本中,这通常称为ST_Perimeter3D
马萨诸塞州平面英尺空中略高的多边形周长
SELECT ST_3DPerimeter(geom), ST_Perimeter2d(geom), ST_Perimeter(geom) FROM (SELECT ST_GeomFromEWKT('SRID=2249;POLYGON((743238 2967416 2,743238 2967450 1, 743265.625 2967416 1,743238 2967416 2))') As geom) As foo; ST_3DPerimeter | st_perimeter2d | st_perimeter ------------------+------------------+------------------ 105.465793597674 | 105.432997272188 | 105.432997272188