[postgis-users] Union a very big Multipolygon table with self intersections

[ibrahim saricicek]

Hi;

create a new geometry column

use update table set new_column=st_buffer(the_geom,0). IsValid will return
true. Then try the union operation..

IBO..

On Fri, Feb 5, 2010 at 12:46 AM, Javier de la Torre
<jatorre at vizzuality.com>wrote:

> Hi all,
>
> I have a table with a MULTIPOLYGON field with around 100k records. Some of
> these records, 2K have self intersections and other problems that make
> ST_IsValid return false. The polygons overlap a lot and I wanted to generate
> another table that will be the union of all polygons.
>
> The table looks like
> id, the_geom
>
> What would be the best way to union all of the geometries into a new table
> where there is only POLYGONS that do not overlap?
>
> Thanks in advance.
>
> Javier.
>
>
> _______________________________________________
> 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/20100205/992d6178/attachment.html>