topic Re: SQL Database: True curves changes to densified line segments with attribute change in Geodatabase Questions

SQL Database: True curves changes to densified line segments with attribute change

DavidQuillin2 — Thu, 04 Feb 2021 17:43:06 GMT

We recently updated the feature classes stored in a SQL database that included changing the geometry storage type from 'High Precision using ESRI Binary spatial type' to 'High Precision using Geometry spatial type (SRID 6557)'. For various reasons, we have always used true curves when digitizing spatial features and continues this practice after the recent updates with no apparent issues. However, I just noticed that the curves change to densified line segments after an attribute change. See below...

Before attribute change - Polygon was saved and stored:

After change - curves are now densified line segments:

In all my experience working with ESRI products, I've never seen the updating of an attribute field result in the changing of the geometry of a feature. Can someone help shed light on what is happening here?

Thanks,

David

Re: SQL Database: True curves changes to densified line segments with attribute change

BillFox — Thu, 04 Feb 2021 22:45:04 GMT

Did the process include moving data in and out of a shape-file?

Re: SQL Database: True curves changes to densified line segments with attribute change

DavidQuillin2 — Thu, 04 Feb 2021 22:57:55 GMT

No, all edits were made in SQL through an ArcMap edit session.

Re: SQL Database: True curves changes to densified line segments with attribute change

VinceAngelo — Fri, 05 Feb 2021 15:01:50 GMT

> I've never seen the updating of an attribute field result in the changing of the geometry of a feature.

But you didn't change an attribute field, you changed the geometry. There's no way for SQL to rewrite the CAD BLOB, so the CAD data is lost.

- V

Re: SQL Database: True curves changes to densified line segments with attribute change

DavidQuillin2 — Fri, 05 Feb 2021 15:16:23 GMT

No. I created the polygon using true curves, and then saved and closed the edit session. Started a new edit session, confirmed that the polygon still maintained the true curves, which it did. Then I entered a value into an attribute field at which point the true curves become densified lines.

Re: SQL Database: True curves changes to densified line segments with attribute change

BillFox — Fri, 05 Feb 2021 16:04:43 GMT

If you can use a backup of the good stuff, maybe create a fresh new layer and load it up to go forward with.