Municipal-level groundwater availability dataset for Mexico (2013--2023)
Description
This dataset provides municipal-level groundwater availability indicators for Mexico, covering the period 2013--2023. It bridges the spatial mismatch between aquifer-level hydrological data published in the Diario Oficial de la Federación (DOF) by CONAGUA and the administrative boundaries of Mexico's 2,469 municipalities (INEGI Marco Geoestadístico, 2020). The spatial crosswalk was constructed by computing the geometric intersection of 653 aquifer polygons with municipal polygons, yielding 6,233 unique aquifer--municipality pairs. Hydrological variables---including mean annual recharge (R), concessioned volume (VCAS), committed natural discharge (DNC), and net mean annual availability (DMA)---were harmonized across five DOF editions and aggregated to the municipal level using area-weighted proportional allocation. The dataset includes three CSV files (spatial crosswalk, granular aquifer--municipality--year panel, and aggregated municipality--year panel), a variable dictionary, a consolidated Excel workbook, the source DOF compilation, and the Python processing script for full reproducibility.
Files
Steps to reproduce
1. Download the aquifer shapefile from CONAGUA's SIGA portal (https://sigagis.conagua.gob.mx) and place it in a folder named c_acuiferos_09112023/. 2. Download the municipal shapefile from INEGI's Marco Geoestadístico Nacional 2020 (https://www.inegi.org.mx/temas/mg/) and place municipal.shp and its companion files in a folder named MG 2020/. 3. Place DOF_Compilado_Agua.xlsx (included in this repository) in the same parent directory as the two shapefile folders. 4. Install Python dependencies: pip install -r requirements.txt 5. Run python build_dataset.py