<!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 content="MSHTML 6.00.2900.2180" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi, Fred </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I tested your solution but as you can see en the
picture , only select a few interior parcels , My question is </FONT></DIV>
<DIV><FONT face=Arial size=2>Why Do not select the other interior
parcels?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Salas </FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<TABLE width="100%" border=0>
<TBODY>
<TR>
<TD width="5%" rowSpan=2><IMG height=42
src="cid:007001ca7f39$ce9e8880$3998a8c0@deltha" width=45></TD>
<TD width="95%" height=21><SPAN class=style3>MSc Francisco D. Salas
Rosette</SPAN></TD></TR>
<TR>
<TD vAlign=top height=22><SPAN class=style3>Director Agencia I+D Aplicado
a la Geomática </SPAN></TD></TR></TBODY></TABLE></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=lehodey@gmail.com href="mailto:lehodey@gmail.com">Fred Lehodey</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users
Discussion</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, December 11, 2009 9:58
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [postgis-users] how obtain
the interior parcels</DIV>
<DIV><BR></DIV>Hi Salas,<BR>not sure this is the better way, but.. ;-)<BR>...
(you need POLYGONs, use ST_Dump() if MULTIPOLYGONs)<BR><BR>you can try
something like this:<BR><BR>SELECT ST_InteriorRingN((the_geom),s) <BR>FROM
your_parcels , generate_series(1,(SELECT max(ST_NumInteriorRing(the_geom))
FROM your_parcels)) s<BR> WHERE ST_NumInteriorRing(the_geom) >
0<BR>AND ST_InteriorRingN(the_geom,s) IS NOT
NULL<BR><BR><BR>Fred...<BR><BR><BR><BR>
<DIV class=gmail_quote>On Thu, Dec 10, 2009 at 8:13 PM, Fsalas <SPAN
dir=ltr><<A
href="mailto:fsalas@geocuba.cu">fsalas@geocuba.cu</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV><FONT style="FONT-SIZE: 10pt; FONT-FAMILY: tahoma">
<DIV>Thanks , Fred.</DIV>
<DIV> </DIV>
<DIV>Yes, I need the list of island polygons i use the
<SPAN>ST_NumInteriorRings(), ... but only obtain the number , and i need
obtain the list of feature island.</SPAN> </DIV>
<DIV><SPAN></SPAN> </DIV>
<DIV><SPAN>How resolve this?</SPAN></DIV>
<DIV><SPAN></SPAN> </DIV>
<DIV><SPAN>regards , salas</SPAN></DIV>
<DIV><BR> </DIV></FONT>
<DIV>
<DIV></DIV>
<DIV class=h5><BR>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(0,0,0) 2px solid; MARGIN-RIGHT: 0px">-----Original
Message-----<BR>From: Fred Lehodey <<A href="mailto:lehodey@gmail.com"
target=_blank>lehodey@gmail.com</A>><BR>To: PostGIS Users Discussion
<<A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A>><BR>Date: Thu,
10 Dec 2009 19:48:17 +0000<BR>Subject: Re: [postgis-users] how obtain the
interior parcels<BR><BR>Hi Salas,<BR>are "interior parcels" islands ?<BR>
<DL>
<DT><SPAN>ST_NumInteriorRings(geometry)</SPAN>
<DD>
<DIV>Return the number of interior rings of the first polygon in the
geometry. Return NULL if there is no polygon in the geometry.</DIV>
<DT><SPAN>ST_NumInteriorRing(geometry)</SPAN>
<DD>
<DIV>Synonym to NumInteriorRings(geometry). The OpenGIS specs are
ambiguous about the exact function naming, so we provide both
spellings.</DIV>
<DT><SPAN>ST_InteriorRingN(geometry,integer)</SPAN>
<DD>
<DIV>Return the N'th interior ring of the polygon geometry. Return NULL
if the geometry is not a polygon or the given N is out of range.</DIV>
<DT><BR></DT></DL>Fred.<BR><BR><BR>
<DIV class=gmail_quote>On Thu, Dec 10, 2009 at 7:35 PM, Fsalas <SPAN
dir=ltr><<A href="mailto:fsalas@geocuba.cu"
target=_blank>fsalas@geocuba.cu</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV><FONT style="FONT-SIZE: 10pt; FONT-FAMILY: tahoma">
<DIV>Hi, </DIV>
<DIV>I have a table parcels , and I need obtain the list of the only
interior parcels, the parcels is not overlap.</DIV>
<DIV>I test ST_Contains(), ST_Intersects() but the result is not
correct.</DIV>
<DIV> </DIV>
<DIV>Salas.</DIV></FONT></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></DIV></DIV></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR></BLOCKQUOTE></DIV><BR>
<P>
<HR>
<P></P>_______________________________________________<BR>postgis-users
mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></BLOCKQUOTE></BODY></HTML>