<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><br>Hi Gaurav,<br><br>You can try the following query,<br><br><pre class="programlisting">SELECT gid, ST_Collect(ST_ExteriorRing(the_geom)) AS erings
FROM (SELECT gid, (ST_Dump(the_geom)).geom As the_geom
FROM sometable) As foo
GROUP BY gid;
--3d Example
SELECT ST_AsEWKT(
ST_ExteriorRing(
ST_GeomFromEWKT('POLYGON((0 0 1, 1 1 1, 1 2 1, 1 1 1, 0 0 1))')
)
);<br><br>regards<br>- Imran<br></pre><br>--- On <b>Mon, 1/14/13, Gaurav Singh <i><singh09721@itc.nl></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Gaurav Singh <singh09721@itc.nl><br>Subject: [postgis-users] merging islands with state to create single multipoly geom<br>To: "postgis-users@postgis.refractions.net" <postgis-users@postgis.refractions.net><br>Cc: "postgis-users@lists.osgeo.org" <postgis-users@lists.osgeo.org><br>Date: Monday, January 14, 2013, 5:54 PM<br><br><div id="yiv92693965"><style><!--
#yiv92693965
_filtered #yiv92693965 {font-family:SimSun;panose-1:2 1 6 0 3 1 1 1 1 1;}
_filtered #yiv92693965 {font-family:SimSun;panose-1:2 1 6 0 3 1 1 1 1 1;}
_filtered #yiv92693965 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered #yiv92693965 {panose-1:2 1 6 0 3 1 1 1 1 1;}
#yiv92693965
#yiv92693965 p.yiv92693965MsoNormal, #yiv92693965 li.yiv92693965MsoNormal, #yiv92693965 div.yiv92693965MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";}
#yiv92693965 a:link, #yiv92693965 span.yiv92693965MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv92693965 a:visited, #yiv92693965 span.yiv92693965MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv92693965 span.yiv92693965EmailStyle17
{font-family:"Calibri", "sans-serif";color:windowtext;}
#yiv92693965 .yiv92693965MsoChpDefault
{font-family:"Calibri", "sans-serif";}
_filtered #yiv92693965 {margin:1.0in 1.0in 1.0in 1.0in;}
#yiv92693965 div.yiv92693965WordSection1
{}
--></style><div><div class="yiv92693965WordSection1"><p class="yiv92693965MsoNormal">Hi All,</p><p class="yiv92693965MsoNormal"> </p><p class="yiv92693965MsoNormal">I have a multipologon geometry of a state with islands as shown in attached Fig1 and I want to convert that state boundary by merging the islands and filling the gaps as shown in Fig2. Can someone please tell me how can I get the Fig2.</p><p class="yiv92693965MsoNormal"> </p><p class="yiv92693965MsoNormal">Thanks </p><p class="yiv92693965MsoNormal">Gaurav </p></div></div></div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@lists.osgeo.org" href="/mc/compose?to=postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users"
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></div></blockquote></td></tr></table>