Upload File

fusion tables

13
Google Fusion Tables Philipz

Upload: philip-zheng

Post on 10-May-2015

822 views

Category:

Documents


6 download

Report

Tags:

DESCRIPTION

2012-11-05 Taiwan-useR-Group

TRANSCRIPT

Page 1: Fusion tables

Google Fusion Tables

Philipz

Page 2: Fusion tables

Philipz

Cobol, PL/I, Lotus notes, Java, Matlab......

[email protected]://server.everfine.com.tw/blog/

mailto:[email protected]
mailto:[email protected]
http://server.everfine.com.tw/blog/
http://server.everfine.com.tw/blog/
Page 3: Fusion tables

It's not GTUG.It is TURG.

Page 4: Fusion tables

WhyMyFunWoo by IndianaLocation, Location, LocationGoogle Map API v3Published on 2010-10Email, CalendarAuction House Data, History

http://www.funwoo.com/
http://www.funwoo.com/
https://developers.google.com/maps/documentation/javascript/reference?hl=zh-TW#FusionTablesLayer
https://developers.google.com/maps/documentation/javascript/reference?hl=zh-TW#FusionTablesLayer
https://mail.google.com/mail/?tab=mm
https://www.google.com/calendar?tab=mc
https://mail.google.com/mail/?tab=mm
https://www.google.com/fusiontables/DataSource?docid=18CSX6zg5zH_sUUc9iYZ4Z489G5SnVkblXZ6a_Q
https://www.google.com/fusiontables/DataSource?docid=1roVET4dVkYqUVKye3zf8_MsDKB9rfcg_BEttLA
https://www.google.com/fusiontables/DataSource?docid=18CSX6zg5zH_sUUc9iYZ4Z489G5SnVkblXZ6a_Q
Page 5: Fusion tables
http://m.everfine.com.tw/
Page 6: Fusion tables

Fusion Tables= Webify Excel + BigTable + Multi-view + Multi-player= Visible NoSQL Tables= Interactive Data warehouse

Page 7: Fusion tables

Applications● Tsunami in Japan, March 2011● Local newspapers, worldwide● Display invented maps Skyrim Data● Census 2010 Interactive Map● Stalled construction in NYC● Submarine Cable Map

http://www.google.com/intl/ja/crisisresponse/japanquake2011_traffic.html
http://www.google.com/intl/ja/crisisresponse/japanquake2011_traffic.html
http://newspapermap.com/
http://newspapermap.com/
http://tamrielma.ps/skyrim/
https://www.google.com/fusiontables/DataSource?dsrcid=2383577
http://tamrielma.ps/skyrim/
http://www.texastribune.org/library/data/census-2010/
http://www.texastribune.org/library/data/census-2010/
http://nycstalled.com/
http://nycstalled.com/
http://www.submarinecablemap.com/
http://www.submarinecablemap.com/
Page 8: Fusion tables

How works?

Page 9: Fusion tables

Data AnalysisNetwork GraphScatterLineMap + KML......

