I've trying to find a solution to applying the OpenStreetMap z-order in QGIS after using
osm2pgsql. Everything is working perfectly, until I add the each layer to the canvas, where the z-order is not being applied.
I've tried searching for solution for the last couple of hours and have yet to find anything that is working.
Here are the steps I've taken thus far:
osm2pgsql -d OSM_Test -l -u -U 'username' -W -H 'host' -P 'port' -k 'filepath'/oregon-latest.osm.pbf
'<...>' is being used as a placeholder.
- Each layer (line, point, polygon, road) is added with a land layer from Natural Earth.
- Rule-based styles are added for each OpenStreetMap road type.
I know that I can combine each road style with the z-order, however, this can create 60 different options for each road type/style.
Where am I going wrong? or am I missing something with a PostGIS function than can applied to the z-order?
I have confirmed that the z-order column is present for each.