Geospatial data type

The geospatial data type can store various geometry objects. For more information, see Geospatial Data.

Data type Possible elements Note

GEOMETRY(srid)

POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION

srid (optional) defines the coordinate system used. Default = 0 (none)