Difference between revisions of "IS428 AY2019-20T1 Assign Li Xiaohang"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<font size="5">'''Mini-Challenge 1: Crowdsourcing for Situational Awareness'''</font>
 
<font size="5">'''Mini-Challenge 1: Crowdsourcing for Situational Awareness'''</font>
 +
<!--MAIN HEADER -->
 +
{|style="background-color:#1B338F;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 +
| style="font-family:Century Gothic; font-size:100%; solid #000000; background:#2B3856; text-align:center;" width="25%" |
 +
;
 +
[[IS428_AY2019-20T1_Assign_Li_Xiaohang| <font color="#FFFFFF">Challenge Overview</font>]]
  
=Overview=
+
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="25%" |
 +
;
 +
[[Data_Page| <font color="#FFFFFF">Data</font>]]
  
St. Himark is a vibrant community located in the Oceanus Sea. Home to the world-renowned St. Himark Museum, beautiful beaches, and the Wilson Forest Nature Preserve, St. Himark is one of the region’s best cities for raising a family and provides employment across a number of industries including the Always Safe Nuclear Power Plant. Well, all that was true before the disastrous earthquake that hits the area during the course of this year’s challenge. Mayor Jordan, city officials, and emergency services are overwhelmed and are desperate for assistance in understanding the true situation on the ground and how best to deploy the limited resources available to this relatively small community.
+
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="25%" |
 
+
;
=The Challenge=
+
[[Interactive_Visualization_and_Reference| <font color="#FFFFFF">Interactive Visualization & Reference</font>]]
In a prescient move, the city of St. Himark released a new damage reporting mobile application shortly before the earthquake. This app allows citizens to provide more timely information to the city to help them understand damage and prioritize their response. In this mini-challenge, use app responses in conjunction with shake maps of the earthquake strength to identify areas of concern and advise emergency planners.
 
 
 
=Introducation of the Data=
 
The dataset countains two parts, image data and text data: <br>
 
'''Image data: '''<br>
 
#Pre-quake Shake Map
 
#Major-quake Shake Map
 
#St. Himark City Map by Location
 
 
 
'''Text data:''' <br>
 
Report data: The dataset contains individual reports of shaking/damage by neighborhood over time, from 6th April to 11th April.
 
 
 
=Pre-Analysis Data Processing=
 
1. The timestamp given in the dataset is in 'YYYY-MM-DD hh:mm:ss' format. For easy aggregation, a new column 'Date' is created. <br>
 
[[File:Date creation.png|600px|center]]
 
  
2. The 'Location' column is identified as a measure when imported to Tableau. It is configured to a dimension for visualization purposes later. <br>
+
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="25%" |
[[File:Location-conversion.png|400px|center]]
+
;
 +
[[Tasks_and_Comments| <font color="#FFFFFF">Tasks and Comments</font>]]
  
=Task and Visualization=
+
| &nbsp;
 
 
'''The interactive visualization can be accessed at:''' <br> https://public.tableau.com/profile/li.xiaohang#!/vizhome/IS428Assignment-LiXiaohang/Dashboard0?publish=yes
 
 
 
==Task 1==
 
'''Emergency responders will base their initial response on the earthquake shake map. Use visual analytics to determine how their response should change based on damage reports from citizens on the ground. How would you prioritize neighborhoods for response? Which parts of the city are hardest hit? Limit your response to 1000 words and 10 images.''' <br>
 
<br>
 
 
 
{| class="wikitable"
 
|-
 
! Visualization #1 || Earthquake Shake Map with Location
 
|-
 
| Visualization ||
 
[[File:Shake-map 1.png|400px|left]] 
 
[[File:Shake map 2.png|400px|right]]
 
|-
 
| Insight || Based on the pre-quake shake map and major quake shake map, the emergency responders will start with location 3 and location 4, as they are the first two areas affected by the earthquake. Area 2, 14, 18, 13, 12, 11 and 7 are affected during major quake subsequently. The level of damage is not clear and needs to be investigated with the damage reports from citizens. <br>
 
Additionally, there are three bridges fall into the area of the earthquake: the Jade Bridge, the 12th of July Bridge, the Himark Bridge.
 
 
|}
 
|}
<br>
 
  
{| class="wikitable"
+
=Background Introducation=
|-
 
! Visualization #2 || Comparison of the Neighborhood Report with Shake Maps
 
|-
 
| Visualization ||
 
[[File:Report April 6th.png|450px|left]]
 
[[File:Report April 8th.png|450px|right]]
 
As the pre-quake shake map and the major quake shake map are generated on 6th and 8th April, a comparison should be done between the shake maps and the neighborhood report on the same two days. To get a general overview, the number of records for each location is plotted against the average shake intensity reported.
 
|-
 
| Insight ||
 
From the first visualization, it is shown that on 6th April, the average shake intensity reported is very high for location 4, and relatively high for location 3, 7 and 12. This aligns with the pre-shake map. <br>
 
From the second visualization, it is shown that on 8th April, the average shake intensity reported is high for more locations. In general, it aligns with the major-shake report, with one exception: location 2 is an affected area from the major shake report, but the reported average intensity is not very high.<br>
 
The total number of report for location 8 remains the highest for both days, although it is not a major affected area. This might due to the high concentration of residency of the city's elite and powerful.
 
|}
 
