There are many supported spatial methods.

An X in the Round-Earth column indicates that the method is also supported on round-Earth spatial reference systems. The SQL/MM column reflects compliance with the SQL/MM standard (ISO/IEC 13249-3: 2006).

Method | Type | Description | Round-Earth | SQL/MM |
---|---|---|---|---|

ST_Affine | ST_Geometry |
Perform an affine transformation that performs rotation, translation and scaling in one call. |
Not in the standard. | |

ST_Area | ST_MultiSurface |
Computes the area of the multi-surface in the specified units. |
9.5.3 | |

ST_Area | ST_Surface |
Calculates the area of a surface in the specified units. |
8.1.2 | |

ST_AsBinary | ST_Geometry |
Returns the WKB representation of an ST_Geometry value. |
X | 5.1.37 |

ST_AsGML | ST_Geometry |
Returns the GML representation of an ST_Geometry value. |
X | 5.1.39 |

ST_AsGeoJSON | ST_Geometry |
Returns a string representing a geometry in JSON format. |
X | Not in the standard. |

ST_AsKML | ST_Geometry |
Returns the KML representation of an ST_Geometry value. |
X | 5.1.39 |

ST_AsSVG | ST_Geometry |
Returns an SVG figure representing a geometry value. |
X | Not in the standard. |

ST_AsText | ST_Geometry |
Returns the text representation of an ST_Geometry value. |
X | 5.1.35 |

ST_AsWKB | ST_Geometry |
Returns the WKB representation of an ST_Geometry value. |
X | Not in the standard. |

ST_AsWKT | ST_Geometry |
Returns the WKT representation of an ST_Geometry value. |
X | Not in the standard. |

ST_AsXML | ST_Geometry |
Returns the XML representation of an ST_Geometry value. |
X | Not in the standard. |

ST_Boundary | ST_Geometry |
Returns the boundary of the geometry value. |
5.1.14 | |

ST_Buffer | ST_Geometry |
Returns the ST_Geometry value that represents all points whose distance from any point of an ST_Geometry value is less than or equal to a specified distance in the given units. |
5.1.17 | |

ST_Centroid | ST_MultiSurface |
Computes the ST_Point that is the mathematical centroid of the multi-surface. |
9.5.5 | |

ST_Centroid | ST_Surface |
Returns the ST_Point value that is the mathematical centroid of the surface value. |
8.1.4 | |

ST_Contains | ST_Geometry |
Tests if a geometry value spatially contains another geometry value. |
5.1.31 | |

ST_ContainsFilter | ST_Geometry |
An inexpensive test if a geometry might contain another. |
Not in the standard. | |

ST_ConvexHull | ST_Geometry |
Returns the convex hull of the geometry value. |
5.1.16 | |

ST_CoordDim | ST_Geometry |
Returns the number of coordinate dimensions stored with each point of the ST_Geometry value. |
X | 5.1.3 |

ST_CoveredBy | ST_Geometry |
Tests if a geometry value is spatially covered by another geometry value. |
X | Not in the standard. |

ST_CoveredByFilter | ST_Geometry |
An inexpensive test if a geometry might be covered by another. |
X | Not in the standard. |

ST_Covers | ST_Geometry |
Tests if a geometry value spatially covers another geometry value. |
X | Not in the standard. |

ST_CoversFilter | ST_Geometry |
An inexpensive test if a geometry might cover another. |
X | Not in the standard. |

ST_Crosses | ST_Geometry |
Tests if a geometry value crosses another geometry value. |
5.1.29 | |

ST_CurveN | ST_CompoundCurve |
Returns the |
X | 7.4.5 |

ST_CurvePolyToPoly | ST_CurvePolygon |
Returns the interpolation of the curve polygon as a polygon. |
X | 8.2.7 |

ST_CurveToLine | ST_Curve |
Returns the ST_LineString interpolation of an ST_Curve value. |
X | 7.1.7 |

ST_Difference | ST_Geometry |
Returns the geometry value that represents the point set difference of two geometries. |
X | 5.1.20 |

ST_Dimension | ST_Geometry |
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. |
X | 5.1.2 |

ST_Disjoint | ST_Geometry |
Test if a geometry value is spatially disjoint from another value. |
X | 5.1.26 |

ST_Distance | ST_Geometry |
Returns the smallest distance between the ${selfexpr} and the specified geometry value. |
X | 5.1.23 |

ST_EndPoint | ST_Curve |
Returns an ST_Point value that is the end point. |
X | 7.1.4 |

ST_Envelope | ST_Geometry |
Returns the bounding rectangle for the geometry value. |
5.1.15 | |

ST_Equals | ST_Geometry |
Tests if an ST_Geometry value is spatially equal to another ST_Geometry value. |
X | 5.1.24 |

ST_EqualsFilter | ST_Geometry |
An inexpensive test if a geometry is equal to another. |
X | Not in the standard. |

