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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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_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 | - | - | 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 | - | - | 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 |
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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mysqlmariadb-spatial-support-matrix/