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

379
5
02-04-2021 09:43 AM
Labels (2)
DavidQuillin2
New Contributor

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:

DavidQuillin2_1-1612460096151.png

After change - curves are now densified line segments:

DavidQuillin2_2-1612460287935.png

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

 

 

 

 

0 Kudos
5 Replies
BillFox
MVP Frequent Contributor

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

0 Kudos
DavidQuillin2
New Contributor

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

0 Kudos
VinceAngelo
Esri Esteemed Contributor

>  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

0 Kudos
DavidQuillin2
New Contributor

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.

0 Kudos
BillFox
MVP Frequent Contributor

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

0 Kudos