[DL-Learner SVN] SF.net SVN: dl-learner:[1815] trunk/src/dl-learner/org/dllearner/scripts/ matching/DBpediaLinkedGeoData.java

[<jen...@us...>]

Revision: 1815
          http://dl-learner.svn.sourceforge.net/dl-learner/?rev=1815&view=rev
Author:   jenslehmann
Date:     2009-07-08 07:31:04 +0000 (Wed, 08 Jul 2009)

Log Message:
-----------
save LGD matchings also as csv file for MySQL import

Modified Paths:
--------------
    trunk/src/dl-learner/org/dllearner/scripts/matching/DBpediaLinkedGeoData.java

Modified: trunk/src/dl-learner/org/dllearner/scripts/matching/DBpediaLinkedGeoData.java
===================================================================
--- trunk/src/dl-learner/org/dllearner/scripts/matching/DBpediaLinkedGeoData.java	2009-07-06 18:39:16 UTC (rev 1814)
+++ trunk/src/dl-learner/org/dllearner/scripts/matching/DBpediaLinkedGeoData.java	2009-07-08 07:31:04 UTC (rev 1815)
@@ -60,10 +60,11 @@
 	
 	// chose between nt and dat
 	private static String dbpediaFileFormat = "dat";
-	static File dbpediaFile =  new File("log/DBpedia_POIs." + dbpediaFileFormat);	
+	static File dbpediaFile =  new File("log/DBpedia_POIs." + dbpediaFileFormat);
 	private static boolean regenerateFile = false;
 	
 	private static File matchingFile = new File("log/DBpedia_GeoData_Links.nt");
+	private static File matchingFileMySQL =  new File("log/DBpedia_POIs.csv");	
 	private static File missesFile = new File("log/DBpedia_GeoData_Misses.dat");
 	private static double scoreThreshold = 0.85;
 	private static StringDistance distance = new Jaro();
@@ -113,6 +114,7 @@
 		Files.clearFile(matchingFile);
 		Files.clearFile(missesFile);
 		FileOutputStream fos = new FileOutputStream(matchingFile, true);
+		FileOutputStream fosMySQL = new FileOutputStream(matchingFile, true);
 		FileOutputStream fosMiss = new FileOutputStream(missesFile, true);
 		// read file point by point
 		BufferedReader br = new BufferedReader(new FileReader(dbpediaFile));
@@ -147,6 +149,17 @@
 					} else {
 						String matchStr = "<" + dp.getUri() + "> <http://www.w3.org/2002/07/owl#sameAs> <" + matchURI + "> .\n";
 						fos.write(matchStr.getBytes());	
+						
+						// strip off http://dbpedia.org/resource/
+						String dpName = dp.getUri().toString().substring(28);
+						String uriStr = matchURI.toString();
+						String nodeWay = uriStr.contains("/node/") ? "node" : "way";
+						String lgdID = uriStr.substring(uriStr.lastIndexOf("/"));
+						String matchStrMySQL = dpName + "\t" + nodeWay + "\t" + lgdID + "\n";
+						fosMySQL.write(matchStrMySQL.getBytes());
+						
+						System.out.println(matchStrMySQL);
+						
 						matches++;
 						matchPerClass.put(poiClass, matchPerClass.get(poiClass)+1);
 					}


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.