Get SRID from Geometry Field – SQL Server Guide

geometrysql serversrid

What is the function for getting SRID from Geometry field.

I have inserted a shapefile into SQL Server table with a Geometry field defined. I know the projection of shapefile is Swreff99_1800 (EPSG:3011).

Now my question is How I get this SRID:3011 by using some OGC method of the geometry field?

Best Answer

Is this what you are looking for?

select distinct SP_GEOMETRY.STSrid from dbo.MYTABLE

This will give you a table with the different SRID's used in the table dbo.MYTABLE

Related Solutions

[GIS] Storing SRID:4326 data as Geometry or Geography

If you do not need to measure distances over the spheroid then geometry suits well. The PostGIS manual contains understandable info about this http://postgis.net/docs/manual-2.0/using_postgis_dbmanagement.html#PostGIS_Geography and it is valid also for MSSQL.

[GIS] Ensuring SRID on geometry column in PostGIS

You don't need constraints for PostGIS 2.x, just us typmods. For 2D geometries with SRID=4326, the typmod is geometry(Geometry,4326). Or for M-dimension geometries, it would be geometry(GeometryM,4326) (you get the idea).

Example:

create temp table sometable(wkt geometry(Geometry,4326));

-- works
insert into sometable(wkt) values('SRID=4326;POINT(1 2)')
insert into sometable(wkt) values('SRID=4326;LINESTRING(1 2, 3 4)')

-- does not work
insert into sometable(wkt) values('POINT(1 2)')
-- ERROR:  Geometry SRID (0) does not match column SRID (4326)
insert into sometable(wkt) values('SRID=4326;POINT M(1 2 3)')
-- ERROR:  Geometry has M dimension but column does not

But as others have cautioned, make sure you can use the wkt data in the end-user applications. Also, it isn't technically stored as well-known text—it is stored as well-known binary or WKB.

Best Answer

Related Solutions

[GIS] Storing SRID:4326 data as Geometry or Geography

[GIS] Ensuring SRID on geometry column in PostGIS

Related Question