Urban Farm IoT Sensor Metrics
This dataset provides granular, real-time IoT sensor readings from urban farms, including environmental metrics, sensor health, and compliance flags. It enables agtech startups and city planners to monitor resource usage, optimize crop yields, and ensure sustainability compliance at scale. The detailed schema supports operational analytics, regulatory reporting, and smart farm management.
Sample rows
preview · 8 of 120 rows · all 18 columns| farm_idstring | sensor_typestring | metric_valuefloat | data_quality_flagboolean | address_citystring | farm_namestring | address_streetstring | address_statestring | address_postal_codestring | address_countrystring | sensor_idstring | sensor_locationstring | timestampdatetime | metric_unitstring | sensor_statusstring | battery_levelfloat | compliance_flagboolean | operator_idstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FARM001 | temperature | 22.4 | true | Chicago | EcoUrban Grow | 112 Greenway Blvd | IL | 60616 | USA | temp-GH1 | Greenhouse North | 2024-05-22T08:23:00Z | C | active | 78.3 | true | chi_Martin |
| FARM002 | humidity | 61.2 | true | Toronto | Urban Harvest | 45 Cityview Dr | ON | M5V2B7 | Canada | hum-GH2 | Greenhouse East | 2024-05-22T10:05:00Z | % | active | 81.7 | true | tor_Miriam |
| FARM003 | soil_moisture | 42.5 | true | San Francisco | MetroSprout | 8 Solar Lane | CA | 94107 | USA | soilM-PT3 | Plot 3 | 2024-05-22T09:18:00Z | % | active | 74.1 | false | sf_Ruth |
| FARM004 | ph | 6.8 | true | Berlin | City Roots | 19 Vine St | BE | 10115 | Germany | ph-GH4 | Greenhouse South | 2024-05-22T11:30:00Z | pH | active | 66.9 | true | ber_Frank |
| FARM005 | light | 12500 | true | Austin | Urban Oasis | 7 Emerald Rd | TX | 78702 | USA | light-TS1 | Tunnel South | 2024-05-22T12:45:00Z | lux | active | 88.1 | true | aus_Carol |
| FARM006 | co2 | 430 | true | London | FreshTech Farm | 123 Future Ave | LDN | E1 6AN | UK | co2-GH7 | Greenhouse Center | 2024-05-22T14:10:00Z | ppm | active | 91 | true | lon_James |
| FARM007 | temperature | 28.1 | true | Singapore | AgriNext Urban | 200 Sprout Way | SG | 238978 | Singapore | temp-PT1 | Plot 1 | 2024-05-22T15:05:00Z | C | active | 79.5 | true | sg_Li |
| FARM008 | humidity | 74 | true | Sydney | GreenEdge Farm | 16 River Dr | NSW | 2000 | Australia | hum-GH3 | Greenhouse West | 2024-05-22T08:49:00Z | % | active | 83.2 | false | syd_Aaron |
| FARM009 | soil_moisture | 19.8 | true | New York | SkyFarm | 88 Skyline Ave | NY | 10013 | USA | soilM-PT4 | Plot 4 | 2024-05-22T16:20:00Z | % | active | 85.6 | false | ny_Monica |
| FARM010 | ph | 7.4 | true | Los Angeles | MetroFarm | 22 Urban St | CA | 90015 | USA | ph-PT2 | Plot 2 | 2024-05-22T17:11:00Z | pH | active | 93.7 | true | la_Luis |
| FARM001 | temperature | 24.2 | false | Chicago | EcoUrban Grow | 112 Greenway Blvd | IL | 60616 | USA | temp-GH2 | Greenhouse South | 2024-05-23T08:17:00Z | C | maintenance | 15.2 | false | chi_Martin |
| FARM002 | humidity | 80.5 | false | Toronto | Urban Harvest | 45 Cityview Dr | ON | M5V2B7 | Canada | hum-GH1 | Greenhouse North | 2024-05-23T10:42:00Z | % | maintenance | 17.4 | false | tor_Miriam |
| FARM003 | soil_moisture | 7 | false | San Francisco | MetroSprout | 8 Solar Lane | CA | 94107 | USA | soilM-PT2 | Plot 2 | 2024-05-23T09:37:00Z | % | maintenance | 22.4 | false | sf_Ruth |
| FARM004 | ph | 5.9 | false | Berlin | City Roots | 19 Vine St | BE | 10115 | Germany | ph-PT1 | Plot 1 | 2024-05-23T11:26:00Z | pH | maintenance | 12.7 | false | ber_Frank |
| FARM005 | light | 400 | false | Austin | Urban Oasis | 7 Emerald Rd | TX | 78702 | USA | light-GH2 | Greenhouse South | 2024-05-23T12:53:00Z | lux | maintenance | 20.6 | false | aus_Carol |
| FARM006 | co2 | 1500 | false | London | FreshTech Farm | 123 Future Ave | LDN | E1 6AN | UK | co2-PT2 | Plot 2 | 2024-05-23T14:25:00Z | ppm | maintenance | 19 | false | lon_James |
| FARM007 | temperature | 37.5 | false | Singapore | AgriNext Urban | 200 Sprout Way | SG | 238978 | Singapore | temp-GH3 | Greenhouse West | 2024-05-23T15:17:00Z | C | error | 4.7 | false | sg_Li |
| FARM008 | humidity | 95.2 | false | Sydney | GreenEdge Farm | 16 River Dr | NSW | 2000 | Australia | hum-PT3 | Plot 3 | 2024-05-23T08:59:00Z | % | error | 2.2 | false | syd_Aaron |
| FARM009 | soil_moisture | 0.1 | false | New York | SkyFarm | 88 Skyline Ave | NY | 10013 | USA | soilM-GH3 | Greenhouse West | 2024-05-23T16:39:00Z | % | error | 1 | false | ny_Monica |
| FARM010 | ph | 4.8 | false | Los Angeles | MetroFarm | 22 Urban St | CA | 90015 | USA | ph-GH1 | Greenhouse North | 2024-05-23T17:20:00Z | pH | error | 3.5 | false | la_Luis |
What the 120 rows show
from the 120-row sampleLight (sensor type) stands out: mean metric_
- 67%data_
quality_ flag = true - 28.3median metric_
value - 4sensor statuses
- 6address countries
- 6metric units
- 18address states
Median 28.3, from 0.0 to 20,000.
- string 13
- float 2
- datetime 1
- boolean 2
Columns
18 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
farm_id | string | Unique identifier for each urban farm | FARM001 |
farm_name | string | Name of the urban farm | EcoUrban Grow |
address_street | string | Street address of the urban farm | 112 Greenway Blvd |
address_city | string | City where the urban farm is located | Chicago |
address_state | string | State or province of the urban farm | IL |
address_postal_code | string | Postal code of the urban farm | 60616 |
address_country | string | Country where the urban farm is located6 countries | USA |
sensor_id | string | Unique identifier for each IoT sensor | temp-GH1 |
sensor_type | string | Type of sensor (e.g., temperature, humidity, soil moisture, pH, light, CO2)7 values | temperature |
sensor_location | string | Physical location or zone of the sensor within the farm | Greenhouse North |
metric_unit | string | Unit of measurement for the metric value (e.g., 'C', '%', 'ppm', 'lux', 'pH')6 values | C |
sensor_status | string | Operational status of the sensor (e.g., active, inactive, maintenance, error)active · inactive · maintenance · error | active |
operator_id | string | Identifier for the farm operator or responsible staffoptional | chi_Martin |
| Numbers 2 columns | |||
metric_value | float | Measured value from the sensor (e.g., temperature in Celsius, humidity in %) | 22.4 |
battery_level | float | Current battery level of the sensor in percentage (0-100)0 to 100 · optional | 78.3 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the sensor reading was recorded | 2024-05-22T08:23:00Z |
| True or false 2 columns | |||
data_quality_flag | boolean | Indicates if the sensor reading passed data quality checks (true = valid, false = suspect) | true |
compliance_flag | boolean | Indicates if the metric value is within sustainability/compliance thresholds | true |
Use it for
An agriculture dashboard
The data_
quality_ flag rate, metric_ value by sensor_ type and a breakdown of address_ city. Excel, Power BI or Tableau. Why do the 16 light rows have a mean metric_
value of 11,471? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Farms120FARM00122.4temperat…FARM00261.2humidityFARM00124.2temperat…
A software demo
Believable farms with farm_
name, address_ street and address_ city to fill a screen in front of a buyer.
blueprint · urban-farm-iot-sensor-metrics
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 18 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 sensor reading from a specific device.
- Sensor data includes temperature, humidity, soil moisture, and light intensity.
- Readings are time-stamped and associated with farm zone identifiers.
- Flag readings outside optimal ranges for alerting and intervention.
- Sensors must be registered and calibrated as per farm compliance standards.
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
- urban-farm-iot-sensor-metrics