Fork me on GitHub

ST_GeomFromText

Signatures

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

Description

Converts the Well Known Text wkt into a Geometry with spatial reference id srid. The default value of srid is 0.

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_GeomFromText('POINT(2 3)', 27572);
-- Answer: POINT(2 3)

SELECT ST_SRID(ST_GeomFromText('LINESTRING(1 3, 1 1, 2 1)'));
-- Answer: 0

SELECT ST_GeomFromText('POLYGON((0 0 -1, 2 0 2, 2 1 3, 0 0 -1))');
-- Answer: POLYGON((0 0, 2 0, 2 1, 0 0))
See also