locked
Polar Steregraphic Projections RRS feed

  • Question

  • I have a large amount of data in SQL server using ESRI SDE. The data is stored in Polar Stereographic Coordinate systems (EPSG:3031 and EPSG:3995). I would like to shift from using SDE's data storage model which has the spatial storage in a binary format in a different table from the attribute data to using the SQL Server geography type.

    But, it appears that SQL server does not support these SRIDs. I could not find anything close even in the 390 SRIDs available.

    What are my options?

    Thursday, November 19, 2009 5:39 PM

Answers

  • Since your data is already projected, you can use the geometry datatype with these spatial reference systems.

    The list of spatial reference systems given in the sys.spatial_reference_systems table is only in cases where you want to store and work with (unprojected) geographic data using the geography datatype - for geometry you can use any spatial reference system you want.
    Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290
    Thursday, November 19, 2009 7:04 PM
    Answerer