<br>
 
  
{| class="wikitable"
+
St. Himark is a vibrant community located in the Oceanus Sea. Home to the world-renowned St. Himark Museum, beautiful beaches, and the Wilson Forest Nature Preserve, St. Himark is one of the region’s best cities for raising a family and provides employment across a number of industries including the Always Safe Nuclear Power Plant. Well, all that was true before the disastrous earthquake that hits the area during the course of this year’s challenge. Mayor Jordan, city officials, and emergency services are overwhelmed and are desperate for assistance in understanding the true situation on the ground and how best to deploy the limited resources available to this relatively small community.
|-
 
! Visualization #3 || General Overview of the Neighbourhood Report
 
|-
 
| Visualization ||
 
[[File:Report April.png|600px|center]]
 
|-
 
| Insight || From the time series visualization, it is observed that location 3 -- the old town, was hit the hardest. Safe town(location 4), Wilson Forest(location 7) and Pepper Mill(location 12) should be investigated for resource allocation priority.
 
|}
 
<br>
 
  
{| class="wikitable"
+
=The Challenge=
|-
+
In a prescient move, the city of St. Himark released a new damage reporting mobile application shortly before the earthquake. This app allows citizens to provide more timely information to the city to help them understand damage and prioritize their response. In this mini-challenge, use app responses in conjunction with shake maps of the earthquake strength to identify areas of concern and advise emergency planners.
! Visualization #4 || Detailed Damage Investigation for Target Locations
 
|-
 
| Visualization ||
 
[[File:Daily Damage Report.png|900px|center]]
 
|-
 
| Insight || By Comparing the four locations, it is observed that the Old Town is hit the hardest for all facilities. <br>
 
For Safe Town, there is constant high rating damage report throughout the whole period for all facilities; <br>
 
For Wilson forest, the data points are fewer and the reported damage has relatively lower ratings. Spcial attention is needed for the Road and Bridges as the Willson Forest Highway is located in that area; <br>
 
For Pepper Mill, the overall condition is similar to the safe town, with a higher median damage rating for Road and Bridges.
 
|}
 
<br>
 
 
 
With the above investigation, it is concluded that the highway condition at Wilson Forest needs to be examined first, as possible damage will delay the resources and rescue team to enter St.Himark. This is the first priority. <br>
 
The old town needs immediate action taken as there are a large community of people being affected by the earthquake, the reported damage rating is also the highest among all locations; <br>
 
Immediate but fewer resources should be allocated to the safe town and Pepper Mill, as the situation is less severer. <br>
 
However, as the Always Safe nuclear facility is located at the safe town, specialists should be sent there immediately to examine possible nuclear leakage -- This could cause potentially more damage. <br>
 
The Wilson Forest lacks data points as there are fewer citizens living in that area. Power and Road need to be fixed, but with lower priority. <br>
 
 
 
==Task 2==
 
'''Use visual analytics to show uncertainty in the data. Compare the reliability of neighborhood reports. Which neighborhoods are providing reliable reports? Provide a rationale for your response. Limit your response to 1000 words and 10 images.''' <br>
 
 
 
