Information Schema SPATIAL_REF_SYS Table

The Information Schema SPATIAL_REF_SYS table stores information about available Spatial Reference Systems (SRS) for geometry data.

Description

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.

See Aso

• information_schema.GEOMETRY_COLUMNS table.

_{This page is licensed: CC BY-SA / Gnu FDL}