Difference between revisions of "ISSS608 2017-18 T3 Assign He Mengqi"

From Visual Analytics and Applications
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 7: Line 7:
  
 
<!--MAIN HEADER -->
 
<!--MAIN HEADER -->
{|width=100%, height=150%, style="background-color:#0000A8; font-family:Calibri; font-size:120%; text-align:center;"
+
{|width=100%, height=150%, style="background-color:#87CEFA; font-family:Calibri; font-size:120%; text-align:center;"
 
|-
 
|-
| | [[Data_Preparation1|<font color = "#ffffff" style="font-family:Comic Sans MS">Data Preparation</font>]] || [[Visualization_Design1|<font color = "#ffffff" style="font-family:Comic Sans MS">Visualization Design</font>]] || [[Answer1|<font color = "#ffffff" style="font-family:Comic Sans MS">Answer</font>]]|| [[Application1|<font color = "#ffffff" style="font-family:Comic Sans MS">Application</font>]]||  
+
| | [[Data_Preparation1|<font color = "#ffffff" style="font-family:Comic Sans MS">Data Preparation</font>]] || [[Visualization_Design1|<font color = "#ffffff" style="font-family:Comic Sans MS">Visualization Design</font>]] || [[Answer1|<font color = "#ffffff" style="font-family:Comic Sans MS">Answer</font>]]|| [[Application1|<font color = "#ffffff" style="font-family:Comic Sans MS">Application</font>]]||  [[Assignments|<font color = "#ffffff" style="font-family:Comic Sans MS">Assignments</font>]]||
 
|-
 
|-
 
|
 
|
 
|}<br>
 
|}<br>
==Data Preparation==
 
1.Prepare the location data, first create the table below then import the table into tableau, drag the Xcoord into Column, Ycoord into Rows and Location into Detail to create the scatter plot.
 
  
[[image:p1.jpg]]
+
==Overview==
 +
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.
  
2.Click Map>Background Image>data on the menu, then click Add Image on the pop-up window, set the each value as below.
+
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.
  
3.Right click on the scatter plot then click Annotate>Point to create the annotation, then drag the point to each arrow of location to get the Xcoord and Ycoord of each location and fill the table.
+
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?
  
4.Import the dataset Boonsong Lekagul waterways readings.csv and location.xlsx and select Left join, set the join clause to Location=Loaction1.
+
Your task is to investigate the hydrology data from across the Preserve. You are given a map of the Preserve (with the same base as last year’s challenge), with named sampling sites indicated on the map (the names have local significance, but are just mnemonics for your study) You are also provided with readings from each sampling station over time for several different chemicals and water properties.
  
5.Create a new worksheet and drag the Sample Date to Column and set the Day then drag another Sample Date to Rows and set to year and drag the third Sample Date to Rows and set to Month and drag the Number of Records to Text. Drag the Sample date to Filter and select only 2015 and 2016 to see the data roughly. From this table, I find the many missing data on Sample Date, so it is better for me to visualize the data by month/year.
+
==Question==
  
6.Because different chemicals have different value scale, I use percentile chart to visualize the data. Drag the Measure and Value into Rows, click the triangle on value and click Measure>Average and Quick Table Calculation>Percentile. Drag the Sample Date to Column, click triangle on Sample Date and click the second Month. From the chart below, I find there are many missing values, so I need to figure out which chemical I should focus on based on the completeness.
+
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.
  
 +
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.
  
When adding the location into the percentile chart, I find Achara, Decha and Taneness only have the data from 2009, but I find there is no explicit difference during 2008-2009.
+
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.
 
 
 
 
7.To filter the data, I create a calculation field named Num of Year to get how many year of sample date each chemical contains.
 

Latest revision as of 01:23, 9 July 2018

Vast Chanllenge 2018 MC2
Like a duck to water

Data Preparation Visualization Design Answer Application Assignments


Overview

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?

Your task is to investigate the hydrology data from across the Preserve. You are given a map of the Preserve (with the same base as last year’s challenge), with named sampling sites indicated on the map (the names have local significance, but are just mnemonics for your study) You are also provided with readings from each sampling station over time for several different chemicals and water properties.

Question

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.

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.