ST_Collect worked for me.
I have a column of multipolygons. I can take the ST_Centroid of each
multipolygon and it produces a multipoint.
Don't have the SQL at hand, but it's something close to:
UPDATE table SET geom_multip=(SELECT
ST_Collect(ST_Centroid(geom_multipoly)) FROM table2 WHERE
ST_IsVa
:52
An: PostGIS Users Discussion
Betreff: [postgis-users] point to multipoint
hi, is someone out there who can explain how to make several points to a
multipoint.. i tried st_union and st_collect but what comes out is a
multilinestring and geometrycollection(string(..)) respectively.
code
hi, is someone out there who can explain how to make several points to a
multipoint.. i tried st_union and st_collect but what comes out is a
multilinestring and geometrycollection(string(..)) respectively.
code with which the unwilling multilinestring happens:
select astext(st_union(c.geom_4326)
.. don't ask why im not just using min(st_distance) to solve that nearest
thing problem :)
you should know that all the unioned points are having the same coordinates.
2009/11/26 Mehmet Sirin
> hi, is someone out there who can explain how to make several points to a
> multipoint.. i tried st_un