Export Data Creating Extra Fields When SQL Geometry Storage Type Used

667
1
Jump to solution
09-04-2014 05:48 PM
Regular Contributor

The 10.1 upgrade process changes the default geometry type from SDEBinary to SQL Geometry.  Since SDEBinary is going away the sooner we migrate away from SDEBinary the better I thought but that hasn't been the case.  We have multiple workflows that are now broken.   New fields are added to the output feature class when doing both an ArcMap Export and using the Feature Class to Feature Class tool.  If the fc is a polygon, the area and length fields get duplicated with the addition of Shape_STArea__ and Shape_STLength__ in the output feature class.  This happens both when going to a file geodatabase and an SDE geodatabase.  This doesn't occurer when the the source feature class is SDEBinary.

After contacting ESRI support I found out that this is expected behavior and not considered a bug.  So, now I have to figure out programmatic work arounds and change interactive workflows. Is there a way to determine the storage type of an SDE feature class in python? If I know the storage type is Geometry I can add a delete fields line to my programs.

We are running ArcSDE 10.1 with SQL Server 2012.

Feature Class Properties after FC2FC.png

Reply
0 Kudos
1 Solution

Accepted Solutions
Regular Contributor

Turns out this is a known bug, NIM-090100, however it was submitted 18 months ago and still no fix

Bug Number NIM090100
Submitted Mar 26, 2013 2:45 PM
Severity Medium
Applies To ArcGIS
Version Found 10.1 SP1
Prog Language N/A
Server Platform All Windows
Client Platform Windows
Database SQL Server
Locale N/A
Status Open: Assigned
Version Fixed N/A
SP Fixed N/A

View solution in original post

Reply
0 Kudos
1 Reply
Regular Contributor

Turns out this is a known bug, NIM-090100, however it was submitted 18 months ago and still no fix

Bug Number NIM090100
Submitted Mar 26, 2013 2:45 PM
Severity Medium
Applies To ArcGIS
Version Found 10.1 SP1
Prog Language N/A
Server Platform All Windows
Client Platform Windows
Database SQL Server
Locale N/A
Status Open: Assigned
Version Fixed N/A
SP Fixed N/A

View solution in original post

Reply
0 Kudos