AnsweredAssumed Answered

Circular polygons created in ArcSDE Geodatabase

Question asked by nccmaAGOL on Nov 19, 2019
Latest reply on Nov 21, 2019 by nccmaAGOL

Hi,

 

I have a polygon feature class within an ArcSDE Geodatbase.

 

Within ArcMap I have created a polygon using the Circle edit tool.

 

I am now accessing the data within SQL Server 2017.

 

My question is can I programmatically identify that this polygon is a Circle within SQL server?

I can obviously identify the feature with statements such as:

SELECT Shape.STGeometryType();  RETURNS Polygon

SELECT Shape.STAsText();  RETURNS POLYGON ((2423859.4153780821 2495265.7907268363, 2423859.4101329744 2495265.7907232433,.....)) plus many more vertices.

 

But these don't delve into the feature geometry detail I require.

I would like to dig deeper and identify that the feature is circular and contains curves.

 

The primary reason I ask is I have another feature class with thousands of records and some of them are circular polygons. Once I identify them I intend on cleaning them up (simplifying to envelopes and deleting where possible) to improve performance on our various clients.

 

Any help would be appreciated.

 

Thanks,

Pat

Outcomes