[postgis-users] select the interior parcels smaller than 25 hectares
fsalas
fsalas at geocuba.cu
Tue Dec 29 13:11:13 PST 2009
Hi,
I used this SQL for select the interior parcels and obtained all interior
parcels on the map..
SELECT ST_InteriorRingN((the_geom),s)
FROM datnivel3, generate_series(1,(SELECT max(ST_NumInteriorRing(the_geom))
FROM datnivel3)) s
WHERE ST_NumInteriorRing(the_geom) > 0
AND ST_InteriorRingN(the_geom,s) IS NOT NULL
.However, I need select from "datnivel3" table, only the parcels smaller
than 25 hectares,
How can I implement this?
Thank you,
Salas
More information about the postgis-users
mailing list