[postgis-users] Need help constructing a query

[Pedro Doria Meunier]

On 07/20/2012 07:38 AM, Tom van Tilburg wrote:
> Hi Pedro,
>
> You might try to create lines from the boat tracks (see examples in
> manual for ST_MakeLine)  and circles (st_buffer) from the proximity
> areas around the buoy.
> Now do a ST_Intersection(boatline, bouycircle). The result should be a
> set of lines within the bouycircle. Every line stands for one pass
> along the bouy.
> I think ST_Intersection might result in a geometry collection of lines
> and points so you would have to make a dump of the result with ST_Dump
> and then select only the lines.
>
> Cheers,
>  Tom
>

Elegant thinking but that would end up in a *single* line, as I only
have the timestamp and (point)geom to work with.
Thanks for your input though :)

-- 
Pedro Doria Meunier
Telf. +351 291 933 006
GSM  +351 915 818 823
Skype: pdoriam

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120720/9b0fc570/attachment.html>