[postgis-users] Need help constructing a query

[Pedro Doria Meunier]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120719/4a37819e/attachment.html>