H2GIS

Fork me on GitHub

ST_MPointFromText

Signature

GEOMETRY ST_MPointFromText(VARCHAR wkt);
GEOMETRY ST_MPointFromText(VARCHAR wkt, INT srid);

Description

Converts the Well Known Text wkt into a Geometry, optionally with spatial reference id srid. Verifies that wkt does in fact specify a MULTIPOINT.

Note: If wkt specifies a Geometry with z-coordinates, they will be conserved in reality but suppressed when visualizing the Geometry as WKT.

Implements the OpenGIS Simple Features Implementation Specification for SQL version 1.2.1.

Examples

SELECT ST_MPointFromText('MULTIPOINT(4 2, 3 7, 6 8)');
-- Answer: MULTIPOINT((4 2), (3 7), (6 8))

SELECT ST_MPointFromText('MULTIPOINT(5 5, 1 2, 3 4, 20 3)', 2154);
-- Answer: MULTIPOINT((5 5), (1 2), (3 4), (20 3))

SELECT ST_MPointFromText('POINT(2 3)', 2154);
-- Answer: The provided WKT Geometry is not a MULTIPOINT.
See also