If you are sure that all your polygons are in actuality single polygons (you can check using numgeometries()) you can just use geometryn(geom,1) to get the data as single polygon. Note that you likely have a constraint on your table that would have to be dropped to run that in an update.<br>
<br>You can always use the "-S" flag in shp2pgsql to bring in geoms as single geometries when importing too.<br><br>David<br><br><div class="gmail_quote">On Wed, Apr 16, 2008 at 2:07 PM, George Silva <<a href="mailto:georger.silva@gmail.com">georger.silva@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello everyone,<br><br>I have a converted dataset that has only polygons, but they were imported from ArcGIS as Multipolygons. I need them to become simple polygons. (I dont have any real multi-polygons in the table - they were just imported that way.<br>
<br>How can i convert this dataset to regular tyep polygons *question mark* (no question marks on this keyboard :( )<br><br>Thx for the help!<br>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>************************************<br>David William Bitner