GEOGRAPHY_ WITHIN_ DISTANCE
On this page
This function takes in two geospatial objects and determines whether any part of them is within the given distance, in meters.
![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blta5eb22a73b0d4e0f/66db60fa82ccaf4e93802b7e/within_distance-N08WbC.png?width=850&disable=upscale&auto=webp)
Syntax
GEOGRAPHY_WITHIN_DISTANCE ( geo1, geo2, meters )
Arguments
-
geo1, geo2: any valid geospatial object or WKT string: path, point or polygon.
-
meters: the maximum range, in meters
Return Type
Boolean
Examples
Important
The two queries below give equivalent results, but WITHIN_
SELECT name FROM neighborhoods WHEREGEOGRAPHY_WITHIN_DISTANCE("POINT(-73.94990499 40.69150746)", shape, 10000);SELECT name FROM neighborhoods WHEREGEOGRAPHY_DISTANCE("POINT(-73.94990499 40.69150746)", shape) <= 10000;
Related Topics
For more information about working with geospatial data, see Working with Geospatial Features.
Last modified: June 29, 2022