>From what I understand of your needs, Postigs topology was designed for this. Cheers,
Rémi-C 2013/11/20 Denis Rouzaud <[email protected]> > Hi all, > > I am drawing some multipolygons in QGIS and sometimes, I have parts of > them which are adjacent and I'd like to homogenize them to have less parts > and no adjacent parts. > > I could do this with a quite complex method: > > 1. get the number of parts Z: > SELECT ST_NumGeometries(geometry) FROMmytable WHERE id=123; > > 2. do the simplification using ST_CollectionHomogenize: > SELECT ST_Multi(ST_CollectionHomogenize(ST_Union(ST_GeometryN(geometry,n)))) > FROM mytable CROSS JOIN generate_series(1,Z) n WHERE id = 123; > > 3. update manually the result in the table (copy paste). > > > Does someone has something more straightforward??? > > Thanks a lot! > > Best regards, > > Denis > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