ST_ExteriorRing | ST_CurvePolygon |
Retrieves or modifies the exterior ring. |
X | 8.2.3 |

ST_ExteriorRing | ST_Polygon |
Retrieve or modify the exterior ring. |
X | 8.3.3 |

ST_GeometryN | ST_GeomCollection |
Returns the |
X | 9.1.5 |

ST_GeometryType | ST_Geometry |
Returns the name of the type of the ST_Geometry value. |
X | 5.1.4 |

ST_InteriorRingN | ST_CurvePolygon |
Returns the |
X | 8.2.6 |

ST_InteriorRingN | ST_Polygon |
Returns the |
X | 8.3.5 |

ST_Intersection | ST_Geometry |
Returns the geometry value that represents the point set intersection of two geometries. |
X | 5.1.18 |

ST_Intersects | ST_Geometry |
Test if a geometry value spatially intersects another value. |
X | 5.1.27 |

ST_IntersectsFilter | ST_Geometry |
An inexpensive test if the two geometries might intersect. |
X | Not in the standard. |

ST_IntersectsRect | ST_Geometry |
Test if a geometry intersects a rectangle. |
X | Not in the standard. |

ST_Is3D | ST_Geometry |
Determines if the geometry value has Z coordinate values. |
X | 5.1.10 |

ST_IsClosed | ST_Curve |
Test if the curve is closed. A curve is closed if the start and end points are coincident. |
X | 7.1.5 |

ST_IsClosed | ST_MultiCurve |
Tests if the 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. |
X | 9.3.3 |

ST_IsEmpty | ST_Geometry |
Determines whether the geometry value represents an empty set. |
X | 5.1.7 |

ST_IsMeasured | ST_Geometry |
Determines if the geometry value has associated measure values. |
X | 5.1.11 |

ST_IsRing | ST_Curve |
Tests if the curve is a ring. A curve is a ring if it is closed and simple (no self intersections). |
X | 7.1.6 |

ST_IsSimple | ST_Geometry |
Determines whether the geometry value is simple (containing no self intersections or other irregularities). |
X | 5.1.8 |

ST_IsValid | ST_Geometry |
Determines whether the geometry is a valid spatial object. |
X | 5.1.9 |

ST_IsWorld | ST_Surface |
Test if the ST_Surface covers the entire space. |
8.1.6 | |

ST_Lat | ST_Point |
Returns the latitude coordinate of the ST_Point value. |
X | Not in the standard. |

ST_LatNorth | ST_Geometry |
Retrieves the northernmost latitude of a geometry. |
X | Not in the standard. |

ST_LatSouth | ST_Geometry |
Retrieves the southernmost latitude of a geometry. |
X | Not in the standard. |

ST_Length | ST_Curve |
Retrieves the length measurement. |
X | 7.1.2 |

ST_Length | ST_MultiCurve |
Returns the length measurement of all the curves in the multicurve. |
X | 9.3.4 |

ST_LinearHash | ST_Geometry |
Returns a binary string that is a linear hash of the geometry. |
X | Not in the standard. |

ST_Long | ST_Point |
Returns the longitude coordinate of the ST_Point value. |
X | Not in the standard. |

ST_LongEast | ST_Geometry |
Retrieves the longitude of the eastern boundary of a geometry. |
X | Not in the standard. |

ST_LongWest | ST_Geometry |
Retrieves the longitude of the western boundary of a geometry. |
X | Not in the standard. |

ST_M | ST_Point |
Retrieves or modifies the measure value of a point. |
X | 6.1.6 |

ST_MMax | ST_Geometry |
Retrieves the maximum M coordinate value of a geometry. |
X | Not in the standard. |

ST_MMin | ST_Geometry |
Retrieves the minimum M coordinate value of a geometry. |
X | Not in the standard. |

ST_NumCurves | ST_CompoundCurve |
Returns the number of curves defining the compound curve. |
X | 7.4.4 |

ST_NumGeometries | ST_GeomCollection |
Returns the number of geometries contained in the geometry collection. |
X | 9.1.4 |

ST_NumInteriorRing | ST_CurvePolygon |
Returns the number of interior rings in the curve polygon. |
X | 8.2.5 |

ST_NumPoints | ST_CircularString |
Returns the number of points defining the circularstring. |
X | 7.3.4 |

ST_NumPoints | ST_LineString |
Returns the number of points defining the linestring. |
X | 7.2.4 |

ST_OrderingEquals | ST_Geometry |
Tests if a geometry is identical to another geometry. |
X | 5.1.43 |

ST_Overlaps | ST_Geometry |
Tests if a geometry value overlaps another geometry value. |
5.1.32 | |

ST_Perimeter | ST_MultiSurface |
Computes the perimeter of the multi-surface in the specified units. |
X | 9.5.4 |

ST_Perimeter | ST_Surface |
Calculates the perimeter of a surface in the specified units. |
X | 8.1.3 |

