[postgis-users] median center instead of st_centroid

Hi, I used st_centroid on a multipoint table to get the mean center. I would like to compare the result on the median center http://en.wikipedia.org/wiki/Center_of_population#Mean_center Is there already an operator in postgis that does that? Otherwise I would like to write one, but I don't have

Re: [postgis-users] median center instead of st_centroid

Hey, what you want is extremely easy to get. First add the median function to your database from here https://wiki.postgresql.org/wiki/Aggregate_Median (Now you have access to median(numeric) ) Then, for a table my_table containing points in the geom column --not tested SELECT

Re: [postgis-users] median center instead of st_centroid

@lists.osgeo.org cc Objet Re: [postgis-users] median center instead of st_centroid Hey, what you want is extremely easy to get. First add the median function to your database from here (Now you have access to median(numeric) ) Then, for a table my_table containing points in the geom column

Re: [postgis-users] median center instead of st_centroid

...@lists.osgeo.org 2015-03-12 12:42 Veuillez répondre à PostGIS Users Discussion postgis-users@lists.osgeo.org A PostGIS Users Discussion postgis-users@lists.osgeo.org cc Objet Re: [postgis-users] median center instead of st_centroid Hey, what you want is extremely easy to get. First add