How do I simplify the straight sections of (multi)Linestring in PostGres/PostGis leav

المشرف العام

Administrator
طاقم الإدارة
I have (multi)linestrings containing upwards of 5000 points and I want to perform two simplifications possibly using Ramer Douglas Peucker or alternative methods in PostGis

The (multi)linestrings consist of straight lines, 90 degree curves, 180 degree curves and loops (circles)

I understand that ST_simplify may remove the loops and possibly some of the bends depending on the tolerance set.

I need to have a Zoomed Out version which can probably be done satisfactorily done with ST_simplify

However, on the zoomed in version, it is important to keep the loops, and curve points.

I would like to remove all the points from the straight segments (within a tolerance) which constitute 90% of the (multi)linestring and keep the points on the curve section.

How can I achieve this in PostGis?



أكثر...
 
أعلى