Actually there is an issue opened for this, as the order by inside the subquery is not guaranteed to be maintained in the outer query: https://github.com/mapserver/mapserver/issues/5008 . For mssql there has been a patch applied, for postgis it is not needed yet.
On 12 February 2015 at 08:48, Smith, Michael ERDC-RDE-CRREL-NH <michael.sm...@erdc.dren.mil> wrote: > No, MapServer respects the feature order. Using the ORDER BY with a > database connection, MapServer will draw features in that order. > > Mike > > -- > Michael Smith > > US Army Corps > Remote Sensing GIS/Center > > > > On 2/12/15, 7:52 AM, "Eichner, Andreas - SID" > <andreas.eich...@sid.sachsen.de> wrote: > >>I'm not sure about this but AFAIK MapServer draws features in the order >>they are returned by the query. For Shapefiles there is the sortshp >>utility. If you're on a relational database like PostGIS or OracleSpatial >>you can try including the "ORDER BY prio" within the DATA. But since MS >>wraps it into a subquery the database might still return the features out >>of order. >> >>> -----Ursprüngliche Nachricht----- >>> Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users- >>> boun...@lists.osgeo.org] Im Auftrag von Vladimir >>> Gesendet: Donnerstag, 12. Februar 2015 12:02 >>> An: mapserver-users@lists.osgeo.org >>> Betreff: [mapserver-users] the lines one above other >>> >>> Hello All! >>> >>> >>> >>> The task is to show multilevel junction of highway. >>> The lines should be at the same layer and has the same style, for >>>example >>> see orange lines on attached pic: >>> [img]http://s14.postimg.org/yk40e0nq9/crossroad.jpg[/img] >>> Is it possible to draw the lines one above other by an one layer? >>> May be some method of Z-index for features in a layer exists? >>> Thanks for any guidance to display this kind of crossroads. >>> >>> Vladimir >>_______________________________________________ >>mapserver-users mailing list >>mapserver-users@lists.osgeo.org >>http://lists.osgeo.org/mailman/listinfo/mapserver-users > > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users