Monthly Effluent Quality Data from Calgary Wastewater Treatment Plants

City of Calgary's dataset contains monthly laboratory and flow results for treated wastewater effluent reported to Alberta Environment and Protected Areas. Data spans from 2007 to the present, covering multiple treatment plant locations. Results derive from daily 24-hour composite samples, with analytical testing conducted by an ISO/IEC 17025 accredited laboratory.

Use Cases

• Analyze trends in Parameter and Numeric Result over Sample Date to assess long-term treatment efficacy.
• Model relationships between different water quality Parameters (e.g., Fecal Coliforms) and flow data to optimize plant operations.
• Map pollutant concentrations using Latitude (Degrees) and Longitude (Degrees) for spatial analysis of effluent discharge.
• Flag regulatory non-compliance events by applying thresholds to Numeric Result and Result Qualifier fields.
• Correlate effluent quality (Parameter, Numeric Result) with seasonal changes using the time-series Sample Date.

Strengths

• Long-term temporal coverage from 2007 to present, enabling trend analysis.
• Data produced by an ISO/IEC 17025 accredited laboratory with documented Quality Assurance programs.
• Includes geospatial coordinates (Latitude, Longitude) for location-based analysis.

Limitations

• Sample locations have been added, removed, or modified over time, complicating longitudinal site comparisons.
• Specific sample size (row count) and data completeness metrics are unknown.
• Method detection limits and testing parameters have changed due to newer analytical techniques, affecting direct comparability of some historical data.

Provenance

Source

City of Calgary, reported to Alberta Environment and Protected Areas.

Collection Method

Laboratory analysis of daily 24-hour composite samples and grab samples (for Fecal Coliforms).

Time Range

2007 to present.

Freshness

Monthly reporting, last updated March 2026.

Geography

Wastewater Treatment Plants in Calgary, Alberta, Canada.