[postgis-users] Intersection of three polygons

Rémi Cura remi.cura at gmail.com
Mon Feb 20 01:42:12 PST 2017

sorry to say it's very difficult to understand what you want to do.
Please either do a schema or a precise description (with math: you have
setA, set B, setC , and you want to find ...).

2017-02-20 5:57 GMT+01:00 Saranya Kuniyil <saranyak578 at gmail.com>:

> Hi all,
> I am new to postgis and I need to find intersection of three polygons.
> In my table named "mytable" contains large no of polygon coordinates and
> grouped into three categories by adding a field called "filename".I
> labelled the category names as part1, part2, part3 in filename . Now I need
> to find all polygon which spacially intersect in three categories.
> I write my code as:
>  SELECT ST_Intersection(a.geom, b.geom) as intersect_ab
> FROM mytable a INNER JOIN mytable b ON ST_Intersects(a.geom,b.geom) INNER
> JOIN mytable c ON ST_Intersects(a.geom,c.geom)
> WHERE ST_Overlaps(a.geom, b.geom) AND ST_Overlaps(b.geom, c.geom) AND
> ST_Overlaps(a.geom, c.geom) AND ST_isvalid(a.geom)='t' AND
> ST_isvalid(b.geom)='t' AND ST_isvalid(c.geom)='t' AND a.filename = 'part1'
>    AND b.filename = 'part2' AND c.filename = 'part3') ;
> Is it correct?????
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170220/c6248d73/attachment.html>

More information about the postgis-users mailing list