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?

  • 3
    Welcome to GIS SE. As a new user, please take the Tour. Unfortunately, the meaning of you question is unclear. You state one capability, then ask about two completely different ones which are unrelated (mapping and aggregation). Please Edit your question to choose one capability, expand your question to include your research on the topic, include your SQL, and specify a focused question on the specific problem you are having.
    – Vince
    Commented Feb 7, 2018 at 14:26
  • @Vince Thanks for your help. I edited my question. I will add sample SQL if it was still unclear.
    – mhsekhavat
    Commented Feb 7, 2018 at 15:07
  • Read this.
    – pLumo
    Commented Feb 7, 2018 at 15:41

1 Answer 1


If I understood your question right you should get started with a simple sql query

select velocity, st_simplify(geom, 0.1) as geom from lines;

Are you sure you want to aggregate lines to one single giant multiline?
If you really need that then you could GROUP BY your velocity column.

  st_simplify(st_collect(geom), 0.1)
from lines
group by velocity; 
  • @mhsekhavat, did this answer help you?
    – LauriK
    Commented Feb 14, 2018 at 20:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.