Thanks to all. I used Regina's solution (fastest trigger). But instead of making a linked line from one polygon to another, I asked the polygons centroids to link to the initial multipolygon centroid.
Cheers On Tue, Sep 16, 2008 at 4:53 PM, Fred Lehodey <[EMAIL PROTECTED]> wrote: > Hi Erik, > > > SELECT gid, ST_ConvexHull(ST_Collect(pts)) FROM (SELECT gid, > ST_PointOnSurface((ST_dump(geometry)).geom) AS pts FROM yourTable) AS foo > GROUP BY gid > > Fred. > > > On Tue, Sep 16, 2008 at 2:06 PM, erik <[EMAIL PROTECTED]> wrote: > >> Hi, >> >> I'm not sure I know how to formulate this >> I have a set of Multipolygons. I'd like to link somehow the polygons of >> each multipolygon with a "string", an arc, that expresses their belonging >> to the same polygon. >> >> Is this possible, is there some predefined function that could accomplish >> this? >> >> Many thanks, >> >> Erik >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
<<attachment: test.png>>
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
