I want to get all parts of a given street.
I use a query like:
Select * from planet_osm_lines where name = 'mystreet'
As a result I get all the LineStrings that are part of a street with the given name, but somehow I have to group the LineStrings to form the correct MultiLinestrings, because there could be other streets with the name "mystreet".
Does someone know how to get this information?