n:m relations of lines including directions

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

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

How can I add the PostGIS extension?

Updated April 10, 2016 08:09 AM

Best way to relate Postgres table to Layer

Updated September 06, 2018 10:22 AM