<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
<br>Hello,<br><br>I'm new around here and after working a while with postgis/postgresql, I'd like to get something that up to know is advanced for me. Please don't get mad at me if this is a stupid question =)<br><br>I want to create a line table based on a point table, which it is composed of rows with equal names, this is an example of this csv table:<br><br>===<br>PROFILE,LONGITUDE,LATITUDE<br>
HH00-23,-80.2835,-8.05167<br>
HH00-23,-80.633,-8.20033<br>
HH00-22,-80.6027,-8.2655<br>
HH00-22,-80.2018,-8.094<br>
...<br>
...<br>===<br><br>I loaded this csv table into my database without problems, so this is how it looks like:<br><br>===<br>profile | longitude | latitude | geom <br>----------+-----------+----------+----------------------------------------------------<br> HH00-23 | -80.2835 | -8.05167 | 0101000020E6100000A01A2FDD241254C05F5E807D741A20C0<br> HH00-23 | -80.633 | -8.20033 | 0101000020E61000008D976E12832854C0BBD05CA7916620C0<br> HH00-22 | -80.6027 | -8.2655 | 0101000020E6100000265305A3922654C00E2DB29DEF8720C0<br> HH00-22 | -80.2018 | -8.094 | 0101000020E61000004D158C4AEA0C54C0E3A59BC4203020C0<br>...<br>...<br>===<br><div><br>now comes the part I don't know how to solve it, I want to get a table like this:<br><br>===<br>profile | comments | geom<br>-------------------------------------------------------------<br>HH00-23 | some stuff | "HERE THE GEOMETRY SHOULD BE A LINE!"<br>HH00-22 | some stuff | "HERE THE GEOMETRY SHOULD BE A LINE!"<br>...<br>...<br>===<br><br>the case is that I have these points (from the csv table) in order, so, a straight line should be build after connecting the points. Here I showed just two pairs of points in each case, but I have also in that table 6 to 10 points with the same profile name. I did this in arcgis manually and it is painful, I think that postgis is definitively more practice.<br><br>Any hint is very welcome,<br><br>Gery<br></div> </div></body>
</html>