<html>
<head>
</head>
<body style="margin-top: 4px; line-height: normal; margin-bottom: 1px; font-variant: normal; margin-right: 4px; margin-left: 4px">
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">All,</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">Seemling simple, but eluding me (at the moment).</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">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).</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">The two options as I see it, are to either:</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">**** calculate the time/distance formula for each segment during creation of the segment and add them, or</font> </p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">**** create a multi-linestring and then chop this up into segments and apply the time/distance formula during chopping.</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">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.</font>
</p>
</body>
</html>