Uses variables in SELECT and WHERE clauses to yield a table of results. – Linked Data for Professional Education

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

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

MarkLogic: Introducing SPARQL

Tue, 19 Jan 2016 14:59:48 +0000

A brief tutorial on how to explore a previously loaded graph database using a SPARQL endpoint. Gives several examples of queries using DBpedia and BBC News. This is just one of several tutorials in a sequence, and they should be done in order to gain the most benefit.

URL: http://developer.marklogic.com/learn/semantics-exercises/sparql-101
Keywords: MarkLogic, BBC News, DBpedia, SPARQL, Graph
Publisher: MarkLogic
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M

MarkLogic: Next Steps

Tue, 19 Jan 2016 14:59:48 +0000

This is just one of several tutorials in a sequence, and they should be done in order to gain the most benefit. This final tutorial presents a few final challenges- using the data loaded and used in the previous exercises, try to answer a series of questions about Aldous Huxley.

URL: http://developer.marklogic.com/learn/semantics-exercises/next-steps
Keywords: XQuery, SPARQL, Graph traversal
Publisher: MarkLogic
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P15M

Example SPARQL queries

Sat, 16 Jan 2016 13:43:29 +0000

This page, which contains SPARQL tools, tips, sample queries, is just starting out and the authors hope it can become a resource for useful snippets of information shared among members of the community. There is also a "Tools" page in Sourceforge that lists more substantial contributions and extensions to VIVO. This page also contains an example of a JSON result and a JavaScript example of how to run a SPARQL query and get back JSON.

URL: https://wiki.duraspace.org/display/VIVO/Example+SPARQL+queries
Keywords: JavaScript, JSON, VIVO, SPARQL
Author: Conlon, Mike
Publisher: Duraspace
Date created: 2016-08-24 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng

SPARQL Queries for Publications and Authors

Sat, 16 Jan 2016 13:43:29 +0000

This page contains SPARQL queries useful for finding information on authors and publications on VIVO. These query examples, if adapted, have other useful applications as well.

URL: https://wiki.duraspace.org/display/VIVO/SPARQL+Queries+for+Publications+and+Authors
Keywords: SPARQL, VIVO
Author: Rejack, Nicholas
Publisher: Duraspace
Date created: 2014-04-02 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P10M
Educational use: professionalDevelopment
Educational audience: professional
Interactivity type: mixed

SPARQL in 11 minutes

Sat, 16 Jan 2016 13:43:29 +0000

This video serves as an introduction to the W3C query language for RDF, SPARQL. Before explaining SPARQL queries themselves, a brief discussion of Linked Data principles (RDF, Triples, HTTP URIs, Ontologies) is given. Sample data and queries used in video are available at http://learningsparql.com/misc/sparqlIn11Minutes.zip .

URL: https://www.youtube.com/watch?v=FvGndkpa4K0
Keywords: SPARQL, HTTP URIs, Triple
Author: DuCharme, Bob
Publisher: O’Reilly
Date created: 2015-05-03 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P15M

Probing the SPARQL endpoint of data.gov.uk

Sat, 16 Jan 2016 13:43:29 +0000

In this blog post, the authors use a series of SPARQL queries to probe the content in the UK's data.gov. The techniques demonstrated can be used to probe any triple store to gain an understanding of what type of data is hosted by a triple store. The authors leveraged a web service http://data-gov.tw.rpi.edu/ws/sparqlproxy.php to convert SPARQL/XMl result into HTML and JSON.

URL: http://tw.rpi.edu/weblog/2009/10/23/probing-the-sparql-endpoint-of-datagovuk/
Keywords: PHP, JSON, SPARQL endpoint, Government Open Data
Author: Ding, Li
Publisher: Tetherless World Constellation (TWC)
Date created: 2009-10-23 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P30M