Farm IoT Biodiversity Monitoring
This dataset provides comprehensive, farm-level IoT monitoring data for biodiversity and water conservation metrics, including sensor readings, species detection, and sustainability goal tracking. It enables AgTech professionals to analyze ecosystem impacts, optimize resource usage, and assess progress towards conservation targets using structured, location-aware sensor data. Ideal for sustainability analytics, operational benchmarking, and precision agriculture applications.
Sample rows
preview · 8 of 146 rows · all 24 columns| farm_idstring | sensor_typestring | goal_current_valuefloat | goal_statusstring | farm_namestring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | address_countrystring | sensor_idstring | sensor_location_latitudefloat | sensor_location_longitudefloat | measurement_idstring | measurement_timestampdatetime | species_detected_countinteger | water_usage_litersfloat | soil_moisture_percentfloat | temperature_celsiusfloat | humidity_percentfloat | conservation_goal_idstring | conservation_goal_descriptionstring | goal_target_valuefloat | species_detected_liststring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FARM001 | biodiversity | 7 | on_track | Willow Creek Valley Farm | 271 Country Route 3 | Syracuse | New York | 13201 | USA | SEN-FARM001-01 | 43.0499 | -76.1474 | MEAS-00001 | 2021-03-14T10:25:46 | 7 | blank | blank | 10.5 | 51.7 | GOAL-FARM001-1 | Increase native pollinator species diversity | 15 | Sturnus vulgaris,Sciurus carolinensis,Quercus alba,Procyon lotor,Turdus migratorius |
| FARM002 | water | 8375.2 | behind | Silverleaf Acres | 44 Pine Hill Road | Lexington | Kentucky | 40509 | USA | SEN-FARM002-02 | 38.0406 | -84.5037 | MEAS-00002 | 2022-07-04T13:40:03 | blank | 8375.2 | blank | 29.2 | 68.1 | GOAL-FARM002-1 | Reduce annual irrigation by 15 percent | 30000 | blank |
| FARM003 | soil_moisture | 41.7 | on_track | Prairie Ridge Homestead | 8125 Winding Trail | Wichita | Kansas | 67209 | USA | SEN-FARM003-01 | 37.6872 | -97.3301 | MEAS-00003 | 2023-11-09T08:19:34 | blank | blank | 41.7 | 6.4 | 65.9 | GOAL-FARM003-2 | Maintain optimal root zone moisture | 55 | blank |
| FARM004 | weather | 2 | on_track | Greenstone Farms | 199 Maplewood Avenue | Olympia | Washington | 98506 | USA | SEN-FARM004-01 | 47.0379 | -122.9007 | MEAS-00004 | 2022-01-15T17:03:15 | blank | blank | blank | 5.2 | 89.3 | GOAL-FARM004-1 | Track frost event frequency | 10 | blank |
| FARM005 | other | 93.1 | on_track | Sunrise Orchard Cooperative | 78 Apple Blossom Lane | Boise | Idaho | 83709 | USA | SEN-FARM005-01 | 43.615 | -116.2023 | MEAS-00005 | 2023-06-23T14:11:08 | blank | blank | blank | 33.8 | 42.9 | GOAL-FARM005-1 | Monitor solar panel efficiency | 95 | blank |
| FARM006 | biodiversity | 0 | not_started | Blue Horizon Estate | 1245 Ridge View Drive | Madison | Wisconsin | 53703 | USA | SEN-FARM006-01 | 43.0731 | -89.4012 | MEAS-00006 | 2024-02-03T13:22:47 | 0 | blank | blank | -2.7 | 78.6 | GOAL-FARM006-1 | Restore grassland pollinator presence | 30 | blank |
| FARM007 | water | 20765.8 | behind | Meadowrun Dairy Collective | 3128 Farmstead Drive | Lancaster | Pennsylvania | 17601 | USA | SEN-FARM007-02 | 40.0379 | -76.3055 | MEAS-00007 | 2021-05-20T09:18:24 | blank | 20765.8 | blank | 17.2 | 55.3 | GOAL-FARM007-1 | Cut water usage by 10 percent | 50000 | blank |
| FARM008 | soil_moisture | 63.4 | achieved | Emerald Valley Farms | 651 Green Pasture Road | Eugene | Oregon | 97402 | USA | SEN-FARM008-01 | 44.0521 | -123.0868 | MEAS-00008 | 2022-09-13T16:56:59 | blank | blank | 63.4 | 22.6 | 49.2 | GOAL-FARM008-2 | Maintain soil moisture above 60 percent | 60 | blank |
| FARM009 | weather | 1 | on_track | Tallgrass Prairie Farm | 3699 Prairie Loop | Tulsa | Oklahoma | 74107 | USA | SEN-FARM009-01 | 36.1539 | -95.9928 | MEAS-00009 | 2024-04-02T06:49:51 | blank | blank | blank | 18.2 | 34.8 | GOAL-FARM009-2 | Track drought risk frequency | 3 | blank |
| FARM010 | other | 115.4 | on_track | Cedar Grove Plantation | 1877 Cedar Grove Road | Greenville | South Carolina | 29615 | USA | SEN-FARM010-01 | 34.8526 | -82.394 | MEAS-00010 | 2021-08-17T11:12:52 | blank | blank | blank | 28.6 | 71.5 | GOAL-FARM010-2 | Increase on-site solar output | 120 | blank |
| FARM011 | biodiversity | 25 | on_track | Riverbend Vineyard | 2359 Valley Road | Napa | California | 94558 | USA | SEN-FARM011-01 | 38.2975 | -122.2869 | MEAS-00011 | 2023-05-29T13:37:41 | 25 | blank | blank | 22.3 | 39.1 | GOAL-FARM011-2 | Expand vineyard biodiversity zones | 30 | Vitis vinifera,Taraxacum officinale,Apis mellifera,Ardea herodias |
| FARM012 | water | 19874 | on_track | Ironwood Ranch | 990 Ironwood Lane | Tucson | Arizona | 85746 | USA | SEN-FARM012-02 | 32.2226 | -110.9747 | MEAS-00012 | 2022-06-11T15:56:02 | blank | 19874 | blank | 34.7 | 21.2 | GOAL-FARM012-1 | Limit water withdrawals from aquifer | 40000 | blank |
| FARM013 | soil_moisture | 0 | not_started | Oakridge Family Farm | 1447 Oakridge Drive | Austin | Texas | 78745 | USA | SEN-FARM013-01 | 30.2672 | -97.7431 | MEAS-00013 | 2021-04-28T09:13:23 | blank | blank | 0 | 33.4 | 16.9 | GOAL-FARM013-2 | Keep moisture above drought threshold | 20 | blank |
| FARM014 | weather | 2 | behind | Maple Hollow Gardens | 23 Maple Hollow Road | Manchester | New Hampshire | 03103 | USA | SEN-FARM014-01 | 42.9956 | -71.4548 | MEAS-00014 | 2023-10-18T15:17:56 | blank | blank | blank | 12.8 | 71.2 | GOAL-FARM014-1 | Monitor frost events in autumn | 6 | blank |
| FARM015 | other | 75 | achieved | Golden Valley Organics | 88 Harvest Lane | Fresno | California | 93722 | USA | SEN-FARM015-02 | 36.7378 | -119.7871 | MEAS-00015 | 2022-02-25T12:09:15 | blank | blank | blank | 19.7 | 53.8 | GOAL-FARM015-1 | Optimize compost heating cycle | 75 | blank |
| FARM016 | biodiversity | 53 | on_track | Red Barn Heritage Farm | 47 Red Barn Road | Des Moines | Iowa | 50310 | USA | SEN-FARM016-01 | 41.5868 | -93.625 | MEAS-00016 | 2023-07-12T07:33:41 | 53 | blank | blank | 25.4 | 61.5 | GOAL-FARM016-2 | Increase ecosystem species richness | 60 | Odocoileus virginianus,Canis latrans,Felis catus,Quercus rubra |
| FARM017 | water | 15000.6 | behind | Hilltop Produce Fields | 562 Hilltop Way | Denver | Colorado | 80221 | USA | SEN-FARM017-02 | 39.7392 | -104.9903 | MEAS-00017 | 2022-05-17T18:53:22 | blank | 15000.6 | blank | 26.1 | 34.2 | GOAL-FARM017-1 | Lower irrigation in dry season | 30000 | blank |
| FARM018 | soil_moisture | 99.5 | achieved | Pinecrest Growers | 97 Pinecrest Drive | Portland | Maine | 04102 | USA | SEN-FARM018-01 | 43.6591 | -70.2568 | MEAS-00018 | 2024-03-08T15:28:47 | blank | blank | 99.5 | 7.8 | 87.1 | GOAL-FARM018-2 | Prevent root zone overwatering | 80 | blank |
| FARM019 | weather | 10 | achieved | Amber Fields Organic | 263 Amber Fields Lane | Columbus | Ohio | 43215 | USA | SEN-FARM019-01 | 39.9612 | -82.9988 | MEAS-00019 | 2023-02-21T10:37:16 | blank | blank | blank | -9.3 | 98.2 | GOAL-FARM019-2 | Monitor freeze events in winter | 10 | blank |
| FARM020 | other | 88 | achieved | Willowbrook Urban Farm | 12 Willowbrook Avenue | Seattle | Washington | 98109 | USA | SEN-FARM020-01 | 47.6062 | -122.3321 | MEAS-00020 | 2022-12-04T12:16:29 | blank | blank | blank | 8.2 | 87.6 | GOAL-FARM020-1 | Increase hydroponic system efficiency | 88 | blank |
What the 146 rows show
from the 146-row sampleWater (sensor type) stands out: mean goal_
- 47.8median goal_
current_ value - 24median species_
detected_ count - 15,001median water_
usage_ liters - 41.7median soil_
moisture_ percent - 17.2median temperature_
celsius - 66.0median humidity_
percent
Median 47.8, from 0.0 to 33,014.
- string 14
- integer 1
- float 8
- datetime 1
Columns
24 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
farm_id | string | Unique identifier for the farm deploymentunique | FARM001 |
farm_name | string | Name of the farm or agricultural site | Willow Creek Valley Farm |
address_street | string | Street address of the farm | 271 Country Route 3 |
address_city | string | City where the farm is located | Syracuse |
address_state | string | State or region of the farm | New York |
address_postal_code | string | Postal code of the farm | 13201 |
address_country | string | Country where the farm is located | USA |
sensor_id | string | Unique identifier for the IoT sensor device | SEN-FARM001-01 |
sensor_type | string | Type of sensor (e.g., biodiversity, water, soil moisture)biodiversity · water · soil_moisture · weather · other | biodiversity |
measurement_id | string | Unique identifier for each sensor measurement eventunique | MEAS-00001 |
species_detected_list | string | Comma-separated list of species names detected (flat string)optional | Apidae,Papilio glaucus |
conservation_goal_id | string | Unique identifier for the farm's conservation or sustainability goaloptional | GOAL-FARM001-1 |
conservation_goal_description | string | Description of the specific conservation or sustainability goaloptional | Monitor heat wave events |
goal_status | string | Status of the conservation goal (e.g., on_track, behind, achieved)on_track · behind · achieved · not_started · optional | on_track |
| Numbers 9 columns | |||
sensor_location_latitude | float | Latitude coordinate of the sensor location-90 to 90 | 43.0499 |
sensor_location_longitude | float | Longitude coordinate of the sensor location-180 to 180 | -76.1474 |
species_detected_count | integer | Number of distinct species detected by biodiversity sensors0 or more · optional | 7 |
water_usage_liters | float | Total water usage measured in liters during the event0 or more · optional | 8375.2 |
soil_moisture_percent | float | Soil moisture percentage at the sensor location0 to 100 · optional | 41.7 |
temperature_celsius | float | Ambient temperature in degrees Celsius at the sensor locationoptional | 10.5 |
humidity_percent | float | Relative humidity percentage at the sensor location0 to 100 · optional | 51.7 |
goal_target_value | float | Target value for the conservation goal (e.g., target water usage, species count)optional | 15 |
goal_current_value | float | Current measured value towards the conservation goaloptional | 7 |
| Dates and times 1 column | |||
measurement_timestamp | datetime | Timestamp when the measurement was recorded | 2021-03-14T10:25:46 |
Use it for
An agriculture dashboard
Goal_
current_ value by sensor_ type and a breakdown of goal_ status. Excel, Power BI or Tableau. Why do the 29 water rows have a mean goal_
current_ value of 15,456? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Farms146FARM0017biodiver…FARM0028375.2waterFARM00341.7soil_moi…
A software demo
Believable farms with farm_
name, address_ street and address_ city to fill a screen in front of a buyer.
This dataset146 rows24 columns
Yours1,000 rows24 columnsaddress_street: UK only
blueprint · farm-iot-biodiversity-monitoring
Behind this dataset
Same schema. As many rows as you need.
These 146 rows came out of a blueprint — 24 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.
Rules it was built with
- Each farm entry includes sensor readings for soil moisture, local species index, and water usage.
- Biodiversity score computed from species count and sensor activity logs.
- Water conservation flag set if average usage per crop falls below threshold for two weeks.
- Alerts generated for biodiversity drop over consecutive sensor checks.
- Farm type and weather conditions must be consistently logged for each record.
Open the blueprint in Data Factory
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
- farm-iot-biodiversity-monitoring