I am trying to store GPS coordinates of devices for which I receive multiple updates every minute. I decided to use AWS TimeStream since all of the data that I am collecting are time series, but now when I am trying to query information that is in a specific area, I need to do complex computation in the query, similar to this solution.
Since there does not seem to be any spaciotemporal database available, what are my option ? I would like to query the database based on time and gps coordinates, but I am not familiar enough with time series DB and geospatial DB to understand properly the tradeoffs
