topic Re: AutocadMap 3D create CURVEPOLYGON on SQLServer geometry field instead of POL in AutoCAD Map 3D Forum

AutocadMap 3D create CURVEPOLYGON on SQLServer geometry field instead of POLYGON

fabiorizzato — Wed, 21 Nov 2018 10:46:07 GMT

On SQL Server 2017 we want to have only POLYGON geometries in the geometry field.

When we add a new geometry to the SQL table with Autocad Map 3D, we find that automatically this new feature is of a CURVEPOLYGON type.

There is a workaround to have only POLYGON created for new geometries on SQL Server 2017? (settings, etc.)

The command that we are using from the layer connected to SQLServer is "New geographic entity from geometry" (DMUI_GISCREATENEWFEATURECMD)

Thanks in advance,

Fabio

gluckett — Thu, 02 May 2019 14:39:31 GMT

Yes, curvepolygons (aka those with Arcs) are not supported by ArcMap/ArcGIS Pro.

I have a workaround where I have to update my Geometry field in SQL Server after the user draws a polygon so ESRI can read it..

update myParcels

set shape=[Shape].CurveToLineWithTolerance(0.1,0)

where Shape.STGeometryType() like 'CurvePolygon'

It would be nice if we could force the FDO layers in AutoCAD Map 3D to draw only Polygons if we wished.