I would draw your attention to the source of this discussion.
http://osgeo-org.1560.x6.nabble.com/the-lines-one-above-other-td5187093.html
It seems I found how to display multilevel junction of highway with "ORDER BY"
in the case using a one layer. Adding "order by id desc" or "order by id asc"
in subquery, also the definition $highwayStyle2 besides $highwayStyle1 works
fine.
Please see the code and the illustrations below:
--------------------------------------------------
$highwayLayer->set('status', MS_ON);
$highwayLayer->set('name', 'highway');
$highwayLayer->set('labelitem', 'name');
$highwayLayer->setConnectionType(MS_POSTGIS);
$highwayLayer->set('connection', 'user=my_user password=my_pass dbname=my_db
host=localhost');
$highwayLayer->set("data","geom from (select id, 'id = '||id as name, geom from
my_table
where ST_Intersects(geom, !BOX!) order by id desc) as subquery using unique id
using srid=3857");
$highwayLayer->setprocessing("close_connection=defer");
$highwayLayer->set("type",MS_LAYER_LINE);
$highwayClass = new ClassObj($highwayLayer);
$highwayClass->set('name', 'highway');
$highwayStyle1 = new styleObj($highwayClass);
$highwayStyle1->color->setRGB(254,173,0);
$highwayStyle1->set('linecap','square');
$highwayStyle1->set('width',4);
$respdorStyle1->outlinecolor->setRGB(255,0,0);
$respdorStyle1->set('outlinewidth',2);
$highwayStyle2 = new styleObj($highwayClass);
$highwayStyle2->color->setRGB(254,173,0);
$highwayStyle2->set('linecap','square');
$highwayStyle2->set('width',4);
$respdorStyle2->outlinecolor->setRGB(255,0,0);
$respdorStyle2->set('outlinewidth',2);
-------------------------
Result when "order by id asc":
http://s22.postimg.org/esbobf18x/order_by_id_asc.jpg
Result when "order by id desc":
http://s10.postimg.org/qeokp2jrd/order_by_id_desc.jpg
-------------------------
That's the goods for me but there is the impression of using some undocumented
singularity.
Thanx for any comments.
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
