Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 32.9Mb
PDF (A4) - 32.9Mb
PDF (RPM) - 30.9Mb
HTML Download (TGZ) - 7.8Mb
HTML Download (Zip) - 7.9Mb
HTML Download (RPM) - 6.7Mb
Man Pages (TGZ) - 143.5Kb
Man Pages (Zip) - 203.6Kb
Info (Gzip) - 3.0Mb
Info (Zip) - 3.0Mb


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

Pre-General Availability Draft: 2017-07-22

24.23 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.

    SRID 0 is special. It is always a legal spatial reference system ID and can be used in any computations on spatial data that depend on SRID values. However, SRID 0 has no entry in ST_SPATIAL_REFERENCE_SYSTEMS because it cannot be described by the SRS definition format. It represents an infinite flat Cartesian plane with no units assigned to its axes. Unlike projected SRSs, it is not georeferenced and it does not necessarily represent Earth. It is an abstract plane that can be used for anything.

  • 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.