List of all supported methods

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 `n`th curve in the compound curve.	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 `n`th geometry in the geometry collection.	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 `n`th interior ring in the curve polygon.	X	8.2.6
ST_InteriorRingN	ST_Polygon	Returns the `n`th interior ring in the polygon.	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 `n`th point in the circularstring.	X	7.3.5
ST_PointN	ST_LineString	Returns the `n`th point in the linestring.	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.