ST_MultiPolygon(ST_MultiLineString[, VARCHAR(128)]) constructor

Creates a multi-polygon from a multilinestring containing exterior rings and an optional list of interior rings.

Syntax

NEW ST_MultiPolygon(multi-linestring[, polygon-format])

Parameters

Name	Type	Description
multi-linestring	ST_MultiLineString	A multilinestring value containing exterior rings and (optionally) a set of interior rings.
polygon-format	VARCHAR(128)	A string with the polygon format to use when interpreting the provided linestrings. Valid formats are 'CounterClockwise', 'Clockwise', and 'EvenOdd'

Remarks

Creates a multi-polygon from a multilinestring containing exterior rings and an optional list of interior rings. The multilinestring must contain only linear rings.

If specified, the polygon-format parameter selects the algorithm the server uses to determine whether a ring is an exterior or interior ring. If not specified, the polygon format of the spatial reference system is used.

For additional information on polygon-format, see POLYGON FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

Note

By default, ST_MultiPolygon uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

Standards and compatibility

Example

The following returns MultiPolygon (((-4 -4, 4 -4, 4 4, -4 4, -4 -4), (-2 1, -3 3, -1 3, -2 1)), ((6 -4, 14 -4, 14 4, 6 4, 6 -4), (8 1, 7 3, 9 3, 8 1))) (two square polygons each with a triangular hole).

SELECT NEW ST_MultiPolygon(
    NEW ST_MultiLineString ('MultiLineString ((-4 -4, 4 -4, 4 4, -4 4, -4 -4), (-2 1, -3 3, -1 3, -2 1), (6 -4, 14 -4, 14 4, 6 4, 6 -4), (8 1, 7 3, 9 3, 8 1))'))

Discuss this page in DocCommentXchange.