Using Geography Maps

• Nusc

  SSCommitted

  Points: 1678

  More actions

  August 1, 2016 at 11:45 am

  #309869

  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)

  .

• J Livingston SQL

  SSC Guru

  Points: 51550

  More actions

  August 1, 2016 at 12:26 pm

  #1893029

  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)

  .

  please post answers here http://www.sqlservercentral.com/Forums/FindPost1805751.aspx

  where this has already been asked and further relevant information

  ________________________________________________________________
  you can lead a user to data....but you cannot make them think
  and remember....every day is a school day