// 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. The data are published as data releases. Data Sets from the National Crude Oil Spill Fate and Natural Attenuation Research Site near Bemidji, Minnesota (https://doi.org/10.5066/P9FJ8I0P) along with Sampling site information, well construction details, and data dictionaries (https://doi.org/10.5066/F7736PDR)
Geospatial Data Summarization and Figure Automation
featuredArcPy-based workflow for automatically generating publication-quality geospatial figures from hydrological model outputs. Reduces manual GIS drafting from days to minutes by templating map layouts and symbology. This data processing pipeline transformed raw geogenic water contamination data into standard national percentiles based on study basin. The figures created from this pipeline were used in "Prioritizing water availability study settings to address geogenic contaminants and related societal factors" by Melinda Erickson et al in the Environmental Monitoring and Accessment journal. (https://doi.org/10.1007/s10661-024-12362-2). Includes figures 3, 4, 5, and 6.
StreamStats Validation and Testing
featuredDeveloped validation tests for the [StreamStats](https://www.usgs.gov/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.