7-day MaxScale Trial: Explore the latest version of our advanced database proxy!
Start Trial Now
Download MariaDBContact Us

MySQL/MariaDB Spatial Support Matrix

This table shows when different spatial features were introduced into MySQL and MariaDB.

  • My = MySQL

  • MDB = MariaDB

  • x = This feature is supported

  • MBR = This feature is present, but operates on the Minimum Bounding Rectangle instead of the actual shape

  • d = This feature is present, but has been deprecated and will be removed in a future version

    • = This feature is present, but may not work the way you expect

    • = This feature is not supported

My 5.4.2
My 5.5
My 5.6.1
My 5.7.4
My 5.7.5
My 5.7.6
MDB 5.1
MDB 5.3.3
MDB 10.1.2
MDB 10.2

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

InnoDB Spatial Indexes

-

-

-

-

x

x

-

-

-

x

MyISAM Spatial Indexes

x

x

x

x

x

x

x

x

x

x

Aria Spatial Indexes

-

-

-

-

-

-

x

x

x

x

Area

x

x

x

x

x

d

x

x

x

x

AsBinary

x

x

x

x

x

d

x

x

x

x

AsText

x

x

x

x

x

d

x

x

x

x

AsWKB

x

x

x

x

x

d

x

x

x

x

AsWKT

x

x

x

x

x

d

x

x

x

x

Boundary

-

-

-

-

-

-

-

-

x

x

Buffer

-

-

x

x

x

d

x

x

x

x

Centroid

-

x

x

x

x

d

x

x

x

x

Contains

MBR

MBR

MBR

MBR

MBR

d

MBR

MBR

MBR

MBR

ConvexHull

-

-

-

-

x

d

-

-

x

x

Crosses

MBR

x

x

x

x

d

MBR

MBR

MBR

MBR

Dimension

x

x

x

x

x

d

x

x

x

x

Disjoint

MBR

MBR

MBR

MBR

MBR

d

MBR

MBR

MBR

MBR

Distance

MBR

-

-

x

x

d

-

-

-

-

EndPoint

x

x

x

x

x

d

x

x

x

x

Envelope

x

x

x

x

x

d

x

x

x

x

Equals

MBR

MBR

MBR

MBR

MBR

d

MBR

MBR

MBR

MBR

My 5.4.2
My 5.5
My 5.6.1
My 5.7.4
My 5.7.5
My 5.7.6
MDB 5.1
MDB 5.3.3
MDB 10.1.2
MDB 10.2

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

ExteriorRing

x

x

x

x

x

d

x

x

x

x

GeomCollFromText

x

x

x

x

x

d

x

x

x

x

GeomCollFromWKB

x

x

x

x

x

d

x

x

x

x

GeometryCollection

x

x

x

x

x

x

x

x

x

x

GeometryCollectionFromText

x

x

x

x

x

d

x

x

x

x

GeometryCollectionFromWKB

x

x

x

x

x

d

x

x

x

x

GeometryFromText

x

x

x

x

x

d

x

x

x

x

GeometryFromWKB

x

x

x

x

x

d

x

x

x

x

GeometryN

x

x

x

x

x

d

x

x

x

x

GeometryType

x

x

x

x

x

d

x

x

x

x

GeomFromText

x

x

x

x

x

d

x

x

x

x

GeomFromWKB

x

x

x

x

x

d

x

x

x

x

GLength

x

x

x

x

x

d

x

x

x

x

InteriorRingN

x

x

x

x

x

d

x

x

x

x

Intersects

MBR

MBR

MBR

MBR

MBR

d

MBR

MBR

MBR

MBR

IsClosed

x

x

x

x

x

d

x

x

x

x

IsEmpty

-

*

*

*

*

d

x

x

x

x

IsRing

-

-

-

-

-

-

-

-

x

x

IsSimple

-

*

*

x

x

d

-

x

x

x

LineFromText

x

x

x

x

x

d

x

x

x

x

My 5.4.2
My 5.5
My 5.6.1
My 5.7.4
My 5.7.5
My 5.7.6
MDB 5.1
MDB 5.3.3
MDB 10.1.2
MDB 10.2

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

LineFromWKB

x

x

x

x

x

d

x

x

x

x

LineString

x

x

x

x

x

x

x

x

x

x

LineStringFromText

x

x

x

x

x

d

x

x

x

x

LineStringFromWKB

x

x

x

x

x

d

x

x

x

x

MBRContains

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBRCoveredBy

-

-

-

MBR

MBR

MBR

-

-

-

-

MBRDisjoint

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBREqual

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBREquals

-

-

-

MBR

MBR

MBR

-

-

-

MBR

MBRIntersects

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBROverlaps

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBRTouches

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBRWithin

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MBR

MLineFromText

x

x

x

x

x

d

x

x

x

x

MLineFromWKB

x

x

x

x

x

d

x

x

x

x

MPointFromText

x

x

x

x

x

d

x

x

x

x

MPointFromWKB

x

x

x

x

x

d

x

x

x

x

MPolyFromText

