Outdated Version
You are viewing an older version of this section. View current production version.
GEOGRAPHY_DISTANCE
This function takes in two geospatial objects and measures the shortest distance between them, in meters, using the standard metric for distance on a sphere.
Syntax
GEOGRAPHY_DISTANCE ( geo1, geo2 )
Arguments
- geo1, geo2: any valid geospatial object or WKT string: path, point or polygon.
Return Type
A double. The measured distance, in meters.
Examples
select b.name as neighbor,
-> round(GEOGRAPHY_DISTANCE(a.shape, b.shape), 0) as distance_from_border
-> from neighborhoods a, neighborhoods b
-> where a.id = 2
-> order by 1;
+---------------------+----------------------+
| neighbor | distance_from_border |
+---------------------+----------------------+
| Probability Bay | 0 |
| Lower Bound Valley | 0 |
| Axiom Township | 0 |
| Elegant Island | 1935 |
| Upper Bound Hill | 5632 |
| Big Endian | 9016 |
| Little Endian | 17290 |
| Isle Zero | 17163 |
...
