Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 33.8Mb
PDF (A4) - 33.8Mb
PDF (RPM) - 31.8Mb
HTML Download (TGZ) - 8.1Mb
HTML Download (Zip) - 8.2Mb
HTML Download (RPM) - 7.0Mb
Man Pages (TGZ) - 146.0Kb
Man Pages (Zip) - 206.9Kb
Info (Gzip) - 3.1Mb
Info (Zip) - 3.1Mb


MySQL 8.0 Reference Manual  /  INFORMATION_SCHEMA Tables  /  The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table

Pre-General Availability Draft: 2017-11-19

25.24 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table

The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems for spatial data. This table is based on the SQL/MM (ISO/IEC 13249-3) standard. MySQL implements ST_SPATIAL_REFERENCE_SYSTEMS as a view on the st_spatial_reference_systems data dictionary table.

ST_SPATIAL_REFERENCE_SYSTEMS has these columns:

  • SRS_NAME

    The spatial reference system name. This value is unique.

  • SRS_ID

    The spatial reference system numeric ID. This value is unique.

    SRS_ID values represent the same kind of values passed as the SRID argument to spatial functions.

  • ORGANIZATION

    The name of the organization that defined the coordinate system on which the spatial reference system is based.

  • ORGANIZATION_COORDSYS_ID

    The numeric ID given to the spatial reference system by the organization that defined it.

  • DEFINITION

    The spatial reference system definition, as a WKT value.

  • DESCRIPTION

    The spatial reference system description.

Notes:

  • The SRS_NAME, ORGANIZATION, ORGANIZATION_COORDSYS_ID, and DESCRIPTION columns contain information that may be of interest to users, but they are not used by MySQL.

Example:

mysql> SELECT * FROM ST_SPATIAL_REFERENCE_SYSTEMS
       WHERE SRS_ID = 4326\G
*************************** 1. row ***************************
                SRS_NAME: WGS 84
                  SRS_ID: 4326
            ORGANIZATION: EPSG
ORGANIZATION_COORDSYS_ID: 4326
              DEFINITION: GEOGCS["WGS 84",DATUM["World Geodetic System 1984",
                          SPHEROID["WGS 84",6378137,298.257223563,
                          AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],
                          PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],
                          UNIT["degree",0.017453292519943278,
                          AUTHORITY["EPSG","9122"]],
                          AXIS["Lat",NORTH],AXIS["Long",EAST],
                          AUTHORITY["EPSG","4326"]]
             DESCRIPTION:

User Comments
Sign Up Login You must be logged in to post a comment.