Demonstrates a working knowledge of the forms and uses of SPARQL result sets (SELECT, CONSTRUCT, DESCRIBE, and ASK). – Linked Data for Professional Education

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

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

SPARQL and Linked Data Homework Exercises

Sat, 21 Jan 2017 06:46:40 +0000

This document contains several "written" and "electronic" homework questions originally from the course "Semantic Web Topics" at LeHigh University. They include: Write a series of SPARQL queries using a provided schema; Write a SPARQL construct query that generates all triples inferred by a specific RDFS entailment rule; Write a SPARQL construct query to generate
owl:sameAs statements between domains which share specified property; Describe the pros and cons of generating links in the manner specified in the previous question; Using Jena, create a class that can read in all the files in a specified directory and create a Web page that lists a series of publications organized by topic – reading all of the files into a single model and only using SPARQL to retrieve information from the model.

URL: http://www.cse.lehigh.edu/~heflin/courses/sw-2013/hw2.pdf
Keywords: SPARQL, RDF Schema, Entailment regime, Apache Jena, Java
Author: Heflin, Jeff
Date created: 2013-02-01 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P4H
Educational use: assessment
Educational audience: teacher-educationSpecialist
Interactivity type: active

Ordnance Survey Linked Data: Combining Postcode and Spatial Queries

Mon, 16 Jan 2017 06:46:07 +0000

Building on previous blog posts, the author shows how to query and combine data from two different datasets. Although the datasets were published by the same organization, they are in two different file formats (CSV and shape). The two datasets are, however, implicitly linked via a key. By converting both datasets into a common data language (RDF), those implicit links can be made explicit, allowing the user to easily query both datasets together.

URL: https://johngoodwin225.wordpress.com/2013/08/05/ordnance-survey-linked-data-combining-postcode-and-spatial-queries/
Keywords: SPARQL, Linked Open Data (LOD), Government Open Data
Author: Goodwin, John
Date created: 2013-08-05 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M
Educational use: instruction

Ordnance Survey Linked Data: A Simple Postcode Query

Mon, 16 Jan 2017 06:46:07 +0000

This blog post shares give some simple examples of what can be done with the Code-Point(R) Open dataset, available as Linked Open Data (LOD). This dataset has a URI for every Postcode Unit, Postcode Sector, Postcode District and Postcode Area in England, Scotland and Wales. Includes example SPARQL queries and also serves as a brief exercise in how to find the URIs of particular resources within a dataset and determine which predicates describe important relationships between those resources. These skills are necessary to form SPARQL queries.

URL: https://johngoodwin225.wordpress.com/2013/08/05/ordnance-survey-linked-data-a-simple-postcode-query/
Keywords: Linked Open Data (LOD), SPARQL
Author: Goodwin, John
Date created: 2013-08-05 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P15M
Educational use: professionalDevelopment
Educational audience: student
Interactivity type: expositive

Ordnance Survey Linked Data: Simple SPARQL Example

Mon, 16 Jan 2017 06:46:07 +0000

This blog post shares how to retrieve several variables of data from the Ordnance Survey dataset, available as Linked Open Data (LOD). Includes SPARQL queries and instructions on how to retrieve the desired output format from the SPARQL endpoint.

URL: https://johngoodwin225.wordpress.com/2013/08/01/ordnance-survey-linked-data-simple-sparql-example/
Keywords: Linked Open Data (LOD), SPARQL
Author: Goodwin, John
Date created: 2013-08-01 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P15M
Educational use: instruction
Educational audience: student
Interactivity type: expositive

Pulling SKOS "prefLabel" and "altLabel" Values Out of DBpedia

Tue, 10 Jan 2017 06:45:33 +0000

In this blog post, the author proposes that DBpedia may be the best source of reusable URIs when one is seeking to describe entities in Linked Open Data. He shares a script for a SPARQL query that selects preferred and alternative labels for a group of DBpedia entries at once. Taking this a step further and adding a few SKOS properties to the mix, a single query can pull data from DBpedia to populate a SKOS-based thesaurus with preferred and alternative labels.

URL: http://www.snee.com/bobdc.blog/2011/02/pulling-skos-preflabel-and-alt.html
Keywords: DBpedia, Simple Knowledge Organization System (SKOS), SPARQL, Controlled vocabulary
Author: DuCharme, Bob
Date created: 2011-02-22 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P10M

SPARQL: Using SELECT Tutorial and Quiz

Thu, 24 Nov 2016 05:51:17 +0000

This slide tutorial focuses on using SELECT in SPARQL queries, but also includes other basic operators. Several examples are provided which include the RDF data being queried, the SPARQL query itself, and the result table. This is followed by quiz questions which ask the user to query DBpedia's SPARQL endpoint. The answers to the question (in the form of completed SPARQL queries) are included.

URL: http://skkudatalab.weebly.com/sparql-select.html
Keywords: SPARQL, DBpedia
Author: Kim, Seonghun
Publisher: Sungkyunkwan University (SKKU)
Date created: 2016-11-22 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M
Educational use: instruction
Educational audience: teacher-educationSpecialist
Interactivity type: mixed

SPARQL: Using ASK Tutorial and Quiz

Thu, 24 Nov 2016 05:51:17 +0000

This slide tutorial focuses on using ASK in SPARQL queries, but also includes other basic operators. Several examples are provided which include the RDF data being queried, the SPARQL query itself, and the result table. This is followed by quiz questions which ask the user to query DBpedia's SPARQL endpoint. The answers to the question (in the form of completed SPARQL queries) are included.

URL: http://skkudatalab.weebly.com/sparql-ask.html
Keywords: SPARQL, DBpedia
Author: Kim, Seonghun
Publisher: Sungkyunkwan University (SKKU)
Date created: 2016-11-22 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M
Educational use: instruction
Educational audience: teacher-educationSpecialist
Interactivity type: mixed

SPARQL: Using DESCRIBE and CONSTRUCT Tutorial and Quiz

Thu, 24 Nov 2016 05:51:17 +0000

This slide tutorial focuses on using DESCRIBE and CONSTRUCT in SPARQL queries, but also includes other basic operators. Several examples are provided which include the RDF data being queried, the SPARQL query itself, and the result table. This is followed by quiz questions which ask the user to query DBpedia's SPARQL endpoint. The answers to the question (in the form of completed SPARQL queries) are included.

URL: http://skkudatalab.weebly.com/sparql-describe.html
Keywords: DBpedia, SPARQL
Author: Oh, Sam
Publisher: Sungkyunkwan University (SKKU)
Date created: 2016-11-22 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M
Educational use: instruction
Educational audience: professional
Interactivity type: expositive