🧪 Bridging Hydrochemistry, Thermodynamic Modeling & GIS: A Relational Schema 🗂️ Hydrogeochemical workflows are often fragmented across spreadsheets, standalone PHREEQC runs, and GIS layers, creating transfer errors and scaling friction. ⚙️ To build a reproducible pipeline, I structured a relational schema connecting raw chemistry, thermodynamic speciation, and spatial topology: 🔑 Relational Keys: Linked via Solution ID and Sampling Location to preserve data integrity across all stages. ⚛️ Automated Speciation: Raw ionic assays are ingested into PHREEQC to computation. 🗺️ Spatial Binding: Speciation outputs join spatial geometries in R (sf and terra packages) for contaminant plume mapping and cross-sections. 📖 Full methodology and regional case studies are detailed in my open-access monograph on mineralized groundwater plume. 💬 Open-access link: https://doi.org/10.5281/zenodo.20709306 #Hydrogeology #Geochemistry #PHREEQC #RStats #SpatialData #GIS #OpenScience #Groundwater #SvystunovaGully