topic Only one spatial column is supprted in this operation error in Data Management Questions

Only one spatial column is supprted in this operation error

RyanStovern__GISP — Wed, 05 Feb 2014 14:05:02 GMT

I am at a confused look on my face. I have a feature that is a static dataset, but for some reason I started getting an error about 2 weeks ago saying that "Only one spatial column is supported in this operation". Has anyone else seen this and if so how to resolve it. I can view the feature in SQL Management Studio, but not in ArcGIS.

ArcSDE 10.1
SQL Server 2008 R2

Thanks for the help,

Ryan

Re: Only one spatial column is supprted in this operation error

Anonymous User — Wed, 05 Feb 2014 16:18:29 GMT

Original User: ryanstovern

I have figured out what the problem was. It appeared that an user added a field called Shape_ and GIS was being confused by two shape fields. I deleted the Shape_ in SQL and now the feature works again.

Ryan

Re: Only one spatial column is supprted in this operation error

Anonymous User — Wed, 05 Feb 2014 16:25:40 GMT

Original User: mboeringa2010

A single dataset / table with spatial objects in them (geometries), is called a Feature Class in ArcGIS. It is better to refer to that, than to talk about "I have a feature"... It avoids confusion.

Good to hear you managed to fix this, this Help page also gives guidance for Feature Classes in ArcGIS, including the need to restrict spatial tables to one spatial column only:

Rules for creating spatial tables to be used with ArcGIS