Questions tagged [google-fusion-tables]

Fusion Tables is Google's product for managing and combining datasets via a web service and Google Drive, and visualizing them in charts and other ways. Fusion Tables was shut down on December 3, 2019, Maps API version 3.37 is the last version that supported Fusion Tables

Google Fusion Tables lets you store, share, query and visualize data tables. It offers a RESTful API to manage your data tables (create, delete). Besides, you can run SQL-like queries to manage data rows (insert/update/delete) and query the table for all rows that match spatial or data conditions.

The results of queries can be in JSON or used directly in the Google Maps API (via Fusion Tables Layer) or Google Chart Tools.

1344 questions
6
votes
2 answers

Using Fusion Tables tiles in Leaflet.js or on non-Google map base?

I love the fact that Google Fusion Tables can show many thousands of markers on a map efficiently. My question: is it possible (both technically and legally) to display a Fusion Tables layer on top of OpenStreetMap map tiles, in either of the…
flossfan
  • 10,554
  • 16
  • 42
  • 53
6
votes
1 answer

Fusion Table and Google Service Accounts

I am trying to use Google Service Accounts to access Fusion table from my AppENgine Java App. This code snippet is used to obtain OAuth access token: ArrayList scopes = new ArrayList(); …
Kirill Lebedev
  • 650
  • 4
  • 9
5
votes
3 answers

styling icons markers - fusion tables

This is offered as assistance to other newbies like myself. I struggled quite a while to figure out how to assign different icons to different categories of markers in my fusion table project. I found the documentation limited and confusing, and I…
wendysmith
  • 67
  • 2
  • 9
5
votes
2 answers

Google Fusion Tables Future?

Does anyone (from Google) know when and if Google Fusion Tables will become "fully" supported instead of being marked as an "experimental application" as stated at: Google Fusion Tables page We would like to make use of Fusion Tables for a project,…
bdcoder
  • 3,280
  • 8
  • 35
  • 55
5
votes
1 answer

Diagnosing Google Fusion Table update using API to upload CSV issue

I'm trying to diagnose issues updating Google Fusion Tables using CSV data via the API. Everything seems to work correctly code side of things with no errors reported but the data does not reflect the changes. Any ideas how I can diagnose what is…
Gavin
  • 5,629
  • 7
  • 44
  • 86
5
votes
4 answers

Google Drive API call to insert Public Share permissions on Fusiontables causes Internal Error

I have been trying to use the Google Drive API to make a Fusiontable publicly readable, and have not been able to get it to work. I am able to use the OAuth 2.0 Playground to insert public share permissions for other Google Drive documents, but for…
jaybrau
  • 403
  • 1
  • 3
  • 9
5
votes
1 answer

Fusion Tables Experimental

What exactly does it mean that Google's Fusion Tables is still "Experimental"? I am not familiar with any other Google services that are labeled as "Experimental". Does this mean that its OK to invest time and money developing for this service or…
5
votes
2 answers

Fusion table KML import

I used to have no problem importing kmls to fusion tables and making lots of great maps but now it only brings in three columns - name, description and geography. The remaining attributes show up when a feature is clicked on but you can't make any…
5
votes
2 answers

Fusion Tables filter conditions OR

According to https://developers.google.com/fusiontables/docs/developers_reference OR operations are not allowed as part of filter conditions. So I'm trying to come up with a creative way to solve the following: I have a fusion table backed google…
Tron
  • 693
  • 1
  • 6
  • 17
4
votes
3 answers

Google Fusion Table SQL query where clause - only AND works, not OR?

My SQL query is: SELECT * FROM 1910640 WHERE stype='P' OR stype='ERC' OR stype='PERC' ORDER BY ST_DISTANCE(geometry, LATLNG(-0.12623619999999391,51.5001524)) LIMIT 6 This results in a "parseerror". If I replace OR with AND the query returns…
Space
  • 2,022
  • 1
  • 19
  • 29
4
votes
3 answers

Configuring heatmap overlays using Google Maps API

I'm trying to use the Google Maps API to generate a heatmap of locations. It works, but the result is not very useful, since the parts rendered by the heatmap are small are hard to see: Nothing in the docs suggest a way to expand the heatmap to…
4
votes
1 answer

Fusion Tables layer URL request limit (2048 chars)

I'm using Google Maps to highlight a bunch of countries using Fusion Tables to grab the geometry. You can see an example of this here: http://jsfiddle.net/4mtyu/689/ var layer = new google.maps.FusionTablesLayer({ query: { select:…
MarioD
  • 1,703
  • 1
  • 14
  • 24
4
votes
2 answers

How can I prevent the leading zero from being removed when importing zip codes from a Google spreadsheet to a Google fusion table?

I have a Google form in which users enter their zip code. The form responses are recorded onto a Google spreadsheet, which is then synced with a Google Fusion Table to be geocoded onto a map. The zip codes are formulated as text in the spreadsheet…
4
votes
3 answers

google service account example returns "Error refreshing the OAuth2 token { “error” : “invalid_grant” }"

My goal is to make the simplest query on Google Fusion Tables on behalf of my web app users. For that, I created a service account on google console. Here is the code: // Creating a google client $client = new \Google_Client(); //…
4
votes
1 answer

Using importRows to upload FusionTables data fails with HttpError 500: Backend Error

I am using Google APIs Client Library for Python to update a Fusion Table and add rows to a Fusion Table with the Fusion Tables API v1. I can do this successfully when I do it one row at a time using the SQL INSERT query method. I would also like…
1
2
3
89 90