Re: [postgis-users] service areas ( I want a polygon of the areas that only have one provider)

2013-08-31 Thread Nicolas Ribot
Hi, If it is the first case your dataset does not contain such polygons. You could identify polygons with no overlapping with others with a query: select gid from test t where not exists ( select 1 from test t1 where t1.gid t.gid and st_intersects(t1.geom, t1.geom) ); If it is

Re: [postgis-users] service areas ( I want a polygon of the areas that only have one provider)

2013-08-30 Thread BladeOfLight16
On Fri, Aug 23, 2013 at 5:30 AM, Nathaniel Clay clay.nathan...@gmail.comwrote: I have a table of polygons that overlap with each other, I need the polygon of the areas that only have one provider eg do not overlap. Please find attached the shape file. Any help would be greatly appreciated!!