Data‐Driven Approach for Analyzing Hydrogeology and Groundwater Quality Across Multiple Scales

Recent trends of assimilating water well records into statewide databases provide a new opportunity for evaluating spatial dynamics of groundwater quality and quantity. However, these datasets are scarcely rigorously analyzed to address larger scientific problems because they are of lower quality and massive. We develop an approach for utilizing well databases to analyze physical and geochemical aspects of groundwater systems, and apply it to a multiscale investigation of the sources and dynamics of chloride (Cl^?) in the near‐surface groundwater of the Lower Peninsula of Michigan. Nearly 500,000 static water levels (SWLs) were critically evaluated, extracted, and analyzed to delineate long‐term, average groundwater flow patterns using a nonstationary kriging technique at the basin‐scale (i.e., across the entire peninsula). Two regions identified as major basin‐scale discharge zones—the Michigan and Saginaw Lowlands—were further analyzed with regional‐ and local‐scale SWL models. Groundwater valleys (“discharge” zones) and mounds (“recharge” zones) were identified for all models, and the proportions of wells with elevated Cl^? concentrations in each zone were calculated, visualized, and compared. Concentrations in discharge zones, where groundwater is expected to flow primarily upwards, are consistently and significantly higher than those in recharge zones. A synoptic sampling campaign in the Michigan Lowlands revealed concentrations generally increase with depth, a trend noted in previous studies of the Saginaw Lowlands. These strong, consistent SWL and Cl^? distribution patterns across multiple scales suggest that a deep source (i.e., Michigan brines) is the primary cause for the elevated chloride concentrations observed in discharge areas across the peninsula.