func.ST_PointInsideCircle
Returns true if the geometry is a point and is inside the circle with center center_x,center_y and radius radius
Spatial Relationships
func.ST_DWithin
Returns true if the geometries are within a given distance
func.ST_DFullyWithin
Returns true if the geometries are entirely within the specified distance of one another
func.ST_Within
Returns TRUE if geometry A is completely inside geometry B
func.ST_Touches
Returns TRUE if the only points in common between g1 and g2 lie in the union of the boundaries of g1 and g2
func.ST_RelateMatch
Tests if a Dimensionally Extended 9-Intersection Model (DE-9IM) intersectionMatrix value satisfies an intersectionMatrixPattern
func.ST_Relate
These functions allow testing and evaluating the spatial (topological) relationship between two geometries
func.ST_OrderingEquals
Compares two geometries and returns it (TRUE) if the geometries are equal and the coordinates are in the same order
func.ST_Overlaps
Returns TRUE if the Geometries "spatially overlap"
func.ST_Intersects
If a geometry or geography shares any portion of space then they intersect
func.ST_Equals
Returns TRUE if the given Geometries are "spatially equal"
func.ST_Disjoint
Overlaps, Touches, Within imply geometries are not spatially disjoint, unless they return true, then they are not spatially disjoint
func.ST_LineCrossingDirection
Given 2 linestrings, returns an integer between -3 and 3 indicating what kind of crossing behavior exists between them
func.ST_3DDWithin
For geometry type returns true if the 3d distance between two objects is within distance_of_srid specified projected units
func.ST_Crosses
Takes two geometry objects and returns TRUE if their intersection "spatially cross", but not all interior points in common
func.ST_3DDFullyWithin
Returns true if the 3D geometries are fully within the specified distance of one another
func.ST_CoveredBy
Returns 1 (TRUE) if no point in Geometry/Geography A is outside Geometry/Geography B
func.ST_ContainsProperly
Returns true if B intersects the interior of A but not the boundary (or exterior)
func.ST_Covers
Returns 1 (TRUE) if no point in Geometry/Geography B is outside Geometry/Geography A
func.ST_Contains
Geo 'A' contains Geo 'B' ONLY IF no points of B lie in the exterior of A, and at least one point of B interior lies in A interior
func.ST_3DIntersects
Overlaps, Touches, Within all imply spatial intersection and if any returns true, then the geometries also spatially intersect
Last modified March 11, 2024 at 3:25 PM EST: Creation of the expression expression library (3110a17)