Articles

How the ST_GeometryCollectionFromWKB() function works in MariaDB?

The ST_GeometryCollectionFromWKB() function in MariaDB is used to construct a GeometryCollection value from a Well-Known Binary (WKB) representation of a geometry collection.

How the ST_GeometryCollectionFromText() function works in MariaDB?

The ST_GeometryCollectionFromText() function in MariaDB is used to construct a GeometryCollection value from a Well-Known Text (WKT) representation of a geometry.

How the ST_GeomCollFromWKB() function works in MariaDB?

The ST_GeomCollFromWKB() function in MariaDB is used to create a geometry collection from a Well-Known Binary (WKB) representation.

How the ST_GeomCollFromText() function works in MariaDB?

The ST_GeomCollFromText() function in MariaDB is used to create a geometry collection from a Well-Known Text (WKT) representation of a geometry.

How the ST_ExteriorRing() function works in MariaDB?

The ST_ExteriorRing() function in MariaDB is used to retrieve the exterior ring of a polygon geometry.

How the ST_EQUALS() function works in MariaDB?

The ST_EQUALS() function in MariaDB is used to determine whether two spatial objects are geometrically equal or not.

How the ST_ENDPOINT() function works in MariaDB?

The ST_ENDPOINT() function in MariaDB is used to retrieve the endpoint of a linestring geometry.

How the ST_ENVELOPE() function works in MariaDB?

The ST_ENVELOPE() function in MariaDB is used to calculate the minimum bounding rectangle (MBR) or envelope of a spatial object.

How the ST_DISTANCE() function works in MariaDB?

The ST_DISTANCE() function in MariaDB is used to calculate the Cartesian distance between two spatial objects.

How the ST_DISTANCE_SPHERE() function works in MariaDB?

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.