Agri-Tech Water Efficiency Tracker

This dataset provides detailed, field-level tracking of water usage, irrigation practices, and crop yields for small to mid-sized farms. It enables robust analysis of water efficiency, supports resource optimization recommendations, and helps agri-tech startups and sustainability managers drive data-driven improvements in agricultural sustainability.

  • last updated 23 Jan 2026
  • by GoMask
The brief that made it

Benchmarking water usage and yield efficiency across farms and fields

Sample rows

preview · 8 of 120 rows · all 22 columns
farm_idstringirrigation_methodstringfarm_size_hectaresfloataddress_countrystringfarm_namestringowner_namestringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringfield_idstringcrop_typestringsowing_datedateharvest_datedateirrigation_eventsintegertotal_water_used_m3floatrainfall_mmfloatyield_kgfloatyield_per_water_kg_per_m3floatwater_efficiency_scorefloatdata_recorded_atdatetimeresource_optimization_recommendationstring
FARM001sprinkler7.5USAGreen Valley EstatesJessica Fulton1240 Willow LaneSalinasCalifornia93901FIELD001ALettuce2023-02-122023-04-3015320021082002.560.722023-05-02T16:35:28Consider scheduling irrigation during cooler hours to reduce evaporation.
FARM002manual0.4IndiaSunrise AcresManish SharmablankGurgaonHaryanablankFIELD002BSpinach2023-09-102023-11-0218120473402.830.982023-11-03T10:10:17Maintain manual irrigation; consider mulching to retain moisture.
FARM003flood520USADelta Rice FarmAnthony Brooks3201 Bayou RoadNew OrleansLouisiana70129FIELD003CRice2022-05-012022-10-15221170006603250002.780.352022-10-18T12:45:00Install water flow meters to monitor and optimize flood cycles.
FARM004drip12.7NorwayNorSun FieldsMagnus Nilsen94 FjordveienTromsøTroms9010FIELD004DBarley2023-04-202023-08-1283200340112003.50.792023-08-13T15:20:05Continue drip irrigation; review intervals for further improvement.
FARM005drip48UAEPalm OasisFatima Al MaktoumblankAl AinAbu DhabiblankFIELD005EDate Palm2021-03-15blank1290003400blank2023-05-05T11:24:39Focus on water conservation; crop cycle ongoing, yield pending.
FARM006manual0.2Hong KongUrban RootsChun LeeblankHong KongKowloonblankFIELD006FPak Choi2023-03-102023-04-02125291683.2312023-04-03T09:18:21Maintain manual irrigation; use shade nets for microclimate control.
FARM007sprinkler210USABlack Soil RanchRichard West3117 County Road 22RoswellNew Mexico88201FIELD007GCorn2023-04-152023-09-2823440002881280002.910.592023-09-29T17:42:59Switch to variable rate irrigation for improved efficiency.
FARM008sprinkler65USAMidwest SoySusan Miller92 Oakwood AveSpringfieldIllinois62704FIELD008HSoybean2022-04-052022-09-22197600417218002.870.662022-09-23T14:11:17Optimize irrigation schedule based on soil moisture sensors.

What the 120 rows show

from the 120-row sample

Other (irrigation method) stands out: mean farm_size_hectares is 8,271, against 114.4 for the rest.

  • 24.9median farm_size_hectares
  • 12median irrigation_events
  • 890.0median total_water_used_m3
  • 202.5median rainfall_mm
  • 3,825median yield_kg
  • 3.2median yield_per_water_kg_per_m3
Mean farm_size_hectares by irrigation_method120 rows
05,00010k21.5drip39 rows147.9sprink…29 rows478.6flood15 rows1.8manual25 rows8,271other12 rows
farm_size_hectares120 rows, in bands of 2,000
060120112010112111010k20kfarm_size_hectares →

Median 24.9, from 0.11 to 20,000.

address_country120 rows · top 10 of 23 values
  1. USA21
  2. India9
  3. Finland9
  4. Brazil9
  5. Argentina8
  6. Russia8
  7. Turkey7
  8. UAE6
  9. Nowhere6
  10. Canada6
22 columns by typefrom the column list below
  • string 12
  • integer 1
  • float 6
  • date 2
  • datetime 1

Columns

22 columns in three groups
blueprint · 22 columns
columntypedescriptionexample
Text 12 columns
farm_idstringUnique identifier for each farmuniqueFARM001
farm_namestringName of the farmGreen Valley Estates
owner_namestringName of the farm owner or managerJessica Fulton
address_streetstringStreet address of the farmoptional1240 Willow Lane
address_citystringCity where the farm is locatedSalinas
address_statestringState or province where the farm is locatedCalifornia
address_postal_codestringPostal code of the farm locationoptional93901
address_countrystringCountry where the farm is locatedUSA
field_idstringUnique identifier for each field/plot within a farmuniqueFIELD001A
crop_typestringType of crop grown in the fieldLettuce
irrigation_methodstringMethod of irrigation used (e.g., drip, sprinkler, flood)drip · sprinkler · flood · manual · othersprinkler
resource_optimization_recommendationstringTextual recommendation for improving water or resource efficiencyoptionalConsider scheduling irrig…
Numbers 7 columns
farm_size_hectaresfloatTotal size of the farm in hectares0.1 or more7.5
irrigation_eventsintegerNumber of irrigation events during the crop cycle0 or more15
total_water_used_m3floatTotal volume of water used for irrigation (in cubic meters)0 or more3200
rainfall_mmfloatTotal rainfall received during the crop cycle (in millimeters)0 or more · optional210
yield_kgfloatTotal crop yield from the field (in kilograms)0 or more8200
yield_per_water_kg_per_m3floatCrop yield per unit of water used (kg/m³)0 or more2.56
water_efficiency_scorefloatCalculated efficiency score based on water usage and yield (0-1 scale, higher is better)0 to 1 · optional0.72
Dates and times 3 columns
sowing_datedateDate when the crop was sown2023-02-12
harvest_datedateDate when the crop was harvestedoptional2023-04-30
data_recorded_atdatetimeTimestamp when this record was collected or updated2023-05-02T16:35:28

Use it for

  • median farm si…24.9120 rowsmean farm size hectar…21.5drip147.9spri…478.6flood1.8manu…

    An agriculture dashboard

    Farm_size_hectares by irrigation_method and a breakdown of address_country. Excel, Power BI or Tableau.

  • Why do the 12 other rows have a mean farm_size_hectares of 8,271?

    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 farms with farm_name, owner_name and farm_size_hectares to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset120 rows22 columns
Yours10,000 rows22 columnsaddress_street: UK only

blueprint · agri-tech-water-efficiency-tracker

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 22 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 row must map crop type to daily water usage and observed yield.
  • Irrigation method (drip, sprinkler, flood) must be specified.
  • Include monthly weather impact variables (rainfall, temperature).
  • Farm size categorized as small, medium, or large.
  • Yield efficiency calculated as kilograms per liter of water.
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
agri-tech-water-efficiency-tracker

More in Agriculture

Browse all
Also in AgricultureFarm Water Usage Impact ScoresPrecision Farming Drone ImageryAgri-Market Price Fluctuation RecordsAll 1,947 datasets

What should your data show?

Preview 20 rows free
No signup. No card.