Hello Rémi,
I was hoping a simplest request without enabling topology but thanks anyway!
Cheers,
Denis
On 20. 11. 13 18:26, Rémi Cura wrote:
From what I understand of your needs, Postigs topology was designed
for this.
Cheers,
Rémi-C
2013/11/20 Denis Rouzaud <[email protected]
<mailto:[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] <mailto:[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
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
