
Water Quality Data Analysis & Reporting Framework
Analyze water quality data and generate regulatory-compliant technical reports
What You Can Do
You can systematically process multi-parameter water quality datasets (pH, dissolved oxygen, turbidity, nutrients, metals, pathogens) to identify contamination patterns, spatial and temporal trends, and source hotspots. The framework contextualizes findings against EPA Water Quality Standards, Maximum Contaminant Levels, and site-specific criteria, then generates statistical summaries and regulatory-compliant reports that justify remediation recommendations and support stakeholder communication.
Features
structure and validate water quality measurements across surface water, groundwater, wastewater, and drinking water samples
automatically benchmark results against EPA WQS, MCLs, and site-specific criteria to flag exceedances and impairment status
identify spatial hotspots, temporal trends, and contamination sources across multiple sampling events
provide defensible confidence intervals, detection limits, and significance testing to support regulatory submissions
apply systematic protocols to evaluate source attribution, pathway analysis, and exposure risk
generate technical narratives that meet EPA, state agency, and litigation-grade documentation standards
recommend appropriate charts, maps, and data presentations for stakeholder and regulatory communication
cross-check analytical results against field duplicates, blanks, and instrument calibration records
Example Output
Example 1: Impairment Assessment Report
Input: Monthly dissolved oxygen and temperature data from a river segment (12 months, 5 stations)
Output:
## Water Quality Assessment Summary
**Station SR-03 Dissolved Oxygen Status:** IMPAIRED
- Mean DO: 3.2 mg/L (n=12)
- Standard: ≥5.0 mg/L (warm-water aquatic life)
- Exceedance frequency: 83% of samples below standard
- 95% CI: 2.6–3.8 mg/L
- Temporal pattern: Lowest values June–August (correlation with temperature, r=−0.87)
**Conclusion:** Station SR-03 fails to meet warm-water aquatic life standards; recommend wastewater source investigation and hypolimnion management strategies.
Example 2: Groundwater Contamination Summary
Input: Quarterly arsenic, nitrate, and uranium data from 8 monitoring wells (2 years)
Output:
## Plume Delineation & Risk Assessment
**Arsenic Contamination:**
- Exceedance wells: MW-02, MW-05, MW-07 (MCL = 10 µg/L)
- Range: 8–34 µg/L (mean 18 µg/L)
- Spatial trend: Highest concentrations downgradient of source area (slope = −0.3 µg/L per 100m)
- Estimated plume velocity: 2.1 ft/year (based on nitrate degradation trends)
**Recommendation:** Delineate plume extent with 4 additional monitoring points at x=50m, x=100m transects; initiate interim remedial action plan for source containment.
What's Included
- SKILL.md: complete framework with analytical protocols, standards reference, and quality assurance checklists
- Multi-parameter data review template: structured checklist for validating pH, DO, turbidity, nutrients, metals, and pathogen data
- Standards comparison matrix: EPA WQS, MCL, and state-specific benchmarks for common contaminants
- Statistical analysis guidance: confidence interval calculation, outlier detection, and trend testing protocols
- Technical report outline: executive summary, methods, results, interpretation, and recommendations sections with regulatory language
- Data visualization toolkit: recommended charts, maps, and time-series presentations for different audiences
Who It's For
- Environmental scientists — analyzing field monitoring data and preparing regulatory submissions
- Water quality specialists — conducting compliance assessments and contamination investigations
- Environmental consultants — synthesizing client datasets into defensible technical reports for agencies and litigation
- Remedial project managers — determining remediation progress and supporting risk-based decision-making
- Regulatory agencies — reviewing submitted water quality data and identifying impaired waters
Best For
- Impairment assessments — classifying water bodies as attainment or non-attainment against Clean Water Act standards
- Contamination source identification — analyzing spatial and temporal patterns to pinpoint pollution sources
- Groundwater plume delineation — mapping extent and migration of subsurface contaminant plumes
- Remedial action support — quantifying baseline conditions and evaluating treatment effectiveness
- Regulatory compliance reporting — generating EPA, state, and tribal submissions with statistical rigor







