Skip to content

SQL Function Reference

ST_Analyze_Agg

Compute the statistics of geometries for the input geometry.

Usage

struct ST_Analyze_Agg(geom: geometry)

ST_Area

Returns the area of a geometry.

Usage

geometry ST_Area(geom: geometry)

ST_AsBinary

Converts a geometry to Well-Known Binary (WKB) format.

Usage

geometry ST_AsBinary(geom: geometry)

ST_Buffer

Computes a geometry that represents all points whose distance from the input geometry is less than or equal to a specified distance.

Usage

geometry ST_Buffer(geom: geometry, distance: float64)
geometry ST_Buffer(geom: geometry, distance: float64, params: utf8)

ST_Intersection

Compute the intersection of two geometries or geographies.

Usage

geometry ST_Intersection(geomA: geometry, geomB: geometry)
geography ST_Intersection(geogA: geography, geogB: geography)