MySQL 5.7 Reference Manual Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6
The following table lists each spatial function and provides a short description of each one.
Table 12.21 Spatial Functions
Name | Description |
---|---|
Area() (deprecated) |
Return Polygon or MultiPolygon area |
AsBinary() , AsWKB() (deprecated) |
Convert from internal geometry format to WKB |
AsText() , AsWKT() (deprecated) |
Convert from internal geometry format to WKT |
Buffer() (deprecated) |
Return geometry of points within given distance from geometry |
Centroid() (deprecated) |
Return centroid as a point |
Contains() (deprecated) |
Whether MBR of one geometry contains MBR of another |
ConvexHull() (deprecated) |
Return convex hull of geometry |
Crosses() (deprecated) |
Whether one geometry crosses another |
Dimension() (deprecated) |
Dimension of geometry |
Disjoint() (deprecated) |
Whether MBRs of two geometries are disjoint |
Distance() (deprecated) |
The distance of one geometry from another |
EndPoint() (deprecated) |
End Point of LineString |
Envelope() (deprecated) |
Return MBR of geometry |
Equals() (deprecated) |
Whether MBRs of two geometries are equal |
ExteriorRing() (deprecated) |
Return exterior ring of Polygon |
GeomCollFromText() , GeometryCollectionFromText() (deprecated) |
Return geometry collection from WKT |
GeomCollFromWKB() , GeometryCollectionFromWKB() (deprecated) |
Return geometry collection from WKB |
GeometryCollection() |
Construct geometry collection from geometries |
GeometryN() (deprecated) |
Return N-th geometry from geometry collection |
GeometryType() (deprecated) |
Return name of geometry type |
GeomFromText() , GeometryFromText() (deprecated) |
Return geometry from WKT |
GeomFromWKB() , GeometryFromWKB() (deprecated) |
Return geometry from WKB |
GLength() (deprecated) |
Return length of LineString |
InteriorRingN() (deprecated) |
Return N-th interior ring of Polygon |
Intersects() (deprecated) |
Whether MBRs of two geometries intersect |
IsClosed() (deprecated) |
Whether a geometry is closed and simple |
IsEmpty() (deprecated) |
Whether a geometry is empty |
IsSimple() (deprecated) |
Whether a geometry is simple |
LineFromText() , LineStringFromText() (deprecated) |
Construct LineString from WKT |
LineFromWKB() , LineStringFromWKB() (deprecated) |
Construct LineString from WKB |
LineString() |
Construct LineString from Point values |
MBRContains() |
Whether MBR of one geometry contains MBR of another |
MBRCoveredBy() |
Whether one MBR is covered by another |
MBRCovers() |
Whether one MBR covers another |
MBRDisjoint() |
Whether MBRs of two geometries are disjoint |
MBREqual() (deprecated) |
Whether MBRs of two geometries are equal |
MBREquals() |
Whether MBRs of two geometries are equal |
MBRIntersects() |
Whether MBRs of two geometries intersect |
MBROverlaps() |
Whether MBRs of two geometries overlap |
MBRTouches() |
Whether MBRs of two geometries touch |
MBRWithin() |
Whether MBR of one geometry is within MBR of another |
MLineFromText() , MultiLineStringFromText() (deprecated) |
Construct MultiLineString from WKT |
MLineFromWKB() , MultiLineStringFromWKB() (deprecated) |
Construct MultiLineString from WKB |
MPointFromText() , MultiPointFromText() (deprecated) |
Construct MultiPoint from WKT |
MPointFromWKB() , MultiPointFromWKB() (deprecated) |
Construct MultiPoint from WKB |
MPolyFromText() , MultiPolygonFromText() (deprecated) |
Construct MultiPolygon from WKT |
MPolyFromWKB() , MultiPolygonFromWKB() (deprecated) |
Construct MultiPolygon from WKB |
MultiLineString() |
Contruct MultiLineString from LineString values |
MultiPoint() |
Construct MultiPoint from Point values |
MultiPolygon() |
Construct MultiPolygon from Polygon values |
NumGeometries() (deprecated) |
Return number of geometries in geometry collection |
NumInteriorRings() (deprecated) |
Return number of interior rings in Polygon |
NumPoints() (deprecated) |
Return number of points in LineString |
Overlaps() (deprecated) |
Whether MBRs of two geometries overlap |
Point() |
Construct Point from coordinates |
PointFromText() (deprecated) |
Construct Point from WKT |
PointFromWKB() (deprecated) |
Construct Point from WKB |
PointN() (deprecated) |
Return N-th point from LineString |
PolyFromText() , PolygonFromText() (deprecated) |
Construct Polygon from WKT |
PolyFromWKB() , PolygonFromWKB() (deprecated) |
Construct Polygon from WKB |
Polygon() |
Construct Polygon from LineString arguments |
SRID() (deprecated) |
Return spatial reference system ID for geometry |
ST_Area() |
Return Polygon or MultiPolygon area |
ST_AsBinary() , ST_AsWKB() |
Convert from internal geometry format to WKB |
ST_AsGeoJSON() |
Generate GeoJSON object from geometry |
ST_AsText() , ST_AsWKT() |
Convert from internal geometry format to WKT |
ST_Buffer() |
Return geometry of points within given distance from geometry |
ST_Buffer_Strategy() |
Produce strategy option for ST_Buffer() |
ST_Centroid() |
Return centroid as a point |
ST_Contains() |
Whether one geometry contains another |
ST_ConvexHull() |
Return convex hull of geometry |
ST_Crosses() |
Whether one geometry crosses another |
ST_Difference() |
Return point set difference of two geometries |
ST_Dimension() |
Dimension of geometry |
ST_Disjoint() |
Whether one geometry is disjoint from another |
ST_Distance() |
The distance of one geometry from another |
ST_Distance_Sphere() |
Minimum distance on earth between two geometries |
ST_EndPoint() |
End Point of LineString |
ST_Envelope() |
Return MBR of geometry |
ST_Equals() |
Whether one geometry is equal to another |
ST_ExteriorRing() |
Return exterior ring of Polygon |
ST_GeoHash() |
Produce a geohash value |
ST_GeomCollFromText() , ST_GeometryCollectionFromText() , ST_GeomCollFromTxt() |
Return geometry collection from WKT |
ST_GeomCollFromWKB() , ST_GeometryCollectionFromWKB() |
Return geometry collection from WKB |
ST_GeometryN() |
Return N-th geometry from geometry collection |
ST_GeometryType() |
Return name of geometry type |
ST_GeomFromGeoJSON() |
Generate geometry from GeoJSON object |
ST_GeomFromText() , ST_GeometryFromText() |
Return geometry from WKT |
ST_GeomFromWKB() , ST_GeometryFromWKB() |
Return geometry from WKB |
ST_InteriorRingN() |
Return N-th interior ring of Polygon |
ST_Intersection() |
Return point set intersection of two geometries |
ST_Intersects() |
Whether one geometry intersects another |
ST_IsClosed() |
Whether a geometry is closed and simple |
ST_IsEmpty() |
Whether a geometry is empty |
ST_IsSimple() |
Whether a geometry is simple |
ST_IsValid() |
Whether a geometry is valid |
ST_LatFromGeoHash() |
Return latitude from geohash value |
ST_Length() |
Return length of LineString |
ST_LineFromText() , ST_LineStringFromText() |
Construct LineString from WKT |
ST_LineFromWKB() , ST_LineStringFromWKB() |
Construct LineString from WKB |
ST_LongFromGeoHash() |
Return longitude from geohash value |
ST_MakeEnvelope() |
Rectangle around two points |
ST_MLineFromText() , ST_MultiLineStringFromText() |
Construct MultiLineString from WKT |
ST_MLineFromWKB() , ST_MultiLineStringFromWKB() |
Construct MultiLineString from WKB |
ST_MPointFromText() , ST_MultiPointFromText() |
Construct MultiPoint from WKT |
ST_MPointFromWKB() , ST_MultiPointFromWKB() |
Construct MultiPoint from WKB |
ST_MPolyFromText() , ST_MultiPolygonFromText() |
Construct MultiPolygon from WKT |
ST_MPolyFromWKB() , ST_MultiPolygonFromWKB() |
Construct MultiPolygon from WKB |
ST_NumGeometries() |
Return number of geometries in geometry collection |
ST_NumInteriorRing() , ST_NumInteriorRings() |
Return number of interior rings in Polygon |
ST_NumPoints() |
Return number of points in LineString |
ST_Overlaps() |
Whether one geometry overlaps another |
ST_PointFromGeoHash() |
Convert geohash value to POINT value |
ST_PointFromText() |
Construct Point from WKT |
ST_PointFromWKB() |
Construct Point from WKB |
ST_PointN() |
Return N-th point from LineString |
ST_PolyFromText() , ST_PolygonFromText() |
Construct Polygon from WKT |
ST_PolyFromWKB() , ST_PolygonFromWKB() |
Construct Polygon from WKB |
ST_Simplify() |
Return simplified geometry |
ST_SRID() |
Return spatial reference system ID for geometry |
ST_StartPoint() |
Start Point of LineString |
ST_SymDifference() |
Return point set symmetric difference of two geometries |
ST_Touches() |
Whether one geometry touches another |
ST_Union() |
Return point set union of two geometries |
ST_Validate() |
Return validated geometry |
ST_Within() |
Whether one geometry is within another |
ST_X() |
Return X coordinate of Point |
ST_Y() |
Return Y coordinate of Point |
StartPoint() (deprecated) |
Start Point of LineString |
Touches() (deprecated) |
Whether one geometry touches another |
Within() (deprecated) |
Whether MBR of one geometry is within MBR of another |
X() (deprecated) |
Return X coordinate of Point |
Y() (deprecated) |
Return Y coordinate of Point |