Output functions can be used to convert a specified geometry object to a Well-Known Text (WKT) string that does not contain spatial reference identifier (SRID) metadata. This can meet your diverse needs in data processing, analysis, and visualization.
Applicable engines and versions
The ST_AsText function is applicable only to all versions of LindormTable.
ST_AsText
This function returns the information about a geometry object in WKT format. The SRID of the geometry object is not returned.
Syntax
string ST_AsText(geometry g)Parameters
Parameter | Description |
g | The geometry object whose information you want to output. |
You can specify a geometry object of the following types: Point, LineString, Polygon, MultiPoint, MultiLineString, MultiPolygon, and GeometryCollection.
By default, the returned results support DOUBLE values with up to 16 decimal places.
Example
SELECT ST_AsText(ST_GeomFromText('POINT(111.1111111 1.1111111)')) AS text;The following result is returned:
+-------------------------------+
| text |
+-------------------------------+
| POINT (111.1111111 1.1111111) |
+-------------------------------+