CREATE SPATIAL REFERENCE SYSTEM Statement The following table shows the projection parameters that MySQL recognizes. Recognition occurs primarily by authority code. If there is no authority code, MySQL falls back to case-insensitive string matching on the parameter name. For details about each parameter, look it up by code in the EPSG Online Registry. Table 13.8 Spatial Reference System Projection Parameters 2540 EPSG Code Projection Name Mandatory Parameters (EPSG Codes) 9816 Tunisia Mining Grid 8821, 8822, 8826, 8827 9817 Lambert Conic Near-Conformal 8801, 8802, 8805, 8806, 8807 9818 American Polyconic 8801, 8802, 8806, 8807 9819 Krovak 8811, 8833, 1036, 8818, 8819, 8806, 8807 9820 Lambert Azimuthal Equal Area 8801, 8802, 8806, 8807 9822 Albers Equal Area 8821, 8822, 8823, 8824, 8826, 8827 9824 Transverse Mercator Zoned Grid System 8801, 8830, 8831, 8805, 8806, 8807 9826 Lambert Conic Conformal (West Orientated) 8801, 8802, 8805, 8806, 8807 9828 Bonne (South Orientated) 8801, 8802, 8806, 8807 9829 Polar Stereographic (variant B) 8832, 8833, 8806, 8807 9830 Polar Stereographic (variant C) 8832, 8833, 8826, 8827 9831 Guam Projection 8801, 8802, 8806, 8807 9832 Modified Azimuthal Equidistant 8801, 8802, 8806, 8807 9833 Hyperbolic Cassini-Soldner 8801, 8802, 8806, 8807 9834 Lambert Cylindrical Equal Area (Spherical) 8823, 8802, 8806, 8807 9835 Lambert Cylindrical Equal Area 8823, 8802, 8806, 8807 EPSG Code Fallback Name (Recognized by MySQL) EPSG Name 1026 c1 C1 1027 c2 C2 1028 c3 C3 1029 c4 C4 1030 c5 C5 1031 c6 C6 1032 c7 C7 1033 c8 C8 1034 c9 C9 1035 c10 C10 1036 azimuth Co-latitude of cone axis 1038 ellipsoid_scale_factor Ellipsoid scaling factor