IS428 AY2019-20T1 Assign Kelvin Chia Sen Wei

Problem & Motivation

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 change over time? Describe the key changes you see. Limit your response to 500 words and 8 images.

Dataset Analysis & Transformation Process

Some of the data given have to be processed to provide an accurate display of information and analysis.

Data Manipulation for given dataset: mc1-reports-data.csv

Pivoting for damage categories

Issue: The different categories of damage can be aggregated to give a more concise dataset and to be displayed as filters.

Solution: The categories: Medical, Power, Road_And_Bridges, Sewer_And_Water and buildings can be pivoted so that the categories can be filtered on Tableau's Dashboard.

The mentioned categories are pivoted using Tableau Prep Builder and transformed into "Area" for the category and "Area Damage" for the values.

Binning of Shake Intensity:

Issue: As mentioned in the provided data, the shake intensity are categorised as above and we have to align the data as such.

Solution: Through Tableau Prep Builder, we can create a calculation to bin each numerals to their respective categories.

Below is a screenshot of the calculation statement:

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

Data Manipulation for given dataset: StHimarkNeighborhoodShapefile/StHimark.shp

In order to overlay the different areas of the neighborhood to display its area outline, I used the shp file that was given in MC2 Challenge.

Issue: However after inserting the background overlay from MC2, the polygons transformed into the centroid points.

Solution: After much research, I found out that the cause is due to "Tableau just drops each Geometry at the centroid (where the generated lat/lon points would be rendered if you were using a point map instead of a filled map). Since there isn't anything that specifies to Tableau how the polygons rendered by the Geometry are to be scaled they seem to just be defaulting to a small size." Hence, I have to carry out the steps as mentioned in the guide to transform the SHP File to Polygon Coordinates.

1. Refer to VA Discussion Forum for guide/steps to implement.
2. Online Link explaining the transformation process: https://community.tableau.com/thread/116369
3. After the transformation into polygon coordinates, StHimark_Features.csv and StHimark_Points.csv are generated and then imported and displayed as such:

Dataset Import Structure & Process

With the dataset analysis and transformation phase completed, the following files will have to be imported into Tableau for analysis:

1. Prepped Data from Tableau Prep Builder
2. StHimark_Points and StHiMark_Features from polygon transformation
3. BuildingLatLong (Contains Hospitals and Nuclear Plant Lat Long)

The following relations are formed within the data files:

Interactive Visualization

The interactive visualization can be accessed here: TABLEAU LINK

Throughout all the different dashboards, useful guides/tips are provided to help users navigate through the different filters and actions so that their analysis can be performed smoothly. The following interactivity elements are also used throughout all the dashboards to maintain consistency:

Interactive Technique	Rationale	Brief Implementation Steps
Selecting the day of earthquake	To allow analyst to pick the day where they are interested in to analyse.	Add "Time" to the filtered tab. Filter by the day of Time.
Selecting the area of damage	This filter can be used when analyst wants to see the area of damage of their interest.	Add "Area of Damage" to the filtered tab. Pick the areas that you want to be visible.
Iterating through the time series	Analyst can view the time series by pressing play and visualise the average area damage to each of the neighborhoods.	Add two "Time" fields to the Pages Tab Filter one by "Hour" and one by "Minute"

The following sections elaborates on other interactivity techniques are integrated into each of the individual dashboard.

Home Dashboard

The following shows the Home Dashboard:

The following interactive technique have been employed in this dashboard:

Interactive Technique	Rationale	Example
Interactive Buttons	Navigation across different dashboards with just a click of a button.

Earthquake Damage Dashboard

The following shows the Earthquake Damage Dashboard:

The following interactive visualisations have been employed in this dashboard:

Interactive Visualisations	Rationale	Example
Displaying of Choropleth Map to depict severity of earthquake damage	Accompanied by the neighborhood names, analyst can clearly see the heavily affected neighborhood at a specific time period to carry out rescue works. With the highly customisable configurations, analyst can also view the different areas of damage (e.g. buildings, medicals).
Overview of the frequency of earthquake on a selected day	By providing a consolidated and macro view of the frequency of earthquakes, rescuers can better gauge the resources needed along with the cloropleth visualisation. For example, at one glance, responders will be able to see a high spike in the amount of reports on the main earthquake day.

Data Uncertainty Dashboard

The following shows the Data Uncertainty Dashboard:

The following interactive visualisation have been employed in this dashboard:

Interactive Visualisation	Rationale	Example
Report Frequency Gantt Chart	With the use of the gantt bar to depict the frequency of reports for a selected day, analyst can discover intervals with irregular amounts of reports. The list of neighborhoods have also been sorted in descending order according to the proximity of the earthquake epicentre. These can help analyst in detecting patterns and find out the level of uncertainty of the report data.
Comparison between actual and reported readings	In order to verify the accurateness of data provided by the reports, it was compared to the actual readings given by the government. This can provide the analyst with an overview on the level of uncertainty of the report data.

Observations

Q1: 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.

Index	Analysis	Evidence
1	Located close to the centre point of the quake, Old Town #3 and Safe Town #4 were hit the hardest. Old Town #3 received large numbers of reports with high values immediately after the first quake on all categories of reports. With the large numbers of reports and high intensity of damage, responders should consider rescuing this area first.
2	Row
3	Row	Row Row
4	Row
5	The reports from Wilson Forest #7 were the least because, perhaps, there were only few reports as it is a lightly populated area.

Q2: 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.

Index	Analysis	Evidence
1	When the first major quake struck the city on 8th April, the reports were consistent with the shake map, where the north-eastern neighbourhoods felt the shake more strongly than the western neighbourhoods.
2	However, when compared to the prequake shake map on 6th April, the reports were not consistent with the shake map, where Old Town reported a weak shake.
3	Illustrates that there are two periods of data missing from Old Town #3 after both quakes, perhaps due to the ongoing work on the electricity system (Fig 1.4). However, the durations were significantly longer than expected. The responders should investigate the situation further by getting results from other sources.	Row Row
4	Visualisation shows that there were many hours of missing data in various neighbourhoods. The data were also missing for a considerable amount of time in neighbourhoods #7 - #10 without known ongoing works. It should be noted that, after any period of missing data, we will see accumulated reports get recorded once, as in **Fig 1.6**. Hence, this information is of the past.	Row Row
5	We can also find neighbourhoods with missing data on Map. For example, in Fig 1.7, Scenic Vista #8 and Broadview #9 had high building damage, but the data were over 1 hour old. Interestingly, East Parton #18 had fresh data with a higher value than its surroundings. The additional information (Fig 1.8) suggests that it has masonry facades, which might be damaged.	Row Row
6	Row	Row

Q3: 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.

Index	Analysis	Evidence
1	Row	Row
2	Row	Row Row
3	Row	Row Row
4	Row	Row Row
5	Row	Row Row

References

Great thanks to the below references to aid in the creation of the visualisations.
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!