Farm Water Conservation Impact Data

This dataset provides detailed, farm-level water usage and conservation impact metrics, enabling agri-tech teams and farm managers to evaluate the effectiveness of smart irrigation and conservation strategies. It supports ESG and regulatory compliance reporting, climate resilience assessments, and optimization of water management practices for sustainable agriculture.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Benchmarking water conservation techniques across farms and fields

Sample rows

preview · 8 of 75 rows · all 25 columns
record_idstringirrigation_schedulestringimpact_percentagefloatesg_compliancebooleancrop_typestringfarm_idstringfarm_namestringlocation_street_addressstringlocation_citystringlocation_statestringlocation_postal_codestringlocation_countrystringfield_idstringirrigation_methodstringwater_usage_litersfloatconservation_techniquestringconservation_start_datedateconservation_end_datedatewater_saved_litersfloatbaseline_water_usage_litersfloatregulatory_compliancebooleanclimate_resilience_scorefloatdata_collection_datedatedata_sourcestringnotesstring
WCI-001-A1sensor-based22.58truecornFARM-101Green Valley Ranch123 Willow RoadSpringfieldIllinois62704USAFIELD-01-GVdrip12000.5soil moisture sensors2023-03-152023-09-303500.215500.7true882023-10-05IoT sensorYield improved post conservation
WCI-002-B2weekly15.52truewheatFARM-202Blue Sky Farms456 Main StHamiltonOntarioL8P 1A1CanadaFIELD-12-BSsprinkler9800mulching2023-04-102023-08-15180011600true75.32023-08-16manual entryReduced evaporation noted
WCI-003-C3monthly18.18falsealmondsFARM-303Sierra Orchards789 Orchard AveFresnoCalifornia93722USAFIELD-07-SOflood22500scheduling2023-02-012023-07-31500027500true70.22023-08-01third-party systemblank
WCI-004-D4daily15.66truesoybeansFARM-404Riverbend Fields321 River RoadGuelphOntarioN1G 2W1CanadaFIELD-19-RBpivot14000cover cropping2023-05-01blank260016600true802023-09-25IoT sensorblank
WCI-005-E5weekly14.12truelettuceFARM-505Sunny Acres555 Sun LaneModestoCalifornia95351USAFIELD-03-SAmanual7300rainwater harvesting2023-06-102023-09-1012008500true78.52023-09-11manual entryHarvested rainwater used for irrigation
WCI-006-F6sensor-based18.6truepotatoesFARM-606Meadowview Estate222 Meadow DrBoulderColorado80301USAFIELD-09-MEdrip10500soil moisture sensors2023-03-01blank240012900true81.72023-09-18IoT sensorSensors calibrated in-situ
WCI-007-G7weekly15.53truebarleyFARM-707Northern Harvest89 Harvest WayRed DeerAlbertaT4N 1E3CanadaFIELD-15-NHsprinkler8700mulching2023-04-202023-08-28160010300true76.82023-09-01manual entryMulch thickness varied by plot
WCI-008-H8daily15.73truecanolaFARM-808Prairie Gold134 Prairie RdReginaSaskatchewanS4P 3X1CanadaFIELD-21-PGpivot11250cover cropping2023-05-05blank210013350false79.22023-09-27IoT sensorblank

What the 75 rows show

from the 75-row sample

Sensor-based (irrigation schedule) stands out: mean impact_percentage is 20.1, against 14.1 for the rest.

  • 93%esg_compliance = true
  • 14.9median impact_percentage
  • 2location countries
  • 3data sources
  • 6irrigation methods
  • 6conservation techniques
Mean impact_percentage by irrigation_schedule75 rows
0204013.8wee…24 r…14.7dai…17 r…20.1sen…12 r…12.1biw…9 ro…16.2mon…5 ro…13.6sen…4 ro…15.7sen…3 ro…16.0sen…1 ro…
impact_percentage75 rows, in bands of 2
015301311307833101824impact_percentage →

