AnsweredAssumed Answered

ArcGIS 10.1  MsSQL 2012 Query Layer not visible at full extent

Question asked by Mitrich2 on Jun 30, 2014
I have a problem with Query layer visibility.
Data from MSSQL 2012 table  - geography type column (WKID: 4326 WGS84)
When I zoom out to the north map extent more than 90 dd, then all features disappear from the map frame (see attachment)

it is known issue for SQL 2008
http://resources.arcgis.com/en/help/main/10.2/002q/002q0000006p000000.htm (last paragraph)

"Zooming to a global extent on a geography feature class in SQL Server 2008 can generate a spatial filter that violates the hemisphere rule or which has coordinates outside valid geography extents, in which case filter shape creation will fail and the query will return no result."

Is it the same problem at SQL2012?
Will ESRI solve this issue?
How to circumvent this obstacle?

extent with Y<90 DD
[ATTACH=CONFIG]34973[/ATTACH]


extent with Y>90 DD

[ATTACH=CONFIG]34974[/ATTACH]

Attachments

Outcomes