Fork me on GitHub

ST_MLineFromText

Signatures

GEOMETRY ST_MLineFromText(VARCHAR wkt);
GEOMETRY ST_MLineFromText(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 MULTILINESTRING.

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_MLineFromText('MULTILINESTRING((1 5, 4 6, 7 5),
                                         (2 4, 4 5, 6 3))');
-- Answer: MULTILINESTRING((1 5, 4 6, 7 5), 
--                         (2 4, 4 5, 6 3))

SELECT ST_MLineFromText('MULTILINESTRING((10 48, 10 21, 10 0),
                                         (16 0, 16 23, 16 48))', 101);
-- Answer: MULTILINESTRING((10 48, 10 21, 10 0),
--                         (16 0, 16 23, 16 48))

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