IS428 AY2019-20T1 Assign Sin Myeong Eun
|
|
|
Problem & Motivation
St Himark’s Always Safe nuclear power plant is a major power provider in St Himark, with approximately 72% of its power being supported by Always Safe. Due to the recent earthquake, the nuclear power plant has been damaged on a moderate level, thus resulting in a certain extent of contamination. Moreover, the employees who work for Always Safe unfortunately faced the issue of their cars being contaminated by coolant leak. Based on the data from citizen-operated mobile sensors and government-operated stationary sensors, a new visualisation platform is to be created for St. Himark’s emergency management team to gain deeper insight regarding the varying conditions across the city, as well as identify the regions that they would have to pay more attention to.
Data preparation
1. Merging StaticSensorReadings.csv & StaticSensorLocations.csv
The merging of the two csv files was the very first step that was taken, because StaticSensorReadings only show us the radiation value that each sensor was able to detect, without knowledge of where the sensor is located at. This step was done on tableau itself, by doing an innerjoin of the two files as shown in the figure below. The sensor IDs were used to match the rows in the files.
When the first step is done properly, tableau would show the output dataset as shown below: