[postgis-users] csv table to points and then create line based on same name

[Gery .]

Hello,

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 =)

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:

===
PROFILE,LONGITUDE,LATITUDE

HH00-23,-80.2835,-8.05167

HH00-23,-80.633,-8.20033

HH00-22,-80.6027,-8.2655

HH00-22,-80.2018,-8.094

...

...
===

I loaded this csv table into my database without problems, so this is how it looks like:

===
profile  | longitude | latitude |                        geom                        
----------+-----------+----------+----------------------------------------------------
 HH00-23  |  -80.2835 | -8.05167 | 0101000020E6100000A01A2FDD241254C05F5E807D741A20C0
 HH00-23  |   -80.633 | -8.20033 | 0101000020E61000008D976E12832854C0BBD05CA7916620C0
 HH00-22  |  -80.6027 |  -8.2655 | 0101000020E6100000265305A3922654C00E2DB29DEF8720C0
 HH00-22  |  -80.2018 |   -8.094 | 0101000020E61000004D158C4AEA0C54C0E3A59BC4203020C0
...
...
===

now comes the part I don't know how to solve it, I want to get a table like this:

===
profile | comments |                geom
-------------------------------------------------------------
HH00-23 | some stuff | "HERE THE GEOMETRY SHOULD BE A LINE!"
HH00-22 | some stuff | "HERE THE GEOMETRY SHOULD BE A LINE!"
...
...
===

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.

Any hint is very welcome,

Gery
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111002/113a55b4/attachment.html>