ISSS608 2017-18 Mini Challenge 2 - Kaushik Jaganathan
Data description & preparation
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)
ii. value (numeric)
iii. location (string)
iv. sample date (string)
v. measure (string)
|
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)
ii. unit (string)
|
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
- 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.
|
|
Annote Point
- 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.
|
|