Dear Salas,
What is your definition of interior?
From the picture, it looks as if all your interior parcels
are selected (shown in purple). Could you point out any
interior parcels that are not selected?
Håvard
fsalas wrote:
Hi, Fred
I tested your solution but as you can see en the picture , only select a
few interior parcels , My question is
Why Do not select the other interior parcels?
Thanks
Salas
MSc Francisco D. Salas Rosette
Director Agencia I+D Aplicado a la Geomática
----- Original Message -----
*From:* Fred Lehodey <mailto:[email protected]>
*To:* PostGIS Users Discussion
<mailto:[email protected]>
*Sent:* Friday, December 11, 2009 9:58 AM
*Subject:* Re: [postgis-users] how obtain the interior parcels
Hi Salas,
not sure this is the better way, but.. ;-)
... (you need POLYGONs, use ST_Dump() if MULTIPOLYGONs)
you can try something like this:
SELECT ST_InteriorRingN((the_geom),s)
FROM your_parcels , generate_series(1,(SELECT
max(ST_NumInteriorRing(the_geom)) FROM your_parcels)) s
WHERE ST_NumInteriorRing(the_geom) > 0
AND ST_InteriorRingN(the_geom,s) IS NOT NULL
Fred...
On Thu, Dec 10, 2009 at 8:13 PM, Fsalas <[email protected]
<mailto:[email protected]>> wrote:
Thanks , Fred.
Yes, I need the list of island polygons i use the
ST_NumInteriorRings(), ... but only obtain the number , and i
need obtain the list of feature island.
How resolve this?
regards , salas
-----Original Message-----
From: Fred Lehodey <[email protected]
<mailto:[email protected]>>
To: PostGIS Users Discussion
<[email protected]
<mailto:[email protected]>>
Date: Thu, 10 Dec 2009 19:48:17 +0000
Subject: Re: [postgis-users] how obtain the interior parcels
Hi Salas,
are "interior parcels" islands ?
ST_NumInteriorRings(geometry)
Return the number of interior rings of the first polygon
in the geometry. Return NULL if there is no polygon in
the geometry.
ST_NumInteriorRing(geometry)
Synonym to NumInteriorRings(geometry). The OpenGIS specs
are ambiguous about the exact function naming, so we
provide both spellings.
ST_InteriorRingN(geometry,integer)
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.
Fred.
On Thu, Dec 10, 2009 at 7:35 PM, Fsalas <[email protected]
<mailto:[email protected]>> wrote:
Hi,
I have a table parcels , and I need obtain the list of
the only interior parcels, the parcels is not overlap.
I test ST_Contains(), ST_Intersects() but the result is
not correct.
Salas.
_______________________________________________
postgis-users mailing list
[email protected]
<mailto:[email protected]>
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
<mailto:[email protected]>
http://postgis.refractions.net/mailman/listinfo/postgis-users
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
------------------------------------------------------------------------
--
Håvard Tveite
Department of Mathematical Sciences and Technology, UMB
Drøbakveien 31, POBox 5003, N-1432 Ås, NORWAY
Phone: +47 64965483 Fax: +47 64965401 http://www.umb.no/imt/
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
