I've to merge all linestrings from a PostgreSQL table "river" that are continued by exactly one another linestring. In the illustration below I use a "M" to mark all start-/endpoints that needs to be merged.
Unfortunately I'm new to PostGIS. To my knowledge QGIS needs an id (gid) and a geometry (geom) column to load a table or view. But I'm not sure which PostGIS function will do the job. Can anyone please help me with the SQL query?
أكثر...
أكثر...