Difference between revisions of "IS428 AY2019-20T1 Assign Sin Myeong Eun"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style=background:#3D5480 border:#A3BFB1>
+
<div style=background:#5c4d7d border:#A3BFB1>
 
[[Image:Nuclearpowerplant.jpg|165px]]
 
[[Image:Nuclearpowerplant.jpg|165px]]
 
<b><font size = 6; color="#FFFFFF">VAST Challenge'19 MC2:Citizen Science to the Rescue</font></b>
 
<b><font size = 6; color="#FFFFFF">VAST Challenge'19 MC2:Citizen Science to the Rescue</font></b>
 
</div>
 
</div>
<!--MAIN HEADER -->
 
  
 
+
{|style="background-color:#5c4d7d;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
{|style="background-color:#3D5480;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
+
| style="font-family:Century Gothic; font-size:100%; solid #000000; background:#9a8abf; text-align:center;" width="20%" |  
| style="font-family:Century Gothic; font-size:100%; solid #000000; background:#3D5480; text-align:center;" width="20%" |  
 
 
;
 
;
 
[[IS428_AY2019-20T1_Assign_Sin_Myeong_Eun| <font color="#FFFFFF">Overview & Data preparation</font>]]
 
[[IS428_AY2019-20T1_Assign_Sin_Myeong_Eun| <font color="#FFFFFF">Overview & Data preparation</font>]]
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#3D5480; text-align:center;" width="20%" |  
+
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#9a8abf; text-align:center;" width="20%" |  
 
;
 
;
 
[[IS428_AY2019-20T1_Assign__Sin_Myeong_Eun_Tasks| <font color="#FFFFFF">Tasks</font>]]
 
[[IS428_AY2019-20T1_Assign__Sin_Myeong_Eun_Tasks| <font color="#FFFFFF">Tasks</font>]]
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#3D5480; text-align:center;" width="20%" |
+
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#9a8abf; text-align:center;" width="20%" |
 
[[IS428_AY2019-20T1_Assign__Sin_Myeong_Eun_InteractiveVisualisation| <font color="#FFFFFF">Interactive Visualisation</font>]]
 
[[IS428_AY2019-20T1_Assign__Sin_Myeong_Eun_InteractiveVisualisation| <font color="#FFFFFF">Interactive Visualisation</font>]]
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#3D5480; text-align:center;" width="20%" |  
+
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#9a8abf; text-align:center;" width="20%" |  
 
;
 
;
 
[[IS428_AY2019-20T1_Assign__Sin_Myeong_Eun_References| <font color="#FFFFFF">References</font>]]
 
[[IS428_AY2019-20T1_Assign__Sin_Myeong_Eun_References| <font color="#FFFFFF">References</font>]]
Line 30: Line 28:
 
<br>
 
<br>
 
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.   
 
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.   
<p>[[File:Innerjoin .jpg||600px]]</p>
+
<p>[[File:Innerjoin .jpg||400px|center]]</p>
 +
<br>When the first step is done properly, tableau would show the output dataset as shown below:
 +
<br>[[File:InnerjoinPreview.jpg|400px|center]]
 
<br>
 
<br>
When the first step is done properly, tableau would show the output dataset as shown below:
+
'''2. Combining StHimark.shp & MobileSensorReadings.csv'''
<br>[[File:InnerjoinPreview.jpg|400px]]
+
<br>MobileSensorReadings.csv alone does not give us much insight as to how the mobile sensors are moving around St.Himark because their locations are only given to us as latitude and longitude fields. It would make more sense for us to study the radiation recordings with the locations of the neighbourhoods clearly shown in a map format. This was done by doing an innerjoin between Geometry of the shape file and MAKEPOINT([Lat],[Long]). The MAKEPOINT() function allows us to format the non-spatial attributes like latitude and longitude into a spatial attribute.
 +
<br>[[File:InnerjoinMobile.jpg|400px|center]]
 +
<br>When the second step has been done correctly, tableau will show the output dataset as shown below:  
 +
<br>[[File:InnerjoinMobilePreview.jpg|500px|center]]

Latest revision as of 18:33, 10 October 2019

Nuclearpowerplant.jpg VAST Challenge'19 MC2:Citizen Science to the Rescue

Overview & Data preparation

Tasks

Interactive Visualisation

References

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.

Innerjoin .jpg


When the first step is done properly, tableau would show the output dataset as shown below:


InnerjoinPreview.jpg


2. Combining StHimark.shp & MobileSensorReadings.csv
MobileSensorReadings.csv alone does not give us much insight as to how the mobile sensors are moving around St.Himark because their locations are only given to us as latitude and longitude fields. It would make more sense for us to study the radiation recordings with the locations of the neighbourhoods clearly shown in a map format. This was done by doing an innerjoin between Geometry of the shape file and MAKEPOINT([Lat],[Long]). The MAKEPOINT() function allows us to format the non-spatial attributes like latitude and longitude into a spatial attribute.


InnerjoinMobile.jpg


When the second step has been done correctly, tableau will show the output dataset as shown below:


InnerjoinMobilePreview.jpg