Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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.

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