<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">I have a (GPS Point) table that looks like:
<div><br>
</div>
<div>
<div>1;0;0;0;0;geom</div>
<div>2;0;0;0;1;geom</div>
<div>3;0;0;0;0;geom</div>
<div>4;0;0;0;1;geom</div>
<div>5;0;0;0;0;geom</div>
<div>6;0;0;0;1;geom</div>
<div>7;0;0;0;0;geom</div>
<div>8;0;0;0;1;geom</div>
<div>9;0;0;0;0;geom</div>
<div>10;0;0;0;1;geom</div>
<div>11;0;0;0;1;geom</div>
<div>12;0;0;0;0;geom</div>
<div>13;0;0;0;0;geom</div>
<div>14;0;0;0;1;geom</div>
<div>15;0;0;0;0;geom</div>
<div>16;0;0;0;1;geom</div>
<div>17;0;0;0;0;geom</div>
</div>
<div><br>
</div>
<div>The next to last column is the plow up/down switch. "1"= Plow Down or start of line segment, and "0" = Plow up or end of line segment. If two or more sequential records have a "1" value, then it's to be treated as a multi-segment line. So, what would
the SQL look like to do that. I know I need a self join, but the "1"/"0" value thing is making my brain freeze for some reason . . . the inner select needs to select the rows sequentially beginning from a "1" value, until it reaches a "0" value. This would
become a linestring in the outer result, right?</div>
<div><br>
</div>
<div>Thanks</div>
<div><br>
</div>
<div>bobb</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</body>
</html>