Remote Irrigation IoT Logs
This dataset provides granular operational logs from networked agricultural IoT devices used in remote irrigation systems. It includes device metadata, event types, sensor readings, water usage statistics, and anomaly reports, enabling advanced analytics for optimizing irrigation, detecting faults, and supporting sustainable water management. Ideal for AI/ML teams seeking actionable insights into smart agriculture operations.
Sample rows
preview · 8 of 120 rows · all 21 columns| log_idstring | statusstring | signal_strength_dbmfloat | field_idstring | device_idstring | timestampdatetime | farm_idstring | device_typestring | event_typestring | soil_moisturefloat | temperature_celsiusfloat | humidity_percentfloat | water_flow_rate_lpmfloat | irrigation_duration_secinteger | water_volume_litersfloat | battery_level_percentfloat | location_latitudefloat | location_longitudefloat | anomaly_codestring | notesstring | anomaly_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LOG0001 | normal | -62.3 | FIELD_01 | DEV_A100 | 2023-05-14T04:15:23Z | FARM_XYZ | soil_sensor | sensor_reading | 34.7 | 15.2 | 56.4 | blank | blank | blank | 88.2 | 29.4317 | -82.1372 | blank | Routine sensor check before sunrise | blank |
| LOG0002 | success | -38.9 | FIELD_01 | DEV_B150 | 2023-05-14T05:12:08Z | FARM_XYZ | valve_controller | irrigation_started | blank | blank | blank | 21.4 | 780 | 174.2 | 95.6 | 29.4318 | -82.1373 | blank | Automated schedule triggered for morning irrigation | blank |
| LOG0003 | normal | -12.4 | blank | DEV_C101 | 2023-05-14T06:03:44Z | FARM_XYZ | weather_station | sensor_reading | blank | 18.5 | 62.3 | blank | blank | blank | 72 | 29.432 | -82.1369 | blank | Afternoon weather station reading | blank |
| LOG0004 | success | -74.2 | FIELD_02 | DEV_D202 | 2023-05-14T06:15:18Z | FARM_XYZ | soil_sensor | sensor_reading | 57.1 | 21.6 | 42.8 | blank | blank | blank | 68.9 | 29.4324 | -82.1379 | blank | Pre-dawn sensor reading | blank |
| LOG0005 | success | -86.9 | FIELD_10 | DEV_E300 | 2023-05-14T07:02:51Z | FARM_QRS | flow_meter | sensor_reading | blank | blank | blank | 18.3 | blank | blank | 59.7 | 35.5104 | -91.432 | blank | Peak irrigation flow measured | blank |
| LOG0006 | success | -42.3 | FIELD_01 | DEV_B150 | 2023-05-14T07:32:26Z | FARM_XYZ | valve_controller | irrigation_stopped | blank | blank | blank | 20.8 | 780 | 174.2 | 92.1 | 29.4318 | -82.1373 | blank | Irrigation completed successfully | blank |
| LOG0007 | warning | -101.3 | FIELD_01 | DEV_A100 | 2023-05-14T08:22:17Z | FARM_XYZ | soil_sensor | anomaly_detected | 100 | 22.4 | 98.7 | blank | blank | blank | 16.4 | 29.4317 | -82.1372 | SM_MAX100 | Saturated soil reading reported | Soil moisture reading at maximum, potential sensor fault. |
| LOG0008 | success | -11 | blank | DEV_F400 | 2023-05-14T09:15:29Z | FARM_QRS | weather_station | maintenance | blank | blank | blank | blank | blank | blank | 99.2 | 35.5108 | -91.4317 | blank | Firmware updated successfully | blank |
| LOG0009 | failure | -150 | FIELD_10 | DEV_G501 | 2023-05-14T10:01:18Z | FARM_QRS | flow_meter | anomaly_detected | blank | blank | blank | -0.1 | blank | blank | 7.2 | 35.5104 | -91.432 | WM_NEGFLOW | Flow meter anomaly, urgent check needed | Negative flow rate detected — possible reverse flow. |
| LOG0010 | warning | -97.4 | FIELD_12 | DEV_H600 | 2023-05-14T11:19:37Z | FARM_QRS | soil_sensor | sensor_reading | 2.1 | 11.8 | 9.6 | blank | blank | blank | 21.3 | 35.5121 | -91.433 | blank | Low soil moisture detected | blank |
| LOG0011 | success | -36.7 | FIELD_13 | DEV_I700 | 2023-05-14T11:45:16Z | FARM_QRS | valve_controller | irrigation_started | blank | blank | blank | 19.2 | 600 | 120.5 | 86.7 | 35.5125 | -91.4333 | blank | Scheduled irrigation event started | blank |
| LOG0012 | error | -150 | blank | DEV_J800 | 2023-05-14T12:17:44Z | FARM_QRS | other | error | blank | 80 | blank | 0 | blank | blank | 4.8 | -90 | 180 | OTH_TEMP80 | Critical error, device location extreme pole | Temperature at device exceeded operational limit. |
| LOG0013 | normal | -65.2 | FIELD_21 | DEV_K900 | 2023-05-14T12:58:31Z | FARM_MNO | soil_sensor | sensor_reading | 41.3 | 23.9 | 38.2 | blank | blank | blank | 75.1 | 44.2134 | -113.3321 | blank | Routine check after irrigation | blank |
| LOG0014 | success | -39.1 | FIELD_13 | DEV_I700 | 2023-05-14T13:13:03Z | FARM_QRS | valve_controller | irrigation_stopped | blank | blank | blank | 19 | 600 | 120.5 | 84.2 | 35.5125 | -91.4333 | blank | Irrigation cycle ended | blank |
| LOG0015 | error | -150 | FIELD_22 | DEV_L100 | 2023-05-14T13:55:40Z | FARM_MNO | flow_meter | error | blank | blank | blank | 99.9 | blank | blank | 0 | 44.2134 | -113.3321 | FM_OVERFLW | Overflow error detected at flow meter | Flow meter reported overflow condition. |
| LOG0016 | success | -73.9 | FIELD_23 | DEV_M200 | 2023-05-14T14:21:17Z | FARM_MNO | soil_sensor | sensor_reading | 60.1 | 19.7 | 44.6 | blank | blank | blank | 82.5 | 44.2138 | -113.3325 | blank | Soil moisture optimal after rainfall | blank |
| LOG0017 | success | -15.2 | blank | DEV_N300 | 2023-05-14T15:02:53Z | FARM_MNO | weather_station | sensor_reading | blank | 28.6 | 48.1 | blank | blank | blank | 68 | 44.2133 | -113.332 | blank | Warm afternoon temperature recorded | blank |
| LOG0018 | warning | -99.8 | FIELD_21 | DEV_O400 | 2023-05-14T16:23:32Z | FARM_MNO | soil_sensor | anomaly_detected | 0 | 10.1 | 0 | blank | blank | blank | 18.4 | 44.2134 | -113.3321 | SM_ZERO00 | Possible sensor dry-out anomaly | Soil moisture reading zero, possible dry patch. |
| LOG0019 | failure | -150 | blank | DEV_P500 | 2023-05-14T16:45:57Z | FARM_MNO | other | anomaly_detected | blank | -50 | blank | blank | blank | blank | 2.1 | 90 | -180 | OTH_NEGTMP | Boundary value test | Negative extreme temperature detected at device. |
| LOG0020 | success | -30 | FIELD_40 | DEV_Q600 | 2023-05-14T17:32:14Z | FARM_STU | valve_controller | maintenance | blank | blank | blank | blank | blank | blank | 100 | 52.214 | -101.34 | blank | Valve cleaned and tested | blank |
What the 120 rows show
from the 120-row sampleError status stands out: mean signal_
- -62.9median signal_
strength_ dbm - 5device types
- 7event types
- 14farms
- 44.4median soil_
moisture - 20.6median temperature_
celsius
Median -62.9, from -150.0 to 0.0.
- string 10
- integer 1
- float 9
- datetime 1
Columns
21 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
log_id | string | Unique identifier for each log entryunique | LOG0001 |
device_id | string | Unique identifier for the IoT device generating the log | DEV_A100 |
farm_id | string | Unique identifier for the farm or agricultural site | FARM_XYZ |
field_id | string | Identifier for the specific field or plot within the farmoptional | FIELD_01 |
device_type | string | Type of IoT device (e.g., soil_sensor, valve_controller, weather_station)5 values | soil_sensor |
event_type | string | Type of event or action logged (e.g., irrigation_started, irrigation_stopped, anomaly_detected, sensor_reading)7 values | sensor_reading |
status | string | Status of the device or event (e.g., success, failure, warning, normal, error)6 values · optional | normal |
anomaly_code | string | Code representing the type of anomaly detected, if anyoptional | SM_MAX100 |
anomaly_description | string | Detailed description of the anomaly or error, if applicableoptional | Soil moisture reading at … |
notes | string | Additional notes or comments about the log entryoptional | Pre-dawn sensor reading |
| Numbers 10 columns | |||
soil_moisture | float | Soil moisture level as measured by the device (percentage, 0-100)0 to 100 · optional | 34.7 |
temperature_celsius | float | Temperature reading in degrees Celsius-50 to 80 · optional | 15.2 |
humidity_percent | float | Relative humidity percentage (0-100)0 to 100 · optional | 56.4 |
water_flow_rate_lpm | float | Water flow rate in liters per minute0 or more · optional | 21.4 |
irrigation_duration_sec | integer | Duration of the irrigation event in seconds0 or more · optional | 780 |
water_volume_liters | float | Total volume of water used during the event (liters)0 or more · optional | 174.2 |
battery_level_percent | float | Battery level of the device as a percentage (0-100)0 to 100 · optional | 88.2 |
signal_strength_dbm | float | Wireless signal strength in dBm-150 to 0 · optional | -62.3 |
location_latitude | float | Latitude coordinate of the device at the time of log-90 to 90 · optional | 29.4317 |
location_longitude | float | Longitude coordinate of the device at the time of log-180 to 180 · optional | -82.1372 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the log entry was recorded (in UTC) | 2023-05-14T04:15:23Z |
Use it for
An agriculture dashboard
Signal_
strength_ dbm by status and a breakdown of field_ id. Excel, Power BI or Tableau. Why do the 11 error rows have a mean signal_
strength_ dbm of -150.0? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs120LOG0001-62.3normalLOG0002-38.9successLOG0003-12.4normal
A software demo
Believable logs with device_
id, timestamp and farm_ id to fill a screen in front of a buyer.
blueprint · remote-irrigation-iot-logs
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 21 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 single irrigation event with timestamp.
- Records include device ID, water dispensed (liters), and valve status.
- Events flagged for abnormal duration or quantity must include an 'anomaly' indicator.
- Sensor data must track soil moisture and weather conditions at event time.
- Device offline or error events must be recorded with error code.
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
- remote-irrigation-iot-logs