https://www.google.com/fusiontables/embedviz?viz=GVIZ&t=GRAPH&containerId=gviz_canvas&sdb=1&state=%7B%22ps%22%3A%221_0_-23_1v_1b_14_-48_q_34_5g_2x_24_5v_y_-1d_x_27_b_-50_1a_-39_-5t_34_-3y_-5c_2_-2x_2d_3_-8h_1g_46_-8p_w_a_-64_-45_1c_17_-3f_5z_-6k_-3p_n_-3p_6b_11_-3v_-69_2z_1u_-3r_8_6k_z_3c_1y_-4g_g_-2d_-63_12_3c_1m_5_2y_-2k_h_77_-3a_i_7f_-46_4t_-5d_-3d_20_l_-3b_1t_-1q_2v_2d_-4d_72_3e_-8u_-6c_2r_-2q_6t_s_-bc_-b_7_-16_2l_55_-9d_-5e_4f_4b_11_1x_1_-3k_d_-c4_-3d_l_8t_16_4j_9_-3a_9_79_21_28_-58_-l_f_-2j_-4k_z_-s_2f_u_-23_39_2c_-18_30_2f_j_-2v_6a_-1g_3f_c_-3h_x_1g_-ag_45_2e_4n_-2o_13_3p_d_4g_-cw_-1r_4q_2w_-3u_4d_6z_-4_2q_-5g_5i_22_-7_2d_7c_6g_-w_w_-7w_-52_10_-44_1n_4a_36_-4i_p_86_-t_1u_2m_-78_x_-21_67_m_88_2x_14_52_-1z_3n_-44_v_33_-cb_-2d_1n_-5g_6n_3v_-34_3z_3u_-1a_-72_5r_-a1_-28_1_-4c_2n_1e_-45_-2g_1h_-bq_3y_4w_-50_-1t_45_5f_29_2o_-83_3z_2u_6p_2p_k_-1r_4f_3q_-at_2j_5y_-63_4_2m_-cu_x_44_5t_-1d_2k_-48_3s_79_60_5m_2n_-5t_62_7i_-2k_4t_6m_7a_3i_1q_-3f_4m_41_-4t_3b_2s_-11_5h_3t_7c_-v_35_-59_1c_6_5x_-36_5a_-7f_-1n_4c_-8_-72_1j_-be_34_7t_-b_-7g_4z_-6g_-6u_29_-7b_-t_30_-r_-7h_2j_4h_-44_6h_1b_1p_5t_-8k_-3n_6s_-5g_2c_2g_-1o_-7i_6c_3r_-20_6d_-6f_-19_51_-6i_-o_4b_-b0_y_5d_-8i_-2a_2h_-a4_-p_1z_6k_4w_5q_4u_-7_5o_-cr_-d_2w_42_-a_69_2h_2b_31_-6n_65_3y_-7e_4r_2y_16_m_6r_-3p_-2s_57_-6p_-62_32_1c_14_54_-9_6a_3a_3o_-6t_68_94_31_b_-95_-2y_15_-a7_-3f_36_63_36_49_-8y_4n_8l_92_-f_6x_-b3_-41_23_7q_1d_48_6f_6i_17_-ca_29_e_-ap_-2t_63_x_3_4s_-b3_-1z_37_-6i_2n_76_5l_-d_1y_-4f_4f_2v_-8p_-4l_3z_-9z_-4a_4l_7v_d_43_-bw_-1g_3f_-af_-5c_4o_6d_-21_5g_-8f_-1i_8a_-4n_-2p_1r_98_-1x_3k_-3e_-22_2a_-9x_-1h_2l_-bw_1a_82_4x_1n_3p_5h_6z_%22%2C%22cx%22%3A-56.16130753344941%2C%22cy%22%3A12.933529651279915%2C%22sw%22%3A1639.627163455747%2C%22sh%22%3A662.2080627850352%2C%22z%22%3A-0.000025410874141374454%7D&gc=true&gd=false&q=select+col4%2C+col5%2C+col11+from+18CSX6zg5zH_sUUc9iYZ4Z489G5SnVkblXZ6a_Q&qrs=+where+col4+%3E%3D+&qre=+and+col4+%3C%3D+&qe=&width=1024&height=768
https://www.google.com/fusiontables/embedviz?viz=GVIZ&t=GRAPH&containerId=gviz_canvas&sdb=1&state=%7B%22ps%22%3A%221_0_-23_1v_1b_14_-48_q_34_5g_2x_24_5v_y_-1d_x_27_b_-50_1a_-39_-5t_34_-3y_-5c_2_-2x_2d_3_-8h_1g_46_-8p_w_a_-64_-45_1c_17_-3f_5z_-6k_-3p_n_-3p_6b_11_-3v_-69_2z_1u_-3r_8_6k_z_3c_1y_-4g_g_-2d_-63_12_3c_1m_5_2y_-2k_h_77_-3a_i_7f_-46_4t_-5d_-3d_20_l_-3b_1t_-1q_2v_2d_-4d_72_3e_-8u_-6c_2r_-2q_6t_s_-bc_-b_7_-16_2l_55_-9d_-5e_4f_4b_11_1x_1_-3k_d_-c4_-3d_l_8t_16_4j_9_-3a_9_79_21_28_-58_-l_f_-2j_-4k_z_-s_2f_u_-23_39_2c_-18_30_2f_j_-2v_6a_-1g_3f_c_-3h_x_1g_-ag_45_2e_4n_-2o_13_3p_d_4g_-cw_-1r_4q_2w_-3u_4d_6z_-4_2q_-5g_5i_22_-7_2d_7c_6g_-w_w_-7w_-52_10_-44_1n_4a_36_-4i_p_86_-t_1u_2m_-78_x_-21_67_m_88_2x_14_52_-1z_3n_-44_v_33_-cb_-2d_1n_-5g_6n_3v_-34_3z_3u_-1a_-72_5r_-a1_-28_1_-4c_2n_1e_-45_-2g_1h_-bq_3y_4w_-50_-1t_45_5f_29_2o_-83_3z_2u_6p_2p_k_-1r_4f_3q_-at_2j_5y_-63_4_2m_-cu_x_44_5t_-1d_2k_-48_3s_79_60_5m_2n_-5t_62_7i_-2k_4t_6m_7a_3i_1q_-3f_4m_41_-4t_3b_2s_-11_5h_3t_7c_-v_35_-59_1c_6_5x_-36_5a_-7f_-1n_4c_-8_-72_1j_-be_34_7t_-b_-7g_4z_-6g_-6u_29_-7b_-t_30_-r_-7h_2j_4h_-44_6h_1b_1p_5t_-8k_-3n_6s_-5g_2c_2g_-1o_-7i_6c_3r_-20_6d_-6f_-19_51_-6i_-o_4b_-b0_y_5d_-8i_-2a_2h_-a4_-p_1z_6k_4w_5q_4u_-7_5o_-cr_-d_2w_42_-a_69_2h_2b_31_-6n_65_3y_-7e_4r_2y_16_m_6r_-3p_-2s_57_-6p_-62_32_1c_14_54_-9_6a_3a_3o_-6t_68_94_31_b_-95_-2y_15_-a7_-3f_36_63_36_49_-8y_4n_8l_92_-f_6x_-b3_-41_23_7q_1d_48_6f_6i_17_-ca_29_e_-ap_-2t_63_x_3_4s_-b3_-1z_37_-6i_2n_76_5l_-d_1y_-4f_4f_2v_-8p_-4l_3z_-9z_-4a_4l_7v_d_43_-bw_-1g_3f_-af_-5c_4o_6d_-21_5g_-8f_-1i_8a_-4n_-2p_1r_98_-1x_3k_-3e_-22_2a_-9x_-1h_2l_-bw_1a_82_4x_1n_3p_5h_6z_%22%2C%22cx%22%3A-56.16130753344941%2C%22cy%22%3A12.933529651279915%2C%22sw%22%3A1639.627163455747%2C%22sh%22%3A662.2080627850352%2C%22z%22%3A-0.000025410874141374454%7D&gc=true&gd=false&q=select+col4%2C+col5%2C+col11+from+18CSX6zg5zH_sUUc9iYZ4Z489G5SnVkblXZ6a_Q&qrs=+where+col4+%3E%3D+&qre=+and+col4+%3C%3D+&qe=&width=1024&height=768
https://www.google.com/fusiontables/embedviz?viz=GVIZ&t=SCATTER&containerId=gviz_canvas&rmax=250&q=select+col9%2C+col10+from+1roVET4dVkYqUVKye3zf8_MsDKB9rfcg_BEttLA+where+col3+%3D+'%E8%87%BA%E5%8C%97%E5%B8%82'+and+col2+%3E%3D+'2012%2F01%2F01'&qrs=+and+col9+%3E%3D+&qre=+and+col9+%3C%3D+&qe=&width=1024&height=768
https://www.google.com/fusiontables/embedviz?viz=GVIZ&t=SCATTER&containerId=gviz_canvas&rmax=250&q=select+col9%2C+col10+from+1roVET4dVkYqUVKye3zf8_MsDKB9rfcg_BEttLA+where+col3+%3D+'%E8%87%BA%E5%8C%97%E5%B8%82'+and+col2+%3E%3D+'2012%2F01%2F01'&qrs=+and+col9+%3E%3D+&qre=+and+col9+%3C%3D+&qe=&width=1024&height=768
https://www.google.com/fusiontables/embedviz?viz=GVIZ&t=LINE&containerId=gviz_canvas&q=select+col4%2C+count()+from+1roVET4dVkYqUVKye3zf8_MsDKB9rfcg_BEttLA+where+col3+%3D+'%E8%87%BA%E5%8C%97%E5%B8%82'+and+col2+%3E%3D+'2012%2F010%2F01'&qrs=+and+col4+%3E%3D+&qre=+and+col4+%3C%3D+&qe=+group+by+col4+order+by+col4+asc+limit+12&width=1024&height=768
https://www.google.com/fusiontables/embedviz?viz=GVIZ&t=LINE&containerId=gviz_canvas&q=select+col4%2C+count()+from+1roVET4dVkYqUVKye3zf8_MsDKB9rfcg_BEttLA+where+col3+%3D+'%E8%87%BA%E5%8C%97%E5%B8%82'+and+col2+%3E%3D+'2012%2F010%2F01'&qrs=+and+col4+%3E%3D+&qre=+and+col4+%3C%3D+&qe=+group+by+col4+order+by+col4+asc+limit+12&width=1024&height=768
https://www.google.com/fusiontables/DataSource?docid=16vpW6kFCvZNHulW2iYA2h2SbClrvGROF-Bo38UA
https://developers.google.com/kml/
https://www.google.com/fusiontables/DataSource?docid=16vpW6kFCvZNHulW2iYA2h2SbClrvGROF-Bo38UA
Page 10: Fusion tables

