From the SARAI project we have https://sarai.igme.es developed a tool in Jupyter Notebook format that allows reading data directly from the websites of the AEMET and the General Directorate of Water, extracting for a list of coordinates the rainfall and piezometry series at a distance of 5 km or less for each of the points listed.
The notebook, written in Python by César Husillos Rodríguez (IGME-CSIC), can be downloaded from GitHub with the following link: https://github.com/cesarhusrod/sarai_piezo_precip
It should be referenced with the following doi: 10.5281/zenodo.7197288
This tool is very useful in any hydrogeological study in which piezometry and precipitation data are interested from the year1950 to the year in which it is available on the websites, currently the year 2020. The main advantage of this tool is that the daily data interpolated by the AEMET can be used directly in a 5 km (https://www.aemet.es/es/serviciosclimaticos/cambio_climat/datos_diarios?w=2&w2=0) mesh. With the help of the script, these daily series in the locations near our points of interest are downloaded in an easy-to-read ascii file (extension .csv).
In the same way it can be done with the piezometry data collected by the General Directorate of Water (https://www.miteco.gob.es/es/cartografia-y-sig/ide/descargas/agua/default.aspx). In this case, the longest piezometric series is obtained, measured in a radius around the coordinates of interest. This radius is, by default, 5 km, but can be changed in the tool’s parameter configuration file.