[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

Re: [postgis-users] Geography point to polygon st_distance for a polygon crossing the equator

2017-02-19 Thread Sebastien Delaux
Thanks for your reply Paul. Yes, that's what I thought. That would explain why (0,-82) is inside the polygon. Nevertheless, if my first segment runs through the south pole, then I would expect both of the queries mentioned in my initial post to return 0 which is not the case. Sebastien On Mon, Fe

Re: [postgis-users] Geography point to polygon st_distance for a polygon crossing the equator

2017-02-19 Thread Paul Ramsey
I don't the polygon you've draw means what you think it does. POLYGON((-90 -80, 90 -80, 90 10, -90 10, -90 -80)) For example, you probably figure the first segment, -90 -80, 90 -80 runs east-west between two points close to the south pole. In fact, it runs directly over the south pole, so actuall

[postgis-users] Geography point to polygon st_distance for a polygon crossing the equator

2017-02-19 Thread Sebastien Delaux
Hi all, I am new to postgis and I am interested in finding all the points that are located at x metres or less of a polygon that are stored in my postgres database. As I am working with data located all over the world and want to work with distances in metres I decided to use the geography type.