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

ribbit-network-dashboard/db.py

Lines 21 to 24 in bd8050d

	def get_sensor_data(host, duration):
	df = query_api.query_data_frame('from(bucket:"co2")'
	f'|> range(start: -{duration})'
	f'|> filter(fn: (r) => r.host == "{host}")'

Is this about the other query, and having a lat lon filter there?

ribbit-network-dashboard/db.py

Lines 9 to 14 in bd8050d

	def get_map_data() -> pd.DataFrame:
	df = query_api.query_data_frame('from(bucket:"co2")'
	'|> range(start:-15m)'
	'|> limit(n:1)'
	'|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")'
	'|> keep(columns: ["host", "lat", "lon", "co2"])')

[brianstrauch]

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