Skip to content

Instantly share code, notes, and snippets.

Open-University-LOD Open-University-LOD

View GitHub Profile
@Open-University-LOD
Open-University-LOD / Qualification Related Content
Last active Jan 2, 2016
YouTube, OpenLearn, BBC and Podcasts content related to Q64
View Qualification Related Content
View YouTube videos, sorted by date (latest first).
PREFIX yt: <http://data.open.ac.uk/youtube/ontology/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX schema: <http://schema.org/>
SELECT
?code ?label (max(?published) as ?date)
FROM <http://data.open.ac.uk/context/youtube>
WHERE
@Open-University-LOD
Open-University-LOD / Podcast tracks
Created Jan 9, 2014
Sorted tracks of a podcast. podcast.open.ac.uk
View Podcast tracks
SELECT ?download ?published
FROM <http://data.open.ac.uk/context/podcast>
WHERE {
?podcast <http://purl.org/dc/terms/published> ?published .
?podcast <http://digitalbazaar.com/media/download> ?download .
?podcast <http://purl.org/dc/terms/isPartOf> <http://data.open.ac.uk/podcast/collection/58dbd5be4f01f4b1eec1df1e8f97eaad> .
} order by desc (?published)
View Properties of OpenLearn units
select distinct ?property
from <http://data.open.ac.uk/context/openlearn>
where {
?subject a <http://data.open.ac.uk/openlearn/ontology/OpenLearnUnit> .
?subject ?property ?x
}
@Open-University-LOD
Open-University-LOD / People names
Created Jan 9, 2014
People with more than one family name in oro.open.ac.uk
View People names
select distinct ?x
from <http://data.open.ac.uk/context/oro> {
?x <http://xmlns.com/foaf/0.1/familyName> ?y .
?x <http://xmlns.com/foaf/0.1/familyName> ?z .
filter(?z!=?y)
}
@Open-University-LOD
Open-University-LOD / Course topic and avaibility
Created Jan 9, 2014
Spanish courses available in Germany.
View Course topic and avaibility
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?c ?l WHERE {
?c <http://purl.org/dc/terms/subject> <http://data.open.ac.uk/topic/spanish> .
?c rdfs:label ?l .
?c <http://data.open.ac.uk/saou/ontology#isAvailableIn> <http://sws.geonames.org/2921044/>
}
@Open-University-LOD
Open-University-LOD / Course offers and prices
Created Jan 9, 2014
Prices (ordered) with currency of OU level 1 courses in Arts and Humanities as available in France.
View Course offers and prices
select ?course ?price ?cur
from <http://data.open.ac.uk/context/course>
where {
?course <http://data.open.ac.uk/saou/ontology#OUCourseLevel> "1"^^<http://www.w3.org/2001/XMLSchema#string>.
?course <http://purl.org/dc/terms/subject> <http://data.open.ac.uk/topic/arts_and_humanities>.
?off <http://purl.org/goodrelations/v1#includes> ?course.
?off <http://purl.org/goodrelations/v1#hasPriceSpecification> ?ps.
?course <http://purl.org/net/mlo/location> <http://sws.geonames.org/3017382/>.
?off <http://purl.org/goodrelations/v1#availableAtOrFrom> <http://sws.geonames.org/3017382/>.
?ps <http://purl.org/goodrelations/v1#hasCurrencyValue> ?price.
@Open-University-LOD
Open-University-LOD / Subject headings used to describe all podcasts
Created Jan 9, 2014
Subject headings used to describe all podcasts. Created by @ppetej
View Subject headings used to describe all podcasts
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT DISTINCT ?tlabel
FROM <http://data.open.ac.uk/context/podcast>
FROM <http://data.open.ac.uk/context/topic>
WHERE {
@Open-University-LOD
Open-University-LOD / Subjects of Podcasts
Created Jan 9, 2014
Subject headings used to describe a specific podcast. Created by @psychemedia
View Subjects of Podcasts
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
select ?s ?y {
<http://data.open.ac.uk/podcast/9687b84ab18c389aace5b9fecdb42457> dct:isPartOf ?c .
?c dct:subject ?s . ?s rdfs:label ?y
}
@Open-University-LOD
Open-University-LOD / Podcasts, OpenLearn units and the term “earthquake”
Created Jan 9, 2014
This query find any video podcast and OpenLearn units which descriptions contain the term “earthquake”.
View Podcasts, OpenLearn units and the term “earthquake”
PREFIX mlo: <http://purl.org/net/mlo/>
SELECT ?thing ?description
FROM <http://data.open.ac.uk/context/openlearn>
FROM <http://data.open.ac.uk/context/podcast>
where {
?thing <http://purl.org/dc/terms/description> ?description .
FILTER EXISTS {
{ ?thing a <http://data.open.ac.uk/openlearn/ontology/OpenLearnUnit> }
UNION
You can’t perform that action at this time.