[Mobilitydb-dev] intersection of tgeompoint with a geometry and period

[Esteban Zimanyi]

Dear Wendell

What about doing
tintersects(atPeriod(flown_path, period), boundary)
The atPeriod function will reduce the number of points (or produce an empty
result if there is no overlap between the periods of the flights and the
boundary) which will speed up the tintersects function which is expensive.
The geometric intersection is actually done by GEOS and then from this
result MobilityDB needs to compute back the timestamps of the intersections.

Please let me know if this works for you.

Regards

Esteban
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-dev/attachments/20220701/b719e57a/attachment.htm>