All functions > GEOSPATIAL
All functions in the GEOSPATIAL category.
Constructor
| Function | DuckDB | Trino | Serving | Description |
|---|
ST_GEOMPOINT() | ✓ | ✓ | ✗ | Creates a GEOMETRY point from x and y coordinates. |
ST_GEOGPOINT() | ✓ | ✓ | ✗ | Creates a GEOGRAPHY point from longitude and latitude coordinates in WGS84. |
ST_GEOMFROMTEXT() | ✓ | ✓ | ✗ | Creates a GEOMETRY value from a WKT (Well Known Text) string. |
ST_GEOGFROMTEXT() | ✓ | ✓ | ✗ | Creates a GEOGRAPHY value from a WKT (Well Known Text) string. Coordinates are interpreted as... |
ST_MAKELINE() | ✓ | ✗ | ✗ | Creates a LINESTRING from two geometry or geography inputs. |
ST_MAKEPOLYGON() | ✓ | ✗ | ✗ | Creates a POLYGON from a closed LineString shell. |
ST_COLLECT() | ✓ | ✗ | ✗ | Combines two geometries or geographies into a collection without dissolving boundaries. |
ST_GEOMFROMWKB() | ✓ | ✓ | ✗ | Creates a GEOMETRY value from a WKB (Well Known Binary) byte string. |
ST_GEOGFROMWKB() | ✓ | ✓ | ✗ | Creates a GEOGRAPHY value from a WKB (Well Known Binary) byte string. Coordinates are interpreted... |
ST_GEOMFROMGEOJSON() | ✓ | ✗ | ✗ | Creates a GEOMETRY value from a GeoJSON string. |
ST_GEOGFROMGEOJSON() | ✓ | ✗ | ✗ | Creates a GEOGRAPHY value from a GeoJSON string. Coordinates are interpreted as lon/lat in WGS84. |
ST_TOGEOGRAPHY() | ✓ | ✓ | ✗ | Casts a GEOMETRY to GEOGRAPHY, reinterpreting coordinates as lon/lat in WGS84 without reprojection. |
ST_TOGEOMETRY() | ✓ | ✓ | ✗ | Casts a GEOGRAPHY to GEOMETRY, reinterpreting the WGS84 lon/lat coordinates as planar x/y without... |
Serialization
| Function | DuckDB | Trino | Serving | Description |
|---|
ST_ASTEXT() | ✓ | ✓ | ✗ | Returns the WKT (Well Known Text) representation of a geometry or geography. |
ST_ASGEOJSON() | ✓ | ✗ | ✗ | Returns the GeoJSON representation of a geometry or geography. |
ST_ASWKB() | ✓ | ✓ | ✗ | Returns the WKB (Well Known Binary) representation of a geometry or geography. |
Measurement
| Function | DuckDB | Trino | Serving | Description |
|---|
ST_DISTANCE() | ✓ | ✓ | ✗ | Returns the minimum distance between two geometries or geographies. |
ST_AREA() | ✓ | ✓ | ✗ | Returns the area of a geometry or geography. |
ST_LENGTH() | ✓ | ✓ | ✗ | Returns the length of a linear geometry or geography. |
ST_PERIMETER() | ✓ | ✗ | ✗ | Returns the perimeter of an areal geometry or geography. |
ST_AZIMUTH() | ✓ | ✓ | ✗ | Returns the azimuth angle in radians from point A to point B, measured clockwise from north... |
Predicate
| Function | DuckDB | Trino | Serving | Description |
|---|
ST_INTERSECTS() | ✓ | ✓ | ✗ | Returns TRUE if two geometries or geographies share any portion of space. |
ST_CONTAINS() | ✓ | ✓ | ✗ | Returns TRUE if geometry/geography A fully contains geometry/geography B. |
ST_WITHIN() | ✓ | ✓ | ✗ | Returns TRUE if geometry/geography A is fully within geometry/geography B. |
ST_DWITHIN() | ✓ | ✓ | ✗ | Returns TRUE if the distance between two geometries or geographies is less than or equal to a... |
ST_EQUALS() | ✓ | ✓ | ✗ | Returns TRUE if two geometries or geographies represent the same point set. |
ST_DISJOINT() | ✓ | ✓ | ✗ | Returns TRUE if two geometries or geographies do not share any space. |
ST_TOUCHES() | ✓ | ✓ | ✗ | Returns TRUE if two geometries share boundary points but no interior points. |
ST_CROSSES() | ✓ | ✓ | ✗ | Returns TRUE if two geometries have some but not all interior points in common. |
ST_OVERLAPS() | ✓ | ✓ | ✗ | Returns TRUE if two geometries of the same dimension have overlapping interiors. |
Accessor
| Function | DuckDB | Trino | Serving | Description |
|---|
ST_X() | ✓ | ✓ | ✗ | Returns the X coordinate of a point (or longitude for geography). |
ST_Y() | ✓ | ✓ | ✗ | Returns the Y coordinate of a point (or latitude for geography). |
ST_GEOMETRYTYPE() | ✓ | ✓ | ✗ | Returns the OGC type name of a geometry or geography as a string. |
ST_NUMPOINTS() | ✓ | ✗ | ✗ | Returns the total number of vertices in a geometry or geography. |
ST_NUMGEOMETRIES() | ✓ | ✓ | ✗ | Returns the number of sub geometries in a collection, or 1 for singular geometries. |
ST_DIMENSION() | ✓ | ✓ | ✗ | Returns the topological dimension of a geometry or geography. |
ST_ISEMPTY() | ✓ | ✓ | ✗ | Returns TRUE if a geometry or geography is empty. |
ST_ISVALID() | ✓ | ✓ | ✗ | Returns TRUE if a geometry is topologically valid (no self intersections, proper ring closure,... |
ST_SRID() | ✓ | ✗ | ✗ | Returns the SRID (Spatial Reference ID) of a geometry. |
ST_ISCLOSED() | ✓ | ✓ | ✗ | Returns TRUE if a geometry is closed (start point equals end point for lines; always TRUE for... |
ST_STARTPOINT() | ✓ | ✓ | ✗ | Returns the first vertex of a LineString. |
ST_ENDPOINT() | ✓ | ✓ | ✗ | Returns the last vertex of a LineString. |
ST_ISSIMPLE() | ✓ | ✓ | ✗ | Returns TRUE if a geometry has no anomalous geometric points such as self-intersections or... |
ST_GEOMPOINTN() | ✓ | ✓ | ✗ | Returns the Nth vertex of a LineString (1-indexed). |
ST_ISPOINT() | ✓ | ✓ | ✗ | Returns TRUE if the geometry or geography is a Point. |
ST_EXTERIORRING() | ✓ | ✓ | ✗ | Returns the outer ring of a Polygon as a LineString. |
ST_ISLINE() | ✓ | ✓ | ✗ | Returns TRUE if the geometry or geography is a LineString. |
ST_ISPOLYGON() | ✓ | ✓ | ✗ | Returns TRUE if the geometry or geography is a Polygon. |
ST_NUMINTERIORRINGS() | ✓ | ✓ | ✗ | Returns the number of interior rings (holes) in a Polygon. |
ST_INTERIORRINGN() | ✓ | ✗ | ✗ | Returns the Nth interior ring (hole) of a Polygon as a LineString (1-indexed). |
ST_ISCOLLECTION() | ✓ | ✓ | ✗ | Returns TRUE if the geometry or geography is a Multi* or GeometryCollection. |
ST_GEOMETRYN() | ✓ | ✓ | ✗ | Returns the Nth sub-geometry from a geometry collection (1-indexed). |
Transformation
| Function | DuckDB | Trino | Serving | Description |
|---|
ST_CENTROID() | ✓ | ✓ | ✗ | Returns the geometric center of mass (centroid) of a geometry or geography. |
ST_BUFFER() | ✓ | ✗ | ✗ | Returns a geometry/geography that represents all points within a given distance of the input. |
ST_ENVELOPE() | ✓ | ✓ | ✗ | Returns the bounding box of a geometry or geography as a polygon. |
ST_CONVEXHULL() | ✓ | ✗ | ✗ | Returns the convex hull of a geometry or geography. |
ST_SIMPLIFY() | ✓ | ✓ | ✗ | Returns a simplified version of a geometry using the Douglas Peucker algorithm. |
ST_INTERSECTION() | ✓ | ✗ | ✗ | Returns the geometry/geography representing the point set intersection of two inputs. |
ST_UNION() | ✓ | ✗ | ✗ | Returns the geometry/geography representing the point set union of two inputs. |
ST_DIFFERENCE() | ✓ | ✗ | ✗ | Returns the geometry/geography representing the point set difference of A minus B. |
ST_SYMDIFFERENCE() | ✓ | ✗ | ✗ | Returns the geometry/geography representing the point set symmetric difference of two inputs (union... |
ST_REVERSE() | ✓ | ✗ | ✗ | Returns a geometry with the vertex order of each component reversed. |
ST_SNAP_TO_GRID() | ✓ | ✗ | ✗ | Snaps all vertices of a geometry to a uniform grid with the given cell size. |
ST_SETSRID() | ✓ | ✗ | ✗ | Sets the SRID on a geometry without modifying or reprojecting coordinates. |
ST_TRANSFORM() | ✓ | ✗ | ✗ | Reprojects a geometry from its current SRID to a target SRID. |
ST_DUMP() | ✓ | ✗ | ✗ | Explodes a Multi* or GeometryCollection into an array of its component geometries. |
Aggregation
| Function | DuckDB | Trino | Serving | Description |
|---|
ST_UNION_AGG() | ✓ | ✗ | ✗ | Aggregate function that dissolves all geometries in a group into a single geometry. |
ST_COLLECT_AGG() | ✓ | ✗ | ✗ | Aggregate function that collects all geometries in a group into a single GeometryCollection without... |
ST_EXTENT() | ✓ | ✗ | ✗ | Aggregate function that returns the bounding box of all geometries in a group as a polygon. |
Summary
Functions in this category: 69