User:Mfilot/Lexeme Day of the week translations matrix

Purpose edit

Illustrate the translation explosion when adding translation (P5972) to senses with item for this sense (P5137) like day of the week (Q41825).

Note: It might be more sensitive to add either translation (P5972) or item for this sense (P5137).

Query edit

SELECT ?l1 ?lemma1 ?l1lang ?lemma1l ?lemma2l ?l2lang ?day1Label WHERE {
  ?l1 a ontolex:LexicalEntry ; 
        wikibase:lemma ?lemma1 ; 
        dct:language/wdt:P218 ?l1lang ; 
        ontolex:sense ?sense1;
        ontolex:sense/wdt:P5972 ?translation.
 # ?sense1 wdt:P5137 wd:Q105 . 
  ?sense1 wdt:P5137 ?day1 .   
  ?day1 wdt:P31 wd:Q41825.
  ?l2 a ontolex:LexicalEntry ;
        wikibase:lemma ?lemma2 ;
        dct:language/wdt:P218 ?l2lang ;
        ontolex:sense ?sense2 ;
  FILTER (?l1lang IN ('de') && ?translation = ?sense2 ) . 
  BIND(concat(str(?lemma1)," ",str(?l1lang)) AS ?lemma1l) .
  BIND(concat(str(?lemma2)," ",str(?l2lang)) AS ?lemma2l) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}

Ideas of Improvements edit

  • explanation how to read the graph
  • better labels
  • add Weekday to the vega graph
  • set the order of the languages
  • query all the days of the week in one run (performace issue-> query runs in timeout)

Results edit

Monday edit

Tuesday edit

Wednesday edit

Thursday edit

Friday edit

Saturday edit

Sunday edit