Description | The |
Syntax | GEO_SPATIAL_DISTANCE( Geometry 1, Geometry 2 [unit]) |
Output | number |
Variables
geometry1: The first geometry in the distance calculation.
geometry2: The second geometry in the distance calculation.
unit (optional): The distance unit used for the calculation. Supported values are
miorkm
Example
GEO_SPATIAL_DISTANCE ('customer_location' , 'store_location' , 'mi')
Customer Location | Store Location | Geo Spatial Distance |
Point A | Point B | 5.71 |
Point C | Point B | 3.85 |
Point D | Point B | 4.92 |
