Get the "real" geometry with ST_ASTEXT?

MartinAmeskamp

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...

MartinAmeskamp

Hi Joshua and Christian,

thanks for your replies! It very much looks like the ST_GEOMETRY WKT functionality works the same as the Python WKT property (tech support should know for sure), and I wasn't aware of the JSON property of the python geometry type - this has the real geometry and can be parsed to identifiy duplicate vertices.

However, this seems to be new with 10.3 as well (like the Data Reviewer checks we're suing now), so it does look like there is no out-of-the-box functionality for identifying duplicate vertices in 10.2.1.

Thanks again, Martin