Difference between revisions of "ISSS608 2017-18 T3 Assign LI Yaru Visualization"
Yaru.li.2017 (talk | contribs) |
Yaru.li.2017 (talk | contribs) |
||
(12 intermediate revisions by the same user not shown) | |||
Line 15: | Line 15: | ||
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#008080; text-align:center;" width="25%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#008080; text-align:center;" width="25%" | | ||
; | ; | ||
− | [[ISSS608_2017-18_T3_Assign_LI_Yaru_Visualization|<b><font size=" | + | [[ISSS608_2017-18_T3_Assign_LI_Yaru_Visualization|<b><font size="3.5"><font color="#E0FFFF">Visualization & Analysis</font></font></b>]] |
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#008080; text-align:center;" width="25%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#008080; text-align:center;" width="25%" | | ||
; | ; | ||
− | [[ISSS608_2017-18_T3_Assign_LI_Yaru_Conclusion & Suggestion| <b><font size="2.5"><font color="#F5F5F5">Conclusion | + | [[ISSS608_2017-18_T3_Assign_LI_Yaru_Conclusion & Suggestion| <b><font size="2.5"><font color="#F5F5F5">Conclusion</font></font></b>]] |
| | | | ||
|} | |} | ||
+ | <br> | ||
==<font size="4.5"><font color="#008080 ">'''Tableau Dashboard Demo'''</font></font>== | ==<font size="4.5"><font color="#008080 ">'''Tableau Dashboard Demo'''</font></font>== | ||
Please refer to this link for more dynamic exploration: | Please refer to this link for more dynamic exploration: | ||
Line 28: | Line 29: | ||
==<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/> | + | <br/><br/> |
<table> | <table> | ||
<table border='1'> | <table border='1'> | ||
Line 36: | Line 37: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td><b> 1. Inconsistent Sampling among | + | <td><b> 1. Inconsistent Sampling among Measures </b> |
<br/>By lining up all the measures for each location at certain period time, we could see the sampling missing pattern for from several dimension. In the sampling detail matrix, one line indicates a single week, horizontally we could see how frequently a measure is recorded in a year and compare the measures sampling time, vertically we could find the measures are recorded within a particular week. | <br/>By lining up all the measures for each location at certain period time, we could see the sampling missing pattern for from several dimension. In the sampling detail matrix, one line indicates a single week, horizontally we could see how frequently a measure is recorded in a year and compare the measures sampling time, vertically we could find the measures are recorded within a particular week. | ||
<br/>From the example below, which shows records of location Kohsoom in year 2015, we could see that contaminants AGOC-3A, Chlorodinine, Methylosmoline are always sampled in a different time as other measures, depicting a discrepancy among other measures but maintain similar interval. Thus, these three measures remain further exploration for correlation or practical interaction. | <br/>From the example below, which shows records of location Kohsoom in year 2015, we could see that contaminants AGOC-3A, Chlorodinine, Methylosmoline are always sampled in a different time as other measures, depicting a discrepancy among other measures but maintain similar interval. Thus, these three measures remain further exploration for correlation or practical interaction. | ||
</td> | </td> | ||
− | <td>[[image:lyr5.jpg| | + | <td>[[image:lyr5.jpg|550px|center]]</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td><b> 2. Measures with Same Sampling | + | <td><b> 2. Measures with Same Sampling Pattern</b> |
<br/>Mentioned by scholar that Methylosmoline is the confirmed contaminant in the waste from light manufacture, so we start with this measure to explore more related changes. From the record frequency gantt chart, we could see the irregular sampling interval through all the years and locations, in some years, many records are noted down whereas there are frequent wide gap appeared between two sampling date in other years. Regarding to Methylosmoline, location Achara, Decha, Tansanee do not take such sample, for those sampled location, this chemical had only been measured from year 2014 onwards. Interestingly, early mentioned suspect correlated measures Chlorodinine, AGOC-3A show identical record frequency patterns as Methylosmoline, meaning that these three chemicals are sampled together under certain condition. | <br/>Mentioned by scholar that Methylosmoline is the confirmed contaminant in the waste from light manufacture, so we start with this measure to explore more related changes. From the record frequency gantt chart, we could see the irregular sampling interval through all the years and locations, in some years, many records are noted down whereas there are frequent wide gap appeared between two sampling date in other years. Regarding to Methylosmoline, location Achara, Decha, Tansanee do not take such sample, for those sampled location, this chemical had only been measured from year 2014 onwards. Interestingly, early mentioned suspect correlated measures Chlorodinine, AGOC-3A show identical record frequency patterns as Methylosmoline, meaning that these three chemicals are sampled together under certain condition. | ||
</td> | </td> | ||
− | <td>[[image:lyr6.jpg| | + | <td>[[image:lyr6.jpg|500px|center]] |
− | <br/>[[image:lyr7.jpg| | + | <br/>[[image:lyr7.jpg|500px|center]]</td> |
</tr> | </tr> | ||
Line 58: | Line 59: | ||
</td> | </td> | ||
<td>[[image:888lyr.jpg|500px|center]] | <td>[[image:888lyr.jpg|500px|center]] | ||
− | <br/>[[image: | + | <br/>[[image:Lyr9.jpg|500px|center]]</td> |
</tr> | </tr> | ||
Line 66: | Line 67: | ||
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. | 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> | ||
− | <td>[[image:10lyr.jpg| | + | <td>[[image:10lyr.jpg|250px|center]] |
<br/>[[image:lyr11.jpg|550px|center]]</td> | <br/>[[image:lyr11.jpg|550px|center]]</td> | ||
</tr> | </tr> | ||
Line 72: | Line 73: | ||
<tr> | <tr> | ||
<td><b>5.Correlated Measures Illustration</b> | <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 | + | <br/>By lining up all the correlated measures versus Methylosmoline and setting an exponential trend line, we find that surprisingly, chemicals Chemical Oxygen Demand (Cr) and Anionic active surfactants share specific similar trend for location Kohsoom, but for other location, which experienced upwards Methylosmoline concentration, the correlated trend is weaker. 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> | ||
− | <td>[[image: | + | <td>[[image:shadiao11.jpg|500px|center]] |
+ | [[image:shadiao9.jpg|500px|center]] | ||
+ | [[image:shadiao10.jpg|500px|center]]</td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
Line 80: | Line 83: | ||
==<font size="4.5"><font color="#008080 ">'''Anomaly Discovery'''</font></font>== | ==<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> | <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/> | + | <br/><br/> |
<table> | <table> | ||
<table border='1'> | <table border='1'> | ||
Line 94: | Line 97: | ||
<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. | <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> | ||
− | <td>[[image:lyr13.jpg| | + | <td>[[image:lyr13.jpg|550px|center]]</td> |
</tr> | </tr> | ||
Line 102: | 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|550px|center]]</td> |
</tr> | </tr> | ||
Line 110: | 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> | ||
<tr> | <tr> | ||
− | <td><b>4.Chemical Oxygen Demand Related Analysis</b> | + | <td><b>4.Chemical Oxygen Demand Related Analysis - Locating the suspect dumping site</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/>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. | <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> | ||
+ | |||
+ | ==<font size="4.5"><font color="#008080 ">'''Sampling Strategy'''</font></font>== | ||
+ | <b>Q3: Would you suggest any changes in the sampling strategy to better understand the waterways situation in the Preserve? </b> | ||
+ | <br/> <br/> | ||
+ | *<b>Standardized Sampling</b><br/> | ||
+ | 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.<br/> | ||
+ | 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.<br/> | ||
+ | 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.<br/> | ||
+ | [[image:shadiao1.jpg|600px]]<br/><br/> | ||
+ | *<b>Increasing Dimension</b><br/> | ||
+ | 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.<br/> | ||
+ | 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.<br/><br/> | ||
+ | *<b>Proposed New Sampling Location</b><br/> | ||
+ | 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. <br/> | ||
+ | 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. <br/> | ||
+ | [[image:shadiao2.jpg|400px]]<br/> |
Latest revision as of 19:03, 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.