User:Syced

Babel user information
fr-N Cet utilisateur a pour langue maternelle le français. en-5 This user has professional knowledge of English. ja-5 この利用者は専門的な日本語の知識を有しています。 de-3 Dieser Benutzer beherrscht Deutsch auf hohem Niveau. nl-1 Deze gebruiker heeft elementaire kennis van het Nederlands. es-1 Esta persona tiene un conocimiento básico del español. it-1 Quest'utente può contribuire con un livello elementare in italiano. zh-1 这位用户的中文达到初级水平。 ru-0 Этот участник не владеет русским языком (или понимает его с трудом). fa-0 این کاربر فارسی را نمی‌فهمد (یا به‌سختی می‌فهمد). hi-0 इस सदस्य को हिन्दी का ज्ञान नहीं है (अथवा समझने में बहुत परेशानी होती है)। be-0 Не ведаю беларускай мовы (або ледзьве разумею). uk-0 Цей користувач не володіє українською мовою (або розуміє її дуже погано).
Users by language

Please let me know If I am doing anything wrong!

TODO

• Harvest dissolutions of Japanese former territorial entities such as 泥江町
• Move Wikidata:Infobox_mappings data to https://tools.wmflabs.org/pltools/harvesttemplates/share.php
• Extract transliteration from Japanese Wikipedia articles, even those without an infobox. Example: 犀川駅（さいがわえき）は、 → name in kana (P1814) さいがわえき　Revised Hepburn romanization (P2125) saigawaeki
• Add instance of (P31) to items around you.
• Add icon (P2910) and image (P18) to most core items
• Tables to write SPARQL queries for: organic compounds
• Wikidata:WikiProject_sum_of_all_paintings/Possible_paintings
• Select an image for items that have a Commons category: Music genres, Things in Tokyo
• Different humans with the same image: Fix any mistake or crop the image.
• Shibuya items without coordinates Map of Shibuya items
• Twin cities France-Taiwan twin cities
• Items with no P18 despite having a Commons category
• Add P18 to countries (WDFIST)
• Most-depicted items without a P18

Memo

• Embedded Wikidata query
• Wikidata:Property_proposal/opening_hours_(v.3)
• Abstract Wikipedia

Harvesting infoboxes to add P31 (instance of)

Let's say all articles on the Polish Wikipedia with template "Meteoryt infobox" are about a meteorite. Many of them do not have any P31. Let's fix that:

1. Open https://tools.wmflabs.org/pltools/harvesttemplates/ and set Wiki=pl.wikipedia.org, Property=P31, Template=Meteoryt infobox, Parameter=0
2. Press on "get values" then "demo". Do NOT press on "add values"!
3. Wait for the demo to finish (this step retrieves the QIDs, all lines become red, don't worry)
4. Press "TSV" to download the data in Gnumeric
5. Keep only the second column "qid"
6. Add a second column with header "P31" and "Q9252191" (replace with the QID of the class you want these items to be an instance of) on all rows
7. Copy the data into Geany, replace all tabs with a comma
8. Open https://tools.wmflabs.org/quickstatements and import as CSV
9. Run

Business hours

Wikidata:Property_proposal/opening_hours_(v.3)

# Museums around me that are open right now
SELECT ?place ?location ?distance ?placeLabel WHERE {
 
 # Museums
 ?place p:P31/ps:P31/wdt:P279* wd:Q33506.
 
 # Open today
 # TODO
 
 # Open today at now's time
 # TODO
 
 # Around me
 SERVICE wikibase:around {
   ?place wdt:P625 ?location . 
   bd:serviceParam wikibase:center "Point(-122.399523 37.786952)"^^geo:wktLiteral .
   bd:serviceParam wikibase:radius "1" . 
   bd:serviceParam wikibase:distance ?distance .
 } 
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?distance LIMIT 10