Agricultural IoT Smart Irrigation Logs
This dataset contains granular event logs from IoT-enabled smart irrigation systems, recording sensor measurements, automated watering actions, environmental conditions, and system alerts across multiple farms and zones. It enables AgTech professionals to analyze water usage efficiency, monitor device health, and implement predictive maintenance for sustainable, data-driven farm management.
Sample rows
preview · 8 of 120 rows · all 22 columns| log_idstring | event_typestring | battery_levelfloat | maintenance_requiredboolean | alert_typestring | device_idstring | farm_idstring | zone_idstring | timestampdatetime | soil_moisturefloat | soil_temperaturefloat | air_temperaturefloat | humidityfloat | rainfallfloat | water_flow_ratefloat | water_volumefloat | watering_durationinteger | valve_statusstring | signal_strengthfloat | operator_idstring | notesstring | alert_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A3C9D1E2-001-BATCH1 | sensor_reading | 92.5 | false | blank | dev-001 | farm-north1 | zone-01 | 2024-06-19T05:12:37 | 45.2 | 19.1 | 20.6 | 78.9 | 0 | blank | blank | blank | blank | -62 | blank | blank | blank |
| F14B-0A21-78E2-BATCH1 | watering_action | 86.4 | false | blank | dev-002 | farm-west2 | zone-05 | 2024-06-19T06:43:21 | 33.1 | 17.3 | 18.9 | 70.7 | 0.2 | 35.8 | 142 | 240 | open | -35 | blank | Automated irrigation sequence | blank |
| BATCH1-Y7K9W2D8S1 | alert | 10 | true | low_battery | dev-003 | farm-east1 | zone-09 | 2024-06-19T07:21:45 | 0 | -40 | blank | blank | blank | blank | blank | blank | blank | -120 | op-alex | Manual acknowledgment required | Device reported battery below threshold at 10%. |
| BATCH1-WT5-4Z8M2C9 | sensor_reading | 98.1 | false | blank | dev-010 | farm-south3 | zone-20 | 2024-06-19T08:59:00 | 49.3 | 15.2 | 17.8 | 63.4 | 0 | blank | blank | blank | blank | -45.6 | blank | blank | blank |
| BATCH1-0051C4A8E4 | maintenance | 95.7 | true | blank | dev-008 | farm-east2 | zone-15 | 2024-06-19T09:30:29 | blank | blank | blank | blank | blank | blank | blank | blank | blank | -22.8 | op-jordan | Firmware updated by technician | blank |
| BATCH1-XCM-4287 | watering_action | 77 | false | blank | dev-005 | farm-north1 | zone-03 | 2024-06-19T10:10:18 | 54.2 | 22.6 | 24.1 | 80.1 | 3.1 | 25.7 | 82.1 | 180 | closed | -67.2 | blank | End of scheduled cycle | blank |
| BATCH1-9R3J5V1P | alert | 7 | true | communication_loss | dev-009 | farm-west2 | zone-16 | 2024-06-19T11:38:09 | blank | blank | blank | blank | blank | blank | blank | blank | blank | -98 | op-nina | Communication interrupted, operator alerted | Lost connection with device, requires inspection. |
| BATCH1-QW8-42LKJ | sensor_reading | 100 | false | blank | dev-004 | farm-south1 | zone-11 | 2024-06-19T12:45:29 | 99.9 | 80 | 80 | 100 | 250 | blank | blank | blank | blank | -120 | blank | Edge case: Max sensor readings | blank |
| BATCH1-7H12K9E4 | watering_action | 81.6 | false | blank | dev-006 | farm-central1 | zone-07 | 2024-06-19T13:00:01 | 41 | 18.2 | 21.7 | 66.9 | 5.2 | 15.2 | 54.8 | 120 | open | -51.4 | blank | Automated irrigation sequence | blank |
| BATCH1-5G7P8Q1R | alert | 0 | true | leak_detected | dev-007 | farm-west3 | zone-14 | 2024-06-19T14:18:42 | 100 | 80 | 80 | 100 | 30.5 | blank | blank | blank | blank | -110 | op-jordan | Leak sensor tripped | Leak sensor triggered, excessive moisture detected. |
| BATCH1-N8K1L4W6 | watering_action | 100 | false | blank | dev-001 | farm-north1 | zone-02 | 2024-06-19T15:22:18 | 62.3 | 23.5 | 25.1 | 82 | 2.2 | 42.6 | 153.7 | 300 | open | -30 | op-nina | Manual override due to low moisture | blank |
| BATCH1-6V7M2T1B | sensor_reading | 77.2 | false | blank | dev-002 | farm-west2 | zone-06 | 2024-06-19T16:55:33 | 37.4 | 20.3 | 15.8 | 68.2 | 0.5 | blank | blank | blank | blank | -55.1 | blank | blank | blank |
| BATCH1-Q2W3E4R5T6 | watering_action | 88.9 | false | blank | dev-003 | farm-east1 | zone-10 | 2024-06-19T17:44:59 | 51.8 | 21.4 | 22.7 | 60.6 | 1.1 | 26.3 | 97.1 | 180 | closed | -44.5 | blank | End of scheduled cycle | blank |
| BATCH1-ZXCVB-1234 | alert | 23 | true | valve_failure | dev-004 | farm-south1 | zone-12 | 2024-06-19T18:09:07 | blank | blank | blank | blank | blank | blank | blank | blank | blank | -96 | op-alex | Operator inspection required | Valve failed to open, irrigation skipped. |
| BATCH1-LM6N8P2Q | sensor_reading | 80.2 | false | blank | dev-005 | farm-north1 | zone-04 | 2024-06-19T19:15:23 | 28.7 | 14.8 | 16.7 | 44.3 | 0 | blank | blank | blank | blank | -59.3 | blank | blank | blank |
| BATCH1-V2C1B3N4M | watering_action | 82.3 | false | blank | dev-006 | farm-central1 | zone-08 | 2024-06-19T20:05:11 | 70 | 18.3 | 17.9 | 67 | 1.7 | 28.9 | 98.6 | 120 | open | -53.2 | op-nina | Manual override due to low moisture | blank |
| BATCH1-4T5R6Y7U8I | alert | 0 | true | sensor_failure | dev-007 | farm-west3 | zone-17 | 2024-06-19T21:22:36 | 100 | -40 | 80 | 0 | 12.5 | blank | blank | blank | blank | -120 | blank | Sensor readings abnormal | Sensor reported out-of-range values, possible failure. |
| BATCH1-QW12ER34 | sensor_reading | 93.6 | false | blank | dev-008 | farm-east2 | zone-18 | 2024-06-19T22:55:08 | 59.9 | 23.7 | 21.2 | 74 | 0 | blank | blank | blank | blank | -36.4 | blank | blank | blank |
| BATCH1-PLM-9382 | watering_action | 65.8 | false | blank | dev-009 | farm-west2 | zone-19 | 2024-06-19T23:59:59 | 15 | 17.5 | 16 | 50.5 | 0 | 0 | 0 | 0 | error | -120 | op-alex | Calibration test, valve error detected | blank |
| BATCH1-7F3G2H1J | sensor_reading | 98 | false | blank | dev-010 | farm-south3 | zone-21 | 2024-06-20T00:23:44 | 60.1 | 25 | 24.6 | 85 | 0.3 | blank | blank | blank | blank | -40.2 | blank | blank | blank |
What the 120 rows show
from the 120-row sampleAlert (event type) stands out: mean battery_
- 29%maintenance_
required = true - 80.1median battery_
level - 3valve statuses
- 10devices
- 11operators
- 20farms
Median 80.1, from 0.0 to 100.0.
- string 10
- integer 1
- float 9
- datetime 1
- boolean 1
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
log_id | string | Unique identifier for each irrigation event log entryunique | A3C9D1E2-001-BATCH1 |
device_id | string | Unique identifier for the IoT device generating the log10 devices | dev-001 |
farm_id | string | Unique identifier for the farm or agricultural site | farm-north1 |
zone_id | string | Identifier for the specific irrigation zone or plot within the farm | zone-01 |
event_type | string | Type of event recorded (e.g., sensor_reading, watering_action, alert)sensor_reading · watering_action · alert · maintenance | sensor_reading |
valve_status | string | Status of the irrigation valve during the event (open, closed, error)open · closed · error · optional | open |
alert_type | string | Type of alert if event_type is 'alert' (e.g., low_battery, leak_detected, sensor_failure)5 values · optional | low_battery |
alert_description | string | Detailed description of the alert, if applicableoptional | Device reported battery b… |
operator_id | string | Identifier for the human operator (if any) who triggered or acknowledged the event11 operators · optional | op-alex |
notes | string | Additional notes or comments related to the eventoptional | End of scheduled cycle |
| Numbers 10 columns | |||
soil_moisture | float | Soil moisture percentage at the time of the event (0-100)0 to 100 · optional | 45.2 |
soil_temperature | float | Soil temperature in degrees Celsius-40 to 80 · optional | 19.1 |
air_temperature | float | Ambient air temperature in degrees Celsius-40 to 80 · optional | 20.6 |
humidity | float | Ambient relative humidity percentage (0-100)0 to 100 · optional | 78.9 |
rainfall | float | Rainfall measured in millimeters since last log0 or more · optional | 0 |
water_flow_rate | float | Water flow rate during irrigation in liters per minute0 or more · optional | 35.8 |
water_volume | float | Total volume of water dispensed during this event in liters0 or more · optional | 142 |
watering_duration | integer | Duration of watering in seconds0 or more · optional | 240 |
battery_level | float | Battery level of the IoT device as a percentage (0-100)0 to 100 · optional | 92.5 |
signal_strength | float | Wireless signal strength of the device in dBm-120 to 0 · optional | -62 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the log entry was recorded | 2024-06-19T05:12:37 |
| True or false 1 column | |||
maintenance_required | boolean | Indicates if maintenance is required based on this eventoptional | false |
Use it for
An agriculture dashboard
The maintenance_
required rate, battery_ level by event_ type and a breakdown of alert_ type. Excel, Power BI or Tableau. Why do the 28 alert rows have a mean battery_
level of 10.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs120A3C9D1E2-001-BATCH192.5sensor_r…BATCH1-Y7K9W2D8S110alertBATCH1-0051C4A8E495.7maintena…
A software demo
Believable logs with device_
id, farm_ id and zone_ id to fill a screen in front of a buyer.
blueprint · agricultural-iot-smart-irrigation-logs
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 22 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Each row must record a unique irrigation event from a specific sensor.
- Soil moisture and weather data must be logged before and after each watering action.
- Automated and manual irrigation actions are differentiated by action type.
- System alerts (e.g., fault, maintenance required) must be timestamped and categorized.
- Rows must include water consumption per event for sustainability tracking.
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- agricultural-iot-smart-irrigation-logs