Was this helpful?
GeometryZMFromText
GEOMETRYZMFROMTEXT(s string [, srid integer])
Alias: GEOMZMFROMTEXT, ST_GEOMETRYZMFROMTEXT, ST_GEOMZMFROMTEXT
Returns a geometry object that corresponds to the Well Known Text (WKT) in s. The SRID can optionally be specified. It is ‑1 by default. This function only supports geometries that contain both Z and M coordinates.
Result type: geometry
Examples:
SELECT ASTEXT(GEOMZMFROMTEXT('MULTIPOINT ZM(0 1 1 5, 1 2 2 5, 3 5 2 5, 8 13 1 5)'));
--------------------------------
col1
--------------------------------
MULTIPOINT ZM (0 1 1 5, 1 2 2 5, 3 5 2 5, 8 13 1 5)
--------------------------------
SRID of point when it is not specified:
SELECT SRID(GEOMZMFROMTEXT('POINT Z(1 2 2 1)'));
-------------
col1
-------------
-1
-------------
SRID of point when it is specified:
SELECT SRID(GEOMZMFROMTEXT('POINT ZM(1 2 2 1)', 4955));
-------------
col1
-------------
4955
-------------
Last modified date: 11/09/2022