Difference between revisions of "ISSS608 2018-19 T3 Assign PARAM GADHAIYA MethodologynDataprep"
Paramg.2017 (talk | contribs) |
Paramg.2017 (talk | contribs) |
||
| Line 59: | Line 59: | ||
= Creating the Geolocation dataset: = | = Creating the Geolocation dataset: = | ||
<font size = 3;font-family: Arial> To find the X and the Y coordinates of every dumping ground in Boonsong Lekagul Waterways, the following steps were taken: </font> | <font size = 3;font-family: Arial> To find the X and the Y coordinates of every dumping ground in Boonsong Lekagul Waterways, the following steps were taken: </font> | ||
| − | 1. Load the Boonsong Lekagul Waterways excel file onto Tableau. Under the maps options, select background images. Select add an image and input the name, file and X and Y field as shown below. | + | <font size = 3;font-family: Arial> <br> 1. Load the Boonsong Lekagul Waterways excel file onto Tableau. Under the maps options, select background images. |
| − | [[Image:1(2).png.png| | + | Select add an image and input the name, file and X and Y field as shown below. |
| + | |||
| + | [[Image:1(2).png|350px]] | ||
| + | <br> 2. Based on the scale of the map, Select the exact point and click on annotate to insert and obtain the X and Y coordinates. Input the coordinates obtained on to a new excel file. The excel sheet now has the following values: | ||
| + | <br> [[Image:2(2).png|350px]] | ||
| + | <br> 3. Save the data sheet and left join the new data set to the existing dataset. | ||
| + | <br> [[Image:3(2).png|350px]] | ||
Revision as of 02:22, 11 July 2018
VAST MINI CHALLENGE 2: Like a Duck to Water
|
|
|
|
|
The following datasets were used for creating the visualizations:
|
Datasets |
Description |
|
Boonsong Lekagul Waterways Readings |
The .xlsx file contains details about the sample id, location from where the sample is taken, date when the sample is taken, type of measure and value of measure. |
|
Chemical Units of Measure |
The .xlsx file contains the name of the measure and the unit of measurement |
|
Map of Waterways |
The .jpg file contains the map which comprises of the several dumping grounds in Boonsong Lekagul waterways |
Creating the Geolocation dataset:
To find the X and the Y coordinates of every dumping ground in Boonsong Lekagul Waterways, the following steps were taken:
1. Load the Boonsong Lekagul Waterways excel file onto Tableau. Under the maps options, select background images.
Select add an image and input the name, file and X and Y field as shown below.
.png)
2. Based on the scale of the map, Select the exact point and click on annotate to insert and obtain the X and Y coordinates. Input the coordinates obtained on to a new excel file. The excel sheet now has the following values:
.png)
3. Save the data sheet and left join the new data set to the existing dataset.
.png)
