Difference between revisions of "ISSS608 2017-18 T3 Assign Kaushik Jaganathan - Methodology and Design"
Jump to navigation
Jump to search
Line 67: | Line 67: | ||
The Waterways Final is a map image that shows the location of dumping site and the waterways. | The Waterways Final is a map image that shows the location of dumping site and the waterways. | ||
<span style=text-align:center;">[[Image:Waterways Final.jpg|200px|thumb|left]]</span> | <span style=text-align:center;">[[Image:Waterways Final.jpg|200px|thumb|left]]</span> | ||
+ | |||
+ | |} | ||
+ | </div> | ||
+ | |||
+ | <div style="margin:0px; padding: 2px; font-family: Arial; border-radius: 1px; text-align:left"> | ||
+ | {| class="wikitable" style="background-color:#FFFFFF;" width="100%" | ||
+ | |- | ||
+ | |style="text-align:center"| | ||
+ | ; | ||
+ | <b>Steps</b> | ||
+ | |style="text-align:center"| | ||
+ | <b>Image</b> | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | <b>Adding Data and Background Image</b> | ||
+ | |||
+ | *Open Boonsong Lekagul waterways readings (.csv file) in Tableau, right click on Location Dimension, click on Geographic Role and select ZIP Code / Postcode. This will generate Latitude and Longitude in Measures. Add the generated fields to Columns and Rows respectively. | ||
+ | *Go to Map options and click on Background Images. In the dialogue box, browse the Waterways Final (.jpg file). In the X Field set Right value to 499 and in the Y Field set the Top value to 499. Go to options and select Always show entire image option and Apply. | ||
+ | |||
+ | || | ||
+ | <span style=text-align:center;">[[Image:Vaishnavi_1.png|300px|thumb|center]]</span> | ||
+ | |||
+ | |- | ||
+ | | | ||
+ | <b>Annote Point</b> | ||
+ | |||
+ | *Create a new excel file Locations, add a column named Location and manually enter the places. Add other two column named X and Y. | ||
+ | *Right click on the tip of the arrow on map, click on Annotate and select Point. | ||
+ | *In the dialog box, insert fields Latitude(generated) and Longitude(generated). | ||
+ | *Manually copy paste the annotated values in the Location.xlsx file, X and Y columns. | ||
+ | *Do this for all the locations. | ||
+ | |||
+ | || | ||
+ | |||
|} | |} | ||
</div> | </div> |
Revision as of 18:31, 7 July 2018
ISSS608 2017-18 Mini Challenge 2 - Kaushik Jaganathan
|
|
|
|
Data description
File Name |
Variables |
Boonsong Lekagul waterways readings (.csv file) |
The given data file has reading of 106 chemicals at 10 different locations from 1998 - 2016. i. id (numeric , unique)
|
chemical units of measure (.csv file) |
The given data file has the unit of each measure (106 measures) in which the readings were taken. i. measure (string, unique)
|
Waterways Final (.jpg file) |
The Waterways Final is a map image that shows the location of dumping site and the waterways. |
Steps |
Image |
Adding Data and Background Image
|
|
Annote Point
|
|