ST_GeometricMedian — Returns the geometric median of a MultiPoint.

`geometry `

geometry **ST_GeometricMedian** (`geom`, float8 `tolerance = NULL`, int `max_iter = 10000`, boolean `fail_if_not_converged = false``)`

;

Computes the approximate geometric median of a MultiPoint geometry using the Weiszfeld algorithm. The geometric median is the point minimizing the sum of distances to the input points. It provides a centrality measure that is less sensitive to outlier points than the centroid (center of mass).

The algorithm iterates until the distance change between successive iterations is less than the supplied `tolerance`

parameter. If this condition has not been met after `max_iterations`

iterations, the function produces an error and exits, unless `fail_if_not_converged`

is set to `false`

(the default).

If a `tolerance`

argument is not provided, the tolerance value is calculated based on the extent of the input geometry.

If present, the input point M values are interpreted as their relative weights.

Availability: 2.3.0

Enhanced: 2.5.0 Added support for M as weight of points.

Questa funzione supporta il 3d e non distrugge gli z-index.

Questa funzione supporta le coordinate M.

WITH test AS ( SELECT 'MULTIPOINT((10 10), (10 40), (40 10), (190 190))'::geometry geom) SELECT ST_AsText(ST_Centroid(geom)) centroid, ST_AsText(ST_GeometricMedian(geom)) median FROM test; centroid | median --------------------+---------------------------------------- POINT(62.5 62.5) | POINT(25.01778421249728 25.01778421249728) (1 row)