Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026.
We will start enforcing it in phases. For more information on the details of Python end of life
and migration options, see the
blog post
ST_DWithin
ST_DWithin returns true if the Euclidean distance between the 2D projections of the two input geometry values is not larger than a threshold value.
Syntax
ST_DWithin(geom1, geom2, threshold)
Arguments
- geom1
-
A value of data type
GEOMETRYor an expression that evaluates to aGEOMETRYtype. - geom2
-
A value of data type
GEOMETRYor an expression that evaluates to aGEOMETRYtype. - threshold
-
A value of data type
DOUBLE PRECISION. This value is in the units of the input arguments.
Return type
BOOLEAN
If geom1 or geom2 is null, then null is returned.
If threshold is negative, then an error is returned.
If geom1 and geom2 don't have the same value for the spatial reference system identifier (SRID), then an error is returned.
If geom1 or geom2 is a geometry collection, then an error is returned.
Examples
The following SQL checks if the distance between two polygons is within five units.
SELECT ST_DWithin(ST_GeomFromText('POLYGON((0 2,1 1,0 -1,0 2))'), ST_GeomFromText('POLYGON((-1 3,2 1,0 -3,-1 3))'),5);
st_dwithin
-----------
true