[geomesa-users] Is it possible to query for objects that were in positio

[Yoav Zibin <yoav.zibin@xxxxxxxxx>]

Hi,
I'm looking for a SpatialTemporal DB that can track moving objects and answer queries of the form: find all objects that were in position X at time X' and also were in position Y at time Y'.
Is it possible to write such a query?

The closest query I could find is:

BBOX(geom,0,0,10,10) AND dtg DURING 2017-01-01T00:00:00.000Z/2017-01-02T00:00:00.000Z 

I could issue two such queries, and do the intersection of the two results, but I was hoping for a better way (because each query could return millions of results, but the intersection is much much smaller).