<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META name=GENERATOR content="MSHTML 8.00.7600.16671"></HEAD>
<BODY>
<DIV><FONT color=#0000ff size=2 face=Arial><SPAN class=635574512-28102010>You
could try making a polygon out of the interior ring and using that with a within
or contains:</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><SPAN
class=635574512-28102010></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><SPAN
class=635574512-28102010>st_buildarea(st_interiorringn(geometryn(geom,1),1))</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><SPAN
class=635574512-28102010></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><SPAN
class=635574512-28102010>-Eric</SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV dir=ltr class=OutlookMessageHeader align=left><FONT size=2
face=Tahoma>-----Original Message-----<BR><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net]<B>On Behalf Of
</B>Andrea Peri<BR><B>Sent:</B> Thursday, October 28, 2010 6:07
AM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> [postgis-users]
Selecting polygons circled by one only
polygons<BR><BR></FONT></DIV>Hi,<BR><BR>I have a table of polygon where every
polygon can be holed.<BR>And in the hole can be inside another polygon
(another record of the table, no multipolygons).<BR><BR>I need to detect all
the polygon that are inside a hole of another polygon.<BR><BR>Initially I
think this was easy but<BR>after some test I notice this is not so easy
because the polygon inside the hole is formerly disjoint from the polygon with
hole.<BR><BR>For more example I don't search the polygon that are full circled
by more than 1 polygon, but only the polygon circled by 1 only
polygon<BR><BR>There is some method to detect this type of situations
?<BR><BR><BR>Thx,<BR><BR>Andrea peri.<BR><BR>--
<BR>-----------------<BR>Andrea Peri<BR>. . . . . . . . . <BR>qwerty
אטלעש<BR>-----------------<BR><BR></BLOCKQUOTE></BODY></HTML>