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 ST_MakePoint(median(ST_X(geom)), median(ST_Y(geom))) as my_median_point FROM my_table Cheers, Rémi-C 2015-03-12 14:56 GMT+01:00 steve.tout...@inspq.qc.ca: 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 much experience doing that, so any tips on how to do that well would be appreciated Thanks in advace for your help! ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] median center instead of st_centroid
Wow merci Remi. That saves me a lot of coding... Rémi Cura remi.c...@gmail.com@lists.osgeo.org Envoyé par : postgis-users-boun...@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 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 --not tested SELECT ST_MakePoint(median(ST_X(geom)), median(ST_Y(geom))) as my_median_point FROM my_table Cheers, Rémi-C 2015-03-12 14:56 GMT+01:00 steve.tout...@inspq.qc.ca: 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 much experience doing that, so any tips on how to do that well would be appreciated Thanks in advace for your help! ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] median center instead of st_centroid
De rien lointain cousin du Québec ;-) Rémi-C 2015-03-12 19:43 GMT+01:00 steve.tout...@inspq.qc.ca: Wow merci Remi. That saves me a lot of coding... *Rémi Cura remi.c...@gmail.com remi.c...@gmail.com@lists.osgeo.org http://lists.osgeo.org* Envoyé par : postgis-users-boun...@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 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 ST_MakePoint(median(ST_X(geom)), median(ST_Y(geom))) as my_median_point FROM my_table Cheers, Rémi-C 2015-03-12 14:56 GMT+01:00 *steve.tout...@inspq.qc.ca* steve.tout...@inspq.qc.ca: 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* 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 much experience doing that, so any tips on how to do that well would be appreciated Thanks in advace for your help! ___ postgis-users mailing list *postgis-users@lists.osgeo.org* postgis-users@lists.osgeo.org *http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users* http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users