RDF Extension for Google Refine

While Google Refine (http://code.google.com/p/google-refine/) helps people clean tabular data, the RDF Extension for Google Refine (http://lab.linkeddata.deri.ie/2010/grefine-rdf-extension/) adds a GUI for exporting the results in RDF.

Purpose: Creating lod-link files for csv2rdf4lod

The purpose of this technology description is to accumulate notes regarding LOGD's use and evaluation of the tool. Google Refine can "reconcile" strings such as "Thailand" to Freebase identifiers such as "/m/07f1x" (see http://code.google.com/p/google-refine/wiki/Reconciliation). This provides a straightforward way to create explicit links from ambiguous strings to existing entities within Linked Open Data. With the addition of DERI's RDF Extension for Google Refine, we can express these connections in RDF and apply them to infer owl:sameAs relationships during LOGD's csv2rdf4lod conversion process. The "create-once" lod-link file from Refine can be reused when enhancing any number of datasets, resulting in a growing number owl:sameAs assertions from a fixed amount of initial human effort.

Reconciling Countries before adding RDF extension

BTW, Google Refine "sets up shop" within a directory it creates for each project, e.g. on the Mac,

~/Library/Application\ Support/Google/Refine/1932739037761.project @@@ snapshots of non-RDF extension csv reconciliation for countries.

Installing the RDF extension

Installing RDF Extension for Google Refine, mkdir -p ~/Library/Application\ Support/Google/Refine/extensions

Creating the lod-link RDF Skeleton

"Bundling" properties was a bit unintuitive. The tutorial at http://lab.linkeddata.deri.ie/2010/grefine-rdf-extension/#example should elaborate on how to do this a bit more; the instruction "We created the skeleton by repeatedly using add rdf:type and add property" is correct, but not obvious. http://logd.tw.rpi.edu/technology/csv2rdf4lod https://github.com/fadmaa/grefine-rdf-extension/issues#issue/7
dcterms:identifier "Thailand" ; rdfs:seeAlso "/m/07f1x" .

Exporting the Refined CSV to RDF

Warning: Table './drupal/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:351:\"Table './drupal/accesslog' is marked as crashed and last (automatic?) repair failed\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('RDF Extension for Google Refine', 'node/4008', '', '', 0, '89go0dmrjshjbi3gs2e8l9vbl5', 81, 1571028373)\";s:5:\"%file\";s:58:\"/data/www/html/drupal/modules/statistics/statistics.module\";s:5:\"%line\";i:63;}', 3, '', 'https://logd.tw.rpi.edu/technology/rdf_extension_g in /data/www/html/drupal/includes/database.mysqli.inc on line 134