localhost:33060+ ssl SQL > SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS¥G ... 中略 ... *************************** 396. row *************************** SRS_NAME: JGD2000 / Japan Plane Rectangular CS VI SRS_ID: 2448 ORGANIZATION: EPSG ORGANIZATION_COORDSYS_ID: 2448 DEFINITION: PROJCS["JGD2000 / Japan Plane Rectangular CS VI",GEOGCS["JGD2000",DATUM["Japanese Geode tic Datum 2000",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHOR ITY["EPSG","6612"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY[" EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4612"]],PROJECTION["Transverse Mercator",AUTH ORITY["EPSG","9807"]],PARAMETER["Latitude of natural origin",36,AUTHORITY["EPSG","8801"]],PARAMETER["Longitude of natural origin",136,AUTHORITY["EPSG","8802"]],PARAMETER["Scale factor at natural origin",0.9999,AUTHORITY["EPSG", "8805"]],PARAMETER["False easting",0,AUTHORITY["EPSG","8806"]],PARAMETER["False northing",0,AUTHORITY["EPSG","880 7"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",NORTH],AXIS["Y",EAST],AUTHORITY["EPSG","2448"]] DESCRIPTION: NULL ... 中略 ... *************************** 2036. 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.257223 563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degr ee",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] DESCRIPTION: NULL ... 中略 ... 5238 row in set (0.0012 sec) MySQL localhost:33060+ ssl SQL > 対応座標系の格納VIEW 5238座標系が登録されている 座標系の名前 SRID 座標系定義、PROJCSで始まるのは投影座標系 座標系の名前 SRID 座標系定義、GEOGCSで始まるのは地理座標系 デフォルトの座標の並び順 (X,Y)の順番 デフォルトの座標の並び順 (緯度,経度)の順番 (内訳︓地理座標系545種+投影座標系4692種+SRID=0)