{| class="wikitable"
 
|-
 
! Visualization #1 || General Overview of Uncertainty
 
|-
 
| Visualization ||
 
[[File:Shake intensity comparison-1.png|800px|center]]
 
|-
 
| Insight || By computing the variance for shake intensity reported by each location, it is observed that the variance can be as high as 18.00. This shows the uncertainty present in the data, as in every minute, the data reported by citizens can vary by a large scale. It is also observed that with a higher volume of reports, the variance increases.
 
|}
 
<br>
 
 
 
{| class="wikitable"
 
|-
 
! Visualization #2 || Neighbourhoods with Reliable Reports
 
|-
 
| Visualization ||
 
[[File:Location 1.png|400px|frameless|left]]
 
[[File:Location 5.png|400px|frameless|right]]
 
[[File:Location 8.png|400px|frameless|center]]
 
|-
 
| Insight || After looking into the variance line chart for all locations, three locations are found with considerable amount of data, and relatively low variance. The locations are Palace Hills (Location 1), Southwest (Location 5) and Scenic Vista (Location 8).
 
|}
 
<br>
 
 
 
==Task 3==
 
'''How do conditions change over time? How does uncertainty in change over time? Describe the key changes you see. Limit your response to 500 words and 8 images.''' <br>
 
 
 
{| class="wikitable"
 
|-
 
! Visualization #1 || Condition Change Over Time
 
|-
 
| Visualization || [[File:Report April.png|600px|center]]
 
|-
 
| Insight || From the visualization, it is observed that there is a small pre-quake on 6th April, which hit the safe town the hardest. There is a stronger shock the next day. On 8th April, the major shock happens and all locations can feel the earthquake.
 
The conditions get better for the next three days, with an abnormal rise for the old town on 10th April. This indicates a possible aftershock for the old town on 10th April.
 
|}
 
<br>
 
 
 
{| class="wikitable"
 
|-
 
! Visualization #2 || Uncertainty Change Over Time
 
|-
 
| Visualization ||
 
[[File:Uncertainty-days.png|600px|center]]
 
|-
 
| Insight || The distribution for reported shake intensity for major affected locations are compared. From the visualization, it is observed that the uncertainty is the highest during and after the major shock, with a large distribution for reported shake intensity.
 
|}
 
<br>
 
 
 
=Visualisation Software=
 
Polarr Photo Editor <br>
 
Tableau Desktop <br>
 
Pages - docucment editor <br>
 
 
 
=References=
 
VAST Challenge 2019 - Mini-Challenge 1: https://vast-challenge.github.io/2019/MC1.html <br>
 
Tableau Community Forum: https://community.tableau.com/community/forums <br>
 
Use Tableau to Show Variance and Uncertainty: https://www.rittmanmead.com/blog/2017/06/using-tableau-to-show-variance-and-uncertainty/ <br>
 
Various Views of Variability: http://www.storytellingwithdata.com/blog/2019/2/21/various-views-of-variability
 
 
 
=Comments=
 
Please leave some comments for possible improvements!
 

Latest revision as of 21:21, 13 October 2019

Mini-Challenge 1: Crowdsourcing for Situational Awareness

Challenge Overview

Data

Interactive Visualization & Reference

Tasks and Comments

 

Background Introducation

St. Himark is a vibrant community located in the Oceanus Sea. Home to the world-renowned St. Himark Museum, beautiful beaches, and the Wilson Forest Nature Preserve, St. Himark is one of the region’s best cities for raising a family and provides employment across a number of industries including the Always Safe Nuclear Power Plant. Well, all that was true before the disastrous earthquake that hits the area during the course of this year’s challenge. Mayor Jordan, city officials, and emergency services are overwhelmed and are desperate for assistance in understanding the true situation on the ground and how best to deploy the limited resources available to this relatively small community.

The Challenge

In a prescient move, the city of St. Himark released a new damage reporting mobile application shortly before the earthquake. This app allows citizens to provide more timely information to the city to help them understand damage and prioritize their response. In this mini-challenge, use app responses in conjunction with shake maps of the earthquake strength to identify areas of concern and advise emergency planners.