Problems1. Poor Functionality2. Date Format3. Full Table Scan

a. Sortb. Query

Page 11: Fusion tables

Reference● Quickly visualize and map a data set

using Google Fusion Tables● Paper

○ Google Fusion Tables: Web-Centered Data Management and Collaboration

○ Big Data Storytelling through Interactive Maps

● API & Example○ Fusion Tables Help○ Fusion Tables API○ Fusion Tables JavaScript Example○ R interface

http://blog.apps.chicagotribune.com/2010/03/04/quickly-visualize-and-map-a-data-set-using-google-fusion-tables/
http://blog.apps.chicagotribune.com/2010/03/04/quickly-visualize-and-map-a-data-set-using-google-fusion-tables/
http://blog.apps.chicagotribune.com/2010/03/04/quickly-visualize-and-map-a-data-set-using-google-fusion-tables/
http://blog.apps.chicagotribune.com/2010/03/04/quickly-visualize-and-map-a-data-set-using-google-fusion-tables/
http://homes.cs.washington.edu/~alon/files/sigmod10.pdf
http://homes.cs.washington.edu/~alon/files/sigmod10.pdf
http://homes.cs.washington.edu/~alon/files/sigmod10.pdf
http://homes.cs.washington.edu/~alon/files/sigmod10.pdf
http://sites.computer.org/debull/A12june/fusiontables.pdf
http://sites.computer.org/debull/A12june/fusiontables.pdf
http://sites.computer.org/debull/A12june/fusiontables.pdf
http://sites.computer.org/debull/A12june/fusiontables.pdf
https://support.google.com/fusiontables/answer/2571232/?hl=en&
https://support.google.com/fusiontables/answer/2571232/?hl=en&
https://developers.google.com/fusiontables/
https://developers.google.com/fusiontables/
http://gmaps-samples.googlecode.com/svn/trunk/fusiontables/javascript-api.html
http://gmaps-samples.googlecode.com/svn/trunk/fusiontables/javascript-api.html
http://gfusiontables.lopatenko.com/
http://gfusiontables.lopatenko.com/
Page 12: Fusion tables