x

x

x

x

x

d

x

x

x

x

MPolyFromWKB

x

x

x

x

x

d

x

x

x

x

MultiLineString

x

x

x

x

x

x

x

x

x

x

My 5.4.2
My 5.5
My 5.6.1
My 5.7.4
My 5.7.5
My 5.7.6
MDB 5.1
MDB 5.3.3
MDB 10.1.2
MDB 10.2

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

MultiLineStringFromText

x

x

x

x

x

d

x

x

x

x

MultiLineStringFromWKB

x

x

x

x

x

d

x

x

x

x

MultiPoint

x

x

x

x

x

x

x

x

x

x

MultiPointFromText

x

x

x

x

x

d

x

x

x

x

MultiPointFromWKB

x

x

x

x

x

d

x

x

x

x

MultiPolygon

x

x

x

x

x

x

x

x

x

x

MultiPolygonFromText

x

x

x

x

x

d

x

x

x

x

MultiPolygonFromWKB

x

x

x

x

x

d

x

x

x

x

NumGeometries

x

x

x

x

x

d

x

x

x

x

NumInteriorRings

x

x

x

x

x

d

x

x

x

x

NumPoints

x

x

x

x

x

d

x

x

x

x

Overlaps

MBR

MBR

MBR

MBR

MBR

d

MBR

MBR

MBR

MBR

Point

x

x

x

x

x

x

x

x

x

x

PointFromText

x

x

x

x

x

d

x

x

x

x

PointFromWKB

x

x

x

x

x

d

x

x

x

x

PointOnSurface

-

-

-

-

-

-

-

-

x

x

PointN

x

x

x

x

x

d

x

x

x

x

PolyFromText

x

x

x

x

x

d

x

x

x

x

PolyFromWKB

x

x

x

x

x

d

x

x

x

x

Polygon

x

x

x

x

x

x

x

x

x

x

My 5.4.2
My 5.5
My 5.6.1
My 5.7.4
My 5.7.5
My 5.7.6
MDB 5.1
MDB 5.3.3
MDB 10.1.2
MDB 10.2

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

PolygonFromText

x

x

x

x

x

d

x

x

x

x

PolygonFromWKB

x

x

x

x

x

d

x

x

x

x

SRID

x

x

x

x

x

d

x

x

x

x

ST_Area

-

-

x

x

x

x

-

x

x

x

ST_AsBinary

-

-

x

x

x

x

-

x

x

x

ST_AsGeoJSON

-

-

-

x

x

x

-

-

-

x

ST_AsText

-

-

x

x

x

x

-

x

x

x

ST_AsWKB

-

-

x

x

x

x

-

x

x

x

ST_AsWKT

-

-

x

x

x

x

-

x

x

x

ST_Boundary

-

-

-

-

-

-

-

-

x

x

ST_Buffer

-

-

x

x

x

x

-

x

x

x

ST_Buffer_Strategy

-

-

-

x

x

x

-

-

-

-

ST_Centroid

-

-

x

x

x

x

-

x

x

x

ST_Contains

-

-

x

x

x

x

-

x

x

x

ST_ConvexHull

-

-

-

-

x

x

-

-

x

x

ST_Crosses

-

-

x

x

x

x

-

x

x

x

ST_Difference

-

-

x

x

x

x

-

x

x

x

ST_Dimension

-

-

x

x

x

x

-

x

x

x

ST_Disjoint

-

-

x

x

x

x

-

x

x

x

ST_Distance

-

-

x

x

x

x

-

x

x

x

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

ST_Envelope

ST_Equals

ST_ExteriorRing

ST_GeoHash

ST_GeomCollFromText

ST_GeomCollFromWKB

ST_GeometryCollectionFromText

ST_GeometryCollectionFromWKB

ST_GeometryFromText

ST_GeometryFromWKB

ST_GeometryN

ST_GeometryType

ST_GeomFromGeoJSON

ST_GeomFromText

ST_GeomFromWKB

ST_InteriorRingN

ST_Intersection

ST_Intersects

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

ST_Distance_Sphere

-

-

-

-

-

x

-

-

-

-

ST_EndPoint

-

-

x

x

x

x

-

x

x

x

ST_Envelope

-

-

x

x

x

x

-

x

x

x

ST_Equals

-

-

x

x

x

x

-

x

x

x

ST_ExteriorRing

-

-

x

x

x

x

-

x

x

x

ST_GeoHash

-

-

-

-

x

x

-

-

-

-

ST_GeomCollFromText

-

-

x

x

x

x

-

x

x

x

ST_GeomCollFromWKB

-

-

x

x

x

x

-

x

x

x

ST_GeometryCollectionFromText

-

-

x

x

x

x

-

x

x

x

ST_GeometryCollectionFromWKB

-

-

x

x

x

x

-

x

x

x

ST_GeometryFromText

-

-

x

x

x

x

-

x

x

x

ST_GeometryFromWKB

-

-

x

x

x

x

-

x

x

x

ST_GeometryN

-

-

x

x

x

x

-

x

