SQL – Identify SRID

By David Crowther

Question:

How can I identify the projection (SRID) of the data in my SQL Table?

Answer:

If you store your spatial data in a SQL database, it will be good to learn several common SQL queries to manage that data correctly.

Firstly, choose to Select the top 1000 records from your SQL table.

Choosing the Spatial Results tab will then show you the geometry for your SQL data.

Back in the Results panel, we can now use this SQL query to identify the projection (SRID) for the data –

select geometryfield.STSrid from dbo.tablename

….for our data table this will be –

select ogr_geometry.STSrid from dbo.conservation_areas

As above, the query will run and identify the projection (SRID) for each record, and in this case each record is returning the value 27700 – which is British National Grid.