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.

xThis feature is supported.
MBRThis feature is present, but operates on the Minimum Bounding Rectangle instead of the actual shape.
dThis 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.
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.