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

Obe, Regina robe.dnd at cityofboston.gov
Tue Sep 16 07:15:43 PDT 2008


First thing that comes to mind to me is string the centroids together.
 
Something like
 
SELECT gid, ST_MakeLine(ST_Centroid(the_geom)) As arc
FROM (SELECT gid, (ST_Dump(the_geom)).geom As the_geom
                FROM multipolytable
) As foo
GROUP BY gid
 
Hope that helps,
Regina

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of erik
Sent: Tuesday, September 16, 2008 9:06 AM
To: PostGIS Users Discussion
Subject: [postgis-users] visually linking the polygons of multipolygon
layer


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



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080916/64ffa66a/attachment.html>


More information about the postgis-users mailing list