The Information Schema SPATIAL_REF_SYS table stores information about available Spatial Reference Systems (SRS) for geometry data.
The Information Schema SPATIAL_REF_SYS table stores information on each spatial reference system used in the database.
It contains the following columns:
Note: See .
table.
This page is licensed: CC BY-SA / Gnu FDL
SRID
smallint(5)
NO
An integer value that uniquely identifies each Spatial Reference System within a database.
AUTH_NAME
varchar(512)
NO
The name of the standard or standards body that is being cited for this reference system.
AUTH_SRID
smallint(5)
NO
The numeric ID of the coordinate system in the above authority's catalog.
SRTEXT
varchar(2048)
NO
The Well-known Text Representation of the Spatial Reference System.