[postgis-users] simplifying (homogenize) a polygon

[Rémi Cura]

>From what I understand of your needs, Postigs topology was designed for
this.
Cheers,

Rémi-C


2013/11/20 Denis Rouzaud <denis.rouzaud at gmail.com>

> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131120/f605a23f/attachment.html>