Back to Starrocks

ST_GeometryFromText,ST_GeomFromText

docs/en/sql-reference/sql-functions/spatial-functions/st_geometryfromtext.md

4.1.0666 B
Original Source

ST_GeometryFromText,ST_GeomFromText

Converts a WKT (Well Known Text) to the corresponding memory geometry.

Syntax

Haskell
GEOMETRY ST_GeometryFromText(VARCHAR wkt)

Examples

Plain
MySQL > SELECT ST_AsText(ST_GeometryFromText("LINESTRING (1 1, 2 2)"));
+---------------------------------------------------------+
| st_astext(st_geometryfromtext('LINESTRING (1 1, 2 2)')) |
+---------------------------------------------------------+
| LINESTRING (1 1, 2 2)                                   |
+---------------------------------------------------------+

keyword

ST_GEOMETRYFROMTEXT,ST_GEOMFROMTEXT,ST,GEOMETRYFROMTEXT,GEOMFROMTEXT