ST_AsText
Definition
ST_AsText wählt ein ST_Geometry-Objekt aus und gibt dessen WKT-Darstellung (Well-Known Text) zurück.
Syntax
sde.st_astext (g1 sde.st_geometry)
Rückgabetyp
Oracle
CLOB
PostgreSQL
Text
Beispiel
Die Funktion ST_AsText wandelt den Standort "hazardous_sites" in dessen Textbeschreibung um.
Oracle
CREATE TABLE hazardous_sites (site_id integer, name varchar(40), location sde.st_geometry); INSERT INTO HAZARDOUS_SITES VALUES ( 102, 'W. H. KleenareChemical Repository', sde.st_pointfromtext ('point (1020.12 324.02)', 0) ); SELECT site_id, name, sde.st_astext (location) Location FROM HAZARDOUS_SITES; SITE_ID NAME Location 102 W. H. KleenareChemical Repository POINT (1020.12000000 324.02000000)
PostgreSQL
CREATE TABLE hazardous_sites (site_id integer, name varchar(40), location sde.st_geometry); INSERT INTO hazardous_sites VALUES ( 102, 'W. H. KleenareChemical Repository', sde.st_point ('point (1020.12 324.02)', 0) ); SELECT site_id, name, sde.st_astext (location) AS location FROM hazardous_sites; site_id name location 102 W. H. KleenareChemical Repository POINT (1020.12000001 324.01999999)
7/10/2012