This post will demonstrate loading data from our google fusion tables to create a vector layer on a web map using the google map api.
First we should have an active google account to be able to practice along. In addition, our google drive should have the app-Google Fusion tables installed in it. Web search ‘Installing google fusion tables in my google drive account’ to get a quick hands-on idea on how to install and use google fusion tables from your google drive.
Download sample data here:https://www.google.com/fusiontables/DataSource?docid=1xQnOYFbBSvgcWQofpi46tVLoAoRI8d_eo_PjXTMt
1. Let us start by opening our sample data using Google Fusion tables. Note that our file is in Xls format. Fusion tables open files in Xls,CSV, Text and KML formats. Note that you must make your file available to the public. Use the ‘Share’ option to set your data to ‘Public’. It is only then that the file will render as a layer on the web map.
Our sample table contains a collection of points which have two fields- longitude and latitude defining their geographic coordinates. Copy out the highlighted code as shown in the red boxed area on the screenshot below. Fusion tables allows us to define the location of the points uisng either latitude or longitude field, we choose latitude.
3. Here is the map generated from the code:
Click on this link to see a live map from my github account:http://htmlpreview.github.io/?https://github.com/mayotunde/google/blob/master/fusionlayer
or Download the plain text file version of the source code here:https://www.dropbox.com/s/eh6mced9mnif05o/loading%20layers%20from%20google%20fusion%20table.txt?dl=0
Thank you for following the blog