syuzan - 経済統計練習帳

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript">
 
var point=new Array();
 
  function sample() {
 
        var query = "SELECT * FROM " +
            '1VOGwfV9t2FhHPiAUIgebWFyAdaZCoyizmHD_fdQI';
        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;
                    point[sx]=rows[i][2]; 
                }
 
 
                number = sx;
 
  google.charts.load('current', {'packages':['geochart'],'mapsApiKey': 'AIzaSyD-9tSrke72PouQMnMX-a7eZSW0jkFMBWY'});
      google.charts.setOnLoadCallback(drawRegionsMap);
 
 
 
 
 
 
            }
        });
 
}
 
 
 
      function drawRegionsMap() {
 
         var x=new Array();
         for(s=0;s<4;s++){
         x[s]=new Array();
         }
         x[0][0]="県";
         x[0][1]="人口";
         x[1][0]="東京";
         x[2][0]="大阪";
         x[3][0]="愛知";
         x[1][1]=point[1];
         x[2][1]=point[2];
         x[3][1]=point[3];
 
 
         var d = google.visualization.arrayToDataTable(x);
 
      var options = {
		region: 'JP',  //地域
		displayMode: 'regions', // regions=塗りつぶし, markers=マーカー 
		backgroundColor: '#ebf7fe', //背景色
		resolution: 'provinces',
		colors:['blue','red'] //階層の色
	};
        var chart = new google.visualization.GeoChart(document.getElementById('memo'));
 
        chart.draw(d, options);
      }
    </script>