Open Data

Page 13: Fusion tables

Thank you!!!


Facetted Browsing of Extracted Fusion Tables Data for ...ceur-ws.org/Vol-906/paper10.pdf · Facetted Browsing of Extracted Fusion Tables Data for Digital Cities Gianluca Quercini

AppInventor and Google Fusion Tables - MIT Libraries, MIT Library

FUSION SERIES DINING TABLES - PBJ Designhouse

Google Fusion Tables: Basics

Visualizing data with Google Fusion Tables

Why Google fusion tables is not a Data Integration tool

Google Fusion Tables: Web-Centered Data Management …web.engr.illinois.edu/~adityagp/courses/cs598/papers/fusion-tables.pdf · Google Fusion Tables: Web-Centered Data Management

Fusion Tables New Ways To Collaborate On Structured Data

Dennys Mejía – Introducción a Google Fusion Tables

Adding Fusion Tables to the Map - s3. · PDF fileIntroduction to the Google Maps API v3 Adding a Fusion Table to Google Maps Fusion Tables, still in the experimental stages of development,

Google Fusion Tables Tutorial: Working with NATA ... · PDF fileGoogle Fusion Tables Tutorial: Working with NATA Geospatial Data This tutorial will introduce you to the following:

Mapping discarded needles in Fusion Tables Tutorial discarded needles in Fusion Tables... · Mapping discarded needles in Fusion Tables Tutorial . In the previous tutorials, we’ve

