Links

measurements

CORE
This module contains functions that compute measurements of distance, area and angles. There are also functions to compute geometry values determined by measurements.

ST_MINKOWSKIDISTANCE

ST_MINKOWSKIDISTANCE(geog [, p])
Description
Calculate the Minkowski p-norm distance between two features.
  • geojsons: ARRAY array of features in GeoJSON format casted to STRING.
  • p (optional): FLOAT64 minkowski p-norm distance parameter. 1: Manhattan distance. 2: Euclidean distance. 1 =< p <= infinity. By default p is 2.
Return type
ARRAY
Examples
SELECT CARTO.CARTO.ST_MINKOWSKIDISTANCE(
ARRAY_CONSTRUCT(
ST_ASGEOJSON(ST_POINT(10,10))::STRING,
ST_ASGEOJSON(ST_POINT(13,10))::STRING
)
);
-- [ [ 0, 3.333333333333333e-01 ], [ 3.333333333333333e-01, 0 ] ]
SELECT CARTO.CARTO.ST_MINKOWSKIDISTANCE(
ARRAY_CONSTRUCT(
ST_ASGEOJSON(ST_POINT(10,10))::STRING,
ST_ASGEOJSON(ST_POINT(13,10))::STRING
),
2
);
-- [ [ 0, 3.333333333333333e-01 ], [ 3.333333333333333e-01, 0 ] ]
Last modified 6mo ago