VAST-2018-MC2
Team member
| Name | ||
|---|---|---|
| Wang Xu | Team leader | wx.insane@gmail.com |
| Zhou Yuchen | Team member | |
| Tao Yu | Team member |
This is a student team. We use D3.js and python to analyze data. This submission cost us 10 hours. We agreed to be posted in the publicly accessible Visual Analytics Benchmark Repository.
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? Your submission for this questions should contain no more than 10 images and 1000 words.
In this part, we will show the trends of recent chemical contamination changes by region. We use boxplot display the past situation and use star points to indicate the most recent situation. For each region we choose the different situations without showing the normal trends.
Achara
From the plot below, we can see that the most recent Biochemical Oxygen is lower than the past situation. And the Bicarbonates is below the normal level. The Calcium is a little lower than the normal level. The Chemical Oxygen Demand(Cr) is higher than the normal level. The iron is the most lowest record in the past. The Chlorides, Potassium and Lead are a little lower than the normal level. The Sulphates, Total organic carbon and Total dissolved salts are also lower than the normal level. The Zinc is higher than the normal level.
Boonsri
From the plot below, we can see that the Magnesium and Dissolved silicates are both lower than their normal level. The Anionic active surfactants and Dissolved oxygen and total hardness are higher than their normal level. The Oxygen saturation is a little higher than the normal level. The Silica (SiO2) is a lot higher than the normal level. In a word, the most recent chemical contamination is generally higher than the past.
Busarakhan
From the plot below, we can see that the Mercury, Dissolved silicates, Potassium, Silica and Total nitrogen are lower than their normal levels. The Oxygen saturation, Arsenic and Total hardness are higher than their past situation.
Chai
From the plot below, we can see that the Anionic active surfactants is lower than the normal level. The Arsenic, Calcium, Total dissolved salts, Total hardness and Total organic carbon are blow their normal level.
Kannika
From the plot below, we can see that the Chlorides and Sulphates are lower than their normal level. The Arsenic, Calcium, Dissolved oxygen, Dissolved silicates, Bicarbonates and Total hardness are higher than their normal level.
Kohsoom
From the plot below, we can see that the Ammonium, Arsenic, Mercury, Chlorides, Water temperature, Total nitrogen, Oxygen saturation, Nitrites, Sulphates, Total dissolved salts and Potassium are lower than normal level. The Anionic active surfactants is higher than the normal level.
Sakda
From the plot below, we can see that the Arsenic, Biochemical Oxygen, Chemical Oxygen Demand(Cr), Dissolved Oxygen, Dissolved silicates, Total hardness, Total organic carbon and Oxygen saturation are higher than their normal level.
Somchair
From the plot below, we can see that the Biochemical Oxygen, Anionic active surfactants, Sulphates, Potassium, Dissolved silicates are lower than their normal level. The Dissolved oxygen, Total hardness, Total dissolved salts and Chlorides are higher than their normal level.
Tansanee
From the plot below, we can see that the Total organic carbon, Calcium is higher than the normal level. The Manganese, Lead, Iron and Copper are lower than the normal level.
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? What changes would you propose to make in the sampling approach to best understand the situation?Your submission for this question should contain no more than 6 images and 500 words.
We found that in the dataset, some data is abnormally higher than normal data. This shows the change in copper content in the past. We found that around 2005, the copper content suddenly increased, far exceeding the usual level. We think this is an anomaly, which may be abnormality in data logging or an error in data detection.
This is the chart of AGOC-3A content in the past years, it has an abnormally high abnormal data, which we think is also one of the errors. More over, the data in most areas is basically zero, and basically not changed. We believe that such data doesn't have much reference value.
These anomalies affect our analysis, and we may treat anomalous data as an increase or decrease in the content of certain chemical elements. This plot below shows the change of AOX content in past years. And from this chart, we find that the data is not sufficient. It has more data recently, and there is almost no data in the early stage.
This plot below shows the change in Endrin content, with more data in the previous period and less data in the later period.
The picture below shows the change in Anthracene content, and it has insufficient data for analysis.
We removed some of the data based on the adequacy of the data, such as data with less than 5 data points or data is zero and data with no change. We believe that such data is not necessary for analysis.
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? Your submission for this question should contain no more than 6 images and 500 words.
We think this waterway might be eutrophication, bioaccumulation and oil spill.
Eutrophication is the process through which a body of water becomes enriched with chemicals such as nitrates and phosphates. Algae and other aquatic plants then feed on these nutrients leading to excess growth. This leads to a reduction in the amount of dissolved oxygen available as algal blooms on the surface restrict the amount of sunlight penetrating the water limiting photosynthesis which causes the death and decomposition of plant life underwater. The lack of dissolved oxygen also kills all animal life in the water body.
This picture shows the change in nitrate content over the past few years. From this we can see that the nitrate content has been relatively high from 1998 to 2008, after which it began to slowly decline. This means that the eutrophication of the water has been alleviated.
Bioaccumulation is the build-up of toxic substances in a food chain. A common example in aquatic systems is the accumulation of heavy metals such as mercury (Hg) in fish. At the start of the chain, mercury is absorbed by algae in the form of methylmecury (CH3Hg+). Fish then eat the algae and aborbing the methylmercury and since they are absorbing it at a faster rate than it can be excreted, it accumulates in the body of the fish. Further up the food chain, predatory fish and birds then absorb the mercury from the fish they consume. Thus Pipit and other wildlife will be harmed.
This picture shows the change in lead content. This shows that the lead content is high from 1998 to 2008 and reduced in recent years.
When an oil spill occurs it can cause a lot of harm to all life in the area. It destroys the insulating ability of fur in mammals such as sea otters and the water repelling properties of birds' feathers. This means they are more exposed to the elements which can lead to hypothermia and death. Recently, it has also been shown that polycyclic aromatic hydrocarbons in oil can cause fish to have heart attacks and in lower concentrations disrupt the development of fish larvae.
This picture shows the change in petroleum hydrocarbons content. We can see that the petroleum hydrocarbons content is high in 2004, 2010 and 2012 to 2017. The cause of this phenomenon may be due to oil leakage, or factory discharge of pollutants.