<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<div>I would love to see some sort of sorting capability but at least for shapefiles I've always relied on a presort (using sortshp utility) for performance reasons. I think if something more configurable was needed then one would simply need to OGR access
as a wrapper for shapefiles. Maybe the various driver owners could weigh in regarding the SORTBY option.</div>
<div><br>
</div>
<div>Steve</div>
<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF980363" style="direction: ltr;"><font face="Tahoma" size="2" color="#000000"><b>From:</b> mapserver-dev-bounces@lists.osgeo.org [mapserver-dev-bounces@lists.osgeo.org] on behalf of Tamas Szekeres [szekerest@gmail.com]<br>
<b>Sent:</b> Sunday, November 09, 2014 3:21 PM<br>
<b>To:</b> geographika@gmail.com<br>
<b>Cc:</b> mapserver-dev@lists.osgeo.org<br>
<b>Subject:</b> Re: [mapserver-dev] incorrect layer drawing order issue<br>
</font><br>
</div>
<div></div>
<div>
<div dir="ltr">Yes that would be the simplest approach in short term.
<div>But I think it would also be reasonable to get it configurable for all supported drivers, through mapfile and mapscript.</div>
<div><br>
</div>
<div>Best regards,</div>
<div><br>
</div>
<div>Tamas</div>
<div><br>
</div>
<div>
<div><br>
<div class="gmail_extra"><br>
<div class="gmail_quote">2014-11-09 20:49 GMT+01:00 geographika <span dir="ltr"><<a href="mailto:geographika@gmail.com" target="_blank">geographika@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div bgcolor="#FFFFFF">
<div>Would a SORTBY clause be added as a keyword in the DATA statement? <br>
E.g. DATA "ogr_geometry from rivers USING UNIQUE ogr_fid USING SRID=4326 USING SORTBY my_sort_fieldname"
<div>
<div class="h5"><br>
<br>
On 07/11/2014 12:49, Tamas Szekeres wrote:<br>
</div>
</div>
</div>
<div>
<div class="h5">
<blockquote type="cite">
<div dir="ltr">We could also extend the DATA section with a SORTBY clause for the mssql driver.
<div>Adding this feature to MSSQL (as per RFC 105) would anyway be fairly easy.</div>
<div><br>
</div>
<div>Tamas</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2014-11-07 11:24 GMT+01:00 geographika <span dir="ltr"><<a href="mailto:geographika@gmail.com" target="_blank">geographika@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div bgcolor="#FFFFFF">Hi list,<br>
<br>
I have come across an issue that is critical to the project I am working on and wondered if it applies to all database drivers or just the SQL Server 2008 one.
<br>
<br>
I have logged the issue on GitHub at: <a href="https://github.com/mapserver/mapserver/issues/5008" target="_blank">
https://github.com/mapserver/mapserver/issues/5008</a><br>
<br>
I will try some tests over the weekend to see if the Postgres driver works the same way, but there seems to be no way of guaranteeing feature display order - even if all documentation suggests it can be achieved in a database layer using "ORDER BY"<br>
Whilst for a low number of records the order seems ordered, with 150+ features I get different images returned each time by my WMS service. No use of clustered indexes, partition statements etc. can get around this as SQL result sets can only be guaranteed
with an ORDER BY in the outermost statement. <br>
<br>
I note that in <a href="http://mapserver.org/fr/development/rfc/ms-rfc-105.html" target="_blank">
http://mapserver.org/fr/development/rfc/ms-rfc-105.html</a> there is a new function msLayerBuildSQLOrderBy() that allows sorting to be done outside of the layer's DATA statement for WFS requests with a SORTBY parameter. Maybe this could also be used by a new
LAYER "SORT" config keyword?<br>
<br>
I see the above is only implemented for a few drivers. The client would be willing to fund adding this to the SQL Server driver if there are any core devs interested in doing this.
<br>
<br>
Regards,<br>
<br>
Seth<br>
<br>
<div lang="x-western"><font color="#888888">--<br>
web:</font><a href="http://geographika.co.uk" target="_blank"><font color="#888888">
</font>http://geographika.co.uk</a><br>
<font color="#888888">twitter: @geographika<br>
</font><br>
</div>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>