ISSS608 2017-18 T3 Assign See Kwan Yen Data Preparation

Geo-coding of Map

1. Create a Location.csv with the following fields. location: location of the water sensor reading X: x coordinate of the location with respect to the waterways map Y: y coordinate of the location with respect to the waterways map

2. Derive the X and Y coordinates of the locations by loading the map into Tableau and annotating the points.

3. Update Location.csv with the derived coordinates

4. Import the Location.csv, Boonsong Lekagul waterways readings.csv, and chemical units of measure.csv files to Tableau, performing the join as follows:

- Join on equal location fields for Location.csv