IS428 AY2019-20T1 Assign Hsu En Yang

MC1: PROBLEM & TASK

St. Himark has been hit by an earthquake, leaving officials scrambling to determine the extent of the damage and dispatch limited resources to the areas in most need. They quickly receive seismic readings and use those for an initial deployment but realize they need more information to make sure they have a realistic understanding of the true conditions throughout the city. In a prescient move of community engagement, the city had 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.

With emergency services stretched thin, officials are relying on citizens to provide them with much needed information about the effects of the quake to help focus recovery efforts.

By combining seismic readings of the quake, responses from the app, and background knowledge of the city, help the city triage their efforts for rescue and recovery.

Tasks and Questions:

• 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.
• 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.
• How do conditions change over time? How does uncertainty in data change over time? Describe the key changes you see. Limit your response to 500 words and 8 images.

DATA TRANSFORMATION

Data transformation is necessary for deep-dive analysis and accurate presentation.

Tableau Prep Builder: Data Manipulation for dataset: mc1-reports-data.csv

Pivoting for damage categories

With the use of the pivot function, the different categories: medical, power, road_and_bridges, sewer_and_water and buildings can be aggregated. These categories are named as Areas and its corresponding column would be Damage Area.

Binning of Shake Intensity:

To align with the given shake intensity categories, we have to bin the raw data of shake intensity. To do so, we create a calculation to bin each numerals into the corresponding categories.

Binning of Event Dates:

To easily identify the day of event, we can bin the dates into pre-earthquake, earthquake and post-earthquake. This allow for easier analysis.

Final Output of Data Transformation:

Below is the generated CSV from Tableau Prep Builder after data manipulation:

External Help: Data Manipulation for given dataset: StHimarkNeighborhoodShapefile/StHimark.shp

The original SHP file given in MC2 could not be used as it defaults to an irregular size and therefore unreadable. In order to grow the map and get the polygon coordinates,

1. Refer to VA Discussion Forum for guide/steps to implement. (shoutout to Kelvin Chia for sharing this tedious process!)
2. After the transformation into polygon coordinates, StHimark_Features.csv and StHimark_Points.csv and will be used during the analysis later.

IMPORTING DATASET PROCESS

1. Import STHimark_Points and StHiMark_Features from polygon transformation -> dataset joined by intersect StHimark ID

2. Import prepped dataset from Tableau Prep Builder -> merged by intersect Location

INTERACTIVE VISUALISATION

Access dashboard here: input link

Technique	Reason
Neighbourhood selection:	To allow viewers to deep dive into respective neighbourhoods to further understand the situation
Example	Example
Example	Example
Example	Example

References

https://www.tableau.com/learn/tutorials/on-demand/getting-started-tableau-prep
https://wiki.smu.edu.sg/1617t1IS428g1/IS428_2016-17_Term1_Assign3_Gwendoline_Tan_Wan_Xin#Interactive_Visualization

Comments

Please input your comments here!