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

[Nathaniel Clay]

Hi all,

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!!

Thanks,

Nathaniel Hunter Clay
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.dbf
Type: application/x-dbf
Size: 32910 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130823/61b9fd00/attachment.bin>
-------------- next part --------------
PROJCS["NAD_1983_UTM_Zone_17N",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137,298.257222101]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",-81],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["Meter",1]]
-------------- next part --------------
PROJCS["NAD83 / UTM zone 17N",GEOGCS["NAD83",DATUM["North_American_Datum_1983",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6269"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4269"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",-81],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","26917"]]
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.shp
Type: application/x-esri-shape
Size: 1404836 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130823/61b9fd00/attachment-0001.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.shx
Type: application/x-esri-shape
Size: 332 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130823/61b9fd00/attachment-0002.bin>