3

I want to smooth Lines in postgis, to be more specific, I want to smooth road data from OpenStreetMap.

Basicly I thought of something like this scenario. This would be a possible road segment.

This would be a possible road segment.

enter image description here

I want to use ST_LineInterpolate_Point() to select the middle Points

enter image description here

After this, I want to create New Points between the original ones and the darkgreen helpline. (I have no Idea how to achieve this...)

enter image description here

I read about circularlinestrings. I hope it will be possible to lay one of these over the darkgreen and red points.

enter image description here

Finaly I want to use ST_LineInterpolate_Point() again on the circularlinestring (if this is possible) and create some new points(yellow ones), to make a new normal LineString.

To sum up, I am new to PostGIS, but since I haven't found anything helpful for LineSmoothing I need a function where I can input a LineString and the number of yellow points per segment. The function should return a new LineString.

First of all: Is this possible to achieve with just pl/pgsql?

Second, since I am new to all of this, can somebody give me some advice where to start?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.