ST_PointN | ST_CircularString |
Returns the |
X | 7.3.5 |

ST_PointN | ST_LineString |
Returns the |
X | 7.2.5 |

ST_PointOnSurface | ST_MultiSurface |
Returns a point that is guaranteed to be on a surface in the multi-surface |
X | 9.5.6 |

ST_PointOnSurface | ST_Surface |
Returns an ST_Point value that is guaranteed to spatially intersect the ST_Surface value. |
X | 8.1.5 |

ST_Relate | ST_Geometry |
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: Test custom relationships using the ST_Relate method. |
5.1.25, Not in the standard. | |

ST_Reverse | ST_Geometry |
Returns the geometry with the element order reversed. |
X | Not in the standard. |

ST_SRID | ST_Geometry |
Retrieves or modifies the spatial reference system associated with the geometry value. |
X | 5.1.5 |

ST_SnapToGrid | ST_Geometry |
Returns a copy of the geometry with all points snapped to the specified grid. |
X | Not in the standard. |

ST_StartPoint | ST_Curve |
Returns an ST_Point value that is the starting point. |
X | 7.1.3 |

ST_SymDifference | ST_Geometry |
Returns the geometry value that represents the point set symmetric difference of two geometries. |
X | 5.1.21 |

ST_ToCircular | ST_Geometry |
Convert the geometry to a circularstring |
X | 5.1.33 |

ST_ToCompound | ST_Geometry |
Converts the geometry to a compound curve. |
X | 5.1.33 |

ST_ToCurve | ST_Geometry |
Converts the geometry to a curve. |
X | Not in the standard. |

ST_ToCurvePoly | ST_Geometry |
Converts the geometry to a curve polygon. |
X | 5.1.33 |

ST_ToGeomColl | ST_Geometry |
Converts the geometry to a geometry collection. |
X | 5.1.33 |

ST_ToLineString | ST_Geometry |
Converts the geometry to a linestring. |
X | 5.1.33 |

ST_ToMultiCurve | ST_Geometry |
Converts the geometry to a multicurve value. |
X | 5.1.33 |

ST_ToMultiLine | ST_Geometry |
Converts the geometry to a multilinestring value. |
X | 5.1.33 |

ST_ToMultiPoint | ST_Geometry |
Converts the geometry to a multi-point value. |
X | 5.1.33 |

ST_ToMultiPolygon | ST_Geometry |
Converts the geometry to a multi-polygon value. |
X | 5.1.33 |

ST_ToMultiSurface | ST_Geometry |
Converts the geometry to a multi-surface value. |
X | 5.1.33 |

ST_ToPoint | ST_Geometry |
Converts the geometry to a point. |
X | 5.1.33 |

ST_ToPolygon | ST_Geometry |
Converts the geometry to a polygon. |
X | 5.1.33 |

ST_ToSurface | ST_Geometry |
Converts the geometry to a surface. |
X | Not in the standard. |

ST_Touches | ST_Geometry |
Tests if a geometry value spatially touches another geometry value. |
5.1.28 | |

ST_Transform | ST_Geometry |
Creates a copy of the geometry value transformed into the specified spatial reference system. |
X | 5.1.6 |

ST_Union | ST_Geometry |
Returns the geometry value that represents the point set union of two geometries. |
X | 5.1.19 |

ST_Within | ST_Geometry |
Tests if a geometry value is spatially contained within another geometry value. |
5.1.30 | |

ST_WithinDistance | ST_Geometry |
Test if two geometries are within a specified distance of each other. |
X | Not in the standard. |

ST_WithinDistanceFilter | ST_Geometry |
An inexpensive of whether two geometries might be within a specified distance of each other. |
X | Not in the standard. |

ST_WithinFilter | ST_Geometry |
An inexpensive test if a geometry might be within another. |
Not in the standard. | |

ST_X | ST_Point |
Retrieves or modifies the X coordinate value of a point. |
X | 6.1.3 |

ST_XMax | ST_Geometry |
Retrieves the maximum X coordinate value of a geometry. |
X | Not in the standard. |

ST_XMin | ST_Geometry |
Retrieves the minimum X coordinate value of a geometry. |
X | Not in the standard. |

ST_Y | ST_Point |
Retrieves or modifies the Y coordinate value of a point. |
X | 6.1.4 |

ST_YMax | ST_Geometry |
Retrieves the maximum Y coordinate value of a geometry. |
X | Not in the standard. |

ST_YMin | ST_Geometry |
Retrieves the minimum Y coordinate value of a geometry. |
X | Not in the standard. |

ST_Z | ST_Point |
Retrieves or modifies the Z coordinate value of a point. |
X | 6.1.4, 6.1.5 |

ST_ZMax | ST_Geometry |
Retrieves the maximum Z coordinate value of a geometry. |
X | Not in the standard. |

ST_ZMin | ST_Geometry |
Retrieves the minimum Z coordinate value of a geometry. |
X | Not in the standard. |