<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Sir,</p>
<p>Thank you for your answer. I tried yours first but it didn't
work, while M Sakr's one worked, which is quite strange as I
reinstalled MobilityDB last week so I guess I should have the most
recent version. An other question, I'm using dwithin() and |=|but
those fonctions seems to don't work. Indeed, for the dectection of
near miss situation between ships I use dwithin to detect ships
who came closer than 1000m to the one studied, but this function
seems to don't work as it also select ships which were at dozens
of kilometers. Also |=| seems lost as it returns a distance of
0.53 m at closest point of approach while QGIS measures 59km for
the same line. I join a screen capture which, I guess, is more
more explicit.</p>
<p>Best Regards,</p>
<p>A. Suc</p>
<p><img src="cid:part1.1184D454.11DD59CC@ecole-navale.fr" alt=""></p>
<div class="moz-cite-prefix">Le 31/08/2021 à 18:28, Esteban Zimanyi
a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CAPqRbE499qfNy9=-mV_RYDT15j2J-L0rwehf5WwWJvgLwVVEDA@mail.gmail.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>Please find enclosed a new version of the function since
the suffixes for the subtypes in MobilityDB have been changed
to _inst, _instset, _seq, and _seqset for better readability.
Usage examples of the function are also included in the file.</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Aug 31, 2021 at 4:53
PM Mahmoud SAKR <<a href="mailto:mahmoud.sakr@ulb.ac.be"
moz-do-not-send="true">mahmoud.sakr@ulb.ac.be</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div dir="ltr">
<div
id="gmail-m_8572380960937891208gmail-yiv9968452757ydp27fbeb66yiv1353059539">
<div dir="ltr">
<div>[...]<br>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<div> </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div dir="ltr">
<div>
<div>
<div
id="gmail-m_8572380960937891208gmail-yiv9968452757ydp27fbeb66yiv1353059539">
<div dir="ltr">
<div>I understand that you got a sequence of
(location, timestamp) pairs, from which you
want to construct a trajectory. But you want
to split into multiple trajectories whenever
there is a big gap (in time or in distance)
between two consecutive points.<br>
</div>
<div dir="ltr"><br clear="none">
</div>
Enclosed is an SQL function to do this.</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</body>
</html>