How To Import Data and Make Maps with Google Fusion Tables

Ad:

Loading Web Site Data into Google Docs

The data that is pulled from the external web sources (Table 1) to the Google docs is now loaded in Google Fusion tables (Classic view) for further analysis and to add the spatial component. As Fusion Tables allows the import of data from .ods or.xls format, Google spreadsheets and creating an empty table directly in the Fusion Tables as shown in below figure 1.

Figure 1. Fusion table Interface to import data.

Figure 1. Fusion table Interface to import data.

Once we upload our spreadsheet as above instructed, we have the below Menu option (figure 2) along with our Table name to proceed further. The below section will start from a very basic operations i.e. Visualizing our data in the form of tables, charts and maps, subsequent sections will brief on the Functionality in the FT.

Figure 2. Menu of Fusion Tables

Figure 2. Menu of Fusion Tables

Visualizing Data in Fusion Tables

Pictorial representations of any data especially the statistical data in the form of charts, tables and maps can make people quickly understand and helps to take apt decision for business making, research studies, policy making etc.

As shown above in the Visualize menu, it provides options to view our data in the form of tables, charts and Maps as below:


Ad:


Table:

All data tabular data along with column names in the spreadsheet are saved in the FT as shown in the Table 4 below. Like any other databases, FT allows to manipulate the schema (add/delete/modify) without any SQL statements. More on the use of the functionality of FT are explained in the next section. FT allows permitted users to comment on the each entity in the table, view the location on of each entity on maps. This facilities the users at different locations to discuss and plan collectively by the click of a mouse.

Table 4. Fusion Table imported from online spreadsheets.

Table 4. Fusion Table imported from online spreadsheets.

Charts:

The data that is visualized in the form of a table can be also visualized in the form of various types of charts. The figure below shows pie chart on based on the data Country and Arrivals column. This option is available in the same menu under the Visualize menu. Likewise one can avail the other options like the line, bar, scatter plot, timeline depending on the selected attributes and the analysis required. For example, if a study requires yearly, quarterly, monthly and daily data on an iterative intuitive chart Timeline option will be the best option.

Figure 3. Chart display of the Top tourism table.

Figure 3. Chart display of the Top tourism table.


Advertising:



Like this article and want more?

Enter your email to receive the weekly GIS Lounge newsletter:

Advertising