Spatial types and functions

The ST_CircularString type is a subtype of ST_Curve that uses circular line segments between control points.

A compound curve is a sequence of ST_Curve values such that adjacent curves are joined at their endpoints. The contributing curves are limited to ST_LineString and ST_CircularString. The start point of each curve after the first is coincident with the end point of the previous curve.

The ST_Curve type is a supertype for types representing lines using a sequence of points.

An ST_CurvePolygon represents a planar surface defined by one exterior ring and zero or more interior rings

An ST_GeomCollection is a collection of zero or more ST_Geometry values.

The ST_Geometry type is the maximal supertype of the geometry type hierarchy.

The ST_LineString type is used to represent a multi-segment line using straight line segments between control points.

An ST_MultiCurve is a collection of zero or more ST_Curve values, and all of the curves are within the spatial reference system.

An ST_MultiLineString is a collection of zero or more ST_LineString values, and all of the linestrings are within the spatial reference system.

An ST_MultiPoint is a collection of zero or more ST_Point values, and all of the points are within the spatial reference system.

An ST_MultiPolygon is a collection of zero or more ST_Polygon values, and all of the polygons are within the spatial reference system.

An ST_MultiSurface is a collection of zero or more ST_Surface values, and all of the surfaces are within the spatial reference system.

The ST_Point type is a 0-dimensional geometry and represents a single location.

An ST_Polygon defines an area of space using an exterior ring and one or more interior rings, all defined using ST_LineString.

The ST_SpatialRefSys type defines routines for working with spatial reference systems.

The ST_Surface type is a supertype for 2-dimensional geometry types. The ST_Surface type is not instantiable.

The SQL/MM standard defines a number of functions that can be used to perform spatial operations.

There are many supported spatial methods.

There are many supported spatial constructors.

There are many static methods available for use with spatial data.

There are many aggregate methods available for use with spatial data.

There are several set operation methods available for use with spatial data.

There are many predicate methods available for use with spatial data.