[postgis-users] simplifying (homogenize) a polygon

[Denis Rouzaud]

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 <denis.rouzaud at gmail.com 
> <mailto: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 <mailto:postgis-users at lists.osgeo.org>
>     http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
>
> _______________________________________________
> 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/20131121/ae62760d/attachment.html>