Presenters
Source
From Barnyard Beasts to Beautiful Dashboards: Visualizing Farm Emissions with Grafana 🐄💨📊
Ever wondered about the invisible world of farm emissions? Sunil Gopalakrishna, a researcher at the Thünen Institute of Agriculture Technology, is tackling this complex challenge head-on, and he’s doing it with a brilliant blend of low-cost sensors and powerful open-source visualization tools. Get ready to dive into how he’s transforming raw sensor data from barns into actionable insights on a dynamic dashboard!
The Challenge: Measuring Emissions in Modern Barns 🚧
Traditionally, animal barns were closed environments, making emission measurement relatively straightforward. However, modern farming practices have evolved. Sunil works with partially ventilated barns, featuring bay areas where animals like pigs can access fresh air. This open design, while beneficial for animal welfare, significantly complicates emission monitoring.
“When you have such barns which are, or which have these bay areas,” Sunil explains, “it becomes very difficult to measure emissions.” The challenge lies in accurately capturing emissions when animals move freely between enclosed and open spaces, and external factors like wind can easily skew readings.
The Solution: Sensor Arrays and Smart Data Transmission 📡
To overcome this hurdle, Sunil and his team developed a Sensor Array Measuring Ball. This ingenious device packs four low-cost sensors capable of measuring:
- Ammonia (NH₃) 💨
- Carbon Dioxide (CO₂) 🌬️
- Particulate Matter (PM) ✨
- Differential Pressure (ΔP) ⚖️
These sensor balls are wired together and transmit data wirelessly. Initially, the team explored Wi-Fi, but due to connectivity issues in their rural locations, they opted for LTE (Long-Term Evolution). This robust cellular network ensures data can be reliably sent back from even the most remote farm settings.
The sensor balls are strategically placed at the interface of these barns. The system is designed for scalability, with the potential to deploy up to 50 balls simultaneously to comprehensively measure emissions.
From Raw Data to Insight: InfluxDB and the Power of Grafana 💡
The raw sensor data arrives as time-indexed packages, essentially a stream of values for particulate matter, carbon dioxide, and ammonia over time. While this data is crucial for understanding emission levels, engineers and technicians found it challenging to interpret in its raw form.
This is where Sunil’s expertise shines. He decided to leverage open-source solutions to make this data accessible and understandable.
Step 1: Data Storage with InfluxDB 💾
Sunil chose InfluxDB, a time-series database, to store the incoming sensor data. InfluxDB is perfectly suited for handling the continuous stream of measurements from the sensor balls. He organizes the data into “buckets,” allowing him to easily retrieve and plot the values from each sensor ball against time.
Step 2: Visualization with Grafana 🖼️
Recognizing that even structured data in InfluxDB wasn’t enough, Sunil turned to Grafana, a powerful open-source analytics and visualization platform. Grafana allows him to create dynamic dashboards that tell a compelling story.
Key features of his Grafana dashboard include:
- Barn Layout Visualization 🏡: Using the Canvas panel in Grafana, Sunil can create a visual representation of the barn and the placement of the sensor balls within it. This provides an intuitive spatial context for the data.
- Real-time Emission Monitoring 📈: The dashboard displays the concentration of emissions from each sphere over time. This allows for immediate understanding of emission levels.
- Correlation with Environmental Factors 🌡️: Sunil can also display related data, such as humidity or other environmental factors, from the spheres. This helps in understanding how different conditions influence emissions.
- Integrated Video Feeds 📹: For added context, the dashboard can incorporate video feeds from partner farms, offering a visual connection to the animals and their environment.
- Emission Spike Correlation ⚡: By carefully observing the dashboard, Sunil can correlate spikes in emissions with specific events, such as the addition of new animals to the barn or changes in animal growth phases.
- Annotations for Context ✍️: The dashboard features annotations on emission values. This is invaluable for marking significant periods like “growth period,” “fattening period,” or noting anomalies like the addition of extra animals.
- Data Completeness Monitoring 💯: A crucial element is the “data completeness” metric. Sunil can see in real-time how much data is being received, quickly identifying any issues with sensors or the server. This ensures the reliability of the monitoring system.
The Impact: Empowering Research and Decision-Making 💪
Sunil’s approach demonstrates the immense potential of open-source tools like Grafana for specialized applications. By pulling data from the sensor balls, calculating velocity using differential pressure, and sending it to InfluxDB, he creates a comprehensive system that provides actionable insights.
“It is possible to use an open source tool like Grafana for this such a use case,” Sunil emphasizes. He’s even engaged with the Grafana community, seeking additional features for the Canvas panel and contributing to its development.
This innovative use of technology not only helps measure emissions but also empowers researchers and farmers to understand the complex interplay of factors influencing them, ultimately contributing to more sustainable and efficient agricultural practices. 🌍✨