Data Sources

Public source links, limitations, and import policy.

Manual data curation comes before scheduled automation. Every imported record should retain its agency, dataset, source URL, import batch, data year, and confidence label.

Current data mode: MySQL data-backed mode. Live pages and APIs are reading from the SIM Water Ledger database.
Public dashboards

Arizona Department of Water Resources

ADWR Data Dashboards

Includes dashboards for agriculture, community water systems, hydrology/depth-to-water, municipal, overdraft, recharge, wells, and supply/demand views.

Refresh policy: Manual source check in prototype

Open public source
GIS and tabular data

Arizona Department of Water Resources

GIS Data and Maps

Includes public links for GWSI, Well Registry, Grandfathered Water Rights, Long-Term Storage Credits, irrigation district maps, groundwater basin maps, and tabular downloads. ADWR lists GWSI tables as last updated 04/14/2026.

Refresh policy: Manual source check in prototype

Open public source
Recharge and LTSC accounting reference

Arizona Department of Water Resources

Recharge Credits and Accounting

Defines long-term storage credit concepts, annual reporting, storage/recovery accounting, and same-AMA recovery context subject to stated conditions.

Refresh policy: Manual source check in prototype

Open public source
Water accounting reports

Bureau of Reclamation

Lower Colorado River Water Accounting

Publishes forecasts, actual use links, Water Accounting Reports, Consumptive Uses and Losses reports, and LCRAS evapotranspiration/evaporation summaries. The page lists 2024 as the newest Water Accounting Report.

Refresh policy: Manual source check in prototype

Open public source
Allocation and subcontract reference

Central Arizona Project

CAP Allocations

Public allocation page links CAP subcontracting status reports, including the current April 2025 report, plus historical allocation documents.

Refresh policy: Manual source check in prototype

Open public source
Open GIS hub

Central Arizona Project

CAP Open Data

Public hub for CAP map layers, service areas, and related open-data applications.

Refresh policy: Manual source check in prototype

Open public source
Water-use methodology

U.S. Geological Survey

Arizona Water Use

Describes Arizona water-use estimates by groundwater basin outside AMAs and the use of crop acreage, consumptive water requirement rates, and irrigation system efficiency where metered data is unavailable.

Refresh policy: Manual source check in prototype

Open public source
Crop budget assumptions

University of Arizona Cooperative Extension

Yuma County 2026 Field Crops Production Budgets

Provides local Yuma field-crop assumptions for flood irrigation, water cost, irrigation efficiency, and irrigation labor used as scenario anchors.

Refresh policy: Manual source check in prototype

Open public source
Crop ET reference

University of Arizona Cooperative Extension

Yuma Lettuce Crop Coefficients and ET Scheduling

Provides Yuma lettuce crop ET scheduling context and recent water requirement range used for crop-specific scenario framing.

Refresh policy: Manual source check in prototype

Open public source
Irrigation survey tables

USDA NASS

2023 Irrigation and Water Management Survey

Provides irrigation water applied, acres irrigated, irrigation method, wells, pump depth, and pumping energy categories used as statewide Arizona benchmarks.

Refresh policy: Manual source check in prototype

Open public source

Nano Flow opportunity import targets

The opportunity engine starts with six public layers that connect water stress, recovery/storage context, CAP exposure, agricultural demand, and Lower Colorado River accounting relevance.

Layer What it reveals Opportunity use Source
ADWR GWSI tabular download Depth-to-water and monitoring-well context Find areas where pumping lift makes peak-demand reduction and energy accounting more valuable. ADWR GIS Data and Maps
ADWR Well Registry layer Well density and agricultural pumping geography Identify concentrated pumping regions for measured Nano Flow pilots. ADWR GIS Data and Maps
ADWR Grandfathered Water Rights layer Irrigation groundwater-right context in AMAs Target regulated-right farms where conservation documentation matters. ADWR GIS Data and Maps
ADWR Long-Term Storage Credits map/dashboard data Stored/recoverable water geography and account balances where public Connect storage/recovery accounting to field-level usability. ADWR Recharge and dashboards
CAP Subcontracting Status Report CAP allocation and subcontract exposure Prioritize CAP-adjacent shortage planning and delivery-smoothing conversations. CAP Allocations
Reclamation Lower Colorado River Water Accounting and CUL data Diversions, returns, consumptive use, ET/acreage accounting context Frame Yuma and Lower Colorado pilots inside serious water-accounting methods. Bureau of Reclamation

Import sequence

  1. Manual CSV or GeoJSON review from official public sources.
  2. Normalize records into ledger, facility, water unit, and source tables.
  3. Log source URL, data year, import batch, and records rejected.
  4. Add scheduled checks only after source shape and update behavior are stable.
Credibility Rule

Do not mix public facts, engineering estimates, and assumptions without labels.

SIM Water Ledger should be useful because it shows what is known, what is calculated, and what remains a scenario.