[postgis-users] MakeLine question

[Pedro Doria Meunier]

Hey Curtis,

 

Should your points contain a timestamp field you might try to order by it
;-)

 

Pedro Doria Meunier

(351) 91 302 49 72 - (351) 96 247 99 12

MSN - pdoriam at hotmail.com

ICQ - 308-182-126

Skype: pdoriam

 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Curtis
W. Ruck
Sent: segunda-feira, 27 de Novembro de 2006 13:48
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] MakeLine question

 

I have a table with gps tracks stored as points, each point being one data
record for every second.

I am trying to write a view which generates a polyline for each track.  I
know I need to "select MakeLine(the_geom) from track_log" but the postgis
documentation suggests "You might want to use a subselect to order points
before feeding them to this aggregate."

Does anyone have an example of how to do this, the postgres documentation
doesn't show an example of using a subquery in the SELECT list portion of
the query.

Curtis

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061127/64580b28/attachment.html>