I was provided with a polygon defined in WKT which has 4741 points and am able to insert it as a geography data type within a database in SQL Server 2008. However, when I view it using the spatial viewer it takes up the entire viewer and looks like a large rectangle. When I look at the same shape in Quantum GIS the shape looks like what I would expect (it is kind of a funky shape). I executed the STNumGeometries() method on the geography shape in SQL Server and it returned 1 so SQL Server thinks it is valid, but does not appear to be able to correctly understand the shape. Is there anything obvious that could be causing this issue?
The boundaries of the shape should be something like:
-89.25521,39.22638 -87.49851,38.84994 -87.97533,38.21419 -89.17156,38.11799 -89.25521,39.22638
What I'm seeing in the SQL Server Spatial viewer is:
-180, 81 180, 81 180, -90 -80, -90 -180, 81
Any assistance woudl be greatly appreciated.