User:MB-one

From Wikidata
Jump to navigation Jump to search
Babel user information
de-N Dieser Benutzer spricht Deutsch als Muttersprache.
en-3 This user has advanced knowledge of English.
fr-1 Cet utilisateur dispose de connaissances de base en français.
pt-1 Este utilizador tem um nível básico de português.
mul-1 This user has basic knowledge of multiple languages.
This user loves OpenRefine.
Users by language

given name (P735)Matti (Q1474085), residence (P551)Frankfurt Rhine-Main Metropolitan Region (Q707278), educated at (P69)Technische Universität Berlin (Q51985)

multiple languages (Q20923490)

Activities

[edit]

Tools & queries

[edit]

Snippets

[edit]
  • p:P31/ps:P31/wdt:P279* (checks subclasses)
  • BIND(SUBSTR(STR(?item), (STRLEN(STR(<http://www.wikidata.org/entity/>))) + 1) AS ?qid) (extracts QID from URL)
  • BIND(SUBSTR( ?string, 1, 4 ) as ?substring) (extracts substrings; here: 1 = starting at first character; 4 = four characters long)
  • (COUNT(?item) AS ?count) (counts items)
  • (CONCAT('"', ?item, '"') AS ?value) (concatenates values and strings)
  • ?article schema:about ?item .
?article schema:isPartOf <https://en.wikipedia.org/>. (checks for existing articles in other wikis)
  • OPTIONAL {?item rdfs:label ?label_en , ?label_de , ?label_fr}
filter(lang(?label_en) = 'en' && lang(?label_de) = 'de' && lang(?label_fr) = 'fr') (gives multiple language labels)
  • OPTIONAL {?item schema:description ?desc FILTER (LANG (?desc) = "de") .} (gives description in selected language)
  • BIND( IF( ?value1 = ?value2, "same", "different" ) AS ?result ) (compares values)
  • { ?item wdt:P131 ?admin1. }
UNION
{ ?item wdt:P131 ?admin2. } (Union of two separate statements)
  • ?item p:P131 ?statement.
?statement ps:P131 wd:Q472 .
FILTER NOT EXISTS {
?statement prov:wasDerivedFrom ?ref
}(statement without references)
  • ?item p:P1082 ?statement.
?statement ps:P1082 ?population.
?statement pq:P585 ?qualifier. (statement with qualifier)
  • ?item p:P31 ?statement.
?statement ps:P31 wd:Q278976. (check for non-truthy statements)

Full Queries

[edit]

Berlin neighborhood maintenance

[edit]

Tools

[edit]