The ST_ISCLOSED() function in MariaDB is used to determine whether a given geometry is closed or not.
ST_ISCLOSED()
The ST_INTERSECTS() function in MariaDB is used to determine whether two given geometries intersect or overlap with each other.
ST_INTERSECTS()
The ST_INTERSECTION() function in MariaDB is used to calculate the geometric intersection between two geometry values.
ST_INTERSECTION()
The ST_InteriorRingN() function in MariaDB is used to retrieve the N-th interior ring of a Polygon geometry. Interior rings are the rings that define holes or inner boundaries within a polygon.
ST_InteriorRingN()
The ST_GeomFromWKB() function in MariaDB is used to construct a geometry value from a Well-Known Binary (WKB) representation of a geometry.
ST_GeomFromWKB()
The ST_GeomFromText() function in MariaDB is used to construct a geometry value from a Well-Known Text (WKT) representation of a geometry.
ST_GeomFromText()
The ST_GEOMETRYTYPE() function in MariaDB is used to retrieve the type of a geometry value.
ST_GEOMETRYTYPE()
The ST_GEOMETRYN() function in MariaDB is used to return the N-th geometry from a collection of geometries, allowing for efficient extraction of individual geometries from collections.
ST_GEOMETRYN()
The ST_GeometryFromWKB() function in MariaDB is used to construct a geometry value from a Well-Known Binary (WKB) representation of a geometry.
ST_GeometryFromWKB()
The ST_GeometryFromText() function in MariaDB is used to construct a geometry value from a Well-Known Text (WKT) representation of a geometry.
ST_GeometryFromText()
The ST_GeometryCollectionFromWKB() function in MariaDB is used to construct a GeometryCollection value from a Well-Known Binary (WKB) representation of a geometry collection.
ST_GeometryCollectionFromWKB()
The ST_GeometryCollectionFromText() function in MariaDB is used to construct a GeometryCollection value from a Well-Known Text (WKT) representation of a geometry.
ST_GeometryCollectionFromText()
The ST_GeomCollFromWKB() function in MariaDB is used to create a geometry collection from a Well-Known Binary (WKB) representation.
ST_GeomCollFromWKB()
The ST_GeomCollFromText() function in MariaDB is used to create a geometry collection from a Well-Known Text (WKT) representation of a geometry.
ST_GeomCollFromText()
The ST_ExteriorRing() function in MariaDB is used to retrieve the exterior ring of a polygon geometry.
ST_ExteriorRing()
The ST_EQUALS() function in MariaDB is used to determine whether two spatial objects are geometrically equal or not.
ST_EQUALS()
The ST_ENDPOINT() function in MariaDB is used to retrieve the endpoint of a linestring geometry.
ST_ENDPOINT()
The ST_ENVELOPE() function in MariaDB is used to calculate the minimum bounding rectangle (MBR) or envelope of a spatial object.
ST_ENVELOPE()
The ST_DISTANCE() function in MariaDB is used to calculate the Cartesian distance between two spatial objects.
ST_DISTANCE()
The ST_DISTANCE_SPHERE() function in MariaDB is used to calculate the minimum distance between two spatial objects on a spherical surface, considering the curvature of the Earth.
ST_DISTANCE_SPHERE()
The ST_DISJOINT() function in MariaDB is used to determine whether two spatial objects are disjoint or not. It returns 1 if the objects do not intersect or touch each other, and 0 if they do.
ST_DISJOINT()
The ST_DIMENSION() function in MariaDB is used to retrieve the dimension value of a spatial object, allowing for efficient analysis and manipulation of spatial data.
ST_DIMENSION()
The ST_Difference() function in MariaDB is used to calculate the geometric difference between two spatial objects, allowing for efficient analysis and manipulation of spatial data.
ST_Difference()
The ST_CROSSES() function in MariaDB is used to determine whether two spatial objects cross each other, allowing for efficient analysis and manipulation of spatial data.
ST_CROSSES()
The ST_ConvexHull() function in MariaDB is used to calculate the convex hull of a given geometry value, allowing for efficient analysis and manipulation of spatial data.
ST_ConvexHull()
The ST_Contains() function in MariaDB is used to determine whether a given geometry value contains another geometry value, allowing for efficient analysis and manipulation of spatial data.
ST_Contains()
The ST_Centroid() function in MariaDB is used to calculate the centroid of a given geometry value, allowing for efficient analysis and manipulation of spatial data.
ST_Centroid()
The ST_BUFFER() function in MariaDB is used to create a buffer geometry around a given geometry value, allowing for efficient analysis and manipulation of spatial data.
ST_BUFFER()
The ST_Boundary() function in MariaDB is used to return the boundary of a given geometry value, allowing for efficient analysis and manipulation of spatial data.
ST_Boundary()
The ST_ASWKT() function in MariaDB is used to convert a geometry value into its Well-Known Text (WKT) representation, allowing for efficient storage and retrieval of spatial data.
ST_ASWKT()
The ST_AsWKB() function in MariaDB is used to convert a geometry value into its Well-Known Binary (WKB) representation, allowing for efficient storage and transfer of spatial data.
ST_AsWKB()
The ST_PointFromWKB() function in MariaDB is used to create a point geometry from its Well-Known Binary (WKB) representation, allowing for efficient storage and retrieval of spatial data.
ST_PointFromWKB()
The ST_PointFromText() function in MariaDB is used to create a point geometry from a Well-Known Text (WKT) representation.
ST_PointFromText()
The ST_OVERLAPS() function in MariaDB is used to determine whether two geometries overlap.
ST_OVERLAPS()
The ST_NUMPOINTS() function in MariaDB is used to retrieve the number of points in a geometry object.
ST_NUMPOINTS()
The ST_NumInteriorRings() function in MariaDB is used to determine the number of interior rings (holes) in a polygon geometry.
ST_NumInteriorRings()
The ST_NUMGEOMETRIES() function in MariaDB is used to retrieve the number of geometries in a geometry collection.
ST_NUMGEOMETRIES()
The ST_LineStringFromWKB() function in MariaDB is used to create a linestring geometry from a well-known binary (WKB) representation of the geometry.
ST_LineStringFromWKB()
The ST_LineStringFromText() function in MariaDB is used to create a linestring geometry from a well-known text (WKT) representation of the geometry.
ST_LineStringFromText()
The ST_LineFromWKB() function in MariaDB is used to create a linestring geometry from a well-known binary (WKB) representation of the geometry.
ST_LineFromWKB()
The ST_LineFromText() function in MariaDB is used to create a linestring geometry from a well-known text (WKT) representation of the geometry.
ST_LineFromText()
The ST_LENGTH() function in MariaDB is used to calculate the length or perimeter of a given geometry.
ST_LENGTH()
The ST_IsSimple() function in MariaDB is used to determine whether a given geometry is simple or not.
ST_IsSimple()
The ST_AsText() function in MariaDB is used to convert a geometry value into its Well-Known Text (WKT) representation, which is a human-readable format for spatial data.
ST_AsText()
This article explores the ST_AsBinary() function in MariaDB, detailing its purpose, syntax, use cases, and practical examples.
This article explores the ST_AREA() function in MariaDB, detailing its purpose, syntax, use cases, and practical examples.
This article explores the SPIDER_FLUSH_TABLE_MON_CACHE() function in MariaDB, detailing its purpose, syntax, use cases, and practical examples.
This article explores the SPIDER_DIRECT_SQL() function in MariaDB, detailing its purpose, syntax, use cases, and practical examples.
This article explores the SPIDER_COPY_TABLES() function in MariaDB, detailing its purpose, syntax, use cases, and practical examples.
This article explores the SPIDER_BG_DIRECT_SQL() function in MariaDB, detailing its purpose, syntax, use cases, and practical examples.