PostGIS has ST_Simplify functionality which gets one multiline as input and returns one output multiline where the general shape of lines are retained while eliminating unnecessary detail.
Instead of one multiline, I have a table with a LineString geometry column (street segment) and an integer column (traffic velocity of that street). I can create a single multiline out of that LineString column and simplify it, but I need to know traffic velocity of simplified geometries too. Is there any tool to aggregate data of integer column into simplified lines?