tiiki-009 - 経済統計練習帳

var point=new Array();
var city=new Array();
var point2=new Array();
var city2=new Array();
var delta=new Array();
var number,number2;
 
function sample() {
 
         var query = "SELECT * FROM " +'18wLvBAyI26We3Kif5XUESbdApr5j3HvityeZKZdk';
        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) {
                var year = rows[i][0];
                var x1 = rows[i][3];
                var x2 = rows[i][5];
                if(year==2010)sx = sx + 1; 
                if(year==2010)city[sx] = x1;
                if(year==2010)point[sx] = x2;
                }
 
 number=sx;
 
 sx=0;
  for (var i in rows) {
                var year = rows[i][0];
                var x1 = rows[i][3];
                var x2 = rows[i][5];
                if(year==2005)sx = sx + 1; 
                if(year==2005)city2[sx] = x1;
                if(year==2005)point2[sx] = x2;
                }
 
 
 
 
                number2 = sx;
 
 for(s=1;s<number+1;s++){
 if(city[s].length<5)city[s]="0"+city[s];    
 }
 
 for(s=1;s<number2+1;s++){
 if(city2[s].length<5)city2[s]="0"+city2[s];    
 }
 
for(s=1;s<number+1;s++){
delta[s]=0;
for(sx=1;sx<number2+1;sx++){
if(city[s]==city2[sx])delta[s]=point[s]/point2[sx];                    
}
}
 
 $("#memo").html("準備完了");
 
 map();
 
 
 
            }
        });
 
}
 
 
 
var lon = new Array();
 var lat = new Array();
 var code = new Array();
 var col = new Array();
 var datanumber;
 
function map() {
 
        var query = "SELECT * FROM " +
            '1DS2H6iPeWFL77foJCLonLlxWo5gkU0WuMT-KpG6X';
        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=?');
 
 
 
 for(s=1;s<5000;s++){
 lon[s]=new Array();
 lat[s]=new Array();
 }
 
 
 
        $.ajax({
            url: url.join(''),
            dataType: 'jsonp',
            success: function (data) {
                var rows = data['rows'];
 
 
 
                sx = 0;
 
                for (var i in rows) {
 
 
                   s=rows[i][0];
                   code[s]=rows[i][1];
                   sx=rows[i][2];
                   lon[s][sx]=rows[i][3];
                   lat[s][sx]=rows[i][4];
                }
 
  datanumber = s;
 
 maxy=0;
 maxx=0;
 for(s=1;s<datanumber;s++){
 if(lon[s][1]>maxy)maxy=lon[s][1];
 }
 
  for(s=1;s<datanumber;s++){
 if(lat[s][1]>maxx)maxx=lat[s][1];
 }
 
 
 
 minx=maxx;
 miny=maxy;
 for(s=1;s<datanumber;s++){
 if(lon[s][1]<miny)miny=lon[s][1];
 }
 
 for(s=1;s<datanumber;s++){
 if(lat[s][1]<minx)minx=lat[s][1];
 }
 
 for(s=1;s<datanumber;s++){
 sxs=0;
 col[s]="blue";
 for(sx=1;sx<number+1;sx++){
 if(code[s]==city[sx])sxs=sx; 
 }                   
 if(delta[sxs]>0.9)col[s]="yellow";
 if(delta[sxs]>0.95)col[s]="orange";
 if(delta[sxs]>1)col[s]="pink";
 if(delta[sxs]>1.05)col[s]="red";
 }
 
 
 paint();
 
 
 
 
 
 
 
            }
        });
 
}
 
 
function paint(){
 
str="<svg width=\"500\" height=\"500\">";
for(s=1;s<datanumber;s++){    
str=str+poly(s,col[s]);
}
str=str+"</svg>";
 
$("#memo").html(str);   
 
}
 
function poly(s,col){
 
    var strx="<polygon points=\"";
  for(sx=1;sx<11;sx++){
y1=500*(lon[s][sx]-miny)/(maxy-miny);    
x1=500*(lat[s][sx]-minx)/(maxx-minx); 
  strx=strx+x1+","+(500-y1)+" ";     
  }
  strx=strx+"\"";
 strx=strx+"style=\"fill:"+col+"\"/>";
    return strx; 
 
}