Task 1

Transboundary aquifers require consistent, high-quality data to understand groundwater flow across borders, yet in practice these data are fragmented, inconsistent, and often difficult to harmonize. Task 1 addresses this challenge by developing a unified spatio-temporal database that integrates satellite observations with in-situ measurements from key sources, including USGS, CONAGUA, and IGRAC. Building on the EU-WATERRES data portal, the task standardizes groundwater monitoring data (e.g., water levels, well construction, lithology, and aquifer properties) using common formats, coordinate systems, and metadata definitions. Particular attention is given to resolving inconsistencies in units, coordinate reference systems (e.g., WGS84 vs. NAD83/UTM), and hydrogeological classifications such as confined versus unconfined conditions, ensuring that datasets from different countries can be reliably compared and integrated.

The database development focuses on priority transboundary systems such as the Mesilla Basin and Conejos-Médanos aquifer, where diverse datasets are being compiled, validated, and linked to hydrogeologic frameworks (e.g., aquifer thickness models and lithological classifications including overburden, terrigenic, and carbonate formations). Task 1 also incorporates additional water balance variables, such as precipitation, evapotranspiration, and temperature, and aligns temporal coverage with satellite missions like GRACE-FO to support integrated analysis. By combining validated ground-based observations with regional and global datasets in a single, accessible platform with API access, Task 1 establishes a robust foundation for improved groundwater modeling, cross-border data sharing, and evidence-based water management in transboundary regions.

Unified Conceptual Model and Spatio-Temporal Database of Groundwater Observations (2012-2023)

• Comprehensive schema

• Populated from multiple sources