x

x

ST_GeometryType

-

-

x

x

x

x

-

x

x

x

ST_GeomFromGeoJSON

-

-

-

-

x

x

-

-

-

x

ST_GeomFromText

-

-

x

x

x

x

-

x

x

x

ST_GeomFromWKB

-

-

x

x

x

x

-

x

x

x

ST_InteriorRingN

-

-

x

x

x

x

-

x

x

x

ST_Intersection

-

-

x

x

x

x

-

x

x

x

ST_Intersects

-

-

x

x

x

x

-

x

x

x

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

ST_IsClosed

ST_IsEmpty

ST_IsRing

ST_IsSimple

ST_IsValid

ST_LatFromGeoHash

ST_Length

ST_LineFromText

ST_LineFromWKB

ST_LineStringFromText

ST_LineStringFromWKB

ST_LongFromGeoHash

ST_NumGeometries

ST_NumInteriorRings

ST_NumPoints

ST_Overlaps

ST_PointFromGeoHash

ST_PointFromText

ST_PointFromWKB

ST_PointOnSurface

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

ST_IsClosed

-

-

x

x

x

x

-

x

x

x

ST_IsEmpty

-

-

x

x

x

x

-

x

x

x

ST_IsRing

-

-

-

-

-

-

-

-

x

x

ST_IsSimple

-

-

x

x

x

x

-

x

x

x

ST_IsValid

-

-

-

-

-

x

-

-

-

-

ST_LatFromGeoHash

-

-

-

-

x

x

-

-

-

-

ST_Length

-

-

-

-

-

x

-

x

x

x

ST_LineFromText

-

-

x

x

x

x

-

x

x

x

ST_LineFromWKB

-

-

x

x

x

x

-

x

x

x

ST_LineStringFromText

-

-

x

x

x

x

-

x

x

x

ST_LineStringFromWKB

-

-

x

x

x

x

-

x

x

x

ST_LongFromGeoHash

-

-

-

-

x

x

-

-

-

-

ST_NumGeometries

-

-

x

x

x

x

-

x

x

x

ST_NumInteriorRings

-

-

x

x

x

x

-

x

x

x

ST_NumPoints

-

-

x

x

x

x

-

x

x

x

ST_Overlaps

-

-

x

x

x

x

-

x

x

x

ST_PointFromGeoHash

-

-

-

-

x

x

-

-

-

-

ST_PointFromText

-

-

x

x

x

x

-

x

x

x

ST_PointFromWKB

-

-

x

x

x

x

-

x

x

x

ST_PointOnSurface

-

-

-

-

-

-

-

-

x

x

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

ST_PointN

ST_PolyFromText

ST_PolyFromWKB

ST_PolygonFromText

ST_PolygonFromWKB

ST_Relate

ST_Simplify

ST_SRID

ST_StartPoint

ST_SymDifference

ST_Touches

ST_Union

ST_Validate

ST_Within

ST_X

ST_Y

StartPoint

Touches

Within

X

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

ST_PointN

-

-

x

x

x

x

-

x

x

x

ST_PolyFromText

-

-

x

x

x

x

-

x

x

x

ST_PolyFromWKB

-

-

x

x

x

x

-

x

x

x

ST_PolygonFromText

-

-

x

x

x

x

-

x

x

x

ST_PolygonFromWKB

-

-

x

x

x

x

-

x

x

x

ST_Relate

-

-

-

-

-

-

-

-

x

x

ST_Simplify

-

-

-

-

-

x

-

-

-

-

ST_SRID

-

-

x

x

x

x

-

x

x

x

ST_StartPoint

-

-

x

x

x

x

-

x

x

x

ST_SymDifference

-

-

x

x

x

x

-

x

x

x

ST_Touches

-

-

x

x

x

x

-

x

x

x

ST_Union

-

-

x

x

x

x

-

x

x

x

ST_Validate

-

-

-

-

-

x

-

-

-

-

ST_Within

-

-

x

x

x

x

-

x

x

x

ST_X

-

-

x

x

x

x

-

x

x

x

ST_Y

-

-

x

x

x

x

-

x

x

x

StartPoint

x

x

x

x

x

d

x

x

x

x

Touches

MBR

x

x

x

x

d

MBR

MBR

MBR

MBR

Within

MBR

MBR

MBR

MBR

MBR

d

MBR

MBR

MBR

MBR

X

x

x

x

x

x

d

x

x

x

x

Y

x

x

x

x

x

d

x

x

x

x

My 5.4.2
My 5.5
My 5.6.1
My 5.7.4
My 5.7.5
My 5.7.6
MDB 5.1
MDB 5.3.3
MDB 10.1.2
MDB 10.2

My 5.4.2

My 5.5

My 5.6.1

My 5.7.4

My 5.7.5

My 5.7.6

MDB 5.1

MDB 5.3.3

MDB 10.1.2

MDB 10.2

This page is licensed: CC BY-SA / Gnu FDL

PreviousGIS ResourcesNextSPATIAL INDEX

Last updated

Was this helpful?