<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=833541114-16092008><FONT face=Arial
color=#0000ff size=2>First thing that comes to mind to me is string the
centroids together.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=833541114-16092008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=833541114-16092008><FONT face=Arial
color=#0000ff size=2>Something like</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=833541114-16092008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=833541114-16092008><FONT face=Arial
color=#0000ff size=2>SELECT gid, ST_MakeLine(ST_Centroid(the_geom)) As
arc</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=833541114-16092008><FONT face=Arial
color=#0000ff size=2>FROM (SELECT gid, (ST_Dump(the_geom)).geom As
the_geom</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN
class=833541114-16092008>
<FONT face=Arial color=#0000ff size=2>FROM multipolytable</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=833541114-16092008><FONT face=Arial
color=#0000ff size=2>) As foo</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=833541114-16092008><FONT face=Arial
color=#0000ff size=2>GROUP BY gid</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=833541114-16092008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=833541114-16092008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=833541114-16092008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>erik<BR><B>Sent:</B> Tuesday, September 16, 2008 9:06 AM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> [postgis-users] visually linking the
polygons of multipolygon layer<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>Hi,<BR><BR>I'm not sure I know how to formulate this<BR>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.<BR><BR>Is this possible, is there some predefined function
that could accomplish this?<BR><BR>Many
thanks,<BR><BR>Erik<BR></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>