sizugarake - 経済統計練習帳

var point = new Array();
 
 var code = new Array();
 var v = new Array();
 
var lon = new Array();
 var lat = new Array();
 
 var x_pol = new Array();
 var y_pol = new Array();
 
 var city = new Array();
 
function sample() {
 
        var query = "SELECT * FROM " +
            '15uzLzYFCFBWv5JH2Pf1XgEtmnisVb-G5LyndRHUN';
        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];
            code[sx]=  rows[i][1];  
            }
 
 
                number = sx;
 
for(s=1;s<number+1;s++){
if(code[s].length==5)code[s]="0"+code[s];    
}
 
 
for(s=1;s<number+1;s++){
code[s]=code[s].substring(0,5);   
}
 
 
play(); 
 
 
 
            }
        });
 
}
 
 
 
 
function play() {
 
 
 
 for(s=1;s<2215;s++){
  lon[s]=new Array();
  lat[s]=new Array(); 
v[s]=0; 
}
 
 
 
 
        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=?');
 
 
 
 
 
        $.ajax({
            url: url.join(''),
            dataType: 'jsonp',
            success: function (data) {
                var rows = data['rows'];
 
 
 
                sx = 0;
 
                for (var i in rows) {
                    n=rows[i][0];
                    m=rows[i][2];
                    city[n] = rows[i][1];
                    lon[n][m] = rows[i][3];
                    lat[n][m] = rows[i][4];
                }
 
 
 
 
 
        datanumber=2214;
 
 
                for (s = 1; s < datanumber;s++){
                if(city[s].length<5)city[s]="0"+city[s];    
                }
 
 
for (s = 1; s < datanumber;s++){
 for (sx = 1; sx < number;sx++){
if(city[s]==code[sx])v[s]=100;    
}    
}
 
 
 
 
                maxx = 0;
                maxy = 0;
                minx = 4000;
                miny = 4000;
                for (s = 1; s < datanumber + 1; s++) {
                    if (lat[s][1] > maxx) maxx = lat[s][1];
                    if (lat[s][1] < minx) minx = lat[s][1];
                    if (lon[s][1] > maxy) maxy = lon[s][1];
                    if (lon[s][1] < miny) miny = lon[s][1];
                }
 
 
 
 
 
                var sub = new svgpaint();
 
                str = "<svg width=\"500\" height=\"500\">";
                for (s = 1; s < datanumber + 1; s++) {
                 number_pol=10;
                 for(sx=1;sx<11;sx++){
                    x_pol[sx] = 500 * (lat[s][sx] - minx) / (maxx - minx);
                    y_pol[sx] =500- 500 * (lon[s][sx] - miny) / (maxy - miny);
                }
                if(v[s]>50) str = str + poly("red");
                if(v[s]<50) str = str + poly("blue");
            }
 
                str = str + "</svg>";
 
                $("#memo").html(str);
 
 
 
 
 
 
            }
        });
 
}
 
 
function poly(col){
 
var str,data;
var s;
data="";
for(s=1;s<number_pol;s++){
data=data+x_pol[s]+","+y_pol[s]+",";
}
s=number_pol;
data=data+x_pol[s]+","+y_pol[s];
 
str="<polygon fill="+chopx(col)+" points="+chopx(data)+"/>";
 
return str; 
}
 
function chopx(str){
 
var strx;
 
strx="\""+str+"\"";
 
return strx;
 
}