Skip to content

sys-spatial-reference-systems-transact-sql.md

Latest commit

 

History

History
48 lines (42 loc) · 1.83 KB

sys-spatial-reference-systems-transact-sql.md

File metadata and controls

48 lines (42 loc) · 1.83 KB

title: "sys.spatial_reference_systems (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "06/10/2016" ms.prod: sql ms.prod_service: "database-engine, sql-database" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:

  • "spatial_reference_systems_TSQL"
  • "sys.spatial_reference_systems_TSQL"
  • "sys.spatial_reference_systems"
  • "spatial_reference_systems" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "sys.spatial_reference_systems catalog view"
  • "spatial_reference_systems" ms.assetid: 3c9bc120-67c3-463f-9e24-29fd623f25a0 caps.latest.revision: 11 author: stevestein ms.author: sstein manager: craigg monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"

sys.spatial_reference_systems (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Lists the spatial reference systems (SRIDs) supported by [!INCLUDEssNoVersion].

Column name Data type Description
spatial_reference_id int The SRID supported by [!INCLUDEssNoVersion].
authority_name nvarchar(128) The authority of the SRID.
authorized_spatial_reference_id int The SRID given by the authority named in authority_name.
well_known_text nvarchar(4000) The WKT representation of the SRID.
unit_of_measure nvarchar(128) The name of the unit of measure.
unit_conversion_factor float The length of the unit of measure in meters.

Permissions

[!INCLUDEssCatViewPerm]