Median 14.9, from 10.2 to 22.6.

crop_type75 rows · top 10 of 18 values
  1. corn9
  2. lettuce9
  3. wheat8
  4. canola8
  5. barley7
  6. potato5
  7. soybeans4
  8. potatoes4
  9. cotton4
  10. soybean4
25 columns by typefrom the column list below
  • string 15
  • float 5
  • date 3
  • boolean 2

Columns

25 columns in four groups
blueprint · 25 columns
columntypedescriptionexample
Text 15 columns
record_idstringUnique identifier for each water conservation impact recorduniqueWCI-001-A1
farm_idstringUnique identifier for the farm where the data was collectedFARM-101
farm_namestringName of the farmGreen Valley Ranch
location_street_addressstringStreet address of the farmoptional123 Willow Road
location_citystringCity where the farm is locatedoptionalSpringfield
location_statestringState or province where the farm is locatedoptionalIllinois
location_postal_codestringPostal code of the farm's locationoptional62704
location_countrystringCountry where the farm is located2 countriesUSA
crop_typestringType of crop grown in the field/plotcorn
field_idstringUnique identifier for the field or plot within the farmFIELD-01-GV
irrigation_methodstringType of irrigation system used (e.g., drip, sprinkler, flood)6 valuesdrip
irrigation_schedulestringDescription of irrigation schedule (e.g., daily, weekly, sensor-based)8 schedulessensor-based
conservation_techniquestringType of water conservation technique applied (e.g., soil moisture sensors, mulching, scheduling)6 techniquessoil moisture sensors
data_sourcestringSource of the data (e.g., IoT sensor, manual entry, third-party system)3 sourcesIoT sensor
notesstringAdditional notes or comments about the recordoptionalYield improved post conse…
Numbers 5 columns
water_usage_litersfloatTotal water usage in liters for the period0 or more12000.5
water_saved_litersfloatEstimated or measured water saved in liters due to conservation efforts0 or more3500.2
baseline_water_usage_litersfloatWater usage in liters before conservation efforts (baseline period)0 or more · optional15500.7
impact_percentagefloatPercentage reduction in water usage due to conservation technique0 to 100 · optional22.58
climate_resilience_scorefloatScore representing the farm's climate resilience based on water conservation practices (0-100)0 to 100 · optional88
Dates and times 3 columns
conservation_start_datedateDate when conservation technique was implemented2023-03-15
conservation_end_datedateDate when conservation technique was concluded or last measuredoptional2023-09-30
data_collection_datedateDate when the data was collected or recorded2023-10-05
True or false 2 columns
esg_compliancebooleanIndicates if the conservation effort meets ESG (Environmental, Social, Governance) compliance standardsoptionaltrue
regulatory_compliancebooleanIndicates if the water usage and conservation efforts comply with local/regional regulationsoptionaltrue

Use it for

  • esg compliance93%70 of 75 rowsmean impact percentag…13.8week…14.7daily20.1sens…12.1biwe…

    An agriculture dashboard

    The esg_compliance rate, impact_percentage by irrigation_schedule and a breakdown of crop_type. Excel, Power BI or Tableau.

  • Why do the 12 sensor-based rows have a mean impact_percentage of 20.1?

    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 location_street_address to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 25 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 rows25 columns
Yours1,000 rows25 columnslocation_street_address: UK only

blueprint · farm-water-conservation-impact-data

Behind this dataset

Same schema. As many rows as you need.

These 75 rows came out of a blueprint — 25 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
  • Record water usage per crop zone daily.
  • Log conservation interventions and date of application.
  • Calculate percentage reduction in water use post-intervention.
  • Indicate weather conditions affecting water needs.
  • Flag any zones with anomaly (usage up >10% after intervention).
Rows
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-water-conservation-impact-data

More in Agriculture

Browse all
Also in AgricultureAgricultural Water Usage InsightsAgriTech Equipment Telemetry DatasetAgri-Market Price Fluctuation RecordsAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.