Skip to content

Instantly share code, notes, and snippets.

@fkraeutli
Created April 3, 2018 15:21
Show Gist options
  • Save fkraeutli/b5e07389cab8a570a2b19d4afbdf18da to your computer and use it in GitHub Desktop.
Save fkraeutli/b5e07389cab8a570a2b19d4afbdf18da to your computer and use it in GitHub Desktop.
Export Sphaera to Pelagios
<http://sphaera.mpiwg-berlin.mpg.de/id/item/f38c54c9-6a37-480b-ab54-581aecae3816> a <http://pelagios.github.io/vocab/terms#AnnotatedThing> ;
<http://purl.org/dc/terms/title> "Sphaera Ioannis de Sacrobosco, emendata" ;
<http://purl.org/dc/terms/description> "Sphaera Ioannis de Sacrobosco, emendata. Eliae Vineti Santonis scholia in eandem Sphaeram, ab ipso auctore restituta. Adiunximus huic libro compendium in Sphaeram, per Pierium Valerianum Bellunensem: Et Petri Nonii Salaciensis demonstrationem eorum, quae in extremo capite de climatibus Sacroboscius scribit de inaequali climatum latitudine, eodem Vineto interprete. Post omnes omnium editiones, auctior & locupletior" ;
<http://purl.org/dc/terms/temporal> "1606/1606" ;
<http://purl.org/dc/terms/language> "la" ;
<http://xmlns.com/foaf/0.1/homepage> <http://sphaera.mpiwg-berlin.mpg.de> .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/f38c54c9-6a37-480b-ab54-581aecae3816/annotations/place> a <http://www.w3.org/ns/oa#Annotation> ;
<http://www.w3.org/ns/oa#hasTarget> <http://sphaera.mpiwg-berlin.mpg.de/id/item/f38c54c9-6a37-480b-ab54-581aecae3816> ;
<http://www.w3.org/ns/oa#hasBody> <http://www.wikidata.org/entity/Q456> , _:genid-76d327d701cd4b509785979a595aaf4c-b0 .
_:genid-76d327d701cd4b509785979a595aaf4c-b0 <http://www.w3.org/2011/content#chars> "Point(4.841388888 45.758888888)"^^<http://www.opengis.net/ont/geosparql#wktLiteral> ;
<http://purl.org/dc/terms/format> "application/wkt" .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/11417c32-ee2f-43cd-a032-d5ead5bd8069> a <http://pelagios.github.io/vocab/terms#AnnotatedThing> ;
<http://purl.org/dc/terms/title> "Speculum astrologiae" ;
<http://purl.org/dc/terms/description> "Speculum astrologiae, comprehendens commentaria in theoricas planetarum, et in sphaeram Ioannis de Sacro Bosco: Unà cum tabulis de Eclipsibus Georgii Purbachii, & supputationibus motuum Planetarum, secundum decreta Alphonsii Regis Hispaniae: & Nicolai Copernici, cum diversis aliis tractatibus Astrologicis. Autore Francisco Iunctino Florentino S.T.D. ac Eleemosynario ordinario Serenissimi Principis Francisci Valesii, Henrici filij, Francisci Nepotis, ac Christianiss Francorum, ac Poloniae Regis fratris unici, Andegauensis Ducis, &c. Salvo per omnia iudicio sanctae sedis Apostolicae. Tomus posterior" ;
<http://purl.org/dc/terms/temporal> "1583/1583" ;
<http://purl.org/dc/terms/language> "la" ;
<http://xmlns.com/foaf/0.1/homepage> <http://sphaera.mpiwg-berlin.mpg.de> .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/11417c32-ee2f-43cd-a032-d5ead5bd8069/annotations/place> a <http://www.w3.org/ns/oa#Annotation> ;
<http://www.w3.org/ns/oa#hasTarget> <http://sphaera.mpiwg-berlin.mpg.de/id/item/11417c32-ee2f-43cd-a032-d5ead5bd8069> ;
<http://www.w3.org/ns/oa#hasBody> <http://www.wikidata.org/entity/Q456> , _:genid-76d327d701cd4b509785979a595aaf4c-b1 .
_:genid-76d327d701cd4b509785979a595aaf4c-b1 <http://www.w3.org/2011/content#chars> "Point(4.841388888 45.758888888)"^^<http://www.opengis.net/ont/geosparql#wktLiteral> ;
<http://purl.org/dc/terms/format> "application/wkt" .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/1dac3b48-7793-4d0c-8d35-bf74e7f39617> a <http://pelagios.github.io/vocab/terms#AnnotatedThing> ;
<http://purl.org/dc/terms/title> "Fr. Iunctini Florentini, sacrae theologiae doctoris, Commentaria in tertium et quartum capitulum Sphaerae Io. de Sacro Bosco" ;
<http://purl.org/dc/terms/description> "Fr. Iunctini Florentini, sacrae theologiae doctoris, Commentaria in tertium et quartum capitulum Sphaerae Io. de Sacro Bosco. Ad nobilem virum D. Marcum Bonavoltam Florentinum" ;
<http://purl.org/dc/terms/temporal> "1577/1577" ;
<http://purl.org/dc/terms/language> "la" ;
<http://xmlns.com/foaf/0.1/homepage> <http://sphaera.mpiwg-berlin.mpg.de> .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/1dac3b48-7793-4d0c-8d35-bf74e7f39617/annotations/place> a <http://www.w3.org/ns/oa#Annotation> ;
<http://www.w3.org/ns/oa#hasTarget> <http://sphaera.mpiwg-berlin.mpg.de/id/item/1dac3b48-7793-4d0c-8d35-bf74e7f39617> ;
<http://www.w3.org/ns/oa#hasBody> <http://www.wikidata.org/entity/Q456> , _:genid-76d327d701cd4b509785979a595aaf4c-b2 .
_:genid-76d327d701cd4b509785979a595aaf4c-b2 <http://www.w3.org/2011/content#chars> "Point(4.841388888 45.758888888)"^^<http://www.opengis.net/ont/geosparql#wktLiteral> ;
<http://purl.org/dc/terms/format> "application/wkt" .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/4208960a-b432-418f-8f72-8dc5c556b928> a <http://pelagios.github.io/vocab/terms#AnnotatedThing> ;
<http://purl.org/dc/terms/title> "Fr. Iunctini Florentini, sacrae theologiae doctoris, Commentaria in Sphaeram Ioannis de Sacro Bosco accuratissima" ;
<http://purl.org/dc/terms/description> "Fr. Iunctini Florentini, sacrae theologiae doctoris, Commentaria in Sphæram Ioannis de Sacro Bosco accuratissima. Omnia iudicio S.R. Ecclesiae submissa sunto" ;
<http://purl.org/dc/terms/temporal> "1578/1578" ;
<http://purl.org/dc/terms/language> "la" ;
<http://xmlns.com/foaf/0.1/homepage> <http://sphaera.mpiwg-berlin.mpg.de> .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/4208960a-b432-418f-8f72-8dc5c556b928/annotations/place> a <http://www.w3.org/ns/oa#Annotation> ;
<http://www.w3.org/ns/oa#hasTarget> <http://sphaera.mpiwg-berlin.mpg.de/id/item/4208960a-b432-418f-8f72-8dc5c556b928> ;
<http://www.w3.org/ns/oa#hasBody> <http://www.wikidata.org/entity/Q456> , _:genid-76d327d701cd4b509785979a595aaf4c-b3 .
_:genid-76d327d701cd4b509785979a595aaf4c-b3 <http://www.w3.org/2011/content#chars> "Point(4.841388888 45.758888888)"^^<http://www.opengis.net/ont/geosparql#wktLiteral> ;
<http://purl.org/dc/terms/format> "application/wkt" .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/e2f49856-fc05-4e39-bda1-9e067fb77e38> a <http://pelagios.github.io/vocab/terms#AnnotatedThing> ;
<http://purl.org/dc/terms/title> "Christophori Clavii Bambergensis ex Societate Iesu, in Sphaeram Ioannis de Sacro Bosco" ;
<http://purl.org/dc/terms/description> "Christophori Clavii Bambergensis ex Societate Iesu, in Sphaeram Ioannis de Sacro Bosco. Commentarius. Nunc quarto ab ipso Auctore recognitus, & plerisque in locis locupletatus" ;
<http://purl.org/dc/terms/temporal> "1593/1593" ;
<http://purl.org/dc/terms/language> "la" ;
<http://xmlns.com/foaf/0.1/homepage> <http://sphaera.mpiwg-berlin.mpg.de> .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/e2f49856-fc05-4e39-bda1-9e067fb77e38/annotations/place> a <http://www.w3.org/ns/oa#Annotation> ;
<http://www.w3.org/ns/oa#hasTarget> <http://sphaera.mpiwg-berlin.mpg.de/id/item/e2f49856-fc05-4e39-bda1-9e067fb77e38> ;
<http://www.w3.org/ns/oa#hasBody> <http://www.wikidata.org/entity/Q456> , _:genid-76d327d701cd4b509785979a595aaf4c-b4 .
_:genid-76d327d701cd4b509785979a595aaf4c-b4 <http://www.w3.org/2011/content#chars> "Point(4.841388888 45.758888888)"^^<http://www.opengis.net/ont/geosparql#wktLiteral> ;
<http://purl.org/dc/terms/format> "application/wkt" .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/00294e5b-c9ed-44f7-af31-550da6b948e0> a <http://pelagios.github.io/vocab/terms#AnnotatedThing> ;
<http://purl.org/dc/terms/title> "Christophori Clavii Bambergensis Ex Societate Iesu, in Sphaeram Ioannis de Sacro Bosco. Commentarius" ;
<http://purl.org/dc/terms/description> "Christophori Clavii Bambergensis Ex Societate Iesu, in Sphaeram Ioannis de Sacro Bosco. Commentarius. Nunc quarto ab ipso Auctore recognitus, & plerisque in locis locupletatus" ;
<http://purl.org/dc/terms/temporal> "1594/1594" ;
<http://purl.org/dc/terms/language> "la" ;
<http://xmlns.com/foaf/0.1/homepage> <http://sphaera.mpiwg-berlin.mpg.de> .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/00294e5b-c9ed-44f7-af31-550da6b948e0/annotations/place> a <http://www.w3.org/ns/oa#Annotation> ;
<http://www.w3.org/ns/oa#hasTarget> <http://sphaera.mpiwg-berlin.mpg.de/id/item/00294e5b-c9ed-44f7-af31-550da6b948e0> ;
<http://www.w3.org/ns/oa#hasBody> <http://www.wikidata.org/entity/Q456> , _:genid-76d327d701cd4b509785979a595aaf4c-b5 .
_:genid-76d327d701cd4b509785979a595aaf4c-b5 <http://www.w3.org/2011/content#chars> "Point(4.841388888 45.758888888)"^^<http://www.opengis.net/ont/geosparql#wktLiteral> ;
<http://purl.org/dc/terms/format> "application/wkt" .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/0fd18ec6-f67b-4f77-9366-f616808d5945> a <http://pelagios.github.io/vocab/terms#AnnotatedThing> ;
<http://purl.org/dc/terms/title> "Sphaera Ioannis de Sacro Bosco, emendata" ;
<http://purl.org/dc/terms/description> "Sphaera Ioannis de Sacro Bosco, emendata. In eandem Francisci Iunctini Florentini, et Eliae Vineti Santonis Scholia. Caetera pagina sequens indicabit" ;
<http://purl.org/dc/terms/temporal> "1573/1573" ;
<http://purl.org/dc/terms/language> "la" ;
<http://xmlns.com/foaf/0.1/homepage> <http://sphaera.mpiwg-berlin.mpg.de> .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/0fd18ec6-f67b-4f77-9366-f616808d5945/annotations/place> a <http://www.w3.org/ns/oa#Annotation> ;
<http://www.w3.org/ns/oa#hasTarget> <http://sphaera.mpiwg-berlin.mpg.de/id/item/0fd18ec6-f67b-4f77-9366-f616808d5945> ;
<http://www.w3.org/ns/oa#hasBody> <http://www.wikidata.org/entity/Q12892> , _:genid-76d327d701cd4b509785979a595aaf4c-b6 .
_:genid-76d327d701cd4b509785979a595aaf4c-b6 <http://www.w3.org/2011/content#chars> "Point(4.4 51.216666666)"^^<http://www.opengis.net/ont/geosparql#wktLiteral> ;
<http://purl.org/dc/terms/format> "application/wkt" .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/118810e5-9b04-4b7c-a698-4099bb9956a3> a <http://pelagios.github.io/vocab/terms#AnnotatedThing> ;
<http://purl.org/dc/terms/title> "Sphaera Iohannis De Sacrobosco" ;
<http://purl.org/dc/terms/description> "Sphaera Iohannis De Sacrobosco" ;
<http://purl.org/dc/terms/temporal> "1547/1547" ;
<http://purl.org/dc/terms/language> "la" ;
<http://xmlns.com/foaf/0.1/homepage> <http://sphaera.mpiwg-berlin.mpg.de> .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/118810e5-9b04-4b7c-a698-4099bb9956a3/annotations/place> a <http://www.w3.org/ns/oa#Annotation> ;
<http://www.w3.org/ns/oa#hasTarget> <http://sphaera.mpiwg-berlin.mpg.de/id/item/118810e5-9b04-4b7c-a698-4099bb9956a3> ;
<http://www.w3.org/ns/oa#hasBody> <http://www.wikidata.org/entity/Q12892> , _:genid-76d327d701cd4b509785979a595aaf4c-b7 .
_:genid-76d327d701cd4b509785979a595aaf4c-b7 <http://www.w3.org/2011/content#chars> "Point(4.4 51.216666666)"^^<http://www.opengis.net/ont/geosparql#wktLiteral> ;
<http://purl.org/dc/terms/format> "application/wkt" .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/1cc43766-934e-40d2-b2a5-9788b0073831> a <http://pelagios.github.io/vocab/terms#AnnotatedThing> ;
<http://purl.org/dc/terms/title> "Sphaera Ioannis de Sacro Bosco, emendata" ;
<http://purl.org/dc/terms/description> "Sphaera Ioannis de Sacro Bosco, emendata. In eandem Francisci Iunctini Florentini, Eliae Vineti Santonis, & Alberti Heronis Scholia" ;
<http://purl.org/dc/terms/temporal> "1582/1582" ;
<http://purl.org/dc/terms/language> "la" ;
<http://xmlns.com/foaf/0.1/homepage> <http://sphaera.mpiwg-berlin.mpg.de> .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/1cc43766-934e-40d2-b2a5-9788b0073831/annotations/place> a <http://www.w3.org/ns/oa#Annotation> ;
<http://www.w3.org/ns/oa#hasTarget> <http://sphaera.mpiwg-berlin.mpg.de/id/item/1cc43766-934e-40d2-b2a5-9788b0073831> ;
<http://www.w3.org/ns/oa#hasBody> <http://www.wikidata.org/entity/Q12892> , _:genid-76d327d701cd4b509785979a595aaf4c-b8 .
_:genid-76d327d701cd4b509785979a595aaf4c-b8 <http://www.w3.org/2011/content#chars> "Point(4.4 51.216666666)"^^<http://www.opengis.net/ont/geosparql#wktLiteral> ;
<http://purl.org/dc/terms/format> "application/wkt" .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/3086ac45-0437-4325-81e7-87800ba30353> a <http://pelagios.github.io/vocab/terms#AnnotatedThing> ;
<http://purl.org/dc/terms/title> "Sphæra Ioannis de Sacrobosco" ;
<http://purl.org/dc/terms/description> "Sphæra Ioannis de Sacrobosco" ;
<http://purl.org/dc/terms/temporal> "1561/1561" ;
<http://purl.org/dc/terms/language> "la" ;
<http://xmlns.com/foaf/0.1/homepage> <http://sphaera.mpiwg-berlin.mpg.de> .
<http://sphaera.mpiwg-berlin.mpg.de/id/item/3086ac45-0437-4325-81e7-87800ba30353/annotations/place> a <http://www.w3.org/ns/oa#Annotation> ;
<http://www.w3.org/ns/oa#hasTarget> <http://sphaera.mpiwg-berlin.mpg.de/id/item/3086ac45-0437-4325-81e7-87800ba30353> ;
<http://www.w3.org/ns/oa#hasBody> <http://www.wikidata.org/entity/Q12892> , _:genid-76d327d701cd4b509785979a595aaf4c-b9 .
_:genid-76d327d701cd4b509785979a595aaf4c-b9 <http://www.w3.org/2011/content#chars> "Point(4.4 51.216666666)"^^<http://www.opengis.net/ont/geosparql#wktLiteral> ;
<http://purl.org/dc/terms/format> "application/wkt" .
PREFIX oa: <http://www.w3.org/ns/oa#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX ecrm: <http://erlangen-crm.org/current/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX efrbroo: <http://erlangen-crm.org/efrbroo/>
PREFIX pelagios: <http://pelagios.github.io/vocab/terms#>
PREFIX sphaera: <http://ontologies.mpiwg-berlin.mpg.de/sphaera/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
CONSTRUCT
{
?subject <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> pelagios:AnnotatedThing .
?subject dcterms:title ?title .
?subject dcterms:description ?full_title .
?subject dcterms:temporal ?timespan .
?subject dcterms:language ?language_code .
?subject foaf:homepage <http://sphaera.mpiwg-berlin.mpg.de> .
?place_annotation <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> oa:Annotation ;
oa:hasTarget ?subject ;
oa:hasBody ?wdPlace ;
oa:hasBody [
cnt:chars ?coordinates;
dcterms:format "application/wkt"
].
}
WHERE
{ ?subject a sphaera:Book ;
ecrm:P3_has_note ?title ;
ecrm:P128_carries ?publication_expression .
?publication_expression ecrm:P102_has_title/ecrm:P3_has_note ?full_title .
?publication_expression efrbroo:R24i_was_created_through/ecrm:P4_has_time-span ?date .
?publication_expression efrbroo:R24i_was_created_through/ecrm:P7_took_place_at ?place .
?publication_expression (ecrm:P165_incorporates/ecrm:P72_has_language)/owl:sameAs ?wd_language .
?date ecrm:P82a_begin_of_the_beginning ?date_from ;
ecrm:P82b_end_of_the_end ?date_to
BIND(uri(concat(str(?subject), "/annotations/place")) AS ?place_annotation)
BIND(concat(str(year(?date_from)), "/", str(year(?date_to))) AS ?timespan)
SERVICE <https://query.wikidata.org/sparql>
{ OPTIONAL
{ ?wd_language wdt:P218 ?language_code }
}
?place owl:sameAs ?wdPlace .
SERVICE <https://wikidata.metaphacts.com/sparql>
{ ?wdPlace wdt:P625 ?coordinates }
}
LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment