sys.spatial_reference_systems (Transact-SQL)sys.spatial_reference_systems (Transact-SQL)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database

列出 SQL ServerSQL Server 支持的空间引用系统 (SRID)。Lists the spatial reference systems (SRIDs) supported by SQL ServerSQL Server.

列名称Column name 数据类型Data type 说明Description
spatial_reference_idspatial_reference_id intint SQL ServerSQL Server 支持的 SRID。The SRID supported by SQL ServerSQL Server.
authority_nameauthority_name nvarchar(128)nvarchar(128) SRID 的授权。The authority of the SRID.
authorized_spatial_reference_idauthorized_spatial_reference_id intint Authority_name 中名为的机构提供的 SRID。The SRID given by the authority named in authority_name.
well_known_textwell_known_text nvarchar(4000)nvarchar(4000) SRID 的 WKT 表示形式。The WKT representation of the SRID.
unit_of_measureunit_of_measure nvarchar(128)nvarchar(128) 度量单位的名称。The name of the unit of measure.
unit_conversion_factorunit_conversion_factor floatfloat 以米为度量单位的长度。The length of the unit of measure in meters.

权限Permissions

目录视图中仅显示用户拥有的安全对象的元数据,或用户对其拥有某些权限的安全对象的元数据。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.