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

[Smith, Michael ERDC-RDE-CRREL-NH]

This is also not an issue in Oracle.

M

On 2/12/15, 8:55 AM, "thomas bonfort" <thomas.bonfort at 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.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