User:Syced: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
Tag: 2017 source edit |
Tag: 2017 source edit |
||
Line 9: | Line 9: | ||
* [https://query.wikidata.org/#SELECT%20%3Fq%20WHERE%20%7B%0A%20SERVICE%20wikibase%3Aaround%7B%3Fq%20wdt%3AP625%20%3Flocation.%20bd%3AserviceParam%20wikibase%3Acenter%20%22Point%28139.735064%2035.660428%29%22%5E%5Egeo%3AwktLiteral.%20bd%3AserviceParam%20wikibase%3Aradius%20%225%22.%7D%0A%20MINUS%20%7B%20%3Fq%20wdt%3AP18%20%3Fimage%20%7D%0A%20MINUS%20%7B%20%3Fq%20wdt%3AP31%20%3Fclass%20%7D%0A%7D%20LIMIT%20100 Add] {{P|31}} to items around you. |
* [https://query.wikidata.org/#SELECT%20%3Fq%20WHERE%20%7B%0A%20SERVICE%20wikibase%3Aaround%7B%3Fq%20wdt%3AP625%20%3Flocation.%20bd%3AserviceParam%20wikibase%3Acenter%20%22Point%28139.735064%2035.660428%29%22%5E%5Egeo%3AwktLiteral.%20bd%3AserviceParam%20wikibase%3Aradius%20%225%22.%7D%0A%20MINUS%20%7B%20%3Fq%20wdt%3AP18%20%3Fimage%20%7D%0A%20MINUS%20%7B%20%3Fq%20wdt%3AP31%20%3Fclass%20%7D%0A%7D%20LIMIT%20100 Add] {{P|31}} to items around you. |
||
* Add {{P|2910}} to most core items |
* Add {{P|2910}} to most core items |
||
* Select image for items that have a Commons category but no image |
|||
* Tables to write SPARQL queries for: [https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Fimage%20WHERE%20%7B%0A%20%23%3Fitem%20p%3AP31%2Fps%3AP31%2Fwdt%3AP279%2a%20wd%3AQ174211.%0A%20%3Fitem%20p%3AP31%2Fps%3AP31%20wd%3AQ174211.%0A%20OPTIONAL%7B%3Fitem%20wdt%3AP18%20%3Fimage.%7D%0A%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D organic compounds] |
* Tables to write SPARQL queries for: [https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Fimage%20WHERE%20%7B%0A%20%23%3Fitem%20p%3AP31%2Fps%3AP31%2Fwdt%3AP279%2a%20wd%3AQ174211.%0A%20%3Fitem%20p%3AP31%2Fps%3AP31%20wd%3AQ174211.%0A%20OPTIONAL%7B%3Fitem%20wdt%3AP18%20%3Fimage.%7D%0A%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D organic compounds] |
||
* [[Wikidata:WikiProject_sum_of_all_paintings/Possible_paintings]] |
* [[Wikidata:WikiProject_sum_of_all_paintings/Possible_paintings]] |
Revision as of 07:48, 10 January 2018
Babel user information | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
Users by language |
Please let me know If I am doing anything wrong!
TODO
- Harvest dissolutions of Japanese former territorial entities such as 泥江町
- Add embassies from https://ja.wikipedia.org/wiki/駐日外国公館の一覧
- 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) to most core items
- Select image for items that have a Commons category but no image
- 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
Memo
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:
- Open https://tools.wmflabs.org/pltools/harvesttemplates/ and set Property=P31, Template=Meteoryt infobox, Parameter=0
- Press on "demo". Do NOT press on "add values"!
- Wait for the demo to finish
- Press "TSV" to download the data in Gnumeric
- Keep only the second column "qid"
- Add a second column with header "P31" and "Q9252191" on all rows
- Copy the data into Geany, replace all tabs with a comma
- Open https://tools.wmflabs.org/quickstatements and import as CSV
- Run