google.charts.load('upcoming', {'packages': ['geochart']});
google.charts.setOnLoadCallback(sample);
var namex = new Array();
var postx = new Array();
var cab = new Array();
var x = new Array();
var year = new Array();
var month = new Array();
var x=new Array();
function sample() {
var query = "SELECT * FROM " +
'1PD_N_F9YmrtLD-CDouJKSc0BjPM3KdRNZW0T5bsr';
var encodedQuery = encodeURIComponent(query);
var url = ['https://www.googleapis.com/fusiontables/v1/query'];
url.push('?sql=' + encodedQuery);
url.push('&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY');
url.push('&callback=?');
$.ajax({
url: url.join(''),
dataType: 'jsonp',
success: function (data) {
var rows = data['rows'];
sx = 0;
for (var i in rows) {
sx = sx + 1;
postx[sx]=rows[i][2];
namex[sx]=rows[i][0];
}
number = sx;
for(s=0;s<number+1;s++){
x[s]=new Array();
}
x[0][0]="city";
x[0][1]="pop";
for(s=1;s<number+1;s++){
x[s][0]=namex[s];
x[s][1]=postx[s];
}
var data = google.visualization.arrayToDataTable(x);
var options = {
region: 'JP',
displayMode: 'markers',
colorAxis: {colors: ['green', 'blue']}
};
var chart = new google.visualization.GeoChart(document.getElementById('memo'));
chart.draw(data, options);
}
});
}
<html>
<head>
<meta charset="utf-8" />
<script type='text/javascript' src='https://www.gstatic.com/charts/loader.js'></script>
<script type='text/javascript' src='sample.js'></script>
<script src="jquery.js"></script>
</head>
<body>
<div id="memo" style="width: 900px; height: 500px;"></div>
</body>
</html>
最終更新:2016年09月14日 10:01