Geometry Accessors


func.ST_Zmflag

Returns a code indicating the ZM coordinate dimension of a geometry

func.ST_Z

Return the Z coordinate of the point, or NULL if not available. Input must be a point

func.ST_Y

Return the Y coordinate of the point, or NULL if not available. Input must be a point

func.ST_X

Return the X coordinate of the point, or NULL if not available. Input must be a point

func.ST_Summary

Returns a text summary of the contents of the geometry

func.ST_StartPoint

Returns the first point of a LINESTRING or CIRCULARLINESTRING geometry as a POINT

func.ST_PointN

Return the Nth point in a single linestring or circular linestring in the geometry

func.ST_PatchN

Returns the 1-based Nth geometry (face) if the geometry is a POLYHEDRALSURFACE or POLYHEDRALSURFACEM

func.ST_NumPoints

Return the number of points in an ST_LineString or ST_CircularString value

func.ST_NumPatches

Return the number of faces on a Polyhedral Surface

func.ST_NumInteriorRing

This function returns the number of interior rings of a polygon geom. It returns NULL if the geom is not a polygon.

func.ST_NumInteriorRings

Return the number of interior rings of a polygon geometry

func.ST_NumGeometries

Returns the number of Geometries

func.ST_NRings

If the geometry is a polygon or multi-polygon returns the number of rings

func.ST_NPoints

Return the number of points in a geometry

func.ST_NDims

Returns the coordinate dimension of the geometry

func.ST_MemSize

Returns the amount of memory space (in bytes) the geometry takes

func.ST_M

Return the M coordinate of a Point, or NULL if not available. Input must be a Point

func.ST_IsSimple

Returns true if this Geometry has no anomalous geometric points

func.ST_IsRing

Returns TRUE if this LINESTRING is both ST_IsClosed and ST_IsSimple (does not self intersect)

func.ST_IsCollection

Returns TRUE if the geometry type of the argument is a geometry collection type

func.ST_IsClosed

Returns TRUE if the LINESTRING's start and end points are coincident

func.ST_InteriorRingN

Returns the Nth interior linestring ring of the polygon geometry

func.ST_HasArc

Returns true if a geometry or geometry collection contains a circular string

func.ST_GeometryN

This section describes functions and operators for examining and manipulating string values

func.ST_ExteriorRing

Returns a line string representing the exterior ring of the POLYGON geometry

func.ST_Envelope

Returns the double-precision (float8) minimum bounding box for the supplied geometry, as a geometry

func.ST_BoundingDiagonal

Returns the diagonal of the supplied geometry's bounding box as a LineString

func.ST_EndPoint

Returns the last point of a LINESTRING as a POINT. Returns NULL if the input is not a LINESTRING

func.ST_DumpRings

This is a set-returning function (SRF). It returns a set of geometry_dump rows, as an integer and a geometry, aliased "path" and "geom"

func.ST_DumpPoints

This set-returning function (SRF) returns a set of geometry_dump rows formed by a geometry (geom) and an array of integers (path)

func.ST_Dump

This is a set-returning function (SRF). It returns a set of geometry_dump rows, formed by a geometry (geom) and an array of integers (path)

func.ST_Dimension

Return the topological dimension of this Geometry object, which must be less than or equal to the coordinate dimension

func.ST_CoordDim

Return the coordinate dimension of the ST_Geometry value

func.ST_Boundary

Returns the closure of the combinatorial boundary of this Geometry

func.ST_GeometryType

Returns the type of the geometry as a string. 'ST_LineString', 'ST_Polygon','ST_MultiPolygon'

func.ST_IsEmpty

Returns true if this Geometry is an empty geometry

Last modified April 06, 2022 at 10:08 AM EST: Initial Documentation Commit (371ae8f)