Filter out all values <= 0°C

[dbrgn]

We already filter this at the relay level, but some historic data ist still part of the database.

This could easily be filtered out in all SQL queries we're calling (WHERE temperature > 0):

• Latest measurements
• Historic aggregate stats
• Maybe others?

[dbrgn]

For testing: Check out the Tribschen Sensor. It shows historic minimal values at -0.1°C.

[rnestler]

Do you want to filter it or clean it?

[rnestler]

Like removing it from the DB or only filter it in the queries?

[dbrgn]

Hm, I think filtering is probably better... Or do you think removing the values would be better (e.g. with an admin command)?

Something else I thought of: In case we ever deploy an ice-proof sensor in a lake that occasionally freezes (e.g. Sihlsee), we'd need to adjust the logic 🙂

[rnestler]

Something else I thought of: In case we ever deploy an ice-proof sensor in a lake that occasionally freezes (e.g. Sihlsee), we'd need to adjust the logic 🙂

Well if the ice get's 80cm thick, then we need to adjust the logic :laughing: otherwise the water below the ice will still have above zero temperature.

[dbrgn]

Yeah, that's the thing, the ice does sometimes get that thick near the shallow shore up there 😄