[postgis-users] I need to select all featcher touch one polygon (eehab hamzeh)

eehab hamzeh eehab40 at hotmail.com
Fri Aug 8 01:36:10 PDT 2008

Hello every body,

can any body help me to write sql statment that select all the polygons that touch polygons in the same feature class.
i try to do it in as below and find all polygon that are within 100 m from the polygon 2.

SELECT the_geom FROM "public"."IGFPLAN"
WHERE "Id" = '2' and distance(the_geom, the_geom) < 100



Explore the seven wonders of the world
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080808/2c449c52/attachment.html>

More information about the postgis-users mailing list