sys.spatial_reference_systems (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Lists the spatial reference systems (SRIDs) supported by SQL Server.

Column nameData typeDescription
spatial_reference_idintThe SRID supported by SQL Server.
authority_namenvarchar(128)The authority of the SRID.
authorized_spatial_reference_idintThe SRID given by the authority named in authority_name.
well_known_textnvarchar(4000)The WKT representation of the SRID.
unit_of_measurenvarchar(128)The name of the unit of measure.
unit_conversion_factorfloatThe length of the unit of measure in meters.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.

Community Additions