[Mobilitydb-users] MobilityDB on QGis issue

[Alan Suc]

Hello,

I'm using mobilityDB through PGAdmin and QGis (with the plugin Move) and 
I have a query which works well with PGAdmin but returns an error with 
Move. This query is :

With bateau As (Select trip, mmsi, traj as trace from ships_3 where mmsi = 257002120)

Select ships_3.mmsi, ships_3.traj, trace, ships_3.trip, shortestline( bateau.trip, ships_3.trip), bateau.trip |=| ships_3.trip From ships_3, bateau where dwithin(ships_3.trip, bateau.trip, 1000)


The error messages are :

2021-09-02T14:35:06     INFO Error: missing FROM-clause entry for table 
"ships_3"

2021-09-02T14:35:17     INFO Error: No supported geometry types in 
geometry column traj


Does someone have an idea ? I'm running mobilityDB 1.0beta3 on docker, 
with Move v0.1. The column traj is of type geometry and trip is tgeompoint.


Best Regards,

A. Suc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-users/attachments/20210902/c5ab9939/attachment.html>