Mercurial > hg > extraction-interface

changeset 2:da5309d54083

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
add missing books to sections as dummy entries for further modification. (1) Alter "Auto_increment" to 5190896 for sections table in database. (2) Finds missing books (using mysql OR _select_distinct() in add_missing_books_to_sections.php (3) Put the missing_books.csv in intermediate_results. and execute: add_missing_books_to_sections.php
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Fri, 23 Jan 2015 19:00:57 +0100
parents ef6d0c6a13d7
children f196939ccc03
files interface/add_missing_books_to_sections.php interface/check_sections_details.php interface/edit_section_db.php interface/intermediate_results/missing_books.csv interface/intermediate_results/missing_books_id.csv map/coordinates/map.php
diffstat 6 files changed, 1391 insertions(+), 11 deletions(-) [+]
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/interface/add_missing_books_to_sections.php	Fri Jan 23 19:00:57 2015 +0100
@@ -0,0 +1,34 @@
+<?php
+include_once('Lib_mb_utf8.php');
+include_once('config.php');
+include_once('edit_section_db.php');
+set_time_limit(0);
+ini_set('memory_limit', '-1');
+
+$link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password);
+mysql_query("SET NAMES utf8");
+
+if (!$link_mysql) {
+    die('Could not connect: ' . mysql_error());
+}
+
+$db_selected = mysql_select_db($mysql_database, $link_mysql);
+if (!$db_selected) {
+    die ('Can\'t use foo : ' . mysql_error());
+}
+?>
+
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+        <head
+        </head>
+        <body>
+		<?php  
+            add_missing_books_to_sections(); 
+			
+		?>
+        </body>
+
+
+</html>
+
--- a/interface/check_sections_details.php	Wed Jan 21 10:49:44 2015 +0100
+++ b/interface/check_sections_details.php	Fri Jan 23 19:00:57 2015 +0100
@@ -120,6 +120,7 @@
 				$bookId=$_GET['book_id'];
 				$count=$_GET['count'];
 				$bookInfo=getBookInfo($bookId);
+
 				$info=checkSectionInfo($bookId);
 				$version=$info['version'];
 				$editor=$info['editor'];
@@ -131,6 +132,7 @@
 		?>
                 	<div id="searchResults">
 		<?php
+				
 				$sectionArray=getSectionArray($bookId,$count,$info);
 				printSectionArray($sectionArray,$missingPageArray);
                         }else{
@@ -143,5 +145,6 @@
 		<script>var version=<?php echo $version;?>;</script>
         </body>
 
+
 </html>
 
--- a/interface/edit_section_db.php	Wed Jan 21 10:49:44 2015 +0100
+++ b/interface/edit_section_db.php	Fri Jan 23 19:00:57 2015 +0100
@@ -64,15 +64,20 @@
 	return $pageArray;
 }
 function getSectionArray($bookId,$count,$versionInfo){
+		
         $str="";
-        if($versionInfo['version']!=0){
-		$table="sections_revisions";
-		$condition="AND deleted=0 ";
-		$condition=" AND versions_id=".$versionInfo['id']." AND deleted=0 ";
-	}else{
-		$table="sections";
-		$condition="";
-	}
+       	if($versionInfo['version']!=0){
+			$table="sections_revisions";
+			$condition="AND deleted=0 ";
+			$condition=" AND versions_id=".$versionInfo['id']." AND deleted=0 ";
+		}else{
+			$table="sections";
+			$condition="";
+		}
+
+		echo "select from ".$table."\n";
+
+
         $query="SELECT * 
                 FROM ".$table."
                 WHERE books_id=".$bookId." ".$condition."
@@ -81,6 +86,7 @@
                 ORDER BY id ASC";
                 /*ORDER BY start_page ASC, level ASC, id ASC,end_page DESC";*/
         $result=mysql_query($query);
+
         $i=0;
 	$pageArray=array();
         while($row=mysql_fetch_assoc($result)){
@@ -155,10 +161,110 @@
 	}
 }
 
