[postgis-users] POLYGON from MULTIPOLYGON

[Dylan Lorimer]

Hi,

I loaded a shapefile of country boundaries into PostGIS using the shp2pgsql
loader. I see that the resulting geometry is a multipolygon. I need it as a
polygon, and considering there is only a single outer ring, this shouldn't
be a problem. But 'Polygonize' is returning a GeometryCollection, rather
than Polygon. Any ideas?

gnis2=#  select GeometryType(Polygonize(the_geom)) from gnis_country_view
where country_name='Canada';
    geometrytype
--------------------
 GEOMETRYCOLLECTION
(1 row)

Cheers,
-dylan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061115/8368fcaf/attachment.html>