[postgis-users] Lines segment(S) from a string of points.

[Bob Basques]

All, 

Seemling simple, but eluding me (at the moment). 

I've found how to generate a Line string from a set of points, even how to bust one up into separate segments.  But what I need is a way to generate separate 2 point line segments from a string of points.  I need to apply a time/distance formula to each segment during the generation, so making a M-linestring and busting it up won't work (easily). 

The two options as I see it, are to either: 

****  calculate the time/distance formula for each segment during creation of the segment and add them, or 
**** create a multi-linestring and then chop this up into segments and apply the time/distance formula during chopping. 

Either can work, but the first option seems like it would be better for long term updating as new points come into the database.  There are also some event criteria that may need to be added to individual segments down the way as well that are captured at the point level. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120403/b3ac2037/attachment.html>