Difference between revisions of "IS428 AY2019-20T1 Assign Hsu En Yang"
Line 49: | Line 49: | ||
<p>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, | <p>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, | ||
− | + | # '''Refer to VA Discussion Forum for guide/steps to implement.''' ''(shoutout to Kelvin Chia for sharing this tedious process!)'' | |
− | # '''Refer to VA Discussion Forum for guide/steps to implement.''' | ||
− | |||
# After the transformation into polygon coordinates, ''StHimark_Features.csv and StHimark_Points.csv'' and will be used during the analysis later. | # After the transformation into polygon coordinates, ''StHimark_Features.csv and StHimark_Points.csv'' and will be used during the analysis later. | ||
<br/> | <br/> |
Revision as of 19:19, 13 October 2019
Contents
MC1: 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 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,
- Refer to VA Discussion Forum for guide/steps to implement. (shoutout to Kelvin Chia for sharing this tedious process!)
- After the transformation into polygon coordinates, StHimark_Features.csv and StHimark_Points.csv and will be used during the analysis later.
Dataset Import Structure & Process
With the dataset analysis and transformation phase completed, the following files will have to be imported into Tableau for analysis:
- Prepped Data from Tableau Prep Builder
- StHimark_Points and StHiMark_Features from polygon transformation
- BuildingLatLong (Contains Hospitals and Nuclear Plant Lat Long)
The following relations are formed within the data files:
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!