Properties

The following property functions are available:

Function	Description
ST_Boundary	Return a Geometry’s boundary
ST_Centroid	Return the centroid of a Geometry
ST_CompactnessRatio	Return the square root of a POLYGON’s area divided by the area of the circle with circumference equal to its perimeter
ST_CoordDim	Return the dimension of the coordinates of a Geometry
ST_Dimension	Return the dimension of a Geometry
ST_Distance	Return the distance between two Geometries
ST_DistanceSphere	Return the minimum distance between two points
ST_EndPoint	Return the last coordinate of a LINESTRING
ST_Envelope	Return a Geometry’s envelope as a Geometry
ST_EnvelopeAsText	Return a Geometry’s envelope as a string
ST_EstimatedExtent	Return the estimated extent of a table
ST_Explode	Explode GEOMETRYCOLLECTIONs into multiple Geometries
ST_Extent	Return the minimum bounding box of a GEOMETRYCOLLECTION
ST_ExteriorRing	Return the exterior ring of a POLYGON
ST_GeometryN	Return the nth Geometry of a GEOMETRYCOLLECTION
ST_GeometryType	Return the type of a Geometry
ST_InteriorRingN	Return the nth interior ring of a POLYGON
ST_IsClosed	Return true if a Geometry is a closed LINESTRING or MULTILINESTRING
ST_IsEmpty	Return true if a Geometry is empty
ST_IsRectangle	Return true if the Geometry is a rectangle
ST_IsRing	Return true if a LINESTRING is ring
ST_IsSimple	Return true if a Geometry is simple
ST_IsValid	Return true if the Geometry is valid
ST_IsValidDetail	Return a valid detail as an array of objects
ST_IsValidReason	Return text stating if a geometry is valid or not and if not valid, a reason why
ST_MemSize	Returns the amount of memory space (in bytes) taken by the geometry
ST_NPoints	Return the number of points in a Geometry
ST_NumGeometries	Return the number of Geometries in a GEOMETRYCOLLECTION
ST_NumInteriorRing	Alias for ST_NumInteriorRings
ST_NumInteriorRings	Return the number of interior rings of a Geometry
ST_NumPoints	Return the number of points in a Linestring
ST_PointN	Return the nth point of a LINESTRING
ST_PointOnSurface	Return an interior or boundary point of a Geometry
ST_SRID	Return a SRID value
ST_StartPoint	Return the first coordinate of a LINESTRING
ST_X	Return the x-value of the first coordinate of a Geometry
ST_XMax	Return the maximum x-value of a Geometry
ST_XMin	Return the minimum x-value of a Geometry
ST_Y	Return the y-value of the first coordinate of a Geometry
ST_YMax	Return the maximum y-value of a Geometry
ST_YMin	Return the minimum y-value of a Geometry