Was this helpful?
AsTextRaw
ASTEXTRAW(g Geometry)
Alias: ST_ASTEXTRAW
Returns g in Well Known Text (WKT) where every number has a precision of 16 (16 digits after the decimal point).
Result type: string
Examples:
SELECT ASTEXTRAW(LINEFROMTEXT('LINESTRING(0 0, 10 10)'));
-------------------------------
col1
-------------------------------
LINESTRING (0.0000000000000000 0.0000000000000000, 10.0000000000000000 10.0000000000000000)
 
 
SELECT ASTEXTRAW(BUFFER(LINEFROMTEXT('LINESTRING(0 0, 10 10)'), 1));
--------------------------------
col1
--------------------------------
POLYGON ((9.2928932188134521 10.7071067811865479, 9.4444297669803987 10.8314696123025467, 9.6173165676349122 10.9238795325112878, 9.8049096779838720 10.9807852804032304, 10.0000000000000018 11.0000000000000000, 10.1950903220161297 10.9807852804032304, 10.3826834323650896 10.9238795325112861, 10.5555702330196031 10.8314696123025449, 10.7071067811865479 10.7071067811865479, 10.8314696123025449 10.5555702330196031, 10.9238795325112861 10.3826834323650896, 10.9807852804032304 10.1950903220161297, 11.0000000000000000 10.0000000000000000, 10.9807852804032304 9.8049096779838720, 10.9238795325112878 9.6173165676349122, 10.8314696123025467 9.4444297669803987, 10.7071067811865479 9.2928932188134521, 0.7071067811865475 -0.7071067811865475, 0.5555702330196012 -0.8314696123025459, 0.3826834323650888 -0.9238795325112872, 0.1950903220161274 -0.9807852804032307, -0.0000000000000006 -1.0000000000000000, -0.1950903220161286 -0.9807852804032304, -0.3826834323650899 -0.9238795325112867, -0.5555702330196020 -0.8314696123025455, -0.7071067811865475 -0.7071067811865476, -0.8314696123025448 -0.5555702330196028, -0.9238795325112865 -0.3826834323650903, -0.9807852804032302 -0.1950903220161295, -1.0000000000000000 -0.0000000000000010, -0.9807852804032308 0.1950903220161266, -0.9238795325112873 0.3826834323650884, -0.8314696123025465 0.5555702330196004, -0.7071067811865475 0.7071067811865475, 9.2928932188134521 10.7071067811865479))
Last modified date: 04/03/2024