[postgis-users] visually linking the polygons of multipolygon layer

erik whatevar89 at gmail.com
Tue Sep 16 08:20:07 PDT 2008


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 <lehodey at gmail.com> 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 <whatevar89 at gmail.com> 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
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080916/2ae53ade/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.png
Type: image/png
Size: 27494 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080916/2ae53ade/attachment.png>


More information about the postgis-users mailing list