Geometry types

Point

ST_Point

The type ST_PolyhedralSurface is currently not in SQL/MM, but will be proposed as a result of this document

Curve

ST_Curve

Linestring

ST_LinestringST_Circularstring ST_CompoundCurve

Surface

ST_Surface ST_CurvePolygon

Polygon

ST_Polygon

PolyhedralSurface

ST_PolyhedralSurface

GeomCollection

ST_Collection

Multipoint

ST_Multipoint

Multicurve

ST_MultiCurve

Multilinestring

ST_Multilinestring

Multisurface

ST_Multisurface

Multipolygon

ST_Multipolygon

Storage

Binary Type, Text Type, Object Type

Object Type

Operations

Equals

ST_Equals

Disjoint

ST_Disjoint

Touches

ST_Touches

Within

ST_Within

Overlaps

ST_Overlaps

Crosses

ST_Crosses

Intersects

ST_Intersects

Contains

ST_Contains

Relate

ST_Relate

Functions

—

—

—

Point

—

ST_Point()

It returns the point

X()

ST_X()

It returns the X-coordinate of the point

Y()

ST_Y()

It returns the Y-coordinate of the point

Z()

ST_Z()

It return the Z-coordinate of the point

M()

ST_M()

It returns the M-coordinate of the point

—

ST_ExplicitPoint()

—

Curve

Length()

ST_Length()

It returns the length of the curve

StartPoint()

ST_StartPoint()

It returns the first point of the curve

EndPoint()

ST_EndPoint()

It returns the last point of the curve

IsClosed()

ST_IsClosed()

It checks whether the curve is closed

IsRing()

ST_ISRing()

It check if the curve is closed and simple

—

ST_CurveToLine

It transforms a curve to LineString

LineString

—

ST_LineString

It returns LineString

—

ST_Points

It returns a collection of points

NumPoints()

ST_NumPoints

It returns the number of points

PointN()

ST_PointN

It returns the nth point of LineString