+
+function _select_distinct(){
+	/*
+	$query="SELECT DISTINCT (books_id) FROM sections";
+	
+	$result=mysql_query($query);
+	if(!$result){
+		echo json_encode("Failed during inserting section records.");
+		return;
+	}else{
+		echo json_encode("Succeeded.");
+	}
+
+	while($row=mysql_fetch_assoc($result)){
+		// echo $row['books_id'], ", ";		
+	}
+
+	echo "section num: ".mysql_num_rows($result);
+	echo '\n';
+	*/
+
+
+	//$query="SELECT id FROM books WHERE id NOT IN (SELECT DISTINCT (books_id) FROM sections)"; 
+	$query="SELECT books.id, books.name FROM books LEFT JOIN sections ON books.id=sections.books_id WHERE sections.books_id IS NULL";
+	
+	$result=mysql_query($query);
+	if(!$result){
+		echo json_encode("Failed during inserting section records.");
+		return;
+	}
+
+	while($row=mysql_fetch_assoc($result)){
+		//echo $row['books_id'], ", ";
+		//echo $row.", ";		
+	}
+	echo "missing books num: ".mysql_num_rows($result);
+	echo '\n';
+
+	
+	
+	
+}
+
+
+
+function add_missing_books_to_sections(){
+	// find missing books
+	// Run the following line/mysql to find out what books are missing in sections table
+	// _select_distinct();
+	// Or load missing_books_id.csv
+	if (($missing_books = fopen("intermediate_results/missing_books.csv", "r")) !== FALSE) {
+	    while (($data = fgetcsv($missing_books, ",")) !== FALSE) {
+
+	    	$bookId = $data[0];
+	    	$name = $data[1];
+
+			_add_book_to_sections($name, $bookId);
+	    	
+	    }
+	    fclose($missing_books);	
+	}
+
+}
+
+
+function _add_book_to_sections($name, $bookId){
+
+	/* 
+	// get Auto_increment 
+	$query = mysql_query("SHOW TABLE STATUS WHERE name='sections'");
+	if (mysql_num_rows($query)) {
+		$result = mysql_fetch_assoc($query);
+		echo $result['Auto_increment'];
+	} else {//error
+		//error control here
+		echo "error in getting Auto_increment";
+	}
+	*/
+
+	// id should be autoincremated 
+	$query="INSERT INTO sections (name,books_id,section_after) VALUES ";
+
+	$str="(";
+	$str.="'".$name."','";
+	$str.=$bookId."',";
+	$str.="''";
+	$str.=")";
+	$query.=$str;	
+	
+	// echo $name.", ".$bookId."\n";
+
+	$result=mysql_query($query);
+	if(!$result){
+		echo json_encode("Failed during inserting section records.");
+		return;
+	}
+	// echo mysql_insert_id();
+	
+}
+
+
 if(isset($_POST['command']) && $_POST['command']!=''){
 	$command=$_POST['command'];
 	if($command=="write"){		
-		
 		$bookId=$_POST['bookId'];
 		$sectionArray=$_POST['sectionArray'];
 		$version=$_POST['version'];
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/interface/intermediate_results/missing_books.csv	Fri Jan 23 19:00:57 2015 +0100
@@ -0,0 +1,618 @@
+36854,"宛平縣志"
+36812,"房山縣志"
+36789,"通州志"
+"00592","順義縣志"
+36861,"昌平外志"
+36860,"昌平州志"
+36811,"大興縣志"
+35689,"密雲縣志"
+17103,"隆慶志"
+"00479","延慶州志"
+36855,"延慶州志"
+16711,"延慶衛志略"
+38469,"武清縣志"
+36819,"靜海縣志"
+"00480","靜海縣志"
+"00519","河北通志稿"
+"00509","藁城縣志"
+36893,"新樂縣志"
+36892,"獲鹿縣志"
+36891,"唐山縣志"
+36907,"臨漳縣志"
+"00603","南宮縣志"
+"00538","內邱縣志"
+"00556","新城縣志"
+17539,"清苑縣志"
+17450,"定興縣志"
+37016,"博野縣志"
+"00485","宣府鎮志"
+36919,"鹽山縣志"
+17162,"浙江通志"
+16877,"浙江通志"
+40629,"嚴州續志"
+16923,"臨安縣志"
+35254,"淳安縣志"
+35270,"寧波府志"
+35255,"慈谿縣志"
+35266,"寧海縣志"
+35264,"象山縣志"
+16626,"永嘉縣志"
+"00578","平陽縣志"
+35271,"泰順縣志"
+"00804","嘉興府志"
+16620,"澉水志"
+35506,"續澉水志"
+"00827","吳興志"
+17357,"湖州府志"
+17293,"安吉州志"
+16868,"會稽志"
+35658,"山陰縣志"
+35267,"諸暨縣志"
+"00802","新修上虞縣志"
+16708,"新昌縣志"
+"00575","蘭谿縣志"
+"00576","蘭谿縣志"
+35145,"義烏縣志"
+35524,"武義縣志"
+35512,"浦江縣志"
+17395,"衢州府志"
+16922,"江山縣志"
+"00574","開化縣志"
+41508,"昌國州圖志"
+16869,"赤城志"
+"00247","黃巖縣志"
+"00225","臨海縣志"
+16988,"仙居志"
+"00572","縉雲縣志"
+35653,"大同府志"
+35571,"左雲縣志"
+35588,"渾源州志"
+35628,"平定州志補"
+35603,"沁州志"
+35635,"重修襄垣縣志"
+35539,"黎城縣續志"
+35542,"直隸絳州志"
+35552,"續修稷山縣志"
+35639,"崞縣志"
+35621,"孝義縣志"
+35637,"汾陽縣志"
+35633,"文水縣志"
+"00351","文水縣志"
+35624,"興縣續志"
+35636,"石樓縣志"
+"00530","臨河縣志"
+17087,"柳邊紀略"
+36534,"復縣志略"
+36494,"海城縣志"
+35394,"安東縣志"
+36533,"鳳城縣志"
+36539,"錦縣志略"
+17527,"北鎮縣志"
+35401,"義縣志"
+36551,"彰武縣志"
+17394,"遼陽縣志"
+36501,"鐵嶺縣志"
+35383,"鐵嶺縣續志"
+36546,"西豊縣志"
+36510,"錦西縣志"
+36515,"興城縣志"
+16824,"吉林外記"
+36574,"梨樹縣志"
+36570,"遼源州志書"
+36524,"西安縣志略"
+36578,"東豊縣志"
+36564,"奉天省靖安縣志"
+36576,"奉天省兆安縣志書"
+36581,"大賫縣志"
+36517,"延吉縣志"
+16825,"黑龍江外記"
+36531,"賓縣縣志"
+36484,"布特哈志略"
+36541,"林甸縣志略"
+36662,"肇州縣志略"
+36869,"寧古塔志"
+36656,"湯原縣志略"
+17526,"璦琿縣志"
+36487,"嫩江縣志"
+36483,"安達縣志"
+36488,"青岡縣志"
+36489,"慶城縣志"
+36491,"望奎縣志"
+16763,"閩書"
+36455,"長樂縣志"
+17582,"閩清縣志"
+"00275","永泰縣志"
+36666,"泉州府志"
+36658,"馬巷廳志"
+36609,"南安縣志"
+16629,"安溪縣志"
+35319,"龍溪縣志"
+17312,"長泰縣志"
+17534,"建甌縣志"
+16635,"建陽縣志"
+17508,"政和縣志"
+36598,"長汀縣志"
+"00334","古田縣志"
+35304,"江西通志"
+36796,"南昌府志"
+36849,"瀘溪縣志"
+36785,"德化縣志"
+36709,"湖口縣志"
+38360,"德安縣志"
+35305,"分宜縣志"
+36770,"貴溪縣志"
+38361,"贛州府志"
+17378,"南安府志"
+36707,"瑞金縣志"
+36828,"信豐縣志續編"
+36851,"宜春縣志"
+36778,"豐城縣志"
+36837,"高安縣志"
+36703,"臨川縣志"
+36835,"東鄉縣志"
+36783,"廣豐縣志"
+17156,"上海志"
+16888,"寶山縣再續志"
+16927,"寶山縣續志"
+16967,"川沙縣志"
+16970,"川沙縣志"
+16971,"婁縣續志"
+16972,"重修華亭縣志"
+16965,"金山縣志"
+17040,"金山縣志"
+16974,"南匯縣志"
+16968,"重修奉賢縣志"
+36476,"京城圖志"
+16867,"建康志"
+16915,"金陵新志"
+17562,"上元縣志"
+36421,"六合縣志"
+17106,"高淳縣志"
+"00391","無錫縣志"
+36460,"重刊荊溪縣志"
+17545,"邳州志"
+17338,"沛縣志"
+36408,"武進陽湖縣志"
+36468,"金壇縣志"
+17367,"吳縣志"
+17325,"長洲縣志"
+16848,"蘇州府志"
+36446,"震澤縣志續"
+35671,"鎮洋縣志"
+17054,"吳江志"
+16760,"海門縣志"
+36429,"續纂清河縣志"
+36420,"盱眙縣志稿"
+17546,"揚州府志"
+16930,"增修甘泉縣志"
+36433,"江都縣新志"
+16773,"鎮江志"
+17326,"丹徒縣志"
+17061,"丹徒縣志"
+16899,"丹陽縣續志"
+16890,"續纂句容縣志"
+16748,"泰州志"
+17035,"古海陵縣志"
+36412,"泰興縣志續"
+16954,"靖江縣志"
+36458,"重修興化縣志"
+36410,"續修興化縣志"
+17398,"繁昌縣志"
+36591,"五河縣志"
+35298,"銅陵縣志"
+17403,"宿松縣志"
+37071,"懷寧縣志"
+35303,"望江縣志"
+35120,"安慶府望江縣志"
+17361,"潛山縣志"
+17370,"徽州府志"
+"00795","徽州府志"
+35284,"休寧縣志"
+37146,"滁州志"
+16725,"天長縣志"
+35288,"備修天長縣志稿"
+35300,"來安縣志"
+17347,"蕭縣志"
+35295,"泗縣志略"
+35674,"碭山縣志"
+17071,"六安州志"
+35142,"舒城縣志"
+16684,"池州府志"
+35829,"東流縣志"
+35285,"青陽縣志"
+17366,"廣德直隸州志"
+40997,"齊乘"
+17171,"長清縣志"
+"00683","平陰縣志"
+35211,"濟陽縣志"
+17180,"商河縣志"
+"00649","續修博山縣志"
+35042,"青城縣志"
+17292,"寧海州志"
+35013,"濟寧直隸續志"
+35204,"魚臺縣志"
+35046,"汶上縣志"
+35202,"泗水縣志"
+35044,"新泰縣志"
+35244,"肥城縣志"
+17290,"德州志"
+"00390","陵縣續志"
+35017,"武城縣志續編"
+35043,"武城縣志"
+35038,"夏津縣志"
+35216,"續修臨邑縣志"
+35021,"朝城縣志"
+17176,"濱州志"
+17173,"長山縣志"
+"00439","鄒平縣志"
+"00647","無棣縣志"
+35019,"新修菏澤縣志"
+"00348","定陶縣志"
+33950,"開封府志"
+"00403","宜陽縣志"
+"00718","續濬縣志"
+"00393","濬縣志"
+"00230","武陟縣志"
+"00427","鄢陵縣志"
+"00717","新修閿鄉縣志"
+"00430","南陽縣志"
+35360,"內鄉縣志"
+"00401","項城縣志"
+17286,"太康縣志"
+32222,"湖北通志檢存稿"
+38357,"黃陂縣志稿"
+35783,"黃陂縣志"
+35792,"長陽縣志"
+17535,"宜昌府志"
+35811,"遠安縣志"
+38366,"遠安縣志"
+38354,"棗陽縣志"
+"00235","南漳縣志"
+16654,"應山縣志"
+"00222","孝感縣志"
+35797,"廣濟縣志"
+"00736","英山縣志"
+38365,"咸寧縣志"
+16643,"沔陽志"
+35786,"潛江縣志"
+35777,"恩施縣志"
+35341,"恩施縣志"
+35778,"建始縣志"
+35337,"建始縣志"
+36701,"湘潭縣志"
+36696,"耒陽縣志"
+17486,"衡陽縣志"
+36816,"衡山縣志"
+"00770","寶慶府志"
+36586,"寶慶府志"
+36809,"綏寧縣志"
+"00452","安鄉縣志"
+36728,"安鄉縣志"
+36700,"益陽縣志"
+36732,"嘉禾縣志"
+36726,"臨武縣志"
+36761,"永明縣志"
+36695,"零陵縣志"
+16977,"永州府志"
+36738,"祁陽縣志"
+35346,"寧遠縣志"
+35343,"東安縣志"
+36712,"沅州府志"
+35862,"重修會同縣志"
+36719,"漵浦縣志"
+36754,"芷江縣志"
+16907,"南海志"
+16996,"粵大記"
+"00636","花縣志"
+"00836","續番禺縣志"
+"00638","樂昌縣志"
+16646,"仁化縣志"
+16649,"翁源縣志"
+"00853","翁源縣新志"
+"00630","高明縣志"
+"00841","順德縣志"
+"00626","赤溪縣志"
+"00632","恩平縣志"
+"00245","茂名縣志"
+"00628","高要縣志"
+17234,"德慶州志"
+"00843","封川縣志"
+"00772","開建縣志"
+"00637","懷集縣志"
+36449,"埔陽志"
+"00837","海豐縣志續編"
+"00766","龍川縣志"
+"00749","英德縣續志"
+"00846","佛岡廳志"
+"00642","陽山縣志"
+"00845","連山綏瑤廳志"
+38336,"饒平縣志"
+"00842","普寧縣志"
+"00800","新興縣志"
+16676,"澳門記略"
+41500,"廣西通志"
+35377,"寧明州志"
+35406,"崇善縣志"
+97002,"馬坪縣志"
+"00496","象州志"
+35412,"榴江縣志"
+35373,"義寧縣志"
+"00495","陽朔縣志"
+"00405","臨桂縣志"
+"00394","靈川縣志"
+35885,"平樂縣志"
+35375,"龍勝廳志"
+35376,"岑溪縣志"
+35914,"桂平縣志"
+"00395","鬱林州志"
+"00363","陸川縣志"
+"00380","百色廳志"
+"00360","鎮安府志"
+"00355","賀縣志"
+"00724","信都縣志"
+35910,"富川縣志"
+97003,"來賓縣志"
+16797,"瓊州府志"
+35904,"大足縣志"
+16672,"夔州府志"
+"00547","雙流縣志"
+"00539","納谿縣志"
+35940,"石泉縣志"
+17333,"營山縣志"
+16687,"洪雅縣志"
+16794,"馬湖府志"
+35889,"興文縣志"
+16957,"貴州通志"
+34488,"黔書"
+36984,"正安州志"
+36988,"正安新志"
+35874,"湄潭縣志"
+"00614","永寧州志"
+38476,"玉屏縣概況"
+"00699","沿河縣志"
+35928,"南籠府志"
+38480,"興義府志續編"
+36870,"興義府志"
+16693,"普安州志"
+36985,"普安縣志"
+"00459","天柱縣志"
+36872,"黎平府志"
+"00706","荔波縣志"
+37039,"荔波縣志稿"
+37024,"獨山州志"
+35382,"昆明縣志"
+35892,"尋甸州志"
+17257,"宣威縣志稿"
+35946,"續修河西縣志"
+17255,"新平縣志"
+16793,"西藏誌"
+38367,"長安縣志"
+17487,"西安府志"
+38399,"盩厔縣志"
+17597,"藍田縣志"
+17477,"續耀州志"
+35459,"宜君縣志"
+38370,"咸陽縣志"
+35464,"邠州新志稿"
+17510,"鄠縣志"
+38467,"興平縣志"
+17469,"興平縣志"
+38409,"三原縣志"
+35460,"武功縣續志"
+38395,"華州志"
+38429,"郃陽縣志"
+38452,"初朝邑縣志"
+38423,"潼關衛志"
+17478,"白水縣志"
+38428,"澄城縣志"
+"00220","富平縣志稿"
+38463,"安塞縣志"
+17474,"宜川縣志"
+35451,"褒城縣志"
+38432,"續修寧羌州志"
+38434,"沔縣志"
+38431,"留壩廳志"
+38418,"洋縣志"
+38433,"重修略陽縣志"
+35471,"清澗縣志"
+"00322","綏德州志"
+38444,"洵陽縣志"
+38402,"磚坪縣志"
+17538,"石泉縣志"
+38400,"寧陝廳志"
+38440,"漢陰廳志"
+35492,"金縣志"
+97051,"會寧縣志"
+35488,"續修會寧縣志"
+97007,"清水縣志"
+"00643","玉門縣志"
+35748,"敦煌縣志"
+35052,"慶陽府志"
+35493,"安定縣志"
+35085,"臨洮府志"
+97016,"續修文縣志"
+97017,"徽縣志"
+97025,"洮州廳志"
+"00558","新疆四道志"
+"00559","新疆志稿"
+"00513","哈密志"
+97026,"臺灣通志"
+10490,"臺海使槎錄"
+97033,"臺灣縣志"
+36821,"續修臺灣府噶瑪蘭廳志"
+17318,"清流縣志"
+35113,"寧國府志"
+16668,"新鄉縣志"
+17295,"范縣志"
+16818,"長垣縣志"
+17363,"寧國縣志"
+35309,"建寧縣志"
+16691,"寧國府志"
+17228,"將樂縣志"
+17314,"歸德志"
+16656,"尤溪縣志"
+17304,"曲沃縣志"
+17287,"陽武縣志"
+17107,"儀真縣志"
+"00585","新修餘姚縣志"
+16683,"寶應縣志略"
+17022,"永安縣志"
+16640,"臨朐縣志"
+36475,"寶應縣志"
+17324,"重修如皋縣志"
+16744,"安邱縣志"
+17305,"翼城縣志"
+17289,"章邱縣志"
+35148,"沙縣志"
+16999,"儋州志"
+17297,"輝縣志"
+17321,"永城縣志"
+16651,"夏邑縣志"
+35183,"陽武縣志"
+17432,"瓊山縣志"
+35533,"汾西縣志"
+35351,"竹山縣志"
+"00545","瓊東縣志"
+35618,"續高平縣志"
+35528,"陵川縣志"
+35281,"續修隰州志"
+35557,"大寧縣志"
+35575,"直隷霍州志"
+38374,"鳳翔府志"
+"00686","慶雲縣志"
+35821,"均州志"
+35609,"平遙縣志"
+35817,"竹山縣志"
+38420,"雒南縣志"
+17557,"如皋縣志"
+35558,"續修鄉寧縣志"
+35600,"臨汾縣志"
+35559,"鄉寧縣志"
+36651,"增續長垣縣志"
+35390,"新民府志"
+"00664","太谷縣志"
+35802,"建寧縣志"
+36814,"萬州志"
+38392,"岐山縣志"
+38465,"醴泉縣志"
+38455,"增續汧陽志"
+35816,"鄖西縣續志"
+35438,"陽城縣志"
+35584,"靈邱縣補志"
+35238,"費縣志"
+35179,"翼城縣志"
+35680,"榮成縣志"
+36622,"將樂縣志"
+"00774","長垣縣志"
+17194,"霑化縣志"
+"00292","寧國縣志"
+"00631","莆田縣志"
+38355,"大冶縣志續編"
+"00708","商邱縣志"
+35103,"湖廣鄖陽府志"
+35619,"高平縣志"
+37118,"寧國府志"
+17238,"浮山縣志"
+38453,"重修汧陽志"
+35484,"隴州志"
+17239,"壽陽縣志"
+35016,"安邱新志"
+17558,"重修寳應縣志"
+"00529","臨高縣志"
+35467,"麟游縣新志草"
+35423,"隰州志"
+35582,"沁水縣志"
+35322,"永安縣志"
+35687,"平谷縣志"
+35541,"壺關縣志"
+35225,"蒙陰縣志"
+35228,"（道光）臨邑縣志（同治）臨邑縣志"
+97037,"苗栗縣志"
+35445,"郿縣志"
+35585,"靈邱縣志"
+17472,"扶風縣志"
+"00824","汾州府志"
+36623,"永安縣續志"
+35162,"湯谿縣志"
+"00210","僊遊縣志"
+35276,"榆社縣志"
+36416,"重修儀徵縣志"
+"00657","郯城縣志"
+35593,"蒲縣新志"
+35466,"隴州續志"
+"00377","獲嘉縣志"
+36813,"定安縣志"
+17282,"介休縣志"
+35425,"遼州志"
+35574,"續刻直隷霍州志"
+17062,"如皐縣志"
+17426,"房縣志"
+35598,"趙城縣志"
+17184,"臨胊縣志"
+37040,"餘慶縣志"
+35878,"澄邁縣志"
+35879,"儋州志"
+35643,"榆次縣志"
+35854,"鄖西縣志"
+35591,"新修曲沃縣志"
+35780,"長垣縣志"
+"00704","涇州志"
+35535,"平陽府志"
+"00697","新鄉縣志"
+17473,"府谷縣志"
+16844,"章邱縣志"
+17262,"餘姚縣志"
+"00369","靈寳縣志"
+17015,"東臺縣志"
+16992,"如臯縣續志"
+97038,"彰化縣志"
+35650,"澤州府志"
+17481,"鳳縣志"
+35325,"寧化縣志"
+"00257","太谷縣志"
+35455,"寳鷄縣志"
+17498,"續修醴泉縣志稿"
+35328,"大田縣志"
+36625,"泰寧縣志"
+"00339","陽武縣志"
+17553,"寳應縣志"
+"00299","鄖西縣志"
+"00726","夏邑縣志"
+17249,"陵川縣志"
+36606,"寧化縣志"
+36561,"雙山縣志"
+35426,"襄陵縣新志"
+35321,"沙縣志"
+17034,"如皋縣志"
+35452,"横山縣志"
+17521,"臨汾縣志"
+"00216","尤溪縣志"
+17281,"翼城縣志"
+35416,"鍾山縣志"
+"00785","儋縣志"
+36503,"寳清縣志"
+"00461","建寧縣志"
+"00619","崇信縣志"
+17485,"寧晉縣志"
+"00376","靈寳縣志"
+"00240","洪洞縣志"
+17431,"續安邱新志"
+35447,"岐山縣志"
+"00453","新鄉縣續志"
+35386,"新民縣志"
+"00272","重修靈臺縣志"
+35456,"重纂興平縣志"
+35317,"明溪縣志"
+35391,"遼中縣志"
+35439,"永和縣志"
+35292,"寧國縣志"
+35440,"重修安澤縣志"
+37029,"都匀縣志稿"
+"00238","和順縣志"
+17270,"瀋陽縣志"
+35435,"鄉寧縣志"
+35025,"慶雲縣志"
+35490,"增修華亭縣志"
+"00507","感恩縣志"
+"00702","獲嘉縣志"
+35576,"浮山縣志"
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/interface/intermediate_results/missing_books_id.csv	Fri Jan 23 19:00:57 2015 +0100
@@ -0,0 +1,619 @@
+"id"
+"00210"
+"00216"
+"00220"
+"00222"
+"00225"
+"00230"
+"00235"
+"00238"
+"00240"
+"00245"
+"00247"
+"00257"
+"00272"
+"00275"
+"00292"
+"00299"
+"00322"
+"00334"
+"00339"
+"00348"
+"00351"
+"00355"
+"00360"
+"00363"
+"00369"
+"00376"
+"00377"
+"00380"
+"00390"
+"00391"
+"00393"
+"00394"
+"00395"
+"00401"
+"00403"
+"00405"
+"00427"
+"00430"
+"00439"
+"00452"
+"00453"
+"00459"
+"00461"
+"00479"
+"00480"
+"00485"
+"00495"
+"00496"
+"00507"
+"00509"
+"00513"
+"00519"
+"00529"
+"00530"
+"00538"
+"00539"
+"00545"
+"00547"
+"00556"
+"00558"
+"00559"
+"00572"
+"00574"
+"00575"
+"00576"
+"00578"
+"00585"
+"00592"
+"00603"
+"00614"
+"00619"
+"00626"
+"00628"
+"00630"
+"00631"
+"00632"
+"00636"
+"00637"
+"00638"
+"00642"
+"00643"
+"00647"
+"00649"
+"00657"
+"00664"
+"00683"
+"00686"
+"00697"
+"00699"
+"00702"
+"00704"
+"00706"
+"00708"
+"00717"
+"00718"
+"00724"
+"00726"
+"00736"
+"00749"
+"00766"
+"00770"
+"00772"
+"00774"
+"00785"
+"00795"
+"00800"
+"00802"
+"00804"
+"00824"
+"00827"
+"00836"
+"00837"
+"00841"
+"00842"
+"00843"
+"00845"
+"00846"
+"00853"
+10490
+16620
+16626
+16629
+16635
+16640
+16643
+16646
+16649
+16651
+16654
+16656
+16668
+16672
+16676
+16683
+16684
+16687
+16691
+16693
+16708
+16711
+16725
+16744
+16748
+16760
+16763
+16773
+16793
+16794
+16797
+16818
+16824
+16825
+16844
+16848
+16867
+16868
+16869
+16877
+16888
+16890
+16899
+16907
+16915
+16922
+16923
+16927
+16930
+16954
+16957
+16965
+16967
+16968
+16970
+16971
+16972
+16974
+16977
+16988
+16992
+16996
+16999
+17015
+17022
+17034
+17035
+17040
+17054
+17061
+17062
+17071
+17087
+17103
+17106
+17107
+17156
+17162
+17171
+17173
+17176
+17180
+17184
+17194
+17228
+17234
+17238
+17239
+17249
+17255
+17257
+17262
+17270
+17281
+17282
+17286
+17287
+17289
+17290
+17292
+17293
+17295
+17297
+17304
+17305
+17312
+17314
+17318
+17321
+17324
+17325
+17326
+17333
+17338
+17347
+17357
+17361
+17363
+17366
+17367
+17370
+17378
+17394
+17395
+17398
+17403
+17426
+17431
+17432
+17450
+17469
+17472
+17473
+17474
+17477
+17478
+17481
+17485
+17486
+17487
+17498
+17508
+17510
+17521
+17526
+17527
+17534
+17535
+17538
+17539
+17545
+17546
+17553
+17557
+17558
+17562
+17582
+17597
+32222
+33950
+34488
+35013
+35016
+35017
+35019
+35021
+35025
+35038
+35042
+35043
+35044
+35046
+35052
+35085
+35103
+35113
+35120
+35142
+35145
+35148
+35162
+35179
+35183
+35202
+35204
+35211
+35216
+35225
+35228
+35238
+35244
+35254
+35255
+35264
+35266
+35267
+35270
+35271
+35276
+35281
+35284
+35285
+35288
+35292
+35295
+35298
+35300
+35303
+35304
+35305
+35309
+35317
+35319
+35321
+35322
+35325
+35328
+35337
+35341
+35343
+35346
+35351
+35360
+35373
+35375
+35376
+35377
+35382
+35383
+35386
+35390
+35391
+35394
+35401
+35406
+35412
+35416
+35423
+35425
+35426
+35435
+35438
+35439
+35440
+35445
+35447
+35451
+35452
+35455
+35456
+35459
+35460
+35464
+35466
+35467
+35471
+35484
+35488
+35490
+35492
+35493
+35506
+35512
+35524
+35528
+35533
+35535
+35539
+35541
+35542
+35552
+35557
+35558
+35559
+35571
+35574
+35575
+35576
+35582
+35584
+35585
+35588
+35591
+35593
+35598
+35600
+35603
+35609
+35618
+35619
+35621
+35624
+35628
+35633
+35635
+35636
+35637
+35639
+35643
+35650
+35653
+35658
+35671
+35674
+35680
+35687
+35689
+35748
+35777
+35778
+35780
+35783
+35786
+35792
+35797
+35802
+35811
+35816
+35817
+35821
+35829
+35854
+35862
+35874
+35878
+35879
+35885
+35889
+35892
+35904
+35910
+35914
+35928
+35940
+35946
+36408
+36410
+36412
+36416
+36420
+36421
+36429
+36433
+36446
+36449
+36455
+36458
+36460
+36468
+36475
+36476
+36483
+36484
+36487
+36488
+36489
+36491
+36494
+36501
+36503
+36510
+36515
+36517
+36524
+36531
+36533
+36534
+36539
+36541
+36546
+36551
+36561
+36564
+36570
+36574
+36576
+36578
+36581
+36586
+36591
+36598
+36606
+36609
+36622
+36623
+36625
+36651
+36656
+36658
+36662
+36666
+36695
+36696
+36700
+36701
+36703
+36707
+36709
+36712
+36719
+36726
+36728
+36732
+36738
+36754
+36761
+36770
+36778
+36783
+36785
+36789
+36796
+36809
+36811
+36812
+36813
+36814
+36816
+36819
+36821
+36828
+36835
+36837
+36849
+36851
+36854
+36855
+36860
+36861
+36869
+36870
+36872
+36891
+36892
+36893
+36907
+36919
+36984
+36985
+36988
+37016
+37024
+37029
+37039
+37040
+37071
+37118
+37146
+38336
+38354
+38355
+38357
+38360
+38361
+38365
+38366
+38367
+38370
+38374
+38392
+38395
+38399
+38400
+38402
+38409
+38418
+38420
+38423
+38428
+38429
+38431
+38432
+38433
+38434
+38440
+38444
+38452
+38453
+38455
+38463
+38465
+38467
+38469
+38476
+38480
+40629
+40997
+41500
+41508
+97002
+97003
+97007
+97016
+97017
+97025
+97026
+97033
+97037
+97038
+97051
--- a/map/coordinates/map.php	Wed Jan 21 10:49:44 2015 +0100
+++ b/map/coordinates/map.php	Fri Jan 23 19:00:57 2015 +0100
@@ -3,8 +3,8 @@
         <head>
                 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
                 <link href="map.css" type="text/css" rel="stylesheet"/>
-                <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js" type="text/javascript"></script>
-		<script src="http://code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
+                <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js" type="text/javascript"></script>
+		<script src="https://code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
 		<link href="../../geotemco/css/platin.css" rel="stylesheet" type="text/css">
         	<script src="../../geotemco/platin.js"></script>
         	<script src="map.js"></script>