The SE_SRID_Authority() function

The SE_SRID_Authority() function takes a spatial reference ID and returns the Authority Name and Authority SRID as an LVARCHAR string in the form AuthName:SRID. If the AuthName is null in the sde.spatial_references table for a given spatial reference ID, the srtext is returned.

Syntax

SE_SRID_Authority(SRID integer)

Return type

LVARCHAR

Example

select SE_SRID_Authority(srid) from sde.spatial_references;

(expression)  UNKNOWN:0
(expression)  EPSG:4135
(expression)  EPSG:4267
(expression)  EPSG:4269
(expression)  EPSG:4326
(expression)  UNKNOWN:0
(expression)  UNKNOWN:0
(expression)  UNKNOWN:0
(expression)  AUTH_NAME:1234
(expression)  GEOGCS["GCS_Old_Hawaiian",
              DATUM["D_OldHawaiian",
              SPHEROID["Clarke_1866",6378206.4,294.9786982]],
              PRIMEM["Greenwich",0],UNIT["Degree",0.01745329 25199433]]

10 row(s) retrieved.