[postgis-users] Re: POLYGON from MULTIPOLYGON

[Dylan Lorimer]

Well,

I realize 'Polygonize' isn't the right function, but I'm still stuck
figuring out which is correct. Any ideas?
Cheers,
dylan

On 11/15/06, Dylan Lorimer <edylan at google.com> wrote:
>
> 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
>



-- 
E. Dylan Lorimer | Google Earth Enterprise
650.253.2459 (O) | 650.862.6810 (M) | 650.644.0182 (F)
--------------------------------------------------------------------------------
Earth Enterprise Support: fusion at google.com | 866.4GO.OGLE ext. 4
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061115/94a6e533/attachment.html>