ex2

Spatial Geo Mapping Assignment

Importance of Spatial Data?

Spatial data is one of the most demand data types. Because spatial data can help us;

· make a better understanding of the answer of Where?

· determine relationships

· identify patterns

· make prediction

Maps are certainly a great way to display spatial data. Nowadays, you don’t need any GIS Software for creating maps and publishing them. BI Tools are now capable of creating a thematic map.

There are lots of Business Intelligence Tools that help you create powerful and effective graphs, dashboard, visualisations such as Tableau, Qlik Sence, Power BI, Looker, Microstrategy etc.

In this assignment, you are going to create an interactive dashboard with Tableau Desktop step by step.

· LondonBoroughs: GeoJSON file of neighbourhoods of the city acquired from Inside Airbnb

· LondonBoroughProfile: CSV file of London Borough Profiles that acquired from Greater London Authority

Step 1: Install Tableau Desktop and Create Profile

Tableau Desktop is software that can allow anyone to connect to a spreadsheet or file and create interactive data visualizations for the web. You can download Tableau Desktop for windows and Mac using this link.

Step 2: Connect Your File to Tableau Desktop

When you open Tableau Desktop Application, you can see the “Connect” area at the upper left.

To connect your spatial file (LondonBorough.GeoJson) select Spatial File, browse your file and open. When you open your spatial file connection screen appears shown below. Your file must include Geometry column in MultiPolygon type.

To add your tabular data (LondonBoroughProfile.csv) click Add button at the Connections area and then select “Text file”.

Browse your LondonBoroughProfile.csv file and Click Open. Now you have 2 connections and 2 files one is Spatial file and other is “Text file”.

If you want to preview your tabular data, you can click the “View Data” button and preview your data.

To create a relation of your two files, select LondonBoroughProfile.csv file, drag and drop to relation area.

Now you have to select a common column (borough name) of two files. The name of the column at LondonBoroughs.geojson is “Neighbourhood” and the name of the column at LondonBoroughProfile.csv is “Borough Name”

After creating the relationship between your files, you can see connections as shown below.

Step 3: Creating a Map Sheet

To create map visualizes, click Sheet 1 that places lower left.

Now you have two tables and tens of attributes which shown different icon based their types (string, number, date, geographic role etc.)

Set up your map by adding Latitude (generated) to Columns and Longitude (generated) to Rows.

To create a London Borough Map, select Geometry column that places under LondonBoroughs.geojson, drag and drop Sheet1 area.

Now you have a basic map of London Boroughs. You need to configure your map with some appearance features such as label, colour, tooltip etc.

To create a label: Select Neighbourhood, drag and drop to Label

(Full-Screen Snapshot Required)

To create a thematic map: Select one feature (under LondonBoroughProfile.csv) that you want to see as a thematic map, drag and drop to Colour area. In this tutorial, I selected “Employment rate (%) – (2015)”

(Full-Screen Snapshot Required)

Now you have a thematic map based on Employment rate. You can configure appearance features by changing colours, labels etc. You can add Filter, Legend, Title etc to get a more understandable map.

To add new features as a Tooltip: Tooltip provides us with additional information about attributes. So you can add more attributes that user can interact when cursor moving over the map. Select one or more attributes, drag and drop to Tooltip area. In this tutorial I selected “Crime rates per thousand population 2014/2015”, “Life Satisfaction score 2011-2014 (out of 10)” and “Number of Cars, (2011 Census)” attributes and renamed shown below;

· Crime Rate

· Life Satisfaction

· Number of Cars

(Full-Screen Snapshot Required)