This is also not an issue in Oracle. M
On 2/12/15, 8:55 AM, "thomas bonfort" <thomas.bonf...@gmail.com> wrote: >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
