Ideophagous

Babel user information

ary-N	هاد لخدايمي لوغتو د لأم هيا دّاريجة.

en-5	This user has professional knowledge of English.

ar-5	هذا المستخدم لديه معرفة احترافية بالعربية.

fr-5	Cet utilisateur dispose de connaissances professionnelles en français.

de-3	Dieser Benutzer beherrscht Deutsch auf hohem Niveau.

ro-2	Acest utilizator poate contribui cu un nivel intermediar de română.

es-2	Esta persona tiene un conocimiento intermedio del español.

ja-2	この利用者は中級の日本語ができます。

nl-2	Deze gebruiker heeft basiskennis van het Nederlands.

la-1	Hic usor/Haec ustrix simplici lingua Latina conferre potest.

zgh-0	ⴰⵏⵙⵙⵎⵔⵙ ⴰⴷ ⵓⵔ ⵖⵓⵔⵙ ⴰⴽⴽⵯ ⴽⵔⴰ ⵏ ⵜⵓⵙⵙⵏⵉⵡⵉⵏ ⴳ ⵜⵎⴰⵣⵉⵖⵜ (ⵏⵖ ⴰⵔ ⵜⵜ ⵉⵜⵜⵔⵎⴰⵙ ⵙ ⵓⵏⵎⴰⵔ ⵉⴳⴳⵓⵜⵏ).

shi-0	Asmras ad ur dars kra n tussna ɣ Taclḥit) (nɣ ar tt ittrmas s tmmara iggutn).

tzm-0	This user has no knowledge of ⵜⴰⵎⴰⵣⵉⵖⵜ (or understands it with considerable difficulty).

Operator of DarijaBot

Some plans

Adjusting Moroccan communes and localities, so much mess there. Queries:
- https://w.wiki/6E7S
Scrape some Morocco related public lists and databases, clean the data and add the items to Wikidata with Quickstatements (or with a bot task):
- This database of Moroccan university professors and researchers
- List of Moroccan Parliament members
Fill the fish base list with Moroccan Darija names (I have it locally as CSV), and similarly enter them on Wikidata
Find other resources to scrape

Shortcuts

Get list of non-ID properties by type of item, ordered by percentage of use (could help with creating automatic infoboxes on Wikipedia): https://w.wiki/5t8y
List properties: https://w.wiki/5vS8 and https://w.wiki/6G$4
Moroccan newspapers: https://w.wiki/5vSV
Special:MergeItems

For 2023 contest

Science and technology in Morocco:
- People https://w.wiki/6JML
- Research institutes https://w.wiki/6ME$

Moroccan territorial entities

Verify if Moroccan geocodes are correct (at least in comparison to the province) for urban communes: https://w.wiki/7Hv9
List of Moroccan communes that have two values or more for P131 (that are a province, adding the circle is OK): https://w.wiki/8PdG (should be 0, last check: 05-12-2023)
List of rural communes in a given province: https://w.wiki/7UfA
List of communes without picture (or Commons category) on Wikidata: https://w.wiki/8BeE

Finnish books

Written works: https://w.wiki/A27R
Editions: https://w.wiki/A27U

Other useful queries

Full Queries

List of Moroccan women

SELECT ?person ?personLabel 
       (GROUP_CONCAT(DISTINCT ?occupationLabel; separator = ", ") AS ?occupations) 
       (SAMPLE(?birthYearValue) AS ?birthYear) 
       (SAMPLE(?deathYearValue) AS ?deathYear)
       (GROUP_CONCAT(DISTINCT ?website; separator = " , ") AS ?websites)
       (GROUP_CONCAT(DISTINCT ?facebook; separator = " , ") AS ?facebookPages)
       (GROUP_CONCAT(DISTINCT ?instagram; separator = " , ") AS ?instagramAccounts)
       (GROUP_CONCAT(DISTINCT ?tiktok; separator = " , ") AS ?tiktokAccounts)
       (GROUP_CONCAT(DISTINCT ?youtube; separator = " , ") AS ?youtubeChannels)
WHERE
{
  ?person wdt:P31 wd:Q5.
  ?person wdt:P27 wd:Q1028.
  ?person wdt:P21 wd:Q6581072.
  ?person wdt:P106 ?occupation.
  OPTIONAL { ?person wdt:P569 ?birthDate. }
  OPTIONAL { ?person wdt:P570 ?deathDate. }
  BIND(YEAR(?birthDate) AS ?birthYearValue)
  BIND(YEAR(?deathDate) AS ?deathYearValue)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,ar,ary,shi,zgh". }
  ?occupation rdfs:label ?occupationLabel FILTER (LANG(?occupationLabel) = "en")
  
  OPTIONAL { ?person wdt:P856 ?website. }
  OPTIONAL { ?person wdt:P2013 ?facebook. }
  OPTIONAL { ?person wdt:P2003 ?instagram. }
  OPTIONAL { ?person wdt:P7085 ?tiktok. }
  OPTIONAL { ?person wdt:P2397 ?youtube. }
}
GROUP BY ?person ?personLabel
ORDER BY ?personLabel

Prop should have at most one value

Example: Moroccan provinces and other geographical items should have at most one value for the Moroccan Geographic Code (2015). The expected number of results´for this query is 0.

SELECT distinct ?item ?itemLabel
WHERE {
  ?item wdt:P31 wd:Q15629582. #province of Morocco
  #wd:Q845643 #region of Morocco
  ?item wdt:P11958 ?geocode.

  {
    SELECT ?item (COUNT(DISTINCT ?g) AS ?countGeo)
    WHERE {
      ?item wdt:P11958 ?g.
    }
    GROUP BY ?item
    HAVING(COUNT(DISTINCT ?g) > 1)
  }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "ar,ary,en". }
}