MariaDB starting with 10.1.2

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:

SRIDsmallint(5)NOAn integer value that uniquely identifies each Spatial Reference System within a database.
AUTH_NAMEvarchar(512)NOThe name of the standard or standards body that is being cited for this reference system.
AUTH_SRIDsmallint(5)NOThe numeric ID of the coordinate system in the above authority's catalog.
SRTEXTvarchar(2048)NOThe Well-known Text Representation of the Spatial Reference System.

Note: See MDEV-7540.

See also


Comments loading...