Perform an affine transformation that performs rotation, translation and scaling in one call.

Computes the area of the multi-surface in the specified units.

Calculates the area of a surface in the specified units.

Returns the WKB representation of an ST_Geometry value.

Returns the GML representation of an ST_Geometry value.

Returns a string representing a geometry in JSON format.

Returns the KML representation of an ST_Geometry value.

Returns an SVG figure representing a geometry value.

Returns the text representation of an ST_Geometry value.

Returns the WKB representation of an ST_Geometry value.

Returns the WKT representation of an ST_Geometry value.

Returns the XML representation of an ST_Geometry value.

Returns the boundary of the geometry value.

Computes the ST_Point that is the mathematical centroid of the multi-surface.

Returns the ST_Point value that is the mathematical centroid of the surface value.

Tests if a geometry value spatially contains another geometry value.

An inexpensive test if a geometry might contain another.

Returns the convex hull of the geometry value.

Returns the number of coordinate dimensions stored with each point of the ST_Geometry value.

Tests if a geometry value is spatially covered by another geometry value.

An inexpensive test if a geometry might be covered by another.

Tests if a geometry value spatially covers another geometry value.

An inexpensive test if a geometry might cover another.

Tests if a geometry value crosses another geometry value.

Returns the nth curve in the compound curve.

Returns the interpolation of the curve polygon as a polygon.

Returns the ST_LineString interpolation of an ST_Curve value.

Returns the geometry value that represents the point set difference of two geometries.

Returns the dimension of the ST_Geometry value. Points have dimension 0, lines have dimension 1, and surfaces have dimension 2. Any empty geometry has dimension -1.

Test if a geometry value is spatially disjoint from another value.

Returns the smallest distance between the ${selfexpr} and the specified geometry value.

Returns an ST_Point value that is the end point of the ST_Curve value.

Returns the bounding rectangle for the geometry value.

Tests if an ST_Geometry value is spatially equal to another ST_Geometry value.

An inexpensive test if a geometry is equal to another.

Retrieves or modifies the exterior ring.

Retrieve or modify the exterior ring.

Returns the nth geometry in the geometry collection.

Returns the name of the type of the ST_Geometry value.

Returns the nth interior ring in the curve polygon.

Returns the nth interior ring in the polygon.

Returns the geometry value that represents the point set intersection of two geometries.

Test if a geometry value spatially intersects another value.

An inexpensive test if the two geometries might intersect.

Test if a geometry intersects a rectangle.

Determines if the geometry value has Z coordinate values.

Test if the ST_Curve value is closed. A curve is closed if the start and end points are coincident.

Tests if the ST_MultiCurve value is closed. A curve is closed if the start and end points are coincident. A multicurve is closed if it is non-empty and has an empty boundary.

Determines whether the geometry value represents an empty set.

Determines if the geometry value has associated measure values.

Tests if the ST_Curve value is a ring. A curve is a ring if it is closed and simple (no self intersections).

Determines whether the geometry value is simple (containing no self intersections or other irregularities).

Determines whether the geometry is a valid spatial object.

Test if the ST_Surface covers the entire space.

Returns the latitude coordinate of the ST_Point value.

Retrieves the northernmost latitude of a geometry.

Retrieves the southernmost latitude of a geometry.

Retrieves the length measurement of the curve value.

Returns the length measurement of the ST_MultiCurve value. The result is measured in the units specified by the parameter.

Returns a binary string that is a linear hash of the geometry.

Returns the longitude coordinate of the ST_Point value.

Retrieves the longitude of the eastern boundary of a geometry.

Retrieves the longitude of the western boundary of a geometry.

Retrieves or modifies the measure value of a point.

Retrieves the maximum M coordinate value of a geometry.

Retrieves the minimum M coordinate value of a geometry.

Returns the number of curves defining the compound curve.

Returns the number of geometries contained in the geometry collection.

Returns the number of interior rings in the curve polygon.

Returns the number of points defining the circularstring.

Returns the number of points defining the linestring.

Tests if a geometry is identical to another geometry.

Tests if a geometry value overlaps another geometry value.

Computes the perimeter of the multi-surface in the specified units.

Calculates the perimeter of a surface in the specified units.

Returns the nth point in the circularstring.

Returns the nth point in the linestring.

Returns a point that is guaranteed to be on a surface in the multi-surface

Returns an ST_Point value that is guaranteed to spatially intersect the ST_Surface value.

Tests if a geometry value is spatially related to another geometry value as specified by the intersection matrix. The ST_Relate method uses a 9-character string from the Dimensionally Extended 9 Intersection Model (DE-9IM) to describe the pair-wise relationship between two spatial data items. For example, the ST_Relate method determines if an intersection occurs between the geometries, and the geometry of the resulting intersection, if it exists. See also: How spatial relationships work.

Returns the geometry with the element order reversed.

Retrieves or modifies the spatial reference system associated with the geometry value.

Returns a copy of the geometry with all points snapped to the specified grid.

Returns an ST_Point value that is the start point of the ST_Curve value.

Returns the geometry value that represents the point set symmetric difference of two geometries.

Convert the geometry to a circularstring

Converts the geometry to a compound curve.

Converts the geometry to a curve.

Converts the geometry to a curve polygon.

Converts the geometry to a geometry collection.

Converts the geometry to a linestring.

Converts the geometry to a multicurve value.

Converts the geometry to a multilinestring value.

Converts the geometry to a multi-point value.

Converts the geometry to a multi-polygon value.

Converts the geometry to a multi-surface value.

Converts the geometry to a point.

Converts the geometry to a polygon.

Converts the geometry to a surface.

Tests if a geometry value spatially touches another geometry value.

Creates a copy of the geometry value transformed into the specified spatial reference system.

Returns the geometry value that represents the point set union of two geometries.

Tests if a geometry value is spatially contained within another geometry value.

Test if two geometries are within a specified distance of each other.

An inexpensive of whether two geometries might be within a specified distance of each other.

An inexpensive test if a geometry might be within another.

Retrieves or modifies the X coordinate value of a point.

Retrieves the maximum X coordinate value of a geometry.

Retrieves the minimum X coordinate value of a geometry.

Retrieves or modifies the Y coordinate value of a point.

Retrieves the maximum Y coordinate value of a geometry.

Retrieves the minimum Y coordinate value of a geometry.

Retrieves or modifies the Z coordinate value of a point.

Retrieves the maximum Z coordinate value of a geometry.

Retrieves the minimum Z coordinate value of a geometry.