The SPATIAL_REF_SYS table was introduced in MariaDB 10.1.2
The Information Schema SPATIAL_REF_SYS table stores information on each spatial reference system used in the database.
It contains the following columns:
| Column | Type | Null | Description |
|---|---|---|---|
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. |
Note: See MDEV-7540.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-spatial_ref_sys-table/