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
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
