[postgis-users] POLYGON from MULTIPOLYGON

Dylan Lorimer edylan at google.com
Wed Nov 15 14:43:00 PST 2006


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';
(1 row)

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

More information about the postgis-users mailing list