← Back to projects
GyL Group · Spanish client

Agricultural monitoring with Machine Learning

Web application for crop monitoring that integrates IoT sensor data analysis with Python and ML, immutable traceability on AWS QLDB and real-time visualizations for crop alerts.

IoT
Sensors with nightly sync
QLDB
Immutable traceability
Real-time
Visualizations and alerts

The Problem

A client in Spain needs to monitor crops in real time from IoT sensor data spread across the field. The data arrives scattered, the history is not auditable and alerts arrive too late.

  • • Scattered IoT sensor data with no reliable history
  • • No auditable traceability of the data feeding decisions
  • • Late crop alerts due to a lack of automated analysis
  • • A team without a unified view of crop status

My Process

1. Data analysis with Python + Colab

Modeled the sensor data analysis with Python in Google Colab, understanding moisture, temperature and irrigation patterns.

  • ✓ EDA of IoT sensor data to detect crop patterns
  • ✓ Data pipeline preparation with Scikit-learn for early signals
  • ✓ Fast prototyping in Colab before productizing

2. Nightly sync to AWS QLDB

Architected a nightly synchronization of sensor data into AWS QLDB, guaranteeing immutable traceability.

  • ✓ QLDB ledger as the single source of truth for sensor history
  • ✓ Automated nightly sync with AWS Lambda and EventBridge
  • ✓ Every piece of history stays immutable and auditable

3. Real-time visualizations and alerts

Built the web UI with real-time visualizations for crop insights and automated alerts.

  • ✓ Real-time visualizations with Matplotlib and Seaborn
  • ✓ Automated alerts by crop thresholds agreed with the client
  • ✓ Angular frontend consuming the Node.js API

4. R&D audit

The project went through an R&D audit, validating the data design and the methodology used.

  • ✓ Data pipeline documentation for the audit
  • ✓ QLDB traceability validated as a quality guarantee
  • ✓ Closed with the R&D team's findings

The Solution

Data with auditable backing

The sensor history stops being a lost file: every reading lands in an immutable ledger.

• AWS QLDB as an immutable record of sensor history
• Full traceability: what data, from which sensor, at what time
• Foundation for data audits and informed decisions

Productized ML analysis

What started as a Colab prototype ended as a production pipeline.

• Data pipeline with Python + Scikit-learn
• Moisture, temperature and irrigation signal analysis
• Automated nightly sync with no manual intervention

Real-time visibility

The team sees crop status up to date and receives automatic alerts.

• Real-time visualizations with Matplotlib/Seaborn
• Automated crop alerts by thresholds
• A single unified view of the field for the team

Results & Impact

R&D
Project audit passed
100%
Sensor data with traceability
Automatic
Alerts by crop thresholds
Nightly
Automated IoT sync

Key Learnings

  • ✓ Prototype to production: starting in Colab accelerated hypothesis validation before investing in infrastructure.
  • ✓ Ledger as an asset: QLDB turned the history into an auditable asset instead of a loose data repository.
  • ✓ Alerts that arrive on their own: automating the sync is what made the operational difference: without a pipeline, there are no alerts.

Tech Stack

Data and ML

• Python
• Scikit-learn
• Google Colab
• Matplotlib
• Seaborn

Backend

• Node.js
• AWS Lambda
• AWS EventBridge
• AWS QLDB

Frontend

• Angular
• Real-time visualizations

Need sensor data with backing and alerts?

If you have IoT devices generating data you're not leveraging, let's build the pipeline: analysis, traceability and alerts.