[postgis-users] brake MPolygon to polygons

[Marko Čubranić]

thanks Nicklas,

2010/2/1 Nicklas Avén <nicklas.aven at jordogskog.no>

>  Hallo
>
> If I understand you right you have multipolygons representing countries
> that you want splitted to single polygons.
>
> That is no problem but they will not fit in the same table since you will
> get additional rows.
>
> If you want to make a new table with this country polygons as single
> polygons you can do
>
> create table single_polygon_countries as
> select (ST_Dump(the_geom)).geom as the_geom, countryID from
> original_country_table;
>
> I put countryID there, just to illustrate that you probably want to bring
> some id or name to the new table. That will be repeated for all single
> polygons from original multi polygon
>
> Hope that helps
> Nicklas
>
>
>
> 2010-02-01 Marko Èubraniæ wrote:
>
> Dear colleagues,
> >
> >if i have x Mpolygons in table (country) and i want to brake each of them
> in polygons, and put polygons in new columns, how should i do that?..
> >
> >thank you
> >
> >Marko Cubranic
> >
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100201/cd1671cf/attachment.html>