GEOSPATIAL Functions

All functions in the GEOSPATIAL category.

Constructor

Function	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	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	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	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	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	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	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 GEOSPATIAL: 69

This documentation is automatically generated from the FeatureMesh registry.

Suggest changes to this page

Last update at: 2026/05/26 17:22:09

On this page

Constructor Serialization Measurement Predicate Accessor Transformation Aggregation