Knows methods for generating RDF data from tabular data in formats such as Comma-Separated Values (CSV). – Linked Data for Professional Education

URI design for RDF conversion of CSV-based data

Fri, 18 Aug 2017 08:22:56 +0000

The sharing of comma-separated files is very common, and a common set of problems arise upon the receipt and processing of data within this format. The RDF vocabulary described in this document provides interpretation instructions to a tool that converts tabular based data into RDF appropriate for linked data publishing. Links to a page which describes a Java-based tool that follows the interpretation vocabulary described here and provides a set of shell script tools to facilitate automatic conversion.

URL: https://data-gov.tw.rpi.edu/wiki/URI_design_for_RDF_conversion_of_CSV-based_data
Keywords: CSV (Comma Separated Values), HTTP URIs, VoID (Vocabulary of Interlinked Datasets)
Author: Williams, Gregory Todd
Publisher: Tetherless World Constellation
Date created: 2011-01-21 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P45M

Tarql: SPARQL for Tables

Fri, 18 Aug 2017 08:22:56 +0000

Tarql is a command-line tool for converting CSV files to RDF using SPARQL 1.1 syntax. In short, a CSV file’s contents are input into a SPARQL query as a table of bindings. This allows manipulation of CSV data using the full power of SPARQL 1.1 syntax, and in particular the generation of RDF using CONSTRUCT queries. Includes design patterns and examples. Discusses how to deal with variations in header rows, delimiters, quotes and character encoding encountered in CSV/TSV files.

URL: http://tarql.github.io/
Keywords: CSV (Comma Separated Values), SPARQL CONSTRUCT, SPARQL OFFSET, Apache Jena, Java (programming language)
Author: Cyganiak, Richard
Date created: 2017-06-22 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P45M

Generating RDF from Tabular Data on the Web

Fri, 18 Aug 2017 08:22:56 +0000

This document defines the procedures and rules to be applied when converting tabular data into RDF. Tabular data may be complemented with metadata annotations that describe its structure, the meaning of its content and how it may form part of a collection of interrelated tabular data. This document specifies the effect of this metadata on the resulting RDF. This is a draft document and may be updated, replaced or obsoleted by other documents at any time. It is inappropriate to cite this document as other than work in progress.

URL: http://w3c.github.io/csvw/csv2rdf/
Keywords: CSV (Comma Separated Values)
Author: Kellogg, Gregg
Publisher: W3C
Date created: 2017-06-07 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M
Interactivity type: expositive

Level Up: Online CSV to RDF Converter (Beta)

Fri, 18 Aug 2017 08:22:56 +0000

This online converter for CSV files was created for the many people out there who are big supporters of "Open Data" but are uncomfortable with getting that data into a format that can be used for Linked Data (regardless of whether it was open or not). Whilst many are happy with saving tabular data as CSV files, a surprising amount are still fairly mystified by saving that same data in RDF format. For more information about "Why RDF?", "What's Linked Open Data?" and similar questions – please have a read of the FAQ; this page concentrates on how to use the converter options to tweak the RDF output. The final step is to simply download a zip file of the converted CSV. The zip file includes the data in three formats – RDF, Turtle (.ttl) and N-Triples (.nt).

URL: http://levelup.networkedplanet.com/instructions
Keywords: CSV (Comma Separated Values)
Publisher: NetwrokedPlanet
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P15M
Educational use: professionalDevelopment
Interactivity type: active

Using the Convert CSV to RDF ingest tool

Fri, 18 Aug 2017 08:22:56 +0000

This guide will walk through the use of the Convert CSV to RDF tool, a semi-automated method of converting comma separated or tab separated text files into RDF that can be displayed in VIVO. These files should include one row of data per record (e.g., a person or publication) and represent the fields or properties associated with each record in separate columns within the row, much as the values appear in a spreadsheet. The most common pattern of loading CSV files involves one CSV file per type of data to be loaded. Note, the current ingest tools involve working through a number of steps from original source data files to the appearance of new data in VIVO. The process requires some understanding of semantic web data modeling and some training.

URL: https://wiki.duraspace.org/display/VIVODOC19x/Using+the+Convert+CSV+to+RDF+ingest+tool
Keywords: CSV (Comma Separated Values), VIVO Ontology for Researcher Discovery, SPARQL
Author: Gross, Benjamin
Publisher: Duraspace
Date created: 2017-03-16 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P30M
Educational use: instruction
Educational audience: teacher-educationSpecialist
Interactivity type: mixed

