Urban Farm Water Efficiency Monitor

This dataset provides daily water usage and efficiency metrics for urban farms equipped with smart irrigation systems, including detailed farm location, crop type, irrigation events, and system status. It enables sustainability managers and agritech developers to analyze consumption patterns, identify water waste, and optimize irrigation schedules for improved ESG reporting and resource management.

  • last updated 5 Dec 2025
  • by GoMask
The brief that made it

Optimizing irrigation schedules for urban farms

Sample rows

preview · 8 of 75 rows · all 19 columns
record_idstringfarm_location_countrystringwater_efficiency_ratiofloatfarm_idstringfarm_namestringfarm_location_streetstringfarm_location_citystringfarm_location_statestringfarm_location_postal_codestringdatedatetotal_water_used_litersfloatirrigation_duration_minutesfloatnumber_of_irrigation_eventsintegercrop_typestringarea_irrigated_sqmfloatestimated_water_waste_litersfloatsmart_system_statusstringweather_conditionstringnotesstring
UF-1001A7BUSA8FARM-01GreenSprout Gardens425 Elm StChicagoIL606072024-04-011200.5903lettuce15036operationalsunnySystem running efficiently.
UF-1002B3CUSA7FARM-02SkyVeg Patch116 Market AveDenverCO802022024-04-0198075.52spinach14024.2operationalcloudyblank
UF-1003F9DCanada7.72FARM-03UrbanHarvest980 Pine StTorontoONM5G 2C32024-04-011350.251204tomatoes17545maintenancerainySensor recalibration performed.
UF-1004D2EUSA8.8FARM-04MetroRoots55 W 12th StNew YorkNY100112024-04-011100803kale12540operationalsunnyIrrigation system fully automated.
UF-1005E4FUSA6.54FARM-05FreshFlow634 Bayview LnSan FranciscoCA941242024-04-01850602arugula13018operationalcloudyblank
UF-1006A1CUK7.69FARM-06CitySprout73 Queen StLondonGreater LondonE1 6AN2024-04-011230853herbs16029maintenancepartly cloudyblank
UF-1007B6FUSA8.87FARM-07EcoGrow Urban12 NE 7th AvePortlandOR972322024-04-01975.6702peppers11015.2operationalsunnyLow water waste observed.
UF-1008C8DUSA8.3FARM-08Rooftop Roots88 South StBostonMA021112024-04-011120803chard13521operationalrainyblank

What the 75 rows show

from the 75-row sample

USA (farm location country) stands out: mean water_efficiency_ratio is 5.3, against 7.8 for the rest.

  • 6.5median water_efficiency_ratio
  • 3smart system statuses
  • 6weather conditions
  • 11crop types
  • 15farm location cities
  • 15farm location states
Mean water_efficiency_ratio by farm_location_country75 rows
0485.3USA61 rows7.7Canada7 rows7.8UK7 rows
water_efficiency_ratio75 rows, in bands of 1
01020920714201132610water_efficiency_ratio →

Median 6.5, from 2.7 to 9.3.

farm_id75 rows · top 10 of 20 values
  1. FARM-014
  2. FARM-024
  3. FARM-034
  4. FARM-044
  5. FARM-054
  6. FARM-064
  7. FARM-074
  8. FARM-084
  9. UF-3102B4
  10. UF-1111C4
19 columns by typefrom the column list below
  • string 12
  • integer 1
  • float 5
  • date 1

Columns

19 columns in three groups
blueprint · 19 columns
columntypedescriptionexample
Text 12 columns
record_idstringUnique identifier for each daily water usage recorduniqueUF-1001A7B
farm_idstringUnique identifier for the urban farmFARM-01
farm_namestringName of the urban farmGreenSprout Gardens
farm_location_streetstringStreet address of the urban farm425 Elm St
farm_location_citystringCity where the urban farm is locatedChicago
farm_location_statestringState or region of the urban farmIL
farm_location_postal_codestringPostal code of the urban farm60607
farm_location_countrystringCountry where the urban farm is located3 countriesUSA
crop_typestringType of crop irrigated (e.g., lettuce, tomatoes)11 typeslettuce
smart_system_statusstringStatus of smart irrigation system (operational, maintenance, offline)operational · maintenance · offlineoperational
weather_conditionstringGeneral weather condition during irrigation (sunny, rainy, cloudy, etc.)6 values · optionalsunny
notesstringAdditional comments or observations for the dayoptionalMaintenance scheduled.
Numbers 6 columns
total_water_used_litersfloatTotal volume of water used in liters for the day0 or more1200.5
irrigation_duration_minutesfloatTotal duration of irrigation in minutes for the day0 or more90
number_of_irrigation_eventsintegerNumber of distinct irrigation events during the day0 or more3
area_irrigated_sqmfloatTotal area irrigated in square meters0 or more150
water_efficiency_ratiofloatRatio of water used per square meter (liters/sqm)0 or more8
estimated_water_waste_litersfloatEstimated volume of water wasted in liters (leakage, over-irrigation)0 or more · optional36
Dates and times 1 column
datedateDate of the water usage measurement2024-04-01

Use it for

  • median water e…6.575 rowsmean water efficiency…5.3USA7.7Canada7.8UK

    An agriculture dashboard

    Water_efficiency_ratio by farm_location_country and a breakdown of farm_id. Excel, Power BI or Tableau.

  • Why do the 61 USA rows have a mean water_efficiency_ratio of 5.3?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable records with farm_id, farm_name and farm_location_street to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset75 rows19 columns
Yours1,000 rows19 columnsfarm_location_street: UK only

blueprint · urban-farm-water-efficiency-monitor

Behind this dataset

Same schema. As many rows as you need.

These 75 rows came out of a blueprint — 19 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 record represents one day for a specific urban farm plot.
  • Water usage is measured in liters and must be within 20% of the recommended crop-specific daily threshold.
  • Efficiency score is calculated by dividing actual yield by water used; minimum score required for positive ESG impact is 0.8.
  • Irrigation events are logged only if system is verified operational by IoT sensor.
  • Sensor fault events must be flagged and exclude related data from yield analytics.
Rows
Open the blueprint in Data Factory

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
urban-farm-water-efficiency-monitor

More in Agriculture

Browse all
Also in AgricultureFarm Water Conservation Impact DataAgri Cold Storage IoT MetricsIoT Precision Irrigation Sensor DataAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.