Smart Irrigation System Event Logs
This dataset provides granular event logs from smart irrigation systems deployed in SME agricultural settings, capturing operational activity, faults, water usage, and sustainability interventions. It enables agri-tech startups and farm managers to monitor device performance, optimize water consumption, and track climate resilience actions, supporting data-driven precision agriculture and sustainability reporting.
Sample rows
preview · 8 of 94 rows · all 17 columns| event_idstring | event_typestring | water_usage_litersfloat | sustainability_flagboolean | operator_idstring | device_idstring | farm_idstring | event_timestampdatetime | event_subtypestring | statusstring | duration_secondsinteger | fault_codestring | fault_descriptionstring | location_latitudefloat | location_longitudefloat | notesstring | optimization_actionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EVT001-2024-06-01T08:01:45 | operational | 120.7 | false | OP100 | DEV-A1001 | FARM-CA-001 | 2024-06-01T08:01:45 | start | active | 1800 | blank | blank | 36.7783 | -119.4179 | Morning cycle started successfully. | blank |
| EVT002-2024-06-01T08:33:02 | fault | 15.2 | true | OP102 | DEV-A1002 | FARM-CA-001 | 2024-06-01T08:33:02 | leak_detected | error | 635 | F102 | Pipe leak detected on sector 2. | 36.7784 | -119.4182 | Leak detected; irrigation halted. | blank |
| EVT003-2024-06-01T09:05:27 | operational | 110.3 | false | OP101 | DEV-A1003 | FARM-CA-002 | 2024-06-01T09:05:27 | stop | inactive | 1750 | blank | blank | 36.7791 | -119.4195 | Irrigation cycle completed. | blank |
| EVT004-2024-06-01T09:17:09 | optimization | 98.5 | true | OP103 | DEV-A1004 | FARM-CA-002 | 2024-06-01T09:17:09 | schedule_adjusted | maintenance | 1480 | blank | blank | 36.7793 | -119.4199 | Schedule optimized for water conservation. | Adjusted watering schedule for drought conditions. |
| EVT005-2024-06-01T10:02:53 | operational | 134.9 | false | OP104 | DEV-A1005 | FARM-CA-003 | 2024-06-01T10:02:53 | start | active | 2100 | blank | blank | 36.7801 | -119.4205 | Cycle started as scheduled. | blank |
| EVT006-2024-06-01T10:30:18 | fault | 25.6 | false | OP105 | DEV-A1006 | FARM-CA-003 | 2024-06-01T10:30:18 | low_pressure | error | 500 | F201 | Low water pressure detected in main line. | 36.7803 | -119.4208 | Pressure dropped below threshold. | blank |
| EVT007-2024-06-01T11:12:41 | operational | 129.6 | false | OP106 | DEV-A1007 | FARM-CA-004 | 2024-06-01T11:12:41 | start | active | 1860 | blank | blank | 36.7806 | -119.4211 | Cycle started, soil moisture adequate. | blank |
| EVT008-2024-06-01T11:44:03 | optimization | 97.2 | true | OP107 | DEV-A1008 | FARM-CA-004 | 2024-06-01T11:44:03 | flow_rate_adjusted | maintenance | 1600 | blank | blank | 36.7809 | -119.4214 | Adjustment made for sustainability. | Reduced flow rate for eco mode. |
| EVT009-2024-06-01T12:05:29 | operational | 121.4 | false | OP108 | DEV-A1009 | FARM-CA-005 | 2024-06-01T12:05:29 | stop | inactive | 1950 | blank | blank | 36.7812 | -119.4218 | Cycle stopped, pump auto-shutdown. | blank |
| EVT010-2024-06-01T12:37:16 | fault | 10.8 | false | OP109 | DEV-A1010 | FARM-CA-005 | 2024-06-01T12:37:16 | sensor_failure | error | 300 | F301 | Moisture sensor failure on device. | 36.7815 | -119.4221 | Sensor replaced by technician. | blank |
| EVT011-2024-06-02T07:58:22 | operational | 125.1 | false | OP100 | DEV-A1001 | FARM-CA-001 | 2024-06-02T07:58:22 | start | active | 1815 | blank | blank | 36.7783 | -119.4179 | Cycle started, weather clear. | blank |
| EVT012-2024-06-02T08:31:47 | optimization | 99.7 | true | OP102 | DEV-A1002 | FARM-CA-001 | 2024-06-02T08:31:47 | schedule_adjusted | maintenance | 1500 | blank | blank | 36.7784 | -119.4182 | Adapted for weather predictions. | Schedule shortened for rainfall forecast. |
| EVT013-2024-06-02T09:02:16 | fault | 8.1 | false | OP101 | DEV-A1003 | FARM-CA-002 | 2024-06-02T09:02:16 | valve_jam | error | 280 | F401 | Irrigation valve jammed, cycle interrupted. | 36.7791 | -119.4195 | Valve serviced post event. | blank |
| EVT014-2024-06-02T09:31:38 | operational | 115.9 | false | OP103 | DEV-A1004 | FARM-CA-002 | 2024-06-02T09:31:38 | stop | inactive | 1680 | blank | blank | 36.7793 | -119.4199 | Cycle ended, moisture levels optimal. | blank |
| EVT015-2024-06-02T10:15:02 | operational | 133.5 | false | OP104 | DEV-A1005 | FARM-CA-003 | 2024-06-02T10:15:02 | start | active | 2050 | blank | blank | 36.7801 | -119.4205 | Cycle started, parameters normal. | blank |
| EVT016-2024-06-02T10:44:27 | optimization | 105.6 | true | OP105 | DEV-A1006 | FARM-CA-003 | 2024-06-02T10:44:27 | flow_rate_adjusted | maintenance | 1690 | blank | blank | 36.7803 | -119.4208 | Eco mode activated. | Flow rate reduced for water savings. |
| EVT017-2024-06-02T11:08:55 | operational | 130.2 | false | OP106 | DEV-A1007 | FARM-CA-004 | 2024-06-02T11:08:55 | stop | inactive | 1920 | blank | blank | 36.7806 | -119.4211 | Irrigation stopped as scheduled. | blank |
| EVT018-2024-06-02T11:32:39 | fault | 12.4 | true | OP107 | DEV-A1008 | FARM-CA-004 | 2024-06-02T11:32:39 | leak_detected | error | 413 | F102 | Leak detected near pump area. | 36.7809 | -119.4214 | Maintenance team notified. | blank |
| EVT019-2024-06-02T12:09:18 | optimization | 108.2 | true | OP108 | DEV-A1009 | FARM-CA-005 | 2024-06-02T12:09:18 | schedule_adjusted | maintenance | 1520 | blank | blank | 36.7812 | -119.4218 | Night cycle reduced for cost savings. | Schedule adjusted for reduced night cycle. |
| EVT020-2024-06-02T12:38:41 | operational | 118.7 | false | OP109 | DEV-A1010 | FARM-CA-005 | 2024-06-02T12:38:41 | start | active | 1805 | blank | blank | 36.7815 | -119.4221 | Cycle started after optimization. | blank |
What the 94 rows show
from the 94-row sampleFault (event type) stands out: mean water_
- 23%sustainability_
flag = true - 116.5median water_
usage_ liters - 4statuses
- 11farms
- 16event subtypes
- 18devices
Median 116.5, from 0.0 to 214.5.
- string 11
- integer 1
- float 3
- datetime 1
- boolean 1
Columns
17 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
event_id | string | Unique identifier for each event log entryunique | evt-20001 |
device_id | string | Unique identifier for the smart irrigation device | DEV-A1001 |
farm_id | string | Unique identifier for the farm where the device is located11 farms | FARM-CA-001 |
event_type | string | Type of event (e.g., operational, fault, optimization)operational · fault · optimization | operational |
event_subtype | string | Specific subtype of the event (e.g., start, stop, leak_detected, schedule_adjusted)optional | start |
status | string | Status of the device at the time of event (e.g., active, inactive, error, maintenance)active · inactive · error · maintenance | active |
fault_code | string | Code representing the specific fault (if applicable)optional | F102 |
fault_description | string | Detailed description of the fault (if applicable)optional | Leak detected, sector 3. |
optimization_action | string | Description of any optimization or intervention performed (if applicable)optional | Adjusted watering schedul… |
operator_id | string | Identifier for the operator or system triggering the eventoptional | OP100 |
notes | string | Additional notes or comments about the eventoptional | Eco mode activated. |
| Numbers 4 columns | |||
water_usage_liters | float | Amount of water used during the event, in liters0 or more · optional | 120.7 |
duration_seconds | integer | Duration of the event in seconds0 or more · optional | 1800 |
location_latitude | float | Latitude coordinate of the device-90 to 90 · optional | 36.7783 |
location_longitude | float | Longitude coordinate of the device-180 to 180 · optional | -119.4179 |
| Dates and times 1 column | |||
event_timestamp | datetime | Date and time when the event occurred | 2024-06-01T08:01:45 |
| True or false 1 column | |||
sustainability_flag | boolean | Indicates if the event is related to a sustainability interventionoptional | false |
Use it for
An agriculture dashboard
The sustainability_
flag rate, water_ usage_ liters by event_ type and a breakdown of operator_ id. Excel, Power BI or Tableau. Why do the 16 fault rows have a mean water_
usage_ liters of 13.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Events94EVT001-2024-06-01T08:01:45120.7operatio…EVT002-2024-06-01T08:33:0215.2faultEVT004-2024-06-01T09:17:0998.5optimiza…
A software demo
Believable events with device_
id, farm_ id and event_ timestamp to fill a screen in front of a buyer.
blueprint · smart-irrigation-system-event-logs
Behind this dataset
Same schema. As many rows as you need.
These 94 rows came out of a blueprint — 17 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 represents a unique event generated by an irrigation device
- Events include type (activation, fault, optimization), timestamp, device ID, and water volume impacted
- Fault events must indicate severity and whether remote intervention resolved the issue
- Optimization events must record the sustainability metric improved (e.g., water saved, energy reduced)
- Only devices registered to SME farms are included
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- smart-irrigation-system-event-logs