Tag Archives: geography

Ring Orientation, Bigger-than-a-Hemisphere Polygons, and the ReorientObject method in SQL Server 2012

If you’ve ever tried to import spatial data (from an ESRI shapefile, say) into SQL Server, you’ve almost certainly encountered the dreaded “bigger than a hemisphere” error, as follows: Msg 6522, Level 16, State 1, Line 1 A .NET Framework … Continue reading

Posted in Spatial, SQL Server | Tagged , , , | 5 Comments

Splitting Multi Geometries into single geometries

Unlike some spatial formats/systems (such as the ESRI shapefile), SQL Server lets you store different types of geometry within a single column. That is to say that a single geometry or geography column within a SQL Server table may contain … Continue reading

Posted in SQL Server | Tagged , , , | 1 Comment