Re: [postgis-users] Finding polygones with 'holes' inside

2008-07-17 Thread Stephan Holl
half Of > Stephan Holl > Sent: Thursday, July 10, 2008 8:06 AM > To: postgis-users@postgis.refractions.net > Subject: [postgis-users] Finding polygones with 'holes' inside > > Hi, > > I like to accomplish the task of finding polygons with holes inside > (the table is a MULTIP

RE: [postgis-users] Finding polygones with 'holes' inside

2008-07-10 Thread Obe, Regina
TECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephan Holl Sent: Thursday, July 10, 2008 8:06 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] Finding polygones with 'holes' inside Hi, I like to accomplish the task of finding polygons with holes inside (the table is a M

[postgis-users] Finding polygones with 'holes' inside

2008-07-10 Thread Stephan Holl
Hi, I like to accomplish the task of finding polygons with holes inside (the table is a MULTIPOLYGON). I tried to use ST_nrings, but I am not sure it this always only finds polygons with wholes inside or also islands, which should be also rings by definition. So a SELECT gid, name FROM table W