Outdated Version
You are viewing an older version of this section. View current production version.
GEOGRAPHY_WITHIN_DISTANCE
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
Info
The two queries below give equivalent results, but WITHIN_DISTANCE can take advantage of any spatial indexes on the columns for faster execution.
select name from neighborhoods where
GEOGRAPHY_WITHIN_DISTANCE("POINT(-73.94990499 40.69150746)", shape, 10000);
select name from neighborhoods where
GEOGRAPHY_DISTANCE("POINT(-73.94990499 40.69150746)", shape) <= 10000;
