[mapserver-users] [EXTERNAL] Re: the lines one above other

[thomas bonfort]

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.Smith at 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.Eichner at 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-bounces at lists.osgeo.org [mailto:mapserver-users-
>>> bounces at lists.osgeo.org] Im Auftrag von Vladimir
>>> Gesendet: Donnerstag, 12. Februar 2015 12:02
>>> An: mapserver-users at 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 at lists.osgeo.org
>>http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users