Difference between revisions of "ISSS608 2017-18 T3 Assign Song Xuejing Data Preparation"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 10: Line 10:
 
| style="font-family: Georgia; font-size:100%; solid #1B338F; background:#838383; text-align:center;" width="20%" |  
 
| style="font-family: Georgia; font-size:100%; solid #1B338F; background:#838383; text-align:center;" width="20%" |  
 
;
 
;
−
[[ISSS608_2017-18_T3_Assign_Song_Xuejing_Data_Preparation|<b><font size="2"><font color="#FFFFFF">Methodology</font></font></b>]]
+
[[ISSS608_2017-18_T3_Assign_Song_Xuejing_Data_Preparation|<b><font size="2"><font color="#FFFFFF">Methodology & Answer</font></font></b>]]
  
 
| style="font-family: Georgia; font-size:100%; solid #1B338F; background:#8d8d8d; text-align:center;" width="20%" |  
 
| style="font-family: Georgia; font-size:100%; solid #1B338F; background:#8d8d8d; text-align:center;" width="20%" |  
Line 27: Line 27:
 
<br/>
 
<br/>
  
 +
==<font size="5"><font color="#f75b47" face=" Georgia">'''Data Preparation'''</font></font>==
  
−
<font size="3.5"><font face="Georgia" color="#000000">''Interactive Tableau dashboard'':</font>
+
<font size="3.5"><font face=" Georgia" color="#000000">We have two dataset which include the chemical units of measure and Boonsong Lekagul waterways readings. There are 106 different chemical measurements of the water, some of them are chemicals that will damage the water, which may possible output by the furniture factory, and some of the chemicals are just minerals such as iron and zinc. Also, these samples were randomly taken from 1998 to 2016. Therefore, firstly, we need to filter out all the chemicals that we need.  
−
[[Image:Tableau.png|150px|center|link=https://public.tableau.com/profile/xuejing7070#!/]]
 
  
 +
We should use chemicals have enough data points at least in recent years, because we need to identify that the water quality has been bad since the furniture factory has been build. If the chemical is no longer measured anymore, there is no point to identify the changes of the water quality. After first round of filtering, we have these chemicals remaining, only these chemicals have data till 2016.
 +
[[Image:Song1.png|300px|center]]
 +
</font></font>
  
−
 
+
==<font size="5"><font color="#f75b47" face=" Georgia">'''Question 1'''</font></font>==
−
==<font size="5"><font color="#f75b47" face=" Georgia">'''Setting the scene'''</font></font>==
 
−
 
 
−
<font size="3.5"><font face=" Georgia" color="#000000">The [http://vacommunity.org/VAST+Challenge+2018+MC2 VAST Mini Challenge 2 2018] is a direct sequel to the [http://www.vacommunity.org/VAST+Challenge+2017+MC2 VAST Mini Challenge 2 2017] which investigated the endangering of the Rose crested blue pipit bird species by environmental pollution.
 
−
 
 
−
Last year, the Kasios Furniture Company was implicated in environmental damage to the Boonsong Lekagul Wildlife Preserve for both dumping toxic waste and polluting the air with chemicals from its manufacturing process. But Kasios is not taking these accusations lying down, and they deny any accusation of industrial waste dumping! Kasios’ spokespersons state that there isn’t any ground contamination near the remote ranger station that was suggested by last year’s mini-challenge 1 and 3 participants, and they have inspected that area and found it as pristine as the rest of the preserve.
 
−
 
 
−
Outraged ornithology professors from Mistford College journeyed out to look over the dumping site themselves and perform soil analyses. They returned to report that the site looked like there had been recent excavation and building activities going on. Boonsong Preserve rangers later confirmed that a new ranger station was being built at that site! Soil samples taken from the site were inconclusive in detecting Methylosmolene (the toxic manufacturing chemical in the suspected dumping) or any other contaminant, as new top soil had been trucked in.
 
−
 
 
−
With a primary piece of evidence against Kasios now gone, investigators will need to take another approach. Professors in the Mistford College Hydrology Department have come forward with several years of water sensor readings from rivers and streams in the preserve. These samples were taken from different locations scattered throughout the area and contain measurements of several chemicals of possible interest, but they have never been analyzed due to lack of funding. Could visual analytics help reveal something in this data that could make up for the soil evidence that was destroyed?</font></font>
 
−
 
 
−
==<font size="5"><font color="#f75b47" face=" Georgia">'''Questions'''</font></font>==
 
  
 
<font size="3.5"><font face=" Georgia" color="#000000">
 
<font size="3.5"><font face=" Georgia" color="#000000">
−
1. 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.
+
After filtering out all the unnecessary chemicals, we can take a look at the overview of all the chemicals in different places one by one. For question1, we need to characterize the past and most recent situation with respect to chemical contamination in the Boonsong Lekagul waterways. Because we don’t know which year the factory was build, we define the recent as data point after 2013, and the past as data points before 2013, in order to see if there is any trend of some chemical measurements.  
−
 
+
After going through all the chemicals, we have found three apparent type of trends. First, the value of some chemicals increased from past to recent years. Including chemicals as below.  
−
2. 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.
 
  
−
3. 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.</font></font>
+
[[Image:q1.1.png|300px|center]]
 +
</font></font>

Revision as of 01:55, 8 July 2018

VAST Challenge 2018: Suspense at the Wildlife Preserve
Mini Challenge 2 - Like a duck to water

Background

Methodology & Answer

Dashboard Design

Feedback

Back to main

 


Data Preparation

We have two dataset which include the chemical units of measure and Boonsong Lekagul waterways readings. There are 106 different chemical measurements of the water, some of them are chemicals that will damage the water, which may possible output by the furniture factory, and some of the chemicals are just minerals such as iron and zinc. Also, these samples were randomly taken from 1998 to 2016. Therefore, firstly, we need to filter out all the chemicals that we need.

We should use chemicals have enough data points at least in recent years, because we need to identify that the water quality has been bad since the furniture factory has been build. If the chemical is no longer measured anymore, there is no point to identify the changes of the water quality. After first round of filtering, we have these chemicals remaining, only these chemicals have data till 2016.

Song1.png

Question 1

After filtering out all the unnecessary chemicals, we can take a look at the overview of all the chemicals in different places one by one. For question1, we need to characterize the past and most recent situation with respect to chemical contamination in the Boonsong Lekagul waterways. Because we don’t know which year the factory was build, we define the recent as data point after 2013, and the past as data points before 2013, in order to see if there is any trend of some chemical measurements. After going through all the chemicals, we have found three apparent type of trends. First, the value of some chemicals increased from past to recent years. Including chemicals as below.

Q1.1.png

Retrieved from ‘https://wiki.smu.edu.sg/1718t3isss608/index.php?title=ISSS608_2017-18_T3_Assign_Song_Xuejing_Data_Preparation&oldid=4966’