For trail planning and route signalization projects, I am looking for a solutions which allows me to connect "physical" trail segments (available as .gdb from authorities) with overlaying routes, whereas the routes may follow the segments in both directions.
The routes should be stored in a Postgres DB.
I assume this is a n:m relation, but how should the directions be manageed? Routes normally consist of >1 segment and there are likely to be more than one route on one segment.
I use QGIS 2.14 on Mac OSX, postgres 11.