Difference between revisions of "ISSS608 2017-18 T3 Assign LI Yaru Visualization"
Yaru.li.2017 (talk | contribs) |
Yaru.li.2017 (talk | contribs) |
||
Line 105: | Line 105: | ||
<br/>The red reference line represents value of Chai main stream and blue and grey bars represent two tributaries, Kohsoom and Boonsri respectively. From the graph we could see that Boonsri seldom contributes Methylosmoline to Chai, and the Methylosmoline concentration of Kohsoom shows slightly discrepancy with that of Chai. At the initial growth phase, concentration in Chai is higher than Kohsoom, as dramatic increase in Kohsoom, Chai surprisingly shows a contrast downwards trend and the dynamic growing concentration from Kohsoom did not affect the stable level maintained in Chai. Practically, the concentration is affected by multiple factors rather than a single steam content, thus further analysis rather than hydrological sampling should be included to collect other dimensions of each tributary. By comparing the tributary and main stream in Chai water system, what we could further infer is that Chai is not the dumping site with untouched concentration while tributary carrying high toxic chemical concentration. | <br/>The red reference line represents value of Chai main stream and blue and grey bars represent two tributaries, Kohsoom and Boonsri respectively. From the graph we could see that Boonsri seldom contributes Methylosmoline to Chai, and the Methylosmoline concentration of Kohsoom shows slightly discrepancy with that of Chai. At the initial growth phase, concentration in Chai is higher than Kohsoom, as dramatic increase in Kohsoom, Chai surprisingly shows a contrast downwards trend and the dynamic growing concentration from Kohsoom did not affect the stable level maintained in Chai. Practically, the concentration is affected by multiple factors rather than a single steam content, thus further analysis rather than hydrological sampling should be included to collect other dimensions of each tributary. By comparing the tributary and main stream in Chai water system, what we could further infer is that Chai is not the dumping site with untouched concentration while tributary carrying high toxic chemical concentration. | ||
</td> | </td> | ||
− | <td>[[image:lyr14.jpg| | + | <td>[[image:lyr14.jpg|500px|center]]</td> |
</tr> | </tr> | ||
Line 113: | Line 113: | ||
For measure Anionic active surfactants, which is popular in industry to be used for wastewater sedimentation, it appears an identical trend to Methylosmoline in Kohsoom, while Somchair did not monitor such index. Specifically, Anionic active surfactants also started to increase from year 2015 onwards, and according to standards, when such measure reach 1mg/L, the water would be severely polluted, although such chemicals is intended to purify the industrial wastewater. There is significant implication that the manufacture tends to increase the concentration of Anionic active surfactants to enhance sedimentation while they dumping more pollutants into river. | For measure Anionic active surfactants, which is popular in industry to be used for wastewater sedimentation, it appears an identical trend to Methylosmoline in Kohsoom, while Somchair did not monitor such index. Specifically, Anionic active surfactants also started to increase from year 2015 onwards, and according to standards, when such measure reach 1mg/L, the water would be severely polluted, although such chemicals is intended to purify the industrial wastewater. There is significant implication that the manufacture tends to increase the concentration of Anionic active surfactants to enhance sedimentation while they dumping more pollutants into river. | ||
</td> | </td> | ||
− | <td>[[image:15lyr.jpg| | + | <td>[[image:15lyr.jpg|500px|center]]</td> |
</tr> | </tr> | ||
Line 121: | Line 121: | ||
<br/>In this way, Kohsoom shows more evidence to be the suspected dumping site of the Kasios Furniture Company. Nonetheless, the stepped growth pattern in Somchair should be investigated as well by introducing daily multiple sampling and other sampling of different environment subject. | <br/>In this way, Kohsoom shows more evidence to be the suspected dumping site of the Kasios Furniture Company. Nonetheless, the stepped growth pattern in Somchair should be investigated as well by introducing daily multiple sampling and other sampling of different environment subject. | ||
</td> | </td> | ||
− | <td>[[image:16lyr.jpg| | + | <td>[[image:16lyr.jpg|500px|center]]</td> |
</tr> | </tr> | ||
</table> | </table> |
Revision as of 18:25, 9 July 2018
|
|
|
|
Tableau Dashboard Demo
Please refer to this link for more dynamic exploration:
Tableau Dashboard
Preliminary Analysis
Q1: Characterize the past and most recent situation with respect to chemical contamination in the Boonsong Lekagul waterways. Do you see any trends of possible interest in this investigation?
Analysis | Visualization |
---|---|
1. Inconsistent Sampling among Measures”
|
|
2. Measures with Same Sampling Pattern”
|
|
3.Methylosmoline Overall Trend
|
|
4.Correlation Exploring
|
|
5.Correlated Measures Illustration
|
Anomaly Discovery
Q2: What anomalies do you find in the waterway samples dataset? How do these affect your analysis of potential problems to the environment? Is the Hydrology Department collecting sufficient data to understand the comprehensive situation across the Preserve?
Analysis | Visualization |
---|---|
1.Detailed Investigation at Daily Record
|
|
2.Stream Path Analysis
|
|
3.Anionic active surfactants Related Analysis
|
|
4.Chemical Oxygen Demand Related Analysis - Locating the suspect dumping site
|
Sampling Strategy
Q3: Would you suggest any changes in the sampling strategy to better understand the waterways situation in the Preserve?
- Standardized Sampling
As for scientific research, the sampling datetime, method and measures should be standardized for more robust comparison. Regarding to sampling interval and cycle, existing records show irregular number of records and sampling interval. The varying number of measures in each year suggests that some measures are no longer to be noted and some new measures are introduced into monitor list.
Suggestion: Unifying the measures category and systemized the sampling date and period throughout the whole years. By industrialized the sampling and monitoring process, more data would be available for comparison both horizontally and vertically, and having no-discrepancy data is essential to clustering similar measures or conduct PCA to reduce dimension to better evaluate the water quality.
The sample records should also mark down the sampling time to provide hourly information for researcher. Meanwhile it is highly recommended to introduce daily multiple sampling method at maximum effort to better understand the variance impacted from time, temperature and others environment factor.
- Increasing Dimension
Other water dimension should be available as well. In stream path analysis, it is reasonable to conclude that the mainstream maintain more stable and lower level of chemicals concentration, but the speed and flow of both upstream and downstream should be considered to assess the reasonable decrease level in the mainstream, since the company may dumping in one sites, and pouring large amount of chemical purifier at the downstream, which is actually the secondary damage.
Field sample from other environment department should be included into research as well, for instance, soil analysis and air analysis. Some area may have characteristic geographical feature which should be considered while comparing to other area, thus recording the variance rather than absolute figure may be a better choice for some special areas.
- Proposed New Sampling Location
Given the present available data, here is the suggested new sampling location, which locates at the downstream of a lake and contribute to the suspect dumping site Somchair. By sampling the water here and comparing to the Somchair, it would be much easier to find the anomaly in Somchair – Why the Methylosmoline concentration keeps increasing and maintain stable? is it due to regular dumping at site or the upstream contribution or the irreversible environment changes.
Moreover, there are only one more tributary flowing into Somchair, so there would be less disturb and noise to compare the upstream and downstream in Somchair. Additionally, the proposed sampling location is right below a lake, where our treasury pipit and other wildlife are alive, so to monitor the water there would help assess the environment which directly related to the wildlife homeland.