Publish your application｜Mash up the Linked Open Data

window.onload = function() {
	var keyword = getParameterFromURL("subject"); // obtain keyword from the URL "?subject="
	var list = ""; // list to be displayed
	//alert("グラフの作成開始");
	var param = [
	[0,0],
	[0,0],
	[0,0],
	[0,0],
	[0,0],
	[0,0],
	[0,0],
	[0,0]
	];

// Work loop
	$.each(LinkData.getWorks(), function(workKey, workValue) {
		// File loop
		$.each(LinkData.getFiles(workValue), function(fileKey, fileValue) {
			//alert(nen);
			//alert(fileKey);
			//alert(fileValue);
			var c_cnt = 0;
			// Subject loop
			$.each(LinkData.getSubjects(workValue, fileValue), function(subjKey, subjValue) {
				$.each( LinkData.getTriplesBySubject(workValue, fileValue, subjValue), function( tripleKey, tripleValue ) {
					if(fileValue==="Agriculture_and_forestry_Census"){
						var prop = tripleValue.property;
						//alert(prop);
						var Nam = getLastName(prop);
						//alert(Nam);
						var obj = tripleValue.object;
						//alert(obj);
						var lab = tripleValue.label;
						//alert(lab);
						if(Nam==="項目"){
							param[c_cnt][0] = obj;
						}
						if(Nam==="URL"){
							param[c_cnt][1] = "<a href=\"" + obj + "\" target=\"_blank\">" + shortenURL(obj) + "</a>";
							c_cnt++;
						}
					}

});
			});
		});
	});
	drawtable(param);
	window.find(highlight);
};

// Get a parameter value in URL (e.g. ?paramString=value )
function getParameterFromURL( paramString )
{			
	var i;
	var r;
	var value = "";
	var topWindow = top.window.location.search;
	var q = decodeURIComponent(topWindow.substring(1,topWindow.length)).split("&");
	if( topWindow ){
		for ( i = 0; i < q.length; i++ ){
			r = q[i].split("=");
			if ( r[0] === paramString ){
				value = r[1];
			}
		}
	}
	return value;
}

// Highlight keyword in the string
function highlight( string, keyword )
{
	if ( keyword.length > 0 ) {
		var ss = string.split(keyword);
		var len = ss.length;
		if ( len > 1 ) {
			string = ss[0];
			for ( i = 1; i < len; i++ ){
//				string += ""+keyword+""+ss[i];
				string += ""+keyword+""+ss[i];
			}
		}
	}
	return string;
}

// get the last name of the string separated with # and /
function getLastName( string )
{
	string = decodeURIComponent(string);
	var sharp = string.split("#");
	var slash = sharp[sharp.length-1].split("/");
	var lastName = slash[slash.length-1];
	return lastName;
}

// return a link to Google map search
function addLinkToMap( latitude, longitude )
{
	var s = " <a target=\"_blank\" href=\"http://www.google.com/maps/?q=" + latitude + "," + longitude + "\">Show map</a>";
	return s;
}

// shortening URL e.g. http://.../123.jpg
function shortenURL( url )
{
	url = decodeURIComponent(url);
	var slash = url.split("/");
	var lastName = slash[slash.length-1];
	return url.split(":")[0]+"://.../"+lastName;
}

function drawtable(param) {
	//alert("param_begin");
	var a0 = param[0][0];
	var a1 = param[1][0];
	var a2 = param[2][0];
	var a3 = param[3][0];
	var a4 = param[4][0];
	var a5 = param[5][0];
	var a6 = param[6][0];
	var a7 = param[7][0];
	var b0 = param[0][1];
	var b1 = param[1][1];
	var b2 = param[2][1];
	var b3 = param[3][1];
	var b4 = param[4][1];
	var b5 = param[5][1];
	var b6 = param[6][1];
	var b7 = param[7][1];
		//alert("google mae");
        var data = new google.visualization.DataTable();
		//alert("google chu");
        data.addColumn('string', '項目');
        data.addColumn('string', 'url');
        data.addRows([
          [a0,b0],
          [a1,b1],
          [a2,b2],
          [a3,b3],
          [a4,b4],
          [a5,b5],
          [a6,b6],
          [a7,b7]
        ]);
	//alert("draw_mae");
        var table = new google.visualization.Table(document.getElementById('table_div'));

table.draw(data, {allowHtml: true, showRowNumber: true, width: '80%', height: '80%'});
}

Select Input Data

LinkData Work	Table Data
宮城県石巻市　統計表　目次	Agriculture_and_forestry_Census DLjun_DataSet_Ishinomakishi OpenData_Ohter_site all_opendata_list_ishinomakishi kokusei_ichiran opendata_list_ishinomakishi toukeihyou_mokuji