Dear Daniel,
thanks for sharing such detailed information about your project. Good luck with everything!
Referring to all topics would require a really extensive answer, so I would like to pick just two things out of the topics you are listing which might help you and your colleagues.
Power
This is exactly what is happening.
Data management
About
We might have conceived the backend system of your dreams already by building an accessible open source data historian within the Hiveeyes Project. While originally built for the purpose of beehive monitoring, the whole system has been designed to be operated in arbitrary environmental monitoring projects of its kind - mostly in the field of academics as we are currently doing within the Bee Observer Project.
The system cares about data acquisition from multiple measurement nodes with easy onboarding, stores measurement data in a timeseries database (InfluxDB) and yields rich visualizations by building upon Grafana.
Details
For more details, you might want to have a look at
Example
As data telemetry and acquisition is rather invisible, I would like to share some of our most recent efforts on the visualization side.
Enjoy visiting Hive overview & Bee weather @ ZK/U Statista. As you can see there, we are also funneling data from the national weather service into the system in order to be able to correlate observations with weather conditions.
Bottom line
Please let us know if some of the things we are working on will spark your interest.
We recognize the forum is a jungle, so we are happy to help you navigate it or better pinpoint to specific software- and hardware-artefacts we are working on and which might be ready to apply them to your endeavor.
Also, I might translate content where appropriate. However, you are welcome to join the forum at https://community.hiveeyes.org/ which will enable you to use the online translation feature provided through Discourse Translator - plugin - Discourse Meta.
With kind regards,
Andreas.