AnsweredAssumed Answered

Spatial Database View giving draw error in ArcMap 10.4

Question asked by TempletonDemographics on May 25, 2016
Latest reply on May 22, 2018 by MatthieuMureau

I am working with MS SQL Server 2012 and ArcMap 10.4.

I'm a bit of newbie to SQL so please bear with me.

 

I have created a view in my database using the following query:

 

CREATE VIEW dbo.intermediate

AS

SELECT MIN(pa.OBJECTID) OBJECTID, MIN(pa.INT_NAME) INT_NAME,

MIN(pa.INT_NAME) + ' INT' AS CAMPUS, MIN(pa.ISD) ISD,

geometry::UnionAggregate(pa.Shape) SHAPE

FROM dbo.pa_evw as pa

GROUP BY pa.ISD, pa.INT_NAME

 

Where 'dbo.pa_evw' is an archived view of a polygon layer with a category field called INT_NAME.

 

The query runs without an error in SQL Server Management Studio and the spatial results look how I would expect them to. However, when I bring the layer into ArcMap, I get a drawing error that says there is a "Shape integrity error."

 

Can anyone point me in the right direction?

Outcomes