For my vector map I'd love to display highways at a quite early zoom level. The problem is that this data would be quite big, so I thought I simply
ST_Simplify it. The problem though is that the OSM data consists of a lot of small road segments. So for Germany f.e. there are roughly 60000 segments of type
Does anybody have an idea on how to better simplify the data? I was thinking of creating longer polylines by combining the small ones and then
The problem is just that I don't know how I should do that...
I could do a
ST_Union on all of my roads, but that would create ONE geometry. So maybe group them somehow. There are relations in OSM, but I don't think that there is an easy query for "Give my only highway", right?
As a bonus, if would be awesome to have only a line in one direction, as for my zoom-level the two lines would look as one anyway.