Spatial Relationships


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

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 April 06, 2022 at 10:08 AM EST: Initial Documentation Commit (371ae8f)