Difference between revisions of "ISSS608 2017-18 T3 Assign Yeo Kaijun Findings"
(34 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<div style=background:#2B3856 border:#A3BFB1> | <div style=background:#2B3856 border:#A3BFB1> | ||
− | + | [[Image:Duck_kj.jpg|300px]] | |
<font size = 5; color="#FFFFFF"><b>VAST Mini Challenge 2: Findings</b></font> | <font size = 5; color="#FFFFFF"><b>VAST Mini Challenge 2: Findings</b></font> | ||
</div> | </div> | ||
Line 16: | Line 16: | ||
| style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:#DDA0DD; width=25%" | | | style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:#DDA0DD; width=25%" | | ||
; | ; | ||
− | [[ISSS608 2017-18 T3 Assign Yeo | + | [[ISSS608 2017-18 T3 Assign Yeo Kaijun_Links|<font color="#000000">Links</font>]] |
|} | |} | ||
<br><br> | <br><br> | ||
Line 26: | Line 26: | ||
<br><br> | <br><br> | ||
− | <font face="Segoe UI Light" color="#000000"> As observed in Img 1, there appears to be no obvious trends in terms of % yearly change of | + | <font face="Segoe UI Light" color="#000000"> As observed in Img 1, there appears to be no obvious trends in terms of % yearly change of average measures value. There is no consistent increase or decrease over the years as observed from the mix of red and green cells across the years. However, it appears to have sharp increase and decrease in terms of average measure values as observed from the bright green or red respectively. Further analysis is done for each measure that has sharp changes in recent years to understand the location that has contributed to these changes. The trends below had been observed |
<br><br><br> | <br><br><br> | ||
<span style="font-size:16px; font-weight:bold;">1. Increase in Arsenic values over the years</span> | <span style="font-size:16px; font-weight:bold;">1. Increase in Arsenic values over the years</span> | ||
[[File:Value of Arsenic over time.png|thumb|Img 2: Value of Arsenic over time by location]] | [[File:Value of Arsenic over time.png|thumb|Img 2: Value of Arsenic over time by location]] | ||
<br><br> | <br><br> | ||
− | As observed in Img 2, even though there had been sharp increases and decreases in arsenic level over the years, as shown by the dotted trend line, arsenic value had on average been increasing over years. Arsenic value in Tansanee had spiked considerably as its value increased from 2.26 ug/L in 2011 to 4.468 ug/L in 2015. Despite the sharp increase in arsenic level, it is important to note that arsenic values are still way below US National Recommended Water Quality Criteria for aquatic life ambient | + | As observed in Img 2, even though there had been sharp increases and decreases in arsenic level over the years, as shown by the dotted trend line, arsenic value had on average been increasing over years. Arsenic value in Tansanee had spiked considerably as its value increased from 2.26 ug/L in 2011 to 4.468 ug/L in 2015. Despite the sharp increase in arsenic level, it is important to note that arsenic values are still way below US National Recommended Water Quality Criteria for aquatic life ambient. |
<br><br><br> | <br><br><br> | ||
<span style="font-size:16px; font-weight:bold;">2. Atrazine values had spiked during 2008 - 2010 for all waterway sensor sampled</span> | <span style="font-size:16px; font-weight:bold;">2. Atrazine values had spiked during 2008 - 2010 for all waterway sensor sampled</span> | ||
Line 44: | Line 44: | ||
<br><br> | <br><br> | ||
− | <span style="font-size:16px; font-weight:bold;">Comparison with a standardized water quality criteria</span | + | <span style="font-size:16px; font-weight:bold;">Comparison with a standardized water quality criteria</span> |
[[File:Comparison with US.png|thumb|Img 5: Comparison with Comparison with US National Recommended Water Quality Criteria]] | [[File:Comparison with US.png|thumb|Img 5: Comparison with Comparison with US National Recommended Water Quality Criteria]] | ||
<br><br> | <br><br> | ||
+ | In Img 5, values that are above the US National Recommended Water Quality Criteria for aquatic life ambient are indicated in orange. As observed, there are 5 main measures that are above the criteria threshold (Cadmium, Chromium, p,p-DDT, Sulfides and Zinc). Further analysis would be done to pinpoint the location/time where the threshold was exceeded | ||
+ | <br><br> | ||
+ | [[File:Value of p,p-DDT & Sulfides.png|Img 6: Value of p,p-DDT & Sulfides by location from 2012-2016]]<br> | ||
+ | Firstly, we look at the measures that exceed the continuous concentration criterion. As observed in the image above, for p,p-DDT, only Boonsori is higher than the continuous concentration criterion. Although, it might seem that this high value of p,p-DDT could be due to the waste dumping, due to Boonsori being near to the approx location of waste dumping, it seems weird that Kohsoom which is also near to the location did not observe such trend. More evaluation is needed to pinpoint the reason behind the high value of p,p-DDT at Boonsori. | ||
+ | |||
+ | On the other hand, sulfides values are higher than the continuous concentration criterion in all locations sampled. However, it is important to note that there was no values sampled at the 2 leftmost waterways (Decha and Tansanee). More samples might be needed to be conducted at the 2 leftmost waterways to check whether this high sulfide value could be the natural state of water around this region. | ||
+ | |||
+ | Next, we look at the measures that exceed the maximum concentration criterion.There are 2 main concerns observed:<br><br> | ||
+ | <span style="font-size:16px; font-weight:bold;">1. Cadmium values at Somchair had been high in recent years</span> | ||
+ | [[File:Value of Cadmium over time.png|thumb|Img 7: Value of Cadmium over time by location]] | ||
+ | <br><br> | ||
+ | As observed in Img 7, although only one data point exceeded the maximum concentration criterion, it can be observed that Somchair's Cadmium value had increased from 2014 and most of the monthly maximum values of Cadmium had been bordering around the maximum concentration criterion. | ||
+ | <br><br><br><br> | ||
+ | <span style="font-size:16px; font-weight:bold;">2. Zinc values at Decha had been high across years</span> | ||
+ | [[File:Value of Zinc over time.png|Img 8: Value of Zinc over time by location]]<br><br> | ||
+ | As observed from the image above, Decha's Zinc value had remained consistently high from 2012 to 2015 and would definitely be a case of concern. <br>There had been no samples done in 2016, thus making it impossible to evaluate after 2015. Zinc content at Decha should be monitored closely to ensure that the value keeps to an acceptable level. | ||
+ | <br> | ||
+ | <br> | ||
+ | <span style="font-size:16px; font-weight:bold;">Insights on Methylosmoline</span> | ||
+ | <br> | ||
+ | As Methylosmoline is the toxic manufacturing chemical in the suspected dumping, further insights are obtained for this measure.<br> | ||
+ | [[File:Value of Methylosmoline over time.png|Img 8.1: Value of Metylosmoline over time by location]]<br> | ||
+ | From the image above, it can be observed that value of Methylosmoline has spiked in 2016 for 2 locations (Kohsoom and Somchair). Further analysis shown in the image below shows that the spike in Methylosmoline is during the month of August. As Kohsoom is near to the suspected location of dumping, it could be possible that chemical dumping did take place in 2016.<br> | ||
+ | [[File:Value of Methylosmoline over months.png|Img 8.1: Value of Metylosmoline over months by location]]<br> | ||
+ | |||
+ | <br><br> | ||
+ | <div style="background:#000000; border:#002060; padding-left:15px; text-align:left;"> | ||
+ | <font size = 3; color="#FFFFFF"><span style="font-family:Century Gothic;">Q2a: What anomalies do you find in the waterway samples dataset and how do they affect my analysis of potential problems to the environment?</span></font> | ||
+ | </div> | ||
+ | <br><br> | ||
+ | There are 3 main anomalies found in the waterway sample dataset:<br> | ||
+ | 1. Minimal waterway sensors for certain waterways<br> | ||
+ | 2. Source of pollutant dump not confirmed<br> | ||
+ | 3. Inconsistency in data collected | ||
+ | <br><br> | ||
+ | <span style="font-size:16px; font-weight:bold;">1. Minimal waterway sensors for certain waterways</span><br> | ||
+ | [[File:Waterway.png|Img 9:Waterway sensor Distribution]]<br><br> | ||
+ | <br><br> | ||
+ | As observed in the image above, the 2 leftmost waterway only have 1 sensor each, which is much less compared to the number of sensors in the other 2 waterways (3 & 5). With minimal sensors in the 2 leftmost waterway, there is a possibility that any analysis of the waterway health for these 2 waterway might be misleading as there is no possibility of comparison with the upstream or downstream water quality for these waterways. | ||
+ | <br><br> | ||
+ | |||
+ | <span style="font-size:16px; font-weight:bold;">2. Source of pollutant dump not confirmed</span><br> | ||
+ | As observed in the map above, only anapproximate location of waste dumping is pin pointed. No confirmed location is provided. | ||
+ | <br><br> | ||
+ | <span style="font-size:16px; font-weight:bold;">3. Inconsistency in data collected</span><br> | ||
+ | [[File:Missing data by location.png|thumb|Img 10:Missing data by location]][[File:Missing data by years.png|thumb|Img 11:Missing data by years]][[File:month.png|thumb|Img 12:Data collected at different time period of year]] | ||
+ | |||
+ | <br><br> | ||
+ | Img 10, 11 and 12 are examples of inconsistency in data sampled. <br><br> | ||
+ | Img 10 shows that there are some measures that do not have any values recorded in certain locations. This indicate that we might be missing insights on certain measures for some locations. Some measures might also only be sampled in a few locations, thus making it tough to analyze the data collected as we are unable to compare the sample collected with different locations of the reserve.<br><br> | ||
+ | Img 11 shows that there are some measures that are not sampled in certain years. There are some issues that comes along with this:<br> | ||
+ | 1. We are unable to compare how certain measures varied over the years for measures with only data for a few years <br> | ||
+ | 2. We will be unable to know the current situation for measures who are missing recent data <br> | ||
+ | 3. Analysis of the measures over time might be misleading. | ||
+ | |||
+ | <br><br> | ||
+ | Img 12 shows that there are some measures where the month of data collected varies across years (E.g. for arsenic, there are values collected in Oct 2014 and 2016 but no values collected in Oct 2015. This might result in misleading analysis as there might be spikes in arsenic values every Oct and missing out Oct 2015 values might result in a sudden decrease in arsenic values when we are evaluating measures on a yearly basis.) | ||
+ | <br><br> | ||
+ | |||
+ | <br><BR> | ||
+ | <div style="background:#000000; border:#002060; padding-left:15px; text-align:left;"> | ||
+ | <font size = 3; color="#FFFFFF"><span style="font-family:Century Gothic;">Q2b: Is the Hydrology Department collecting sufficient data to understand the comprehensive situation across the Preserve and what changes would you propose to make in the sampling approach to best understand the situation?</span></font> </div> | ||
+ | <br><br> | ||
+ | |||
+ | As mentioned in part 2(a), the hydrology department is not collecting sufficient data. Some changes to be suggested are:<br> | ||
+ | 1. Increase the number of sensors in the 2 leftmost waterways<br> | ||
+ | 2. Confirm the site of dumping to ensure more accurate evaluation<br> | ||
+ | 3. Ensure consistent sampling periods<br> | ||
+ | 4. Ensure consistent measures sampled across location | ||
+ | |||
+ | <br><BR> | ||
+ | <div style="background:#000000; border:#002060; padding-left:15px; text-align:left;"> | ||
+ | <font size = 3; color="#FFFFFF"><span style="font-family:Century Gothic;">Q3: After reviewing the data, do any of your findings cause particular concern for the Pipit or other wildlife? Would you suggest any changes in the sampling strategy to better understand the waterways situation in the Preserve?</span></font> </div> | ||
+ | <br><br> | ||
+ | Firstly, Methylosmoline the suspected chemical dumped has spiked considerably in year 2016 in 2 locations, Somchair and Kohsoom, with Kohsoom having an exceptionally high level of Methylosmoline of 145 ug/L at Aug 2016. Suspected dumping might have occurred in these 2 locations during 2016. | ||
+ | <br> | ||
+ | <Br> | ||
+ | Secondly, the average sulfides value for 2012 - 2016 is above the US National Recommended Water Quality Criteria for aquatic life ambient in all locations sampled. It might be important to look into the high sulfides level to ensure that it is not due to unnatural causes and would not harm the wildlife around it. | ||
+ | <br><br> | ||
+ | Another point to note is that for the most recent samples, Zinc values in Decha, Cadmium values in Somchair appears to had increased and most samples are bordering around/above the US National Recommended Water Quality Criteria for aquatic life ambient. | ||
+ | <br><br> | ||
+ | Lastly, it can be observed that extreme spikes in values of measures could be seen in different locations over time (e.g. The case of Atrazine and Petroleum hydrocarbons shown in Q1). These spikes do not appear to be natural and unless valid reasons could be provided should be looked into. | ||
+ | <br><br> | ||
+ | Other than the suggested changes in sampling mentioned in Q2b, there are a few other changes that should be made to dig deeper according to the insights obtained:<br> | ||
+ | 1. For the suspected Methylosmoline dump at locations Somchair and Kohsoom, it is important to also add in sample points at the upstream of these 2 locations. As shown in the map of the waterways, there are samples done at the downstream of these 2 areas (Sakda and Chai respectively), there was none at the upstream. This is important to pinpoint the exact location of the source for further investigation, especially so for Somchair as there is a convergence of different water stream before the sample was taken at Somchair.<br> | ||
+ | 2. For the high sulfides value, it is important to collect more recent data, as observed in the image below, the most recent data collected for sulfides was in 2012. If the sulfide level remains to be high, investigation into the high sulfide values should be done. It is possible to check with local researchers on the possible reasons behind the high sulfide value and whether they had seen any changes in wildlife activities compared to be past.<br> | ||
+ | [[Image:Value of Sulfides.png|Img 13:Value of Sulfide over time by location (years)]]<br> | ||
+ | 3. Similarly to Sulfide, more recent data of Zinc should also be collected.<br> | ||
+ | <br><br> | ||
[[Assignments|<font face="Segoe UI Light" color="#3C33FF">Back to Assignments</font>]] | [[Assignments|<font face="Segoe UI Light" color="#3C33FF">Back to Assignments</font>]] |
Latest revision as of 00:31, 10 July 2018
|
|
|
|
Q1: Characterize the past and most recent situation with respect to chemical contamination in the Boonsong Lekagul waterways.
Comparison across time
As observed in Img 1, there appears to be no obvious trends in terms of % yearly change of average measures value. There is no consistent increase or decrease over the years as observed from the mix of red and green cells across the years. However, it appears to have sharp increase and decrease in terms of average measure values as observed from the bright green or red respectively. Further analysis is done for each measure that has sharp changes in recent years to understand the location that has contributed to these changes. The trends below had been observed
1. Increase in Arsenic values over the years
As observed in Img 2, even though there had been sharp increases and decreases in arsenic level over the years, as shown by the dotted trend line, arsenic value had on average been increasing over years. Arsenic value in Tansanee had spiked considerably as its value increased from 2.26 ug/L in 2011 to 4.468 ug/L in 2015. Despite the sharp increase in arsenic level, it is important to note that arsenic values are still way below US National Recommended Water Quality Criteria for aquatic life ambient.
2. Atrazine values had spiked during 2008 - 2010 for all waterway sensor sampled
As observed in the above image, atrazine levels have consistently spiked across all the locations where readings are available from 2008 to 2010. This pattern seen across all the locations should be investigated further for the root cause.
3. Petroleum hydrocarbons values had spiked during 2012 for all waterway sensor sampled other than Boonsri
As observed in the above image, petroleum hydrocarbons levels have spiked across all the locations where readings are available, other than Boonsri in 2012. This pattern seen across all the locations should be investigated further for the root cause.
Comparison with a standardized water quality criteria
In Img 5, values that are above the US National Recommended Water Quality Criteria for aquatic life ambient are indicated in orange. As observed, there are 5 main measures that are above the criteria threshold (Cadmium, Chromium, p,p-DDT, Sulfides and Zinc). Further analysis would be done to pinpoint the location/time where the threshold was exceeded
Firstly, we look at the measures that exceed the continuous concentration criterion. As observed in the image above, for p,p-DDT, only Boonsori is higher than the continuous concentration criterion. Although, it might seem that this high value of p,p-DDT could be due to the waste dumping, due to Boonsori being near to the approx location of waste dumping, it seems weird that Kohsoom which is also near to the location did not observe such trend. More evaluation is needed to pinpoint the reason behind the high value of p,p-DDT at Boonsori.
On the other hand, sulfides values are higher than the continuous concentration criterion in all locations sampled. However, it is important to note that there was no values sampled at the 2 leftmost waterways (Decha and Tansanee). More samples might be needed to be conducted at the 2 leftmost waterways to check whether this high sulfide value could be the natural state of water around this region.
Next, we look at the measures that exceed the maximum concentration criterion.There are 2 main concerns observed:
1. Cadmium values at Somchair had been high in recent years
As observed in Img 7, although only one data point exceeded the maximum concentration criterion, it can be observed that Somchair's Cadmium value had increased from 2014 and most of the monthly maximum values of Cadmium had been bordering around the maximum concentration criterion.
2. Zinc values at Decha had been high across years
As observed from the image above, Decha's Zinc value had remained consistently high from 2012 to 2015 and would definitely be a case of concern.
There had been no samples done in 2016, thus making it impossible to evaluate after 2015. Zinc content at Decha should be monitored closely to ensure that the value keeps to an acceptable level.
Insights on Methylosmoline
As Methylosmoline is the toxic manufacturing chemical in the suspected dumping, further insights are obtained for this measure.
From the image above, it can be observed that value of Methylosmoline has spiked in 2016 for 2 locations (Kohsoom and Somchair). Further analysis shown in the image below shows that the spike in Methylosmoline is during the month of August. As Kohsoom is near to the suspected location of dumping, it could be possible that chemical dumping did take place in 2016.
Q2a: What anomalies do you find in the waterway samples dataset and how do they affect my analysis of potential problems to the environment?
There are 3 main anomalies found in the waterway sample dataset:
1. Minimal waterway sensors for certain waterways
2. Source of pollutant dump not confirmed
3. Inconsistency in data collected
1. Minimal waterway sensors for certain waterways
As observed in the image above, the 2 leftmost waterway only have 1 sensor each, which is much less compared to the number of sensors in the other 2 waterways (3 & 5). With minimal sensors in the 2 leftmost waterway, there is a possibility that any analysis of the waterway health for these 2 waterway might be misleading as there is no possibility of comparison with the upstream or downstream water quality for these waterways.
2. Source of pollutant dump not confirmed
As observed in the map above, only anapproximate location of waste dumping is pin pointed. No confirmed location is provided.
3. Inconsistency in data collected
Img 10, 11 and 12 are examples of inconsistency in data sampled.
Img 10 shows that there are some measures that do not have any values recorded in certain locations. This indicate that we might be missing insights on certain measures for some locations. Some measures might also only be sampled in a few locations, thus making it tough to analyze the data collected as we are unable to compare the sample collected with different locations of the reserve.
Img 11 shows that there are some measures that are not sampled in certain years. There are some issues that comes along with this:
1. We are unable to compare how certain measures varied over the years for measures with only data for a few years
2. We will be unable to know the current situation for measures who are missing recent data
3. Analysis of the measures over time might be misleading.
Img 12 shows that there are some measures where the month of data collected varies across years (E.g. for arsenic, there are values collected in Oct 2014 and 2016 but no values collected in Oct 2015. This might result in misleading analysis as there might be spikes in arsenic values every Oct and missing out Oct 2015 values might result in a sudden decrease in arsenic values when we are evaluating measures on a yearly basis.)
As mentioned in part 2(a), the hydrology department is not collecting sufficient data. Some changes to be suggested are:
1. Increase the number of sensors in the 2 leftmost waterways
2. Confirm the site of dumping to ensure more accurate evaluation
3. Ensure consistent sampling periods
4. Ensure consistent measures sampled across location
Firstly, Methylosmoline the suspected chemical dumped has spiked considerably in year 2016 in 2 locations, Somchair and Kohsoom, with Kohsoom having an exceptionally high level of Methylosmoline of 145 ug/L at Aug 2016. Suspected dumping might have occurred in these 2 locations during 2016.
Secondly, the average sulfides value for 2012 - 2016 is above the US National Recommended Water Quality Criteria for aquatic life ambient in all locations sampled. It might be important to look into the high sulfides level to ensure that it is not due to unnatural causes and would not harm the wildlife around it.
Another point to note is that for the most recent samples, Zinc values in Decha, Cadmium values in Somchair appears to had increased and most samples are bordering around/above the US National Recommended Water Quality Criteria for aquatic life ambient.
Lastly, it can be observed that extreme spikes in values of measures could be seen in different locations over time (e.g. The case of Atrazine and Petroleum hydrocarbons shown in Q1). These spikes do not appear to be natural and unless valid reasons could be provided should be looked into.
Other than the suggested changes in sampling mentioned in Q2b, there are a few other changes that should be made to dig deeper according to the insights obtained:
1. For the suspected Methylosmoline dump at locations Somchair and Kohsoom, it is important to also add in sample points at the upstream of these 2 locations. As shown in the map of the waterways, there are samples done at the downstream of these 2 areas (Sakda and Chai respectively), there was none at the upstream. This is important to pinpoint the exact location of the source for further investigation, especially so for Somchair as there is a convergence of different water stream before the sample was taken at Somchair.
2. For the high sulfides value, it is important to collect more recent data, as observed in the image below, the most recent data collected for sulfides was in 2012. If the sulfide level remains to be high, investigation into the high sulfide values should be done. It is possible to check with local researchers on the possible reasons behind the high sulfide value and whether they had seen any changes in wildlife activities compared to be past.
3. Similarly to Sulfide, more recent data of Zinc should also be collected.
Back to Assignments