[Mobilitydb-users] building a tgeogpointi with time only known for some points

[Esteban Zimanyi]

In MobilityDB an underlying assumption is that all temporal types with
instantset subtype cannot assume any interpolation. A typical case is
collecting check-ins for social networks like Foursquare.

If in your particular application you can assume some interpolation for the
missing timestamps (e.g. using the previous and/or subsequent known
timestamp) I would suggest to use SQL window functions
https://www.postgresql.org/docs/13/tutorial-window.html
https://www.postgresql.org/docs/13/functions-window.html
such as lead or lag to fill the missing timestamps before entering them
into MobilityDB.


On Fri, May 21, 2021 at 6:38 PM Jannis R <mail at jannisr.de> wrote:

> hey everyone!
>
> is it possible to construct a `tgeogpointi` from a list of `geography` +
> `timestamptz` items if some of the items don't have a `timestamptz`? or to
> put it another way: i have a geospatial + temporal trajectory, where I only
> know the temporal value of *some* of the points.
>
> ideally, i would like mobilitydb to interpolate between them on the fly.
> do i understand correctly that there's no such feature?
>
> – jannis
> _______________________________________________
> Mobilitydb-users mailing list
> Mobilitydb-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mobilitydb-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-users/attachments/20210521/b7e4d308/attachment.html>