fusiontables

Google Fusion Tables

Google Fusion Tables (shortened as Fusion Tables) is a web app developed by Google in 2009. It's a tool for data management, visualization and sharing. Fusion Tables has two interfaces:

The Graphic Interface for Web Users
The API for Programmers

For Web Users:

You can have a basic ideas about Fusion Tables Here: Help Page for Fusion Tables.

Basically, Fusion Tables allows you to:

Find public data
Import your own data(CSV, KML, ODS, XLS, or Google Spreadsheets)
Manage your data
Visualize your data
Merge two tables
Share your data

To Find Public Data, go to Fusion Tables Public Data. Example: Starbucks Locations

Creating A Fusion Table

Log in your google account(Better NOT be your A&M account).
Open your Google Drive.
In the sidebar on the left, click on "New->More->Connect More Apps"
Search for Fusion Tables, click on "Connect"
Now, again in the left sidebar, click on "New->More->Google Fusion Tables(A green icon with a white zigzagging line through it)"
Choose one of the three options to create a new table.

Critical Concepts about a Fusion Table:

Table ID(Unique ID number of a table)

On the top bar of a table, click on "file->about this table"
The last entry is the table ID.

Access Control

Click on "file->share"
By default, a table is private at first-only the creator can access this table. To invite more editors, Type in the names or email addresses to be invited.
To change the access settings, below "Who can access", click on "change...".

Table Management

Edit Columns and Rows
Add a new visualization style
Merge two tables or Create a View(A subset of a table)

For Programmers:

It takes several steps to create a project, and interact with Fusion Tables in Java.

Acquiring and using a client ID

Every request your application sends to the Fusion Tables API needs to identify your application to Google.

If the request requires authorization (such as a request for an individual's private data), then the application must provide an OAuth 2.0 token with the request.

If the request doesn't require authorization (such as a request for public data), then the application must provide either the API key or an OAuth 2.0 token, or both—whatever option is most convenient for you.

So, OAuth 2.0 token works in both cases. Let's use the token!

To get an OAuth 2.0 token(https://developers.google.com/fusiontables/docs/v2/using#auth):

Login your Google Account(Better NOT be your A&M account).
Go to the Google Developers Console.
In the top bar, Click on "Select a project". Then, in the dropdown menu, click on "Create a project...". Type in the project name, and create a project.
Now, in the dashboard, click on the section "Use Google APIs". Then, in the left sidebar, choose "Overview". Then, search for "Fusion Tables". Select the only result, and click on "Enable API".
In the left sidebar, choose "Credentials". Then, in the menu on the top, choose "OAuth consent screen". Type in your email address and the name of the project. Scroll down to the bottom and click on "Save".
Now, in the top menu, choose "Credentials". Click on "New Credentials". In the dropdown menu, choose "OAuth Client ID".
What to do next depends on the application type:

For a Java App: Choose the type "Other", and type in a name for the project. Click on "Create".
For an Android App: There is an additional step: Getting your package name and SHA-1 fingerprint.

https://developers.google.com/fusiontables/docs/v2/using#installed-applications

https://support.google.com/cloud/answer/6158849?hl=en#android