Basque Dictionaries: Difference between revisions
From LexBib
Line 15: | Line 15: | ||
(group_concat(distinct ?targetlang;SEPARATOR=",") as ?targetlangs) | (group_concat(distinct ?targetlang;SEPARATOR=",") as ?targetlangs) | ||
(strafter(str(?lcr), "https://lexbib.elex.is/entity/") as ?lcrqid) ?lcrLabel | (strafter(str(?lcr), "https://lexbib.elex.is/entity/") as ?lcrqid) ?lcrLabel | ||
?distr (strafter(str(?distr), "https://lexbib.elex.is/entity/") as ?distrqid) ?distrLabel | # ?distr (strafter(str(?distr), "https://lexbib.elex.is/entity/") as ?distrqid) ?distrLabel | ||
(YEAR(?distrdate) as ?date) | (YEAR(?distrdate) as ?date) | ||
(group_concat(distinct ?authorname; SEPARATOR="; ") as ?authors) | (group_concat(distinct ?authorname; SEPARATOR="; ") as ?authors) | ||
Line 25: | Line 25: | ||
?sourcelangitem ldp:P32 ?sourcelang. ?targetlangitem ldp:P32 ?targetlang.} | ?sourcelangitem ldp:P32 ?sourcelang. ?targetlangitem ldp:P32 ?targetlang.} | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }} | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }} | ||
group by ?lcr ?sourcelangs ?targetlangs ?lcrLabel ?distr ?distrLabel ?distrdate ?authors | group by ?lcr ?sourcelangs ?targetlangs ?lcrLabel # ?distr ?distrLabel | ||
?distrdate ?authors | |||
order by ?lcrLabel ?distrdate | order by ?lcrLabel ?distrdate | ||
</sparql> | </sparql> |
Latest revision as of 21:54, 23 December 2022
This page describes Euskarazko Hiztegien LOD katalogoa, a project funded by Wikimedia Basque Country, starting 2023. It is the first use case for a catalogue of dictionaries based on the LexMeta data model.
SPARQL Queries
LCR CSV for bilingual dictionaries source and target language annotation
PREFIX lwb: <https://lexbib.elex.is/entity/>
PREFIX ldp: <https://lexbib.elex.is/prop/direct/>
PREFIX lp: <https://lexbib.elex.is/prop/>
PREFIX lps: <https://lexbib.elex.is/prop/statement/>
PREFIX lpq: <https://lexbib.elex.is/prop/qualifier/>
PREFIX lpr: <https://lexbib.elex.is/prop/reference/>
select ?lcr
(group_concat(distinct ?sourcelang;SEPARATOR=",") as ?sourcelangs)
(group_concat(distinct ?targetlang;SEPARATOR=",") as ?targetlangs)
(strafter(str(?lcr), "https://lexbib.elex.is/entity/") as ?lcrqid) ?lcrLabel
# ?distr (strafter(str(?distr), "https://lexbib.elex.is/entity/") as ?distrqid) ?distrLabel
(YEAR(?distrdate) as ?date)
(group_concat(distinct ?authorname; SEPARATOR="; ") as ?authors)
where {
?lcr ldp:P5 lwb:Q4; ldp:P55 ?distr .
?distr ldp:P15 ?distrdate .
optional {?distr lp:P12 [lpq:P38 ?authorname].}
optional {?lcr lp:P115 [lps:P115 lwb:Q14384; lpq:P150 ?sourcelangitem; lpq:P134 ?targetlangitem].
?sourcelangitem ldp:P32 ?sourcelang. ?targetlangitem ldp:P32 ?targetlang.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }}
group by ?lcr ?sourcelangs ?targetlangs ?lcrLabel # ?distr ?distrLabel
?distrdate ?authors
order by ?lcrLabel ?distrdate