func.ST_Zmflag
Returns a code indicating the ZM coordinate dimension of a geometry
Geometry Accessors
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 March 11, 2024 at 3:25 PM EST: Creation of the expression expression library (3110a17)