[postgis-users] brake MPolygon to polygons

[Nicklas Avén]

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 asselect (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 helpsNicklas 

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100201/08fd74d7/attachment.html>