The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table 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: This entry describes the SRS used for GPS systems. It has a name ( SRS_NAME ) of WGS 84 and an ID ( SRS_ID ) of 4326, which is the ID used by the European Petroleum Survey Group (EPSG). The  DEFINITION  values for projected and geographic SRSs begin with  PROJCS  and  GEOGCS , respectively. The definition for SRID 0 is special and has an empty  DEFINITION  value. The following query determines how many entries in the  ST_SPATIAL_REFERENCE_SYSTEMS  table correspond to projected, geographic, and other SRSs, based on  DEFINITION  values: mysql>  SELECT COUNT(*), CASE LEFT(DEFINITION, 6) WHEN ’PROJCS’ THEN ’Projected’ WHEN ’GEOGCS’ THEN ’Geographic’ ELSE ’Other’ END AS SRS_TYPE FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS GROUP BY SRS_TYPE; +----------+------------+ | COUNT(*) | SRS_TYPE | +----------+------------+ | 1 | Other | | 4668 | Projected | | 483 | Geographic | +----------+------------+ To enable manipulation of SRS entries stored in the data dictionary, MySQL provides these SQL statements: The  ST_UNITS_OF_MEASURE  table (available as of MySQL 8.0.14) provides information about acceptable units for the  ST_Distance()  function. The  ST_UNITS_OF_MEASURE  table has these columns: • CREATE SPATIAL REFERENCE SYSTEM : See Section 13.1.19, “CREATE SPATIAL REFERENCE SYSTEM Statement” . The description for this statement includes additional information about SRS components. • DROP SPATIAL REFERENCE SYSTEM : See Section 13.1.31, “DROP SPATIAL REFERENCE SYSTEM Statement” . • UNIT_NAME 26.3.37 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table 4825