n:m relations of lines including directions

by Kevkev770   Last Updated October 09, 2019 18:22 PM

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.

Related Questions

Updated April 10, 2016 08:09 AM

Updated June 19, 2015 08:09 AM

Updated August 16, 2018 10:22 AM

Updated July 11, 2019 07:22 AM

Updated September 06, 2018 10:22 AM