Aiqi Zhang
Patchuolink hero

Patchuolink

Supervisor: 

Developed an IoT prototype for real-time cultivation monitoring, integrating wireless data flow, storage, analysis, and a user-friendly web interface.

Jan 2024 - Apr 2024
IoTCultivation Monitoring

Highlight Contributions

  • Designed and implemented a full-stack data visualization and monitoring center, from SQL backend to Python-Django web interface.
  • Produced a demo video and documentation detailing the design concept, process, and final solution.

Demo Video

Introduction

The opportunity space lies in tackling the soil degradation caused by patchouli cultivation, which often forces farmers to abandon and relocate farmland. By integrating IoT technologies into the growth phase, there is potential to guide more sustainable land management, improve crop yield and quality, and ultimately increase farmers' revenue. This space directly engages farmers as the main beneficiaries, with farm extension workers supporting adoption and knowledge transfer.

We introduce Patchoulink, an advanced IoT system for real-time cultivation monitoring. Our prototype focuses on data flow through wireless communication, data management, storage, and analysis, with a user-friendly website interface. Our prototype focuses on data flow through wireless communication, data management, storage, and analysis, with a user-friendly website interface.

patchuolink system architecture
Fig 1: System architecture diagram of Patchuolink, credit to Bella Semeniuk.

Utilizing wireless communication, nodes in the field transmit data in real time. The data journey begins with capturing analog signals from the sensor, packaging the data with communication protocols, and converting it into digital signals for transmission. Once received, the data is decoded and stored in a structured backend database, which records node configurations.

The heart of Patchoulink lies in its ability to analyze and present this data in a website interface. Here, farmers gain actionable insights, visualized with clarity and precision. Defined thresholds alert users to optimal growing conditions, ensuring informed decision-making. Further enhancing usability, Patchoulink features an OpenAI chatbot for immediate support, simplifying the translation of complex data into actionable farming strategies.

Patchoulink is more than a technological advancement for Indonesian patchouli farming—it's a sustainable, intelligent revolution, empowering farmers with instant insights for informed decision-making.

Hub Design

I was responsible for designing the central data visualization and monitoring hub, including database architecture and real-time data management with SQL on the backend, and a Python-Django web interface on the frontend.

patchuolink webpage dashboard
Fig 2: Pachuolink webpage dashboard.
Experimental setup
Fig 3: Dashboard page for overview of all information.
Methodology flow
Fig 4: Chatbot page for information integration and Q&A type of query.
Experimental setup
Fig 5: Map page including measurement node's geographical location for easy view and check.
Methodology flow
Fig 6: Update history page for all raw data table.

Acknowledgements

This project was a team effort. Credit to my wonderful teammates - Rachel, Kevin, Bella, Vhea, and Caroline!

Resources