Convert coordinate systems using SQLGeometery

One of my shape files looks like this:

  -91.513078999999991 36.970298, 
  -87.01993499999999 36.970298, 
  -87.01993499999999 42.508337999999995, 
  -91.513078999999991 42.508337999999995, 
  -91.513078999999991 36.970298)

Another file is using SRID 3857:

  • How to trace steps in SQL profiler for only particular application
  • Is it possible to use relative paths for SSIS packages dtsConfig files?
  • can we make multiple rows as comma seperated in SQL Query?
  • Warning! The maximum key length is 900 bytes. The index has maximum length of 8009 bytes
  • Processing multiple results from CLR stored procedure in T-SQL
      -10033572.109485552 4727287.954831399, 
      -10033571.708142675 4727287.954831399, 
      -10033571.708142675 4727288.1439229213, 
      -10033572.109485552 4727288.1439229213, 
      -10033572.109485552 4727287.954831399)

    Assuming I can figure out which coordinate systems are being used, how do I convert from one format to the other?

    One Solution collect form web for “Convert coordinate systems using SQLGeometery”

    Use the GeometryToGeometry function from Pro Spatial, chapter 8.

    Source code and data tables:

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.