<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello Rémi,<br>
<br>
I was hoping a simplest request without enabling topology but thanks
anyway!<br>
<br>
Cheers,<br>
<br>
Denis<br>
<br>
<div class="moz-cite-prefix">On 20. 11. 13 18:26, Rémi Cura wrote:<br>
</div>
<blockquote
cite="mid:CAJvUf_sffVgXc04rQSGGmv_HNRyDYfrdp6e+Bq-JrhF5VTJcbg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div><br>
</div>
From what I understand of your needs, Postigs topology was
designed for this.
<div>Cheers,</div>
<div><br>
</div>
<div>Rémi-C</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/11/20 Denis Rouzaud <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:denis.rouzaud@gmail.com" target="_blank">denis.rouzaud@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hi all,<br>
<br>
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.<br>
<br>
I could do this with a quite complex method:<br>
<br>
1. get the number of parts Z:<br>
SELECT ST_NumGeometries(geometry) FROMmytable WHERE id=123;<br>
<br>
2. do the simplification using ST_CollectionHomogenize:<br>
SELECT ST_Multi(ST_CollectionHomogenize(ST_Union(ST_GeometryN(geometry,n))))
FROM mytable CROSS JOIN generate_series(1,Z) n WHERE id =
123;<br>
<br>
3. update manually the result in the table (copy paste).<br>
<br>
<br>
Does someone has something more straightforward???<br>
<br>
Thanks a lot!<br>
<br>
Best regards,<br>
<br>
Denis<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@lists.osgeo.org"
target="_blank">postgis-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users"
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>