// projects
Scientific Tools &
Data Workflows
Python-based tools built for real hydrology and geoscience problems — automating data pipelines, geospatial workflows, and model calibration at the USGS. Most work lives in internal USGS repositories; descriptions here capture what each tool does.
── Featured
Groundwater Level Data Compiler and Data Pipeline
featuredAutomated Python pipeline for compiling and standardizing groundwater level and oil contamination data from multiple databases. Includes data cleaning, unit normalization, and structured export workflows ready for analysis and public release. Published as USGS data releases from the National Crude Oil Spill research site near Bemidji, Minnesota.
Geospatial Data Summarization and Figure Automation
featuredArcPy-based workflow for automatically generating publication-quality geospatial figures from hydrological model outputs — reducing manual GIS drafting from days to minutes. Transformed raw geogenic water contamination data into national percentiles by study basin. Produced figures 3–6 in Erickson et al. (Environmental Monitoring and Assessment, 2024).
StreamStats Validation and Testing
featuredDeveloped validation tests for the USGS StreamStats application, including percent error checks, automated logging reports, and custom calculation test methods to ensure accurate streamflow statistics.
── Other Work
SWB Model Calibration Toolkit
Python toolkit for calibrating Soil Water Balance (SWB) models against observed groundwater recharge data. Implements iterative parameter estimation and uncertainty analysis for regional recharge assessments.
Watershed Data Pipeline
End-to-end data organization and preprocessing pipeline for watershed modeling teams. Automates ingestion of multi-source hydrological records into structured formats compatible with standard modeling frameworks.
Geologic Map Digitization Tool
Utility for digitizing and standardizing legacy geologic map data into modern GIS-ready formats. Enables integration of historical field surveys into current USGS data workflows and spatial databases.
Recharge Estimation Dashboard
Interactive visualization tool for exploring groundwater recharge estimates across the Upper Midwest. Displays modeled vs. observed recharge data with spatial and temporal filtering capabilities.