danduncan.dev
  • Home
  • Portfolio
  • My CV

On this page

  • Featured Projects

Portfolio

A collection of code and projects stemming from my work and curiosity

Featured Projects

Upper Cache la Poudre DSS

This decision-support system is designed to provide municipal water managers with current and future information on water quality and quantity. We create models of in-stream water quality using real-time data from a network of water-quality sondes throughout the Upper Cache la Poudre River. These models, developed by the ROSSyndicate Lab at Colorado State University, provide real-time and forecasted data, which are visualized through a Shiny dashboard for municipal water suppliers.

View Repository

NOAA CO-OPs Tide Planning Application

A Shiny app built to help the Northwest Straits Commission and coastal communities with field planning by visualizing NOAA CO-OPs tide data and forecasts. Users can input a location, date range, and tide threshold to determine what time window is best for field work.

View Repository

Water Quality ETL Pipeline

Built with R, this codebase extracts, transforms, and loads 20+ years of water quality data from a municipal water treatment facility. The pipeline cleans and normalizes non-standardized data, saving it in .parquet format for efficient storage and analysis. This project serves as a foundation for data analysis and modeling efforts within the Upper CLP decision support system.
An extract, transform, and load pipeline

View Repository