Re: [postgis-users] Intersection of three polygons

2017-02-22 Thread Giuseppe Broccolo
Hi Saranya, 2017-02-21 10:51 GMT+01:00 Saranya Kuniyil : > Hai, > yes. I am interested to retrieve all polygons which intersects any one > among three categories.. > In the above example, > 1)POLYGON((0 0,0 1,1 1,1 0,0 0)) filename as part1 > POLYGON((0 0,0 2,2 2,2 0,0

Re: [postgis-users] Intersection of three polygons

2017-02-21 Thread Saranya Kuniyil
Hai, yes. I am interested to retrieve all polygons which intersects any one among three categories.. In the above example, 1)POLYGON((0 0,0 1,1 1,1 0,0 0)) filename as part1 POLYGON((0 0,0 2,2 2,2 0,0 0)) filename as part2 POLYGON((0 0,0 3,3 3,3 0,0 0)) filename as part3 >From these polygons

Re: [postgis-users] Intersection of three polygons

2017-02-20 Thread Giuseppe Broccolo
Hi Saranya, 2017-02-20 5:57 GMT+01:00 Saranya Kuniyil : > >> 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

Re: [postgis-users] Intersection of three polygons

2017-02-20 Thread Saranya Kuniyil
For example: POLYGON((0 0,0 1,1 1,1 0,0 0)) filename as part1 POLYGON((0 0,0 3,3 3,3 0,0 0)) filename as part1 POLYGON((0 0,0 2,2 2,2 0,0 0)) filename as part2 POLYGON((0 0,0 5,5 5,5 0,0 0)) filename as part2 POLYGON((0 0,0 3,3 3,3 0,0 0)) filename as part3 POLYGON((0 0,0 4,4 4,4 0,0 0))

Re: [postgis-users] Intersection of three polygons

2017-02-20 Thread Rémi Cura
Hey, 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 ...). Cheers, Rémi-C 2017-02-20 5:57 GMT+01:00 Saranya Kuniyil : > Hi all, > I am new

[postgis-users] Intersection of three polygons

2017-02-19 Thread Saranya Kuniyil
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