topic Detect arc in st_geometry in Geodatabase Questions

Detect arc in st_geometry

LOU_Sud-OuestThales_Services — Mon, 10 Apr 2017 08:43:02 GMT

Hello,

I have two features class (multipolygon and multiline) with ST_GEOMETRY format in a 9.3 geodatabase.

How to detect features that contains arcs using sde ?

Re: Detect arc in st_geometry

JoshuaBixby — Sun, 12 Dec 2021 07:27:29 GMT

I am not sure of an SQL-based approach, but you can use an ArcPy search cursor:

fc = # path to feature class
with arcpy.da.SearchCursor(fc, ["OID@","SHAPE@"]) as cur:
    for oid, shape in cur:
        if "curve" in shape.JSON:
            print oid‍‍‍‍‍

Re: Detect arc in st_geometry

LOU_Sud-OuestThales_Services — Mon, 10 Apr 2017 17:00:44 GMT

I'm under ArcGIS 9.3.1, so I tried using ArcgisScripting.

But Geometry object seems not to have ".JSON" property.

Re: Detect arc in st_geometry

JoshuaBixby — Mon, 10 Apr 2017 17:28:36 GMT

I didn't realize your client was also stuck back at 9.3.x. Do you have access to a newer client that can connect to the 9.3 geodatabase?

If you have to stick with ArcGIS 9.3.1 as a client, I will have to think about options. It may be you could use comtypes or a similar package to access ArcObjects directly from Python.

Re: Detect arc in st_geometry

LOU_Sud-OuestThales_Services — Wed, 12 Apr 2017 12:08:02 GMT

OK, I will try using ArcObjects and ComTypes.

But how to test an ArcObject IGeometry (polyline or polygon) contains arcs ?