This dataset contains results from the City of Calgary's Wastewater Treatment Plants that are reported monthly to Alberta Environment and Protected Areas. Results include laboratory and flow data for the wastewater treatment plants’ treated effluents, 2007 to present. Sampling locations have been added, removed, or modified over time. All laboratory results have been determined from the daily 24-hour composite samples, with the exception of Fecal Coliforms which are determined from the grab sampling. The City of Calgary uses approved and documented analytical testing methodologies, and the City of Calgary laboratory is accredited to the ISO/IEC 17025 standard. Quality Assurance programs track and ensure consistent laboratory performance. Changes in data over time, such as method detection limits, accredited testing parameters, and formatting are the result of newer analytical techniques and improved data quality standards.
This dataset has the following 10 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
ID | id | number | 9826923 73510856 66356513 40427313 30867811 view top 100 |
Sample Site | sample_site | text | Bonnybrook Wastewater Treatment Plant Effluent Pine Creek Wastewater Treatment Plant Effluent Fish Creek Wastewater Treatment Plant Effluent Bonnybrook Wastewater Treatment Plant Effluent (After UV) Fish Creek Wastewater Treatment Plant Effluent (After UV) view top 100 |
Sample Date | sample_date | calendar_date | 2013-01-21T00:00:00.000 2013-04-19T00:00:00.000 2013-02-28T00:00:00.000 2014-09-24T00:00:00.000 2017-02-23T00:00:00.000 view top 100 |
Parameter | parameter | text | Fecal Coliforms Total Effluent Flow to River Final Effluent Temperature Ammonia Total Kjeldahl Nitrogen view top 100 |
Numeric Result | numeric_result | number | 2.000000 3.000000 1.000000 4.000000 5.000000 view top 100 |
Result Qualifier | result_qualifier | text | < > view top 100 |
Formatted Result | formatted_result | text | <2 3 2 4 5 view top 100 |
Result Units | result_units | text | mg/L CFU/100mL 1000m3/day C view top 100 |
Latitude (Degrees) | latitude_degrees | text | 51.009746 50.856343 50.911276 view top 100 |
Longitude (Degrees) | longitude_degrees | text | -114.020502 -113.980748 -114.009075 view top 100 |