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
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users