MulitLineStrings that may consist of several detached lines like these three:
What I need is to transform it to a
LineString. For my use case it would be the best strategy if I could connect the lines with the shortest connection line between each other so that I would get this:
I was thinking of using a combination of
ST_ShortestLine() but was wondering if there may be another hack to do that.