<div dir="ltr">Please tell us which version you downloaded, if Mahmoud's function worked then most probably you had the master version while we are in the process of preparing the next beta version and thus working on the develop branch.<div><br></div><div>Furthermore, please tell us which SRID you are using. In order to help you we need a sample data so we can test the function that is not working for you. Ideally the sample data should be as small as possible, possibly with only the one ship you have shown in your screenshot.<br><div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div>------------------------------------------------------------<br>Prof. Esteban Zimanyi<br>Department of Computer & Decision Engineering (CoDE) CP 165/15 <br>Universite Libre de Bruxelles <br>Avenue F. D. Roosevelt 50 <br>B-1050 Brussels, Belgium <br>fax: + 32.2.650.47.13<br>tel: + 32.2.650.31.85<br>e-mail: <a href="mailto:esteban.zimanyi@ulb.be" target="_blank">esteban.zimanyi@ulb.be</a><br>Internet: <a href="http://cs.ulb.ac.be/members/esteban/" target="_blank">http://cs.ulb.ac.be/members/esteban/</a><br>------------------------------------------------------------</div></div></div></div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Sep 1, 2021 at 1:56 PM Alan Suc <<a href="mailto:suc.eleve@ecole-navale.fr">suc.eleve@ecole-navale.fr</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>
<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 alt=""></p>
<div>Le 31/08/2021 à 18:28, Esteban Zimanyi
a écrit :<br>
</div>
<blockquote type="cite">
<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>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_-3480062664119354870gmail-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_-3480062664119354870gmail-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>
</div>
</blockquote></div>