[postgis-users] Select smoothed lines

[Sandro Santilli]

On Mon, Jan 30, 2012 at 02:50:46PM +0100, Rocco Pispico wrote:
> Hi all,
> my database contains a lot of paths of storms.
> Each storm path is generated by joining the centroids of the storm at any
> moment of measurement.
> The result is sometimes a line with a lot of edge.
> Can you suggest me a method to select these lines a little bit smoothed.

ST_Simplify(geometry, tolerated_drift_from_original)

--strk;

  ,------o-. 
  |   __/  |    Thank you for PostGIS-2.0 Topology !
  |  / 2.0 |    http://www.pledgebank.com/postgistopology
  `-o------'