The Ultimate Guide to High Availability with MariaDB

MySQL/MariaDB Spatial Support Matrix

You are viewing an old version of this article. View the current version here.

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

xHas Support
*Has Support with caveat
MBROperates on MBR instead of geometry
dPresent, but deprecated
MySQL 5.4.2MySQL 5.5MySQL 5.6.1MySQL 5.7.4MySQL 5.7.5MySQL 5.7.6MariaDB 5.1MariaDB 5.3.3MariaDB 10.1.2
InnoDB Spatial Indexes----xx---
MyISAM Spatial Indexesxxxxxxxxx
Aria Spatial Indexes------xxx
Areaxxxxxdxxx
AsBinaryxxxxxdxxx
AsTextxxxxxdxxx
AsWKBxxxxxdxxx
AsWKTxxxxxdxxx
Boundary--------x
Buffer--xxxdxxx
Centroid-xxxxdxxx
ContainsMBRMBRMBRMBRMBRdMBRMBRMBR
ConvexHull----xd---
CrossesMBRxxxxdMBRMBRMBR
Dimensionxxxxxdxxx
DisjointMBRMBRMBRMBRMBRdMBRMBRMBR
DistanceMBR--xxd---
EndPointxxxxxdxxx
Envelopexxxxxdxxx
EqualsMBRMBRMBRMBRMBRdMBRMBRMBR
ExteriorRingxxxxxdxxx
GeomCollFromTextxxxxxdxxx
GeomCollFromWKBxxxxxdxxx
GeometryCollectionxxxxxxxxx
GeometryCollectionFromTextxxxxxdxxx
GeometryCollectionFromWKBxxxxxdxxx
GeometryFromTextxxxxxdxxx
GeometryFromWKBxxxxxdxxx
GeometryNxxxxxdxxx
GeometryTypexxxxxdxxx
GeomFromTextxxxxxdxxx
GeomFromWKBxxxxxdxxx
GLengthxxxxxdxxx
InteriorRingNxxxxxdxxx
IntersectsMBRMBRMBRMBRMBRdMBRMBRMBR
IsClosedxxxxxdxxx
IsEmpty-****dxxx
IsRing--------x
IsSimple-**xxd-xx
LineFromTextxxxxxd---
LineFromWKBxxxxxdxxx
LineStringxxxxxxxxx
LineStringFromTextxxxxxd---
LineStringFromWKBxxxxxdxxx
MBRContainsMBRMBRMBRMBRMBRMBRMBRMBRMBR
MBRCoveredBy---MBRMBRMBR---
MBRDisjointMBRMBRMBRMBRMBRMBRMBRMBRMBR
MBREqualMBRMBRMBRMBRMBRMBRMBRMBRMBR
MBREquals---MBRMBRMBR---
MBRIntersectsMBRMBRMBRMBRMBRMBRMBRMBRMBR
MBROverlapsMBRMBRMBRMBRMBRMBRMBRMBRMBR
MBRTouchesMBRMBRMBRMBRMBRMBRMBRMBRMBR
MBRWithinMBRMBRMBRMBRMBRMBRMBRMBRMBR
MLineFromTextxxxxxdxxx
MLineFromWKBxxxxxdxxx
MPointFromTextxxxxxdxxx
MPointFromWKBxxxxxdxxx
MPolyFromTextxxxxxdxxx
MPolyFromWKBxxxxxdxxx
MultiLineStringxxxxxxxxx
MultiLineStringFromTextxxxxxdxxx
MultiLineStringFromWKBxxxxxdxxx
MultiPointxxxxxxxxx
MultiPointFromTextxxxxxdxxx
MultiPointFromWKBxxxxxdxxx
MultiPolygonxxxxxxxxx
MultiPolygonFromTextxxxxxdxxx
MultiPolygonFromWKBxxxxxdxxx
NumGeometriesxxxxxdxxx
NumInteriorRingsxxxxxdxxx
NumPointsxxxxxdxxx
OverlapsMBRMBRMBRMBRMBRdMBRMBRMBR
Pointxxxxxxxxx
PointFromTextxxxxxdxxx
PointFromWKBxxxxxdxxx
PointOnSurface--------x
PointNxxxxxdxxx
PolyFromTextxxxxxdxxx
PolyFromWKBxxxxxdxxx
Polygonxxxxxxxxx
PolygonFromTextxxxxxdxxx
PolygonFromWKBxxxxxdxxx
SRIDxxxxxdxxx
ST_Area--xxxx-xx
ST_AsBinary--xxxx-xx
ST_AsGeoJSON---xxx---
ST_AsText--xxxx-xx
ST_AsWKB--xxxx-xx
ST_AsWKT--xxxx-xx
ST_Boundary--------x
ST_Buffer--xxxx-xx
ST_Buffer_Strategy---xxx---
ST_Centroid--xxxx-xx
ST_Contains--xxxx-xx
ST_ConvexHull----xx--x
ST_Crosses--xxxx-xx
ST_Difference--xxxx---
ST_Dimension--xxxx-xx
ST_Disjoint--xxxx-xx
ST_Distance--xxxx---
ST_Distance_Sphere-----x---
ST_EndPoint--xxxx-xx
ST_Envelope--xxxx-xx
ST_Equals--xxxx-xx
ST_ExteriorRing--xxxx-xx
ST_GeoHash----xx---
ST_GeomCollFromText--xxxx-xx
ST_GeomCollFromWKB--xxxx-xx
ST_GeometryCollectionFromText--xxxx-xx
ST_GeometryCollectionFromWKB--xxxx-xx
ST_GeometryFromText--xxxx-xx
ST_GeometryFromWKB--xxxx-xx
ST_GeometryN--xxxx-xx
ST_GeometryType--xxxx-xx
ST_GeomFromGeoJSON----xx---
ST_GeomFromText--xxxx-xx
ST_GeomFromWKB--xxxx-xx
ST_InteriorRingN--xxxx-xx
ST_Intersection--xxxx-xx
ST_Intersects--xxxx-xx
ST_IsClosed--xxxx-xx
ST_IsEmpty--xxxx-xx
ST_IsRing--------x
ST_IsSimple--xxxx-xx
ST_IsValid-----x---
ST_LatFromGeoHash----xx---
ST_Length-----x---
ST_LineFromText--xxxx-xx
ST_LineFromWKB--xxxx-xx
ST_LineStringFromText--xxxx-xx
ST_LineStringFromWKB--xxxx-xx
ST_LongFromGeoHash----xx---
ST_NumGeometries--xxxx-xx
ST_NumInteriorRings--xxxx-xx
ST_NumPoints--xxxx-xx
ST_Overlaps--xxxx-xx
ST_PointFromGeoHash----xx---
ST_PointFromText--xxxx-xx
ST_PointFromWKB--xxxx-xx
ST_PointOnSurface--------x
ST_PointN--xxxx-xx
ST_PolyFromText--xxxx-xx
ST_PolyFromWKB--xxxx-xx
ST_PolygonFromText--xxxx-xx
ST_PolygonFromWKB--xxxx-xx
ST_Relate--------x
ST_Simplify-----x---
ST_SRID--xxxx-xx
ST_StartPoint--xxxx-xx
ST_SymDifference--xxxx-xx
ST_Touches--xxxx-xx
ST_Union--xxxx-xx
ST_Validate-----x---
ST_Within--xxxx-xx
ST_X--xxxx-xx
ST_Y--xxxx-xx
StartPointxxxxxdxxx
TouchesMBRxxxxdMBRMBRMBR
WithinMBRMBRMBRMBRMBRdMBRMBRMBR
Xxxxxxdxxx
Yxxxxxdxxx

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.