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(geog [, p])
Description
Calculate the Minkowski p-norm distance between two features.
geojsons:ARRAYarray of features in GeoJSON format casted to STRING.p(optional):FLOAT64minkowski p-norm distance parameter. 1: Manhattan distance. 2: Euclidean distance. 1 =< p <= infinity. By defaultpis2.
Return type
ARRAYExamples
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 ] ]
Additional examples
Last modified 6mo ago