Providing Linked Data

Abi Evans — Tue, 15 Sep 2015 02:33:09 +0000

This video presentation covers the whole spectrum of Linked Data production and exposure. It begins with a grounding in Linked Data principles and best practices, with special emphasis on the VoID vocabulary. It then covers R2RML (for operating on relational databases), Open Refine (for operating on spreadsheets), and GATECloud (for operating on natural language). Finally, the presentation describes means to increase inter-linkage between datasets, focusing on tools like Silk. NOTE: This a three-part lecture, with all three videos hosted at the same URL. These videos represent material from several lessons that comprised a larger "module" of the EUCLID Project. As such, they cover a wider range of topics than most resources.

URL: http://videolectures.net/eswc2013_norton_acosta_linked_data/
Keywords: Vocabulary of Interlinked Datasets (VOID), Data extraction, Link discovery, Validation, Simple Knowledge Organization System (SKOS), Linked Open Vocabularies (LOV)
Author: Norton, Barry
Publisher: EUCLID Project
Date created: 2013-11-05 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P3H
Educational use: instruction
Educational audience: professional
Interactivity type: expositive

Karma Demonstration: Integrating Web APIs into the Linked Data Cloud

Abi Evans — Thu, 13 Aug 2015 14:33:33 +0000

While the amount of data available in the Linked Data Cloud continues to grow, there are still relatively few services for consuming and producing Linked Data. This video demonstrates the Karma data integration tool, a new approach that allows domain experts to rapidly create semantic models of services using an interactive Web-based interface (quickly and without specialized knowledge of RDF and SPARQL). This approach empowers users to rapidly model existing services and immediately use them to consume and produce Linked Data.

URL: https://www.youtube.com/watch?v=3L1G5kh5jYg
Keywords: REST API, Karma
Author: Taheriyan, Mohsen
Date created: 2012-11-11 07:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P15M

From Excel File to RDF with Links to DBpedia and Europeana

Abi Evans — Thu, 13 Aug 2015 13:45:23 +0000

This screencast is a step-by-step walk-through showing how to transform Excel tables to RDF data and then link that RDF data to external data sources. Google Refine is used for the transformation process. The goal is to show how to build a basic RDF structure, link particular tables, and explain the reconciliation process. The data is linked to the DBpedia and Europeana SPARQL endpoints.

URL: https://www.youtube.com/watch?v=XdpzmGxA33U
Keywords: Google Refine, Google Refine Expression Language (GREL), Excel, Schema alignment
Author: Da, Ani
Publisher: Digital Enterprise Research Institute (DERI)
Date created: 2012-10-23 07:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P15M

Providing Linked Data

Abi Evans — Thu, 13 Aug 2015 13:45:22 +0000

This slide presentation covers the whole spectrum of Linked Data production and exposure. It begins with a grounding in Linked Data principles and best practices, with special emphasis on the VoID vocabulary. It then covers R2RML (for operating on relational databases), Open Refine (for operating on spreadsheets), and GATECloud (for operating on natural language). Finally, the presentation describes means to increase inter-linkage between datasets, focusing on tools like Silk. NOTE: These slides represent material from several lessons that comprised a larger "module" of the EUCLID Project. As such, they cover a wider range of topics than most resources.

URL: http://www.slideshare.net/EUCLIDproject/providing-linked-data?related=6
Keywords: Linked Open Vocabularies (LOV), Vocabulary of Interlinked Datasets (VOID), Simple Knowledge Organization System (SKOS), Validation, Link Discovery, Data extraction
Author: Norton, Barry
Publisher: EUCLID Project
Date created: 2013-04-27 07:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P2H

Publishing Legacy Data as Linked Data

Abi Evans — Thu, 13 Aug 2015 13:45:21 +0000

This screencast describes how to publish legacy data as Linked Data using a variety of tools. First, a CSV file is imported to Google Refine. Then, using DERI's RDF extension, several of the data fields are reconciled against DBpedia. Next, the data is aligned with classes and properties from RDF Schema. Finally, the data is published as RDF/XML using the Linked Media Framework. At this point, it can be viewed in human-readable format (via a browser) or machine-readable (via a REST client).

URL: https://www.youtube.com/watch?v=_3BmNcHW4Ew
Keywords: RDF Schema, Google Refine, Schema alignment, REST API
Author: Schaffert, Sebastian
Publisher: Salzburg New Media Lab- Semantic Web Company
Date created: 2012-03-26 07:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P10M
Educational use: instruction
Educational audience: professional