I have a network(nodes=7479, edges=9033)
on QGIS that I want to reduce by merging some edges
and deleting some nodes
that I will not use for my calculation. Below a zoom on a part of my `network.
What I want to do is:
- Keep the nodes that contain information (in the example the hubs H1, H2 and H3)
- Merge the edges in one that doesn’t contain any needed nodes (between i1 and i2 / between H2 and i3 in the example)
- Don’t merge the edges when there is an interaction of more than three edges (e1 and e2 will not be merged because i2 is an interaction point to e3 as well)
Doing it manually will take me a long time and I was wondering if there is an automatic way to do it under QGIS or PostGIS (I’m a beginner in PostGIS, I just use it to perform simple calculation like finding the closest distance)