[postgis-users] Detecting holes in geometries

[Barend K=?ISO-8859-1?B?9g==?=bben]

 SELECT AsText(InteriorRingN(geom),1) AS geometryOfHole from areas

Would get you the geometry of the 1st hole as OGC Well-Known Text...


__ 
Barend Köbben
International Institute for Geo-information
Sciences and Earth Observation (ITC)
PO Box 6, 7500AA Enschede (The Netherlands)
ph: +31 (0)53 4874253; fax: +31 (0)53 4874335


On 24-08-2007 10:15, "Thorsten Kraus" <Thorsten.Kraus at ptv.de> wrote:

> Hello,
> 
> I am able to detect the number of holes in a geometry with the following sql
> statement:
> 
> SELECT SUM(NumInteriorRings(geom)) AS countHoles from areas
> 
> Is there any possibility to get the position where the holes are?
> Regards,
> Thorsten
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users