Tools & Data

Decision-support tools, geospatial workflows, and modeling frameworks for agricultural water systems.

I develop applied tools and data workflows that combine agricultural economics, irrigation engineering, geospatial analysis, groundwater data, crop information, and optimization models to support research and decision-making.

Featured Tools

These tools and workflows support analysis of irrigation investment, groundwater conservation, crop transitions, and land-use adaptation in water-limited agricultural regions.

Geospatial workflow

County-level Agricultural Data Processing

GIS and Python workflows for processing crop area, irrigation status, climate, slope, soil water storage, and groundwater variables at county and field scales.

Common data sources

  • USDA NASS crop and yield data
  • CDL crop classification
  • LANID irrigation maps
  • PRISM climate data
  • USGS groundwater datasets
ArcGIS Python Remote sensing County data
Optimization model

Hydro-economic Optimization Models

Optimization models that evaluate crop choice, irrigation capacity, groundwater depletion, reinvestment decisions, and land-use transitions across multi-year planning horizons.

Model components

  • Crop-specific net returns
  • Irrigation capacity constraints
  • Groundwater stock and pumping relationships
  • Dryland and bioenergy crop transitions
  • Long-term investment decisions
GAMS MILP Hydro-economic modeling Crop choice
Research data system

Agricultural Water and Land-use Data Integration

Integrated datasets linking irrigation, crop production, climate, groundwater, soil, energy, and economic variables for regional agricultural water systems analysis.

Data integration themes

  • Irrigated and dryland crop patterns
  • Groundwater availability and aquifer decline
  • Energy cost and pumping economics
  • Crop budgets and production returns
  • Land-use transition pathways
Data integration Groundwater Land use Agricultural economics

Technical Workflow

My tool development process typically connects spatial data processing, economic modeling, scenario analysis, and decision-support outputs.

01

Data collection

Compile crop, irrigation, groundwater, climate, soil, slope, energy, and economic datasets from federal, state, and project-specific sources.

02

Spatial processing

Use GIS and Python workflows to harmonize raster, vector, county, and field-scale datasets into consistent analytical units.

03

Economic modeling

Estimate costs, returns, investment feasibility, pumping economics, water savings, and net present value under alternative scenarios.

04

Decision support

Translate model outputs into tools, maps, tables, and indicators that support research interpretation and applied decision-making.

Software and Methods

I use a combination of analytical, spatial, and computational tools.

Excel/VBA Python ArcGIS GAMS Optimization modeling Hydro-economic modeling Remote sensing Spatial data processing Net present value analysis Crop budgets Groundwater datasets Scenario analysis

Interested in research collaboration or related work?

I welcome inquiries related to agricultural water management, groundwater sustainability, irrigation economics, land-use transitions, and decision-support modeling.