tizunnn - 経済統計練習帳

<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() {
 
 
pp="県名,"+"北海道,青森,岩手,宮城,秋田,山形,福島,茨城,栃木,群馬"; 
pp=pp+","+"埼玉,千葉,東京,神奈川,新潟,富山,石川,福井,山梨,長野"; 
pp=pp+","+"岐阜,静岡,愛知,三重,滋賀,京都,大阪,兵庫,奈良,和歌山"; 
pp=pp+","+"鳥取,島根,岡山,広島,山口,徳島,香川県,愛媛,高知,福岡"; 
pp=pp+","+"佐賀,長崎,熊本,大分,宮崎,鹿児島,沖縄";
 
var pref=pp.split(","); 
 
         var x=new Array();
         for(s=0;s<48;s++){
         x[s]=new Array();
         }
         x[0][0]="県";
         x[0][1]="人口";
        for(s=1;s<48;s++){
        x[s][0]=pref[s];
        x[s][1]=s*point[1];
        }
 
 
         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>