ISSS608 2017-18 T3 Assign Low Zhi Wei Visualisations
Through the use of a few specific types of visualisations, and a deep-dive into each individual chemical, a few findings and insights were uncovered around the climate of the reserve, potential gaps and opportunities of improvement for sampling, fluctuations in Methylosmoline, and some other chemicals of interest. These findings are presented below.
Contents
Findings 1 - Climate
The water temperature varies seasonally over each year. This makes sense intuitively as the temperature of water would rise and fall in accordance to climate changes. From the chart below, warmer parts of the year are from June to August, while the cold months are from December to February.
Impact on other chemicals
With the variations in climate, there also appears to be a similar but inverse pattern of variation on a few chemicals, which hints that temperature of the environment may have a subtle effect on the naturally occurring quantities of these chemicals in the soil.
Note: Uppermost extreme values for Total dissolved salts and Nitrates were excluded to enable greater visual differentiation of intra-year variations.
Findings 2 - Data outliers and potential sampling issues
While this exercise seeks to find patterns of interest, which includes extremities in fluctuations, it is important to also be mindful of the fact that such outliers may be potential errors arising from inherent data deficiencies.
The following charts present a few outliers which are suspect, and in totality points to a serious problem with the sample collection process and methodology. The issues uncovered on the data present a huge challenge in analysis, underscoring an urgent need to be addressed in order to progress the agenda against toxic pollutors.
Total Coliforms
Key outliers in question:
- Reading for Total Coliforms in Achara on 15 Jan 2009 indicates a value of 16090 mg/l.
- Reading for Total Coliforms in Kohsoom on 20 Oct 2010 indicates a value of 13000 mg/l.
In comparison, most of the values for the other readings fall below 1000 mg/l. Considering the unit of measure, the increase is effectively more than 10 grams per litre. At both locations, the daily sample collected is only 1 per day, so there is no additional data to corroborate the evidence or rule out errors in sample collection. In the case of Achara, there are also only a total of 3 readings over the entire span of 18 years which creates an absence of benchmark norms for comparison. Given the circumstances, it is risky to draw any conclusions from these 2 outliers.
Iron
Key outliers in question:
- Reading for Iron in Busarkhan on 15 Aug 2003 indicates a value of 21666 mg/l.
- Reading for Iron in Chai on 15 Aug 2003 indicates a value of 19329 mg/l.
- Reading for Iron in Kannika on 15 Aug 2003 indicates a value of 33208 mg/l.
- Reading for Iron in Kohsoom on 15 Aug 2003 indicates a value of 37959 mg/l.
- Reading for Iron in Sakda on 15 Aug 2003 indicates a value of 28902 mg/l.
- Reading for Iron in Somchair on 15 Aug 2003 indicates a value of 24791 mg/l.
The immediate observation is that the outliers all coincide on the same day of measurement. This indicates either the possibility of a macro-level event which resulted in a massive release of Iron into the soil, or an error in the sampling to testing process to determine the values for Iron. In the case of the former, it is reasonable to expect such a large-scale event to also have a longer lasting impact on the soil as chemicals do not biodegrade overnight or a few days. However, the outliers exist simply on their own with no signs of high readings in the following collected samples.
Metals and 15 Aug 2003
With the assumption that a large-scale event should have other indicators of residual impact, further investigation into the date was conducted. Comparing readings in the neighbourhood of the date, the following chart illustrates the impact of this event - all other metals (Chromium, Copper, Manganese, Nickel, and Zinc) also registered a large spike in their respective readings. Yet, these outliers also existed on their own with no higher readings in the following collections. This defies logic from an ecological perspective, so it is more likely determined to be an error with the sampling collection process.
Zinc
The final suspect outlier:
- Reading for Zinc in Kohsoom on 25 Feb 2011 indicates a value of 915 mg/l.
Similar to the evaluation for Total coliforms, there only exists 1 sample reading per day for Zinc. This lack of corroborative evidence casts a strong shadow of doubt on the legitimacy of this outlier being an actual significant ecological event with impact to the wildlife.
Findings 3 - Abnormalities in Kohsoom
Other than the above outliers, there are several other chemical readings with observations that appear to indicate some form of ecological impact on the soil. Amongst these, a commonality was noticed in their location which was Kohsoom. While some of them still suffer from some form of data deficiency, the fact that the observations and patterns displayed were common to Kohsoom warrants additional investigation and understanding of the causes. The featured chemicals are also found to be measured in mg/l, a unit of measurement larger than µg/l by 3 orders of magnitude. Thus, any significant increases may call for greater caution and attention.
It is important to note that despite these observations, they do not prove or support the case of chemical contamination, as soil changes may be due in part to certain wildlife changes in the environment (for example, unique species inhabiting Kohsoom) or contributed by other random non-threatening human activities specific to Kohsoom.
Sustained increases
Three chemicals were noted to have sustained increases in their readings after spikes at Kohsoom, indicating some form of external causes which led to higher amounts of chemical remnants. These are:
- Anionic active surfactants (mg/l)
- Chemical Oxygen Demand (Cr) (mg/l)
- Fecal streptococci (mg/l)
A quick view of their respective maps of monthly readings over time clearly show Kohsoom as a location of interest (For 2, Tansanee is also noted as an area of high readings which stand out)
Anionic active surfactants
The data for this chemical indicates an increase since early 2014, and further abnormally high readings all the way into most of 2016. A closer look at its timechart shows a general increasing pattern since 2014.
Chemical Oxygen Demand
Fecal streptococci
Findings 4 - Methylosmoline
With the contexts of Finding 2, it is still possible to deep-dive into the data on Methylosmoline readings to uncover further insights. To start off, the seasonal view for Methylosmoline is explored, followed by a review on the monthly readings.
From the charts, there are no seasonal changes within each year in Methylosmoline. However there is a significant increase in its quantities in the soil in 2016, especially December, which reflects an extreme increase in readings. From the location breakdown, it is clear that all the outliers are fall into the 2 locations - Kohsoom and Somchair.