ST_Distance
This section contains reference documentation for the ST_Distance function.
For geometry type, returns the 2-dimensional cartesian minimum distance (based on spatial ref) between two geometries in projected units. For geography, returns the great-circle distance in meters between two SphericalGeography points. Note that g1, g2 shall have the same type.
ST_Distance(geography/geometry, geography/geometry)
select group_city,
STASTEXT(location) AS locationString,
ST_Distance(location, ST_POINT(2.154007,41.390205, 1)) AS distanceInMetres
from meetupRsvp
LIMIT 1
group_city | locationString | distanceInMetres |
|---|---|---|
Madrid | POINT (-3.71 40.42) | 504376.5534398629 |
Last modified 1yr ago