Spatial SQL - identify arcs (curves) in polygon/line and layers

Question

Is it possible use spatial SQL to identify the st_polygon and/or st_linestring shapes that were constructed with arcs? By arcs I mean true arcs or curves and not line strings.

I am using ArcSDE 9.2 with Oracle.

Bud · Answer

FYI - I submitted an ArcGIS Idea about this topic:
Determine if line has true curves via SQL (Oracle ST_GEOMETRY)

But I doubt ESRI will ever look at it. They don't seem to be interested in improving ST_GEOMETRY.

PaulDziemiela · Answer

Hi Nick,

Sorry, if you are only working with SDE.ST_GEOMETRY I don't think there is a way to do it on the sql side of things.  Converting the data to SDO_GEOMETRY is the only way I know of to expose the innards of a geometry.  What happens when you run SDE.ST_AsText on an ST_GEOMETRY with curves?   I've never tried.

Cheers,

Paul

NickHarrison · Answer

Thanks Paul.

But my data is ST_GEOMETRY.

I have curves in my data which don't come accross when I extract it with third party software.

I was looking for an appropriate ST_GEOMETRY function, which apparently doesn't exist.