Difference between revisions of "ISSS608 2017-18 T3 Assign LI Yaru Visualization"
Yaru.li.2017 (talk | contribs) (Created page with "<div style=background:#008080 border:#A3BFB1> 180px <b><font size = 5.5; color="#F5F5F5"> VAST Challenge 2018 Mini-Challenge 2:Like a Duck to Water </f...") |
Yaru.li.2017 (talk | contribs) |
||
Line 25: | Line 25: | ||
==<font size="4.5"><font color="#008080 ">'''Preliminary Analysis'''</font></font>== | ==<font size="4.5"><font color="#008080 ">'''Preliminary Analysis'''</font></font>== | ||
<b>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?</b> | <b>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?</b> | ||
+ | <br/> | ||
<table> | <table> | ||
+ | <table border='1'> | ||
<tr> | <tr> | ||
− | |||
<th>Analysis</th> | <th>Analysis</th> | ||
<th>Visualization</th> | <th>Visualization</th> | ||
Line 39: | Line 40: | ||
</tr> | </tr> | ||
− | + | ||
<tr> | <tr> | ||
<td><b> 2. Measures with Same Sampling Pattern” </b> | <td><b> 2. Measures with Same Sampling Pattern” </b> | ||
Line 53: | Line 54: | ||
<br/>Right from end of year 2014, different streams began to show diverging trend with a rocket increasing concentration in Somchair, Kohsoom, Chai, while other location remains the same level as previous time. Those sites with stable trend all experienced a sharp dropdown at the end of year 2015, and all drop to around 0.02 mg/L of Methylosmoline, since they are in the same stream system, the most reasonable reason caused drops is the environment. In terms of the macro impact from environment, there should be more or less impact to other stream regardless of the location, since impacted stream have no hierarchical networks among each other. Thus Somchair, Kohsoom and Chai are the most suspect candidate dumping sites, and more justification from other measures and pattern analysis need to be done to investigate deeper. | <br/>Right from end of year 2014, different streams began to show diverging trend with a rocket increasing concentration in Somchair, Kohsoom, Chai, while other location remains the same level as previous time. Those sites with stable trend all experienced a sharp dropdown at the end of year 2015, and all drop to around 0.02 mg/L of Methylosmoline, since they are in the same stream system, the most reasonable reason caused drops is the environment. In terms of the macro impact from environment, there should be more or less impact to other stream regardless of the location, since impacted stream have no hierarchical networks among each other. Thus Somchair, Kohsoom and Chai are the most suspect candidate dumping sites, and more justification from other measures and pattern analysis need to be done to investigate deeper. | ||
</td> | </td> | ||
− | <td>[[image: | + | <td>[[image:88lyr.jpg|500px|center]] |
+ | <br/>[[image:lyr9.jpg|550px|center]]</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td><b>4.Correlation Exploring</b> | ||
+ | <br/>According to unfold measures, we implement multivariate analysis for contaminant Methylosmoline to dig deeper to see any related measures. Here are selected measures with relative high correlation (>0.6) with Methylosmoline, and AGOC-3A, Chlorodinine respectively. The matrix shows that suspect measures hardly have correlation with Methylosmoline. For other measures, although the pairwise value is quite high, but it is very conservative due to large missing value pattern, meaning too little matching record could be paired to evaluate correlation. | ||
+ | The scatterplot matrix shows poor correlated patterns for almost each measure, but undeniably some points appear strong correlation, so we should map these measures into tableau to compare the trend with Methylosmoline geographically. | ||
+ | </td> | ||
+ | <td>[[image:lyr10.jpg|500px|center]] | ||
+ | <br/>[[image:lyr11.jpg|550px|center]]</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td><b>5.Correlated Measures Illustration</b> | ||
+ | <br/>By lining up all the correlated measures versus Methylosmoline and setting an exponential trend line, we find that Dissolved silicates who possess the highest positive correlation with Methylosmoline appears poor correlated scatterplot and trend on a detailed level. Surprisingly, chemicals Chemical Oxygen Demand (Cr) and Anionic active surfactants share specific similar trend for location Kohsoom, but less identical patterns for other Methylosmoline value upwards location. In this way, site Kohsoom have more mystery to explore and the practical relevance between Methylosmoline and Anionic active surfactants, Chemical Oxygen Demand (Cr) require more field and lab research. | ||
+ | </td> | ||
+ | <td>[[image:lyr12.jpg|600px|center]]</td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | <br/> | ||
+ | ==<font size="4.5"><font color="#008080 ">'''Anomaly Discovery'''</font></font>== | ||
+ | <b>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? </b> | ||
+ | <br/> | ||
+ | <table> | ||
+ | <table border='1'> | ||
+ | <tr> | ||
+ | <th>Analysis</th> | ||
+ | <th>Visualization</th> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td><b>1.Detailed Investigation at Daily Record</b> | ||
+ | <br/>From the preliminenary analysis, we include Somchair, Kohsoom and Chai into suspect dumping site list, also we discover a stepped growth in Methylosmoline concentration in sites Somchair and Chai, which is worth exploring into more detailed sampling date. The daily record in these three sites provide some evidence for uncontrollable factor while assessing the dumping site: | ||
+ | <br/><b>Chai</b> is the most modest growing member from 0.3mg/L to 5mg/L then dropping to 1mg/L, showing a very rhythmic patterns within a day. Since there are multiple sampling within a day showing different value at different time, the plot of Chai provides a view of impact from time. At the end of year 2015, the daily maximum value of Chai suddenly zoomed up to 4.3mg/L while the daily minimum value appears milder upwards trend and maintain at about 1.5mg/L. In this way, Chai is less suspect due to regular and consistent hourly variance. Moreover, the sudden increase is worth investigating since Chai is the main stream for another suspect tributary -Kohsoom. | ||
+ | <br/><b>Somchair</b> also shows a stepped growing trend: two sudden rocket turning point followed by onwards stable level in Methylosmoline concentration. However, it is very inconclusive to criticize Somchair as dumping point due to consistent polluting. So Pattern analysis should be introduced to compare the polluting patterns in both Somchair and Kohsoom. | ||
+ | </td> | ||
+ | <td>[[image:lyr13.jpg|600px|center]]</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td><b>2.Stream Path Analysis</b> | ||
+ | <br/>Based on the map, the Kohsoom is a tributary of Chai, which belongs to Kannika stream system, and Somchair belongs to main stream Skada. For Skada water system, there are another sampling sites Achara, but this site did not record the measure Methylosmoline, thus it is more difficult and limited to conduct path pattern analysis. In this way, we mainly focus on Chai water system. | ||
+ | <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>[[image:lyr14.jpg|600px|center]]</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td><b>3.Stream Path Analysis</b> | ||
+ | <br/>To further compare site Somchair and Kohsoom, we resort to other measures to discover difference between them. Earlier mentioned measures Anionic active surfactants and Chemical Oxygen Demand (Cr), which show similar trends with Methylosmoline in some sites to help evaluate pollutant status. | ||
+ | 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>[[image:lyr14.jpg|600px|center]]</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td><b>4.Stream Path Analysis</b> | ||
+ | <br/>For measure Chemical Oxygen Demand (Cr), which is used to quantify amount of oxidizable pollutants found in surface water, higher meaning severer pollution. From the pair graph, we could see that at year 2014, Kohsoom and Somchair shared same level in both Methylosmoline and Chemical Oxygen Demand (Cr). However, when it comes to year 2015, COD in Kohsoom increased sharply and whole concentration level is lifted by about 10 units, while COD in Somchair still maintain a stable level as year 2014 despite some abnormal increase. | ||
+ | <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>[[image:lyr14.jpg|600px|center]]</td> | ||
</tr> | </tr> | ||
+ | </table> |
Revision as of 00:11, 9 July 2018
|
|
|
|
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.Stream Path Analysis
|
|
4.Stream Path Analysis
|