Spatial_Table.st_distance
st_distancefrom_columnto_columnas
Group: Calculations
Documentation
Gets the distance between two spatial objects on each row. Note this will be the distance in the coordinate system of the spatial objects, i.e. for WGS84 coordinates this will be in degrees. For distance in metres use st_length.
Arguments
from_column: The column, expression, or name/index of the column containing the starting spatial objects.end_column: The column, expression, or name/index of the column containing the ending spatial objects.
Returns
A new table with the existing columns and a new column containing the distance.