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