H2GIS

Fork me on GitHub

ST_3DPerimeter

Signature

DOUBLE ST_Perimeter(GEOMETRY poly);

Description

Returns the 3D perimeter of a polygon or a multipolygon.

that .

Perimeter is measured in the units of the spatial reference system.

Remarks:

  • In the case of a 2D geometry, ST_3DPerimeter returns the same value as ST_Perimeter,
  • Polygons and multipolygons within geometrycollection are accepted.

Examples

SELECT ST_3DPerimeter('POLYGON((1 2 0, 4 2 1, 4 6 3, 1 6 5, 1 2 0))');
-- Answer: 17.63

SELECT ST_3DPerimeter('POLYGON((1 2, 4 2, 4 6, 1 6, 1 2))');
-- Answer: 14.0

SELECT ST_3DPerimeter('MULTIPOLYGON(((0 2 0, 3 2 1, 3 6 2, 0 6 3, 0 2 0)),
                                    ((5 0 1, 7 0 3, 7 1 4, 5 1 2, 5 0 1)))');
-- Answer: 23.93

SELECT ST_3DPerimeter('GEOMETRYCOLLECTION(
                    MULTIPOINT((4 4), (1 1), (1 0), (0 3)),
                    LINESTRING(2 1, 1 3, 5 2),
                    POLYGON((1 2 0, 4 2 1, 4 6 2, 1 6 3, 1 2 0)))');
-- Answer: 15.44

SELECT ST_3DPerimeter('LINESTRING(2 1, 1 3, 5 2)');
-- Answer: 0
See also