[visualization-api] Load data from spreadsheet into Maps visualisation

[Sanne de Boer]

Hi,

Been trying to get to know the Google Visualizations and already got a lot 
of answers from reading and researching here, but I got stuck on 1 item I 
can't get fixed.

I'm trying to load data from a Google Spreadsheet by performing a database 
query. Until now this works for all charts I have tried expect the chart 
"Maps".

For example this works for the geochart and bar chart:

<script type='text/javascript' src='https://www.google.com/jsapi'></script>
<script type='text/javascript'>
 google.load('visualization', '1', {'packages': ['geochart']});
 google.setOnLoadCallback(drawGID);

  function drawGID() {
  var queryString = encodeURIComponent('SELECT E, F, G LIMIT 5');
  var query = new google.visualization.Query(
      
'https://docs.google.com/spreadsheets/d/1jzPF0FF2gP6-z_l0LsfooJP7gY6WOZfH-FoynPNiuu8/gviz/tq?gid=0&headers=1&tq='
 + queryString);
  query.send(handleQueryResponse);
  }

  function handleQueryResponse(response) {
  if (response.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + 
response.getDetailedMessage());
    return;
  }

  var data = response.getDataTable();
  var options = {
    region: 'NL',
    displayMode: 'markers',
    colorAxis: {colors: ['green', 'blue']}
    };

  var chart = new 
google.visualization.GeoChart(document.getElementById('chart_div'));
  chart.draw(data, options);
};
</script>


But when I try this for Maps it won't work:

<script type="text/javascript" src="https://www.google.com/jsapi";></script>
<script>google.load('visualization', '1', { 'packages': ['map'] });
google.setOnLoadCallback(drawGID);

  function drawGID() {
  var queryString = encodeURIComponent('SELECT E, F, G LIMIT 4');
  var query = new google.visualization.Query(
      
'https://docs.google.com/spreadsheets/d/1jzPF0FF2gP6-z_l0LsfooJP7gY6WOZfH-FoynPNiuu8/gviz/tq?gid=0&headers=1&tq='
 + queryString);
  query.send(handleQueryResponse);
  }

  function handleQueryResponse(response) {
  if (response.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + 
response.getDetailedMessage());
    return;
  }

  var data = response.getDataTable();
  var options = { showTip: true };

  var map = new google.visualization.Map(document.getElementById('chart_div'));
  map.draw(data, options);
};
</script>


I'm guessing something goes wrong with 
var data = response.getDataTable();

although I have no idea why.

The test sheet can be viewed here 
<https://docs.google.com/spreadsheets/d/1jzPF0FF2gP6-z_l0LsfooJP7gY6WOZfH-FoynPNiuu8/>
 
and there is a button called "Dashboard" to load the charts.

Any help would be great!

Thanks

-- 
You received this message because you are subscribed to the Google Groups 
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.