PostGIS
Name
ST_AsEWKT — Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.
Synopsis
text +`*`+ST_AsEWKT*(`geometry `g1`)`;
text +`*`+ST_AsEWKT*(`geometry `g1, integer
maxdecimaldigits=15`)`;
text +`*`+ST_AsEWKT*(`geography `g1`)`;
text +`*`+ST_AsEWKT*(`geography `g1, integer
maxdecimaldigits=15`)`;
Description
Returns the Well-Known Text representation of the geometry prefixed with the SRID. The optional `maxdecimaldigits` argument may be used to reduce the maximum number of decimal digits after floating point used in output (defaults to 15).
To perform the inverse conversion of EWKT representation to PostGIS geometry use ST_GeomFromEWKT.
|
|
|
Enhanced: 3.1.0 support for optional precision parameter.
Enhanced: 2.0.0 support for Geography, Polyhedral surfaces, Triangles and TIN was introduced.
This
function supports 3d and will not drop the z-index.
This
method supports Circular Strings and Curves.
This
function supports Polyhedral surfaces.
This
function supports Triangles and Triangulated Irregular Network Surfaces
(TIN).
Examples
SELECT ST_AsEWKT('0103000020E61000000100000005000000000000
000000000000000000000000000000000000000000000000000000
F03F000000000000F03F000000000000F03F000000000000F03
F000000000000000000000000000000000000000000000000'::geometry);
st_asewkt
--------------------------------
SRID=4326;POLYGON((0 0,0 1,1 1,1 0,0 0))
(1 row)
SELECT ST_AsEWKT('0108000080030000000000000060E30A4100000000785C0241000000000000F03F0000000018
E20A4100000000485F024100000000000000400000000018
E20A4100000000305C02410000000000000840')
--st_asewkt---
CIRCULARSTRING(220268 150415 1,220227 150505 2,220227 150406 3)