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

On 19-7-2012 20:03, Pedro Doria Meunier wrote:
Hi,

Need help/pointers on how to best construct the following:

1 known point in a table. (call it buoy)

another table containing the history (with a geom column) of where a particular object (a boat) has been in time/space

What I need to construct is a query that gives me the count of how many times that boat has gone past that buoy. (there *will* be more than 1 rows giving proximity of the object to the buoy -- need to get rid of those ;) -- since the boat is slow moving (2-10 knots))

Btw, both tables' geoms srid=4326.

Any help highly appreciated ;)

TIA,

--
Pedro Doria Meunier
Telf. +351 291 933 006
GSM   +351 917 999 236
Skype: pdoriam


_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to