This question already has an answer here:

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?

marked as duplicate by Evan Carroll, whyzar, aldo_tapia, HDunn, nmtoken Nov 29 '17 at 19:28

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


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.

Not the answer you're looking for? Browse other questions tagged or ask your own question.