ArcSDE data won't appear at all zoom levels

Question

I have a number of vector datasets I just loaded into ArcSDE (SQL Server 2008 R2, ArcSDE 10 sp2, geography datatype) and when I view the data in ArcMap 10 sp2 the data will display only if I am zoomed in closer than ~1:50m (it varies based on the dataset).  This is a problem for me since I am working with countrywide datasets and required to use the geography datatype.

Is this a spatial index problem or is there some other setting that I need to alter?  I've tried a number of things that I read on the forums today but nothing seems to work.  And btw, my geomerty datatype SDE databases work fine at all scale levels.

Thanks for in advance for any tips or ideas.

Ben Spaulding

ShannonShields · Answer

I can understand the mult-hemisphere problem, but I am having this issue with a features wholy located in a single hemisphere (northern and eastern, let's say) and about the size of Austria.

You are probably encountering the other Geography type limitation - features cannot extend past 90 degrees north or -90 degrees south. If you are zooming into northern Europe and the upper limit of your display window exceeds 90 degrees latitude then the spatial filter (zoom window extent) that is passed to SQL Server will fail and no results will be returned.

-Shannon

deleted-user-XYH0uc33lKDp · Answer

Quick update.  I changed my workflow and now only use geomerty datatypes and everything works perfectly.

deleted-user-XYH0uc33lKDp · Answer

I can understand the mult-hemisphere problem, but I am having this issue with a features wholy located in a single hemisphere (northern and eastern, let's say) and about the size of Austria.

I'll try sdelayer command and see what happens.

thanks!