HAVERSINE
Learn how to use the HAVERSINE geometry function in PlaidCloud Lakehouse. Calculates the great circle distance in kilometers between two points on the...
Geometry Functions
This section provides reference information for the geometry and distance functions in PlaidCloud Lakehouse.
ST_ASBINARY
Learn how to use ST_ASBINARY in PlaidCloud Lakehouse. Alias for the ST_ASWKB geometry function. Includes detailed syntax, examples, and usage reference.
ST_ASEWKB
Learn how to use the ST_ASEWKB geometry function in PlaidCloud Lakehouse. Converts a GEOMETRY object into a EWKB(extended well-known-binary) format...
ST_ASEWKT
Learn how to use the ST_ASEWKT geometry function in PlaidCloud Lakehouse. Converts a GEOMETRY object into a EWKT(extended well-known-text) format...
ST_ASGEOJSON
Learn how to use the ST_ASGEOJSON geometry function in PlaidCloud Lakehouse. Converts a GEOMETRY object into a GeoJSON representation. With syntax and examples.
ST_ASTEXT
Learn how to use ST_ASTEXT in PlaidCloud Lakehouse. Alias for the ST_ASWKT geometry function. Includes detailed syntax, examples, and usage reference.
ST_ASWKB
Learn how to use the ST_ASWKB geometry function in PlaidCloud Lakehouse. Converts a GEOMETRY object into a WKB(well-known-binary) format representation.
ST_ASWKT
Learn how to use the ST_ASWKT geometry function in PlaidCloud Lakehouse. Converts a GEOMETRY object into a WKT(well-known-text) format representation.
ST_CONTAINS
Learn how to use the ST_CONTAINS geometry function in PlaidCloud Lakehouse. Returns TRUE if the second GEOMETRY object is completely inside the first...
ST_DIMENSION
Learn how to use the ST_DIMENSION geometry function in PlaidCloud Lakehouse. Return the dimension for a geometry object. Includes syntax and examples.
ST_DISTANCE
Learn how to use the ST_DISTANCE geometry function in PlaidCloud Lakehouse. Returns the minimum Euclidean distance between two GEOMETRY objects.
ST_ENDPOINT
Learn how to use the ST_ENDPOINT geometry function in PlaidCloud Lakehouse. Returns the last Point in a LineString. Includes syntax and examples.
ST_GEOHASH
Learn how to use the ST_GEOHASH geometry function in PlaidCloud Lakehouse. Return the geohash for a GEOMETRY object. Includes syntax and examples.
ST_GEOM_POINT
Learn how to use ST_GEOM_POINT in PlaidCloud Lakehouse. Alias for the ST_MAKEGEOMPOINT geometry function. Includes usage and syntax details.
ST_GEOMETRYFROMEWKB
Learn how to use ST_GEOMETRYFROMEWKB in PlaidCloud Lakehouse. Alias for the ST_GEOMTRYFROMWKB geometry function. Includes syntax and examples.
ST_GEOMETRYFROMEWKT
Learn how to use ST_GEOMETRYFROMEWKT in PlaidCloud Lakehouse. Alias for the ST_GEOMTRYFROMWKT geometry function. Includes syntax and examples.
ST_GEOMETRYFROMTEXT
Learn how to use ST_GEOMETRYFROMTEXT in PlaidCloud Lakehouse. Alias for the ST_GEOMETRYFROMWKT geometry function. Includes syntax and examples.
ST_GEOMETRYFROMWKB
Learn how to use the ST_GEOMETRYFROMWKB geometry function in PlaidCloud Lakehouse. Parses a WKB(well-known-binary) or EWKB(extended well-known-binary) input...
ST_GEOMETRYFROMWKT
Learn how to use the ST_GEOMETRYFROMWKT geometry function in PlaidCloud Lakehouse. Parses a WKT(well-known-text) or EWKT(extended well-known-text) input and...
ST_GEOMFROMEWKB
Learn how to use ST_GEOMFROMEWKB in PlaidCloud Lakehouse. Alias for the ST_GEOMTRYFROMWKB geometry function. Full syntax and usage reference.
ST_GEOMFROMEWKT
Learn how to use ST_GEOMFROMEWKT in PlaidCloud Lakehouse. Alias for the ST_GEOMTRYFROMWKT geometry function. Full syntax and usage reference.
ST_GEOMFROMGEOHASH
Learn how to use the ST_GEOMFROMGEOHASH geometry function in PlaidCloud Lakehouse. Returns a GEOMETRY object for the polygon that represents the boundaries...
ST_GEOMFROMTEXT
Learn how to use ST_GEOMFROMTEXT in PlaidCloud Lakehouse. Alias for the ST_GEOMTRYFROMWKT geometry function. Full syntax and usage reference.
ST_GEOMFROMWKB
Learn how to use ST_GEOMFROMWKB in PlaidCloud Lakehouse. Alias for the ST_GEOMTRYFROMWKB geometry function. Full syntax and usage reference.
ST_GEOMFROMWKT
Learn how to use ST_GEOMFROMWKT in PlaidCloud Lakehouse. Alias for the ST_GEOMTRYFROMWKT geometry function. Full syntax and usage reference.
ST_GEOMPOINTFROMGEOHASH
Learn how to use the ST_GEOMPOINTFROMGEOHASH geometry function in PlaidCloud Lakehouse. Returns a GEOMETRY object for the point that represents center of a...
ST_LENGTH
Learn how to use the ST_LENGTH geometry function in PlaidCloud Lakehouse. Returns the Euclidean length of the LineString(s) in a GEOMETRY object.
ST_MAKE_LINE
Learn how to use ST_MAKE_LINE in PlaidCloud Lakehouse. Alias for the ST_MAKELINE geometry function. Includes detailed syntax, examples, and usage reference.
ST_MAKEGEOMPOINT
Learn how to use the ST_MAKEGEOMPOINT geometry function in PlaidCloud Lakehouse. Constructs a GEOMETRY object that represents a Point with the specified...
ST_MAKELINE
Learn how to use the ST_MAKELINE geometry function in PlaidCloud Lakehouse. Constructs a GEOMETRY object that represents a line connecting the points in the...
ST_MAKEPOLYGON
Learn how to use the ST_MAKEPOLYGON geometry function in PlaidCloud Lakehouse. Constructs a GEOMETRY object that represents a Polygon without holes.
ST_NPOINTS
Learn how to use the ST_NPOINTS geometry function in PlaidCloud Lakehouse. Returns the number of points in a GEOMETRY object. Includes syntax and examples.
ST_NUMPOINTS
Learn how to use ST_NUMPOINTS in PlaidCloud Lakehouse. Alias for the ST_NPOINTS geometry function. Includes detailed syntax, examples, and usage reference.
ST_POINTN
Learn how to use the ST_POINTN geometry function in PlaidCloud Lakehouse. Returns a Point at a specified index in a LineString. Includes syntax and examples.
ST_POLYGON
Learn how to use ST_POLYGON in PlaidCloud Lakehouse. Alias for the ST_MAKEPOLYGON geometry function. Includes detailed syntax, examples, and usage reference.
ST_SETSRID
Learn how to use the ST_SETSRID geometry function in PlaidCloud Lakehouse. Returns a GEOMETRY object that has its SRID (spatial reference system identifier)...
ST_SRID
Learn how to use the ST_SRID geometry function in PlaidCloud Lakehouse. Returns the SRID (spatial reference system identifier) of a GEOMETRY object.
ST_STARTPOINT
Learn how to use the ST_STARTPOINT geometry function in PlaidCloud Lakehouse. Returns the first Point in a LineString. Includes syntax and examples.
ST_TRANSFORM
Learn how to use the ST_TRANSFORM geometry function in PlaidCloud Lakehouse. Converts a GEOMETRY object from one spatial reference system (SRS) to another.
ST_X
Learn how to use the ST_X geometry function in PlaidCloud Lakehouse. Returns the longitude (X coordinate) of a Point represented by a GEOMETRY object.
ST_XMAX
Learn how to use the ST_XMAX geometry function in PlaidCloud Lakehouse. Returns the maximum longitude (X coordinate) of all points contained in the...
ST_XMIN
Learn how to use the ST_XMIN geometry function in PlaidCloud Lakehouse. Returns the minimum longitude (X coordinate) of all points contained in the...
ST_Y
Learn how to use the ST_Y geometry function in PlaidCloud Lakehouse. Returns the latitude (Y coordinate) of a Point represented by a GEOMETRY object.
ST_YMAX
Learn how to use the ST_YMAX geometry function in PlaidCloud Lakehouse. Returns the maximum latitude (Y coordinate) of all points contained in the specified...
ST_YMIN
Learn how to use the ST_YMIN geometry function in PlaidCloud Lakehouse. Returns the minimum latitude (Y coordinate) of all points contained in the specified...
TO_GEOMETRY
Learn how to use the TO_GEOMETRY geometry function in PlaidCloud Lakehouse. Parses an input and returns a value of type GEOMETRY. Includes syntax and examples.
TO_STRING
Learn how to use the TO_STRING geometry function in PlaidCloud Lakehouse. Converts a GEOMETRY object into a String representation. Includes syntax and examples.