📄️ ST_AsText,ST_AsWKT
Converts a geometric figure to WKT (Well Known Text) format.
📄️ ST_Circle
Converts a WKT (WEll Known Text) to a circle on the sphere of the earth.
📄️ ST_Contains
Checks whether the geometric figure shape1 can fully contain shape2.
📄️ ST_Distance_Sphere
Calculates the spherical distance between two points on the Earth in "meters". The parameters inputted are longitude at X, latitude at X, longitude at Y, latitude at Y.
📄️ ST_GeometryFromText,ST_GeomFromText
Converts a WKT (Well Known Text) to the corresponding memory geometry.
📄️ ST_LineFromText,ST_LineStringFromText
Converts a WKT (Well Known Text) to a memory representation in the form of Line.
📄️ ST_Point
Returns the corresponding Point with the given X-coordinate and Y-coordinate. At the moment this value only makes sense on a spherical set. X/Y corresponds to longitude/latitude.
📄️ ST_Polygon,ST_PolyFromText,ST_PolygonFromText
Converts a WKT (Well Known Text) to a corresponding polygon memory form.
📄️ ST_X
If point is of a valid Point type, return the corresponding X-coordinate value.
📄️ ST_Y
If point is of a valid Point type, return the corresponding Y-coordinate value.