ST_ASTEXT
Learn how to use the ST_ASTEXT spatial function in PlaidCloud Lakehouse. Converts a geometry to its WKT (Well-Known Text) representation.
Spatial Functions
This section provides reference information for the spatial functions in PlaidCloud Lakehouse.
ST_CIRCLE
Learn how to use the ST_CIRCLE spatial function in PlaidCloud Lakehouse. Creates a circle geometry from a center longitude, latitude and radius in meters.
ST_CONTAINS
Learn how to use the ST_CONTAINS spatial function in PlaidCloud Lakehouse. Checks whether one geometry contains another. Returns 1 if true.
ST_DISTANCE_SPHERE
Learn how to use the ST_DISTANCE_SPHERE spatial function in PlaidCloud Lakehouse. Returns the spherical distance between two points in meters.
ST_GEOMETRYFROMTEXT
Learn how to use the ST_GEOMETRYFROMTEXT spatial function in PlaidCloud Lakehouse. Creates a geometry from a WKT (Well-Known Text) string.
ST_LINEFROMTEXT
Learn how to use the ST_LINEFROMTEXT spatial function in PlaidCloud Lakehouse. Creates a line geometry from a WKT string - see syntax, examples, and output.
ST_POINT
Learn how to use the ST_POINT spatial function in PlaidCloud Lakehouse. Creates a point geometry from longitude and latitude values - with syntax and examples.
ST_POLYGON
Learn how to use the ST_POLYGON spatial function in PlaidCloud Lakehouse. Creates a polygon geometry from a WKT string - see syntax, examples, and output.
ST_X
Learn how to use the ST_X spatial function in PlaidCloud Lakehouse. Returns the X coordinate (longitude) of a point geometry - with syntax and examples.
ST_Y
Learn how to use the ST_Y spatial function in PlaidCloud Lakehouse. Returns the Y coordinate (latitude) of a point geometry - with syntax and examples.