[prev in list] [next in list] [prev in thread] [next in thread] 

List:       qgis-developer
Subject:    Re: [Qgis-developer] Postgresql provider - Use ST_RemoveRepeatedPoints for server-side simplificatio
From:       kimaidou <kimaidou () gmail ! com>
Date:       2015-11-27 13:27:24
Message-ID: CAMKXKO470R8OpQ9iRnvQkkyUEQbMw6fVe+au77tSj4wZZiPGYA () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hi all,

I updated my PR.
I made some quick tests, and it seems this PR can improve speed for PostGIS
layers ( with PostGIS 2.2 )
More details in the last comment [1]

Please help to test it with a variety of data types and complexity.

[1] https://github.com/qgis/QGIS/pull/2410#issuecomment-160138487

Regards
Micha=C3=ABl aka "kimaidou"

2015-10-30 11:50 GMT+01:00 kimaidou <kimaidou@gmail.com>:

> Hi all
>
> Following the blog post written by Paul Ramsey [1], I decided to propose
> using PostGIS 2.2 ST_RemoveRepeatedPoints function instead of ST_SnapToGr=
id
> to do the server side simplification
>
> We could also investigate other new features, such as the 3rd parameter
> for ST_Simplify, but we use St_SimplifyPreserveTopology in QGIS, and I do
> not think this function has got this new parameter too.
>
> I made a pull request : see [2]
> Please help me to test and review it
>
> [1] http://blog.cartodb.com/smaller-faster/
> [2] https://github.com/qgis/QGIS/pull/2410
>

[Attachment #5 (text/html)]

<div dir="ltr"><div><div><div><div><div>Hi all, <br><br></div>I updated my \
PR.<br></div>I made some quick tests, and it seems this PR can improve speed for \
PostGIS layers ( with PostGIS 2.2 )<br></div><div>More details in the last comment \
[1]<br></div><br>Please help to test it with a variety of data types and \
complexity.<br><br>[1] <a \
href="https://github.com/qgis/QGIS/pull/2410#issuecomment-160138487">https://github.co \
m/qgis/QGIS/pull/2410#issuecomment-160138487</a><br><br></div>Regards<br></div>Michaël \
aka &quot;kimaidou&quot;<br></div><div class="gmail_extra"><br><div \
class="gmail_quote">2015-10-30 11:50 GMT+01:00 kimaidou <span dir="ltr">&lt;<a \
href="mailto:kimaidou@gmail.com" \
target="_blank">kimaidou@gmail.com</a>&gt;</span>:<br><blockquote class="gmail_quote" \
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div \
dir="ltr"><div><div><div>Hi all<br><br></div>Following the blog post written by Paul \
Ramsey [1], I decided to propose using PostGIS 2.2 ST_RemoveRepeatedPoints function \
instead of ST_SnapToGrid to do the server side simplification<br><br></div><div>We \
could also investigate other new features, such as the 3rd parameter for ST_Simplify, \
but we use St_SimplifyPreserveTopology in QGIS, and I do not think this function has \
got this new parameter too.<br></div><div><br></div>I made a pull request : see \
[2]<br></div>Please help me to test and review it <br><div><div><div><br>[1] <a \
href="http://blog.cartodb.com/smaller-faster/" \
target="_blank">http://blog.cartodb.com/smaller-faster/</a><br>[2] <a \
href="https://github.com/qgis/QGIS/pull/2410" \
target="_blank">https://github.com/qgis/QGIS/pull/2410</a><br></div></div></div></div>
 </blockquote></div><br></div>


[Attachment #6 (text/plain)]

_______________________________________________
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer

[prev in list] [next in list] [prev in thread] [next in thread]