Product Solutions Support
Try MemSQL

GEOGRAPHY_WITHIN_DISTANCE

This function takes in two geospatial objects and determines whether any part of them is within the given distance, in meters.

image

Syntax

GEOGRAPHY_WITHIN_DISTANCE ( geo1, geo2, meters )

Arguments

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.

memsql> select name from neighborhoods where
GEOGRAPHY_WITHIN_DISTANCE("POINT(-73.94990499 40.69150746)", shape, 10000);

memsql> select name from neighborhoods where
GEOGRAPHY_DISTANCE("POINT(-73.94990499 40.69150746)", shape) <= 10000;
Was this article useful?