5

In SQLServer geometry field, I want to change the coordinates of geometry from one spatial reference system to another spatial reference system (from SRID 4326 to SRID 3011) by using ST_Transform. But the destination SRID 3011 is not available in sys.spatial_reference_systems table.

How I do this conversion? Is there any other way?

nmtoken
  • 13,355
  • 5
  • 38
  • 87
user1899
  • 1,427
  • 7
  • 29
  • 36

1 Answers1

7

There is no native way to do this in SQL Server (isn't ST_Transform a PostGIS method?). Look into something like SQL Server Spatial Tools and this post from a few weeks back. Also, you won't find any projected coordinate systems in the sys.spatial_reference_systems table as that table is only GEOGCS and used for geography datatypes.

Community
  • 1
Chad Cooper
  • 12,714
  • 4
  • 46
  • 87