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_ANGLE
ST_ANGLE(startPoint, midPoint, endPoint, mercator)
Description
Finds the angle formed by two adjacent segments defined by 3 points. The result will be the (positive clockwise) angle with origin on the startPoint-midPoint segment, or its explementary angle if required.
startPoint: GEOGRAPHY start Point Coordinates.
midPoint: GEOGRAPHY mid Point Coordinates.
endPoint: GEOGRAPHY end Point Coordinates.
mercator: BOOLEAN|NULL if calculations should be performed over Mercator or WGS84 projection. If NULL the default value false is used.
Return type
FLOAT64
Example
carto-un
carto-un-eu
carto-os
manual
SELECT `carto-un`.carto.ST_ANGLE(ST_GEOGPOINT(-3.70325 ,40.4167), ST_GEOGPOINT(-4.70325 ,10.4167), ST_GEOGPOINT(-5.70325 ,40.4167), false);
-- 3.933094586038578
SELECT `carto-un-eu`.carto.ST_ANGLE(ST_GEOGPOINT(-3.70325 ,40.4167), ST_GEOGPOINT(-4.70325 ,10.4167), ST_GEOGPOINT(-5.70325 ,40.4167), false);
-- 3.933094586038578
SELECT `carto-os`.carto.ST_ANGLE(ST_GEOGPOINT(-3.70325 ,40.4167), ST_GEOGPOINT(-4.70325 ,10.4167), ST_GEOGPOINT(-5.70325 ,40.4167), false);
-- 3.933094586038578
SELECT carto.ST_ANGLE(ST_GEOGPOINT(-3.70325 ,40.4167), ST_GEOGPOINT(-4.70325 ,10.4167), ST_GEOGPOINT(-5.70325 ,40.4167), false);
-- 3.933094586038578
ST_MINKOWSKIDISTANCE
ST_MINKOWSKIDISTANCE(geog, p)
Description
Calculate the Minkowski p-norm distance between two features.
geog: ARRAY<GEOGRAPHY> featureCollection.
p: FLOAT64 minkowski p-norm distance parameter. 1: Manhattan distance. 2: Euclidean distance. 1 =< p <= infinity. If NULL the default value 2 is used.
Return type
ARRAY<STRING>
Example
carto-un
carto-un-eu
carto-os
manual
SELECT `carto-un`.carto.ST_MINKOWSKIDISTANCE([ST_GEOGPOINT(10,10),ST_GEOGPOINT(13,10)],2);
-- ["0,0.3333333333333333","0.3333333333333333,0"]
SELECT `carto-un-eu`.carto.ST_MINKOWSKIDISTANCE([ST_GEOGPOINT(10,10),ST_GEOGPOINT(13,10)],2);
-- ["0,0.3333333333333333","0.3333333333333333,0"]
SELECT `carto-os`.carto.ST_MINKOWSKIDISTANCE([ST_GEOGPOINT(10,10),ST_GEOGPOINT(13,10)],2);
-- ["0,0.3333333333333333","0.3333333333333333,0"]
SELECT carto.ST_MINKOWSKIDISTANCE([ST_GEOGPOINT(10,10),ST_GEOGPOINT(13,10)],2);
-- ["0,0.3333333333333333","0.3333333333333333,0"]
​
This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 960401.
lds
placekey
Last modified 1mo ago