IS428 AY2019-20T1 Assign Jessica Yuen Chui Shan

From Visual Analytics for Business Intelligence
Revision as of 17:49, 6 October 2019 by Csyuen.2016 (talk | contribs)
Jump to navigation Jump to search

To be a Visual Detective - VAST Challenge 2019: Mini-Challenge 2

Overview Assignment Details

One of St. Himark’s largest employers is the Always Safe nuclear power plant. The pride of the city, it produces power for St. Himark’s needs and exports the excess to the mainland providing a steady revenue stream. However, the plant was not compliant with international standards when it was constructed and is now aging. As part of its outreach to the broader community, Always Safe agreed to provide funding for a set of carefully calibrated professional radiation monitors at fixed locations throughout the city. Additionally, a group of citizen scientists led by the members of the Himark Science Society started an education initiative to build and deploy lower cost homemade sensors, which people can attach to their cars. The sensors upload data to the web by connecting through the user’s cell phone. The goal of the project was to engage the community and demonstrate that the nuclear plant’s operations were not significantly changing the region’s natural background levels of radiation. When an earthquake strikes St. Himark, the nuclear power plant suffers damage resulting in a leak of radioactive contamination. Further, a coolant leak sprayed employees’ cars and contaminated them at varying levels. Now, the city’s government and emergency management officials are trying to understand if there is a risk to the public while also responding to other emerging crises related to the earthquake as well as satisfying the public’s concern over radiation. Note: reviewing the city description document may be helpful to understanding the landscape and character of the city.

Problem, Motivation, Objectives

Dataset Import Structure & Process Tasks Instruction & Interactive Visualization Your task, as supported by visual analytics that you apply, is to help St. Himark’s emergency management team combine data from the government-operated stationary monitors with data from citizen-operated mobile sensors to help them better understand conditions in the city and identify likely locations that will require further monitoring, cleanup, or even evacuation. Will data from citizen scientists clarify the situation or make it more uncertain? Use visual analytics to develop responses to the questions below. Novel visualizations of uncertainty are especially interesting for this mini-challenge.

Task 1: Visualize radiation measurements over time from both static and mobile sensors to identify areas where radiation over background is detected. Characterize changes over time.
Limit your response to 6 images and 500 words.

Task 2: Use visual analytics to represent and analyze uncertainty in the measurement of radiation across the city.
a. Compare uncertainty of the static sensors to the mobile sensors. What anomalies can you see? Are there sensors that are too uncertain to trust?
b. Which regions of the city have greater uncertainty of radiation measurement? Use visual analytics to explain your rationale.
c. What effects do you see in the sensor readings after the earthquake and other major events? What effect do these events have on uncertainty?
Limit your responses to 12 images and 1000 words.

Task 3: Given the uncertainty you observed in question 2, are the radiation measurements reliable enough to locate areas of concern?
a. Highlight potential locations of contamination, including the locations of contaminated cars. Should St. Himark officials be worried about contaminated cars moving around the city?
b. Estimate how many cars may have been contaminated when coolant leaked from the Always Safe plant. Use visual analysis of radiation measurements to determine if any have left the area.
c. Indicated where you would deploy more sensors to improve radiation monitoring in the city. Would you recommend more static sensors or more mobile sensors or both? Use your visualization of radiation measurement uncertainty to justify your recommendation.
Limit your responses to 12 images and 1000 words

Task 4: Summarize the state of radiation measurements at the end of the available period. Use your novel visualizations and analysis approaches to suggest a course of action for the city. Use visual analytics to compare the static sensor network to the mobile sensor network. What are the strengths and weaknesses of each approach? How do they support each other?
Limit your response to 6 images and 800 words.

Task 5: The data for this challenge can be analyzed either as a static collection or as a dynamic stream of data, as it would occur in a real emergency. Describe how you analyzed the data - as a static collection or a stream. How do you think this choice affected your analysis? Limit your response to 200 words and 3 images.

Data Preparation

In the zipped folder, we were given 3 raw datasets namely:
1) MobileSensorReadings.csv - contains mobile sensor readings from various user IDs from 6 April 2020 0000 to 10 April 2020 2359 and its coordinates (longitude & latitude)
2) StaticSensorLocations.csv - contains sensor readings of 9 different sensor IDs with the coordinates (longitude & latitude)
3) StaticSensorReadings.csv - contains static sensor readings from various user IDs from 6 April 2020 0000 to 10 April 2020 2359 and its coordinates (longitude & latitude)

Removing Redundant Data In both MobileSensorReadings.csv and StaticSensorReadings.csv, there is a column named "Units" that were not used in the data pre-processing. Hence, I decided to remove it when I was importing the csv files into Tableau. To do so,

    1. Add StaticSensorReadings.csv into the Panel.

1.png

    2. Right click on the column "Units" and click "Hide" for both StaticSensorReadings.csv and MobileSensorReadings.csv
      500px Merging StaticSensorReadings.csv and StaticSensorLocations.csv To make the data more accurate and meaningful, I decided to merge StaticSensorReadings.csv with StaticSensorLocations.csv.
      500px I would then save the data from StaticSensorReadings and StaticSensorLocations in a new CSV file. I have named it as SensorReadings.csv
      Merging SensorReadings.csv and MobileSensorReadings.csv Similar to the StaticSensor CSV files, I decided to merge SensorREadings.csv with MobileSensorReadings.csv.
      Bear in mind that we need to remove "Units" column in MobileSensorReadings.csv too
      Changing the Timestamp to 1 minute intervals Currently, the data is set to 5 sec interval, however, I decided to change to 1 minute interval instead.
      500px Click on "Create Calculated Field" and key in the formula: DATETIME(INT([Timestamp]) + (INT(FLOAT([Timestamp]) % 1 * (60*24)) / (60*24)))

      Interactive Visualization

      Objectives

      References

      Comments

      Feel free to comment!