FAQ Database Discussion Community


How to compare innerHTML string?

javascript,google-maps,innerhtml,google-fusion-tables
Is it possible to get the results of "fusiontabledata" and "fusiontabledata2", compare both and generate a third "sidebar" showing only the duplicates? document.getElementById('sidebar_1').innerHTML = fusiontabledata; document.getElementById('sidebar_2').innerHTML = fusiontabledata2; function getData_From(response) { FTresponse = response; numRows = response.getDataTable().getNumberOfRows(); numCols = response.getDataTable().getNumberOfColumns(); fusiontabledata = "<table><tr>"; fusiontabledata += "</tr><tr>"; for (i =...

How can I Write Where Query in Fusion Tables

mysql,google-fusion-tables
I want to select all the coordinates(latlong) where user_id(a Number) = 1 from the fusion table.. I tried using var tableid = "1WjowbI77j1WFcn3IEtbwBymhVZh8jfmP_dg1epd9"; var key = "AIzaSyCALoSz00ZY3zTL1D_xUTD9GMb3T1ocBdU"; var query = "SELECT * FROM "+tableid+"&key="+key+" WHERE user_id=1"; var url = "https://www.googleapis.com/fusiontables/v2/query?sql="+query didn't work.. Errors : GET...

How import all information of location history KML file on Fusion Table?

kml,google-fusion-tables,location-history
I exported the KML file from locationhistory of google maps. Thus, I try to create a Fusion Table using Google drive and importing this file. During the import I selected the row that contains column names. The columns created in fusion table are: description, name and geometry The Fusion Table...

Fusion Table with App Inventor: displaying map with location column

dictionary,geolocation,google-fusion-tables,app-inventor
I am using App Inventor 2 from MIT. I have a fusion table with location column of type location. Using the FusiontableControls component I am able to write into the table and view the table using the WebViewer component, I am able to view the URL of the Table and...

Toggle custom legend on google maps using a radio button

javascript,html,google-maps,google-maps-api-3,google-fusion-tables
I created a legend for a google map using the following code from Google Developers Website <title>Fusion Tables Layer Example: Legend</title> <link href="/apis/fusiontables/docs/samples/style/default.css" rel="stylesheet" type="text/css"> <script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script> <style type="text/css"> #legend { background: #FFF; padding: 10px; margin: 5px; font-size: 12px; font-family: Arial, sans-serif; } .color { border: 1px solid; height:...

App Inventor 2 - UPDATE SQL: Fusion table

sql,sql-update,google-fusion-tables,app-inventor
I'm trying to update a single field in an fusion table using AppInventor. I have successfully obtained the rowid using a select query and stored this value and displayed in a label. I then want to update a field for this row using the rowid obtained but the rowid is...

Does Fusion drop columns?

csv,google-spreadsheet,google-fusion-tables
I've got a CSV file with approximately 300 columns. Here's a sample of the columns: The file is almost 100mb. I've imported it into fusion tables using their GUI import through the browser. Here's what it looks like after import: As you can see all the way to the right...

unauthorized_Client while refreshing google access token

curl,google-fusion-tables,access-token
I want to upload a csv file to fusion table using curl. I created client id and secret using developer console. Then I generated access token using google playground link. using the generated access token, I could successfully import data in fusion table from csv file. Now, the problem is...

How to share a private google doc with an appengine app

google-app-engine,google-oauth,google-fusion-tables
I have a document (its actually a fusion table) stored in my private Google Drive. I would like to share the document with a web application running on google app engine. I would like to enter the link to the document into the app and have it read the document...

How to highlight multiple countries on Google Maps using fusion table

jquery,google-maps,google-fusion-tables
I am trying to highlight multiple countries on Google Maps, but I am a little bit confused about the query. It works on a single country, e.g., if I highlight Mexico it works, but when try to highlight Mexico and India it does not work. jsFiddle I have tried the...

How make a list in the Info Window of a Fusion Map from a comma separated list?

google-fusion-tables
Can a cell with comma separated information be turned into a list? I've got uneven amounts of data (companies) and would like to just have it display as a basic List when the flag is clicked on in the Fusion Map. Say I have: Location: Seminole County, FL Companies: Acme...

Write Query to Compare time in google fusion table

sql,google-fusion-tables
I want to get all the entries from google fusion table which satisfies the condition in a given date Time column > specific time https://www.googleapis.com/fusiontables/v2/query?sql=SELECT * FROM 1WjowbI77j1WFcn3IEtbwBymhVZh8jfmP_dg1epd9 WHERE Date = '2015-02-23' AND Time > '10:25:04'&key=AIzaSyCALoSz00ZY3zTL1D_xUTD9GMb3T1ocBdU But it gives me all the entries as result.. fusion table : https://www.google.com/fusiontables/data?docid=1WjowbI77j1WFcn3IEtbwBymhVZh8jfmP_dg1epd9&key=AIzaSyCALoSz00ZY3zTL1D_xUTD9GMb3T1ocBdU#rows:id=1...

Displaying Data from a Google Fusion Table in a Table

json,api,google-fusion-tables
I am new to google fusion tables and was on the google developer website looking at examples. I made my own fusion table and tried to sub it in and it did not work. Here is my fiddle: http://jsfiddle.net/Dansker/xzrc31gp/. I think it is not working because of this: "dataSourceUrl": "//www.google.com/fusiontables/gvizdata?tq=",...

Create links to map markers in map created with Fusion Table

javascript,google-maps,google-fusion-tables
A map is being created like so (also see code at end of post). What I'm trying to create is a list of links which would point to the markers on the map, in order to recenter the map and display infowindows when the links are followed. This question and...

Highlight country around the border from your search area only

javascript,google-maps-api-3,kml,google-fusion-tables
I have to make a KML file from the Dutch country. What I want to do is: I want to Highlight only the countries around the border from my search area. Example: As a user searches on 'Amsterdam'. There are like 9 (Zaandam, Amstelveen, Hooftdorp, Diemen, Duivendrecht, ......) other states...

'500 Backend Error' on Google Fusion Table Insert Table

google-fusion-tables
I would like enable a user to create a new Fusion Table through my application. gapi.client.load('fusiontables', 'v2').then(function() { var request = gapi.client.fusiontables.table.insert({ 'columns' : [{ 'name': 'test' }], 'isExportable' : true, 'name' : 'Foobar', }); request.then(function(resp) { alert(resp) }, function(reason) { console.log(reason); alert('Error: ' + reason.result.error.message); }); }); Everything appears...

import data from Google fusion table into Google spreadsheet

android,google-apps-script,google-spreadsheet,google-fusion-tables
I'm making a decent IT-inventory system using Google Drive. I wrote an Android app (using app inventor) that allows me to scan the barcode of a pc and add some comments to it. That data gets stored in a Google Fusion Table. (Date | PC-code | Task) Now I want...

Angular $http and Fusion Tables in IE9

javascript,angularjs,internet-explorer-9,google-fusion-tables
I am trying a simple get request to a google fusion table in my angular controller. $http.get(url) .success(function(data) { //Do stuff with data }) This works in firefox, chrome, safari and IE10+ however in IE9 (Which I am requried to support) the request fails to even send and the console...

Google Maps Fusion Table API SQL “LIKE” command not working

javascript,sql,google-maps,google-maps-api-3,google-fusion-tables
I'm using Google Maps API to pull data from a Fusion Table based on user input. I trying to use the "LIKE" command to create a more robust search feature, however anything other than simple where queries (like where x=y or x>y) seems to return every entry or no entry...

Can't SELECT DISTINCT via Google Fusion Tables REST API

sql,google-apps-script,google-fusion-tables
In my Fusion Table, my State Abbr. column contains many duplicate values; and I only want to list the different values. So I tried querying the table with SELECT DISTINCT 'State Abbr. FROM <table_id>' But I got the error below; so, I guess that it doesn't like SELECT DISTINCT Invalid...