Nusc (8/1/2016)

---

Hi,

is anyone familiar with building maps with SQL Query?

I am trying to find follow this example:

https://dba.stackexchange.com/questions/24954/convert-spatial-points-data-to-line-data-for-use-in-line-layer-in-sql-server-rep

But I run into errors when I use my own data such as:

A .NET Framework error occurred during execution of user-defined routine or aggregate "geography":

Microsoft.SqlServer.Types.GLArgumentException: 24206: The specified input cannot be accepted because it contains an edge with antipodal points. For information about using spatial methods with FullGlobe objects, see Types of Spatial Data in SQL Server Books Online.

Microsoft.SqlServer.Types.GLArgumentException:

at Microsoft.SqlServer.Types.GLNativeMethods.ThrowExceptionForHr(GL_HResult errorCode)

at Microsoft.SqlServer.Types.GLNativeMethods.GeodeticIsValid(GeoData& g, Double eccentricity, Boolean forceKatmai)

at Microsoft.SqlServer.Types.SqlGeography.IsValidExpensive(Boolean forceKatmai)

at Microsoft.SqlServer.Types.SqlGeography..ctor(GeoData g, Int32 srid)

at Microsoft.SqlServer.Types.SqlGeography.GeographyFromText(OpenGisType type, SqlChars taggedText, Int32 srid)

at Microsoft.SqlServer.Types.SqlGeography.Parse(SqlString s)

.