Google Fusion Tables API Inneke Ponet. Google Fusion Tables: Store, share, query and visualize data. API to run SQL-like queries applications that use

geokov.com Shahram Yassemi · Google Fusion Tables Fusion Tables is a web application for visualizing, gathering and sharing data. Data are stored in tables with similar functionality

Geocoding Tutorial using Google Fusion Tables · PDF fileGeocoding Tutorial using Google Fusion Tables Geocoding involves assigning latitude and longitude coordinates to an item described

Google Fusion Tables: Web-Centered Data Management and ...adityagp/courses/cs598/papers/fusion-tables.pdfFusion Tables is designed with new applications in mind and according to a

High res using google fusion tables to make interactive maps

FME Lightning Talk - Google Fusion Tables

Chapter 8 A Guide to Google Fusion Tables Visualizations

Department of Computer Science, edlib.asdf.res · Google Fusion Tables [4] is a cloud-based service for data management and integration. Launched in 2009, Fusion Tables has received

Google Fusion Tables - Silicon Valley CodeCamp 2010

Google Fusion Tables

Google Image Search, Code, Fusion Tables Audrey and Chris

MAKING MAPS WITH GOOGLE FUSION · PDF fileMAKING MAPS WITH GOOGLE FUSION TABLES (Data for this tutorial at Thanks to Google Fusion Tables, creating maps

Google Fusion Tables for Health - datause.ucsf.edu Fusion... · Version 1.0 | 3 1. Introduction This manual offers a systematic approach to using Google Fusion Tables as a tool for

Creating a heat map in Fusion Tables - David McKiedavidmckie.com/Bike-theft heat map tutorial.pdfCreating a heat map in Fusion Tables In the first tutorial, we learned how use Fusion

Chapter 8 A Guide to Google Fusion Tables Visualizations 8 A Guide to Google Fusion Tables Visualizations Summary: The Google Fusion Tables is described as “experimental”, which

MAKING A CLASS MAP WITH GOOGLE FUSION TABLES

A guide to Google Fusion Tables Visualizations - David McKie guide to Google Fusion Tables Visualizations... · A guide to Google Fusion Tables Visualizations Summary: The Google

Guidance on Google Fusion tables and maps - gov.uk · PDF fileGuidance on Google Fusion tables and maps 4 Introduction Google Fusion Table, is an experimental data visualisation web

GeoMeetup - Styled Maps & Fusion Tables

Using Fusion Tables

Google Fusion Tables Tutorial: Displaying Facilities in

AppInventor and Google Fusion Tables - MIT Librarieslibraries.mit.edu/files/gis/appInventorFusionAPI.pdf · AppInventor and Google Fusion Tables Daniel Sheehan MIT GIS Services [email protected]

Radar-Coding and Geocoding Lookup Tables for the Fusion of