Only query data for sensors that are visible on the map

[brianstrauch]

The map is 2D, so we only need to query and render the sensors that are visible on the map. Approach: find the (lat, lon) of the top left and bottom right corners of the map and pass those coordinates to the InfluxDB query.

https://docs.influxdata.com/influxdb/cloud/query-data/flux/geo/filter-by-region/#box

[keenanjohnson]

That would be a great improvement for sure as the number of sensors grows.

[sriki18]

Hello,

It looks like at the moment, sensor data is queried only for specific sensors

https://github.com/Ribbit-Network/ribbit-network-dashboard/blob/bd8050df06d0514dea20e99916c39e8e7d9e7d20/db.py#L21-L24

Is this about the other query, and having a lat lon filter there? https://github.com/Ribbit-Network/ribbit-network-dashboard/blob/bd8050df06d0514dea20e99916c39e8e7d9e7d20/db.py#L9-L14

[brianstrauch]

@sriki18 Yep, this issue is for the top query (the map data query)