1 of 1

ST_AsText

Converts a value in internal geometry format to its WKT representation and returns the string result.

Syntax

ST_AsText(g)
AsText(g)
ST_AsWKT(g)
AsWKT(g)

Description

Converts a value in internal geometry format to its representation and returns the string result.

ST_AsText(), AsText(), ST_AsWKT() and AsWKT() are all synonyms.

Examples

_{This page is licensed: GPLv2, originally from}

SET @g = 'LineString(1 1,4 4,6 6)';

SELECT ST_AsText(ST_GeomFromText(@g));
+--------------------------------+
| ST_AsText(ST_GeomFromText(@g)) |
+--------------------------------+
| LINESTRING(1 1,4 4,6 6)        |
+--------------------------------+

ST_AsText

hashtagSyntax

hashtagDescription

hashtagExamples

ST_AsText

hashtagSyntax

hashtagDescription

hashtagExamples

Syntax

Description

Examples

Syntax

Description

Examples