AnsweredAssumed Answered

Get the "real" geometry with ST_ASTEXT?

Question asked by ameskamp on Jun 16, 2016
Latest reply on Jun 17, 2016 by ameskamp

Hi, we've been trying to identify some line features with duplicate vertices recently (this is ArcGIS 10.2.1 with ST_GEOMETRY on Oracle 11.2), and one obvious way seemed to be to output the geometry as OGC WKT using the ST_GEOMETRY function ST_ASTEXT. I noticed, however, that line features are always output as LINESTRING, i.e. with straight line segments, even though the real geometry (as seen in the edit vertices window in ArcMap) has circular segments as well. Also, my duplicate vertices don't show up in the WKT LINESTRING either

 

Is there a way of exporting the "real" geometry as text, especially the location of all vertices?

 

Thanks, Martin

 

PS We're using Data Reviewer 10.3 right now, but installing that at a customer site otherwise running 10.2.1 is a bit of a hassle...

Outcomes