User:Daniel/QuickStatements: Difference between revisions

Revision as of 06:00, 7 March 2024

About

This page assists in managing queries that produce output in a format that can serve as input to QuickStatements, either on the MaRDI instance or on the Wikidata one.

Target: MaRDI

QuickStatements URL: https://quickstatements.portal.mardi4nfdi.de/#/batch/new

Add Wikidata QID statements to MaRDI items about works, based on DOI lookup
- No case normalization yet
  - draft variant for case normalization
Add Wikidata QID statements to MaRDI items about authors, based on zbMATH Author ID lookup
Add DOI statements to MaRDI based on zbMATH document ID lookup
Add zbMATH author ID statements to MaRDI based on ORCID lookup
Add DBLP author ID statements to MaRDI based on ORCID lookup
Add ORCID statements based on zbMATH lookup in Wikidata
Add Wikidata QID statements to MaRDI items about journals, based on matching "published in" statements of papers in both MaRDI and Wikidata
For authors only known to MaRDI by their initials, add full name from Wikidata if available

Target: Wikidata

QuickStatements URL: https://quickstatements.toolforge.org/#/batch

Add zbMATH document ID statements to Wikidata based on DOI lookup
- Watch out for values of None
- Case-normalized
WikiProject tagging based on zbMATH author ID or zbMATH document ID
- just for zbMATH doc ID
Add DOI statements to Wikidata based on zbMATH document ID lookup
Add zbMATH author ID statements to Wikidata based on ORCID lookup
Create Wikidata lexemes based on zbMATH keyword string
Add "occupation: researcher" to Wikidata items with zbMATH author ID but no occupation statement
add zbMATH author statements to Wikidata items based on MaRDI zbMATH
- start with single-author papers (draft query)
math awards
add "describes a project that uses" statements to Wikidata

@@ Line 22: / Line 22: @@
 :QuickStatements URL: [https://quickstatements.toolforge.org/#/batch https://quickstatements.toolforge.org/#/batch]
-* [https://query.portal.mardi4nfdi.de/#%23%20This%20query%20produces%20statements%20for%0A%23%20https%3A%2F%2Fquickstatements.toolforge.org%2F%23%2Fbatch%2Fnew%0A%23%20Help%3A%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FHelp%3AQuickStatements%20.%0A%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fentity%2F%3E%0A%0APREFIX%20wikidata_wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wikidata_wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20DISTINCT%0A%0A%23%23%23%23%23%23%23%0A%23%20To%20get%20the%20QuickStatements%20commands%2C%20comment%20out%20the%20lines%20until%20the%20next%20hash%20line%0A%23%20%3Fmardi_item%0A%23%20%23%20%3Fmardi_item_label%0A%23%20%3Fwikidata%0A%23%20%23%20%3Fwikidata_label%0A%23%20%3FzbMATH_docID%0A%23%20%3FDOI%0A%23%23%23%23%23%23%23%0A%0A%28REPLACE%28STR%28%3Fwikidata%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%20AS%20%3Fwikidata_qid%29%20%0A%28%22P894%22%20AS%20%3Fproperty%29%0A%28CONCAT%28%22%5C%22%22%2C%20STR%28%3FzbMATH_docID%29%2C%20%22%5C%22%22%29%20AS%20%3FzbMATH_docID_string%29%20%0A%0AWHERE%20%7B%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fmardi_item%20wdt%3AP225%20%3FzbMATH_docID%20.%20bd%3AserviceParam%20bd%3Asample.limit%2010000%20%7D%0A%20%20FILTER%20%28%3FzbMATH_docID%20%21%3D%20%22None%22%29%0A%20%20%3Fmardi_item%20wdt%3AP27%20%3FDOI%20.%0A%20%20service%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%3Fwikidata%20wikidata_wdt%3AP356%20%3FDOI%20.%0A%20%20%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fwikidata%20wdt%3AP894%20%3FzbMATH_docID%20%7D%20%0A%23%20%20%20%20%20%3Fwikidata%20rdfs%3Alabel%20%3Fwikidata_label%20.%0A%23%20%20%20%20%20FILTER%20%28LANG%28%3Fwikidata_label%29%20%3D%20%22en%22%29%0A%20%20%7D%0A%23%20%20%20%3Fmardi_item%20rdfs%3Alabel%20%3Fmardi_item_label%20.%0A%23%20%20%20FILTER%20%28LANG%28%3Fmardi_item_label%29%20%3D%20%22en%22%29%0A%7D%0ALIMIT%201000 Add zbMATH document ID statements to Wikidata based on DOI lookup]
+* [https://query.portal.mardi4nfdi.de/#%23%20This%20query%20produces%20statements%20for%0A%23%20https%3A%2F%2Fquickstatements.toolforge.org%2F%23%2Fbatch%2Fnew%0A%23%20Help%3A%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FHelp%3AQuickStatements%20.%0A%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fentity%2F%3E%0A%0APREFIX%20wikidata_wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wikidata_wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20DISTINCT%0A%0A%23%23%23%23%23%23%23%0A%23%20To%20get%20the%20QuickStatements%20commands%2C%20comment%20out%20the%20lines%20until%20the%20next%20hash%20line%0A%23%20%3Fmardi_item%0A%23%20%23%20%3Fmardi_item_label%0A%23%20%3Fwikidata%0A%23%20%23%20%3Fwikidata_label%0A%23%20%3FzbMATH_docID%0A%23%20%3FDOI%0A%23%23%23%23%23%23%23%0A%0A%28REPLACE%28STR%28%3Fwikidata%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%20AS%20%3Fwikidata_qid%29%20%0A%28%22P894%22%20AS%20%3Fproperty%29%0A%28CONCAT%28%22%5C%22%22%2C%20STR%28%3FzbMATH_docID%29%2C%20%22%5C%22%22%29%20AS%20%3FzbMATH_docID_string%29%20%0A%0AWHERE%20%7B%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fmardi_item%20wdt%3AP225%20%3FzbMATH_docID%20.%20bd%3AserviceParam%20bd%3Asample.limit%2010000%20%7D%0A%20%20FILTER%20%28%3FzbMATH_docID%20%21%3D%20%22None%22%29%0A%20%20%3Fmardi_item%20wdt%3AP27%20%3FDOI%20.%0A%20%20service%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%3Fwikidata%20wikidata_wdt%3AP356%20%3FDOI%20.%0A%20%20%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fwikidata%20wikidata_wdt%3AP894%20%3FzbMATH_docID%20%7D%20%0A%23%20%20%20%20%20%3Fwikidata%20rdfs%3Alabel%20%3Fwikidata_label%20.%0A%23%20%20%20%20%20FILTER%20%28LANG%28%3Fwikidata_label%29%20%3D%20%22en%22%29%0A%20%20%7D%0A%23%20%20%20%3Fmardi_item%20rdfs%3Alabel%20%3Fmardi_item_label%20.%0A%23%20%20%20FILTER%20%28LANG%28%3Fmardi_item_label%29%20%3D%20%22en%22%29%0A%7D%0ALIMIT%201000 Add zbMATH document ID statements to Wikidata based on DOI lookup]
 ** Watch out for values of [http://tinyurl.com/yq73olp7 None]
 ** [https://query.portal.mardi4nfdi.de/#%23%20This%20query%20produces%20statements%20for%0A%23%20https%3A%2F%2Fquickstatements.toolforge.org%2F%23%2Fbatch%2Fnew%0A%23%20Help%3A%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FHelp%3AQuickStatements%20.%0A%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fentity%2F%3E%0A%0APREFIX%20wikidata_wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wikidata_wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20DISTINCT%0A%0A%23%23%23%23%23%23%23%0A%23%20To%20get%20the%20QuickStatements%20commands%2C%20comment%20out%20the%20lines%20until%20the%20next%20hash%20line%0A%23%20%3Fmardi_item%0A%23%20%23%20%3Fmardi_item_label%0A%23%20%3Fwikidata%0A%23%20%23%20%3Fwikidata_label%0A%23%20%3FzbMATH_docID%0A%23%20%3FDOI%0A%23%23%23%23%23%23%23%0A%0A%28REPLACE%28STR%28%3Fwikidata%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%20AS%20%3Fwikidata_qid%29%20%0A%28%22P894%22%20AS%20%3Fproperty%29%0A%28CONCAT%28%22%5C%22%22%2C%20STR%28%3FzbMATH_docID%29%2C%20%22%5C%22%22%29%20AS%20%3FzbMATH_docID_string%29%20%0A%0AWHERE%20%7B%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fmardi_item%20wdt%3AP225%20%3FzbMATH_docID%20.%20bd%3AserviceParam%20bd%3Asample.limit%2010000%20%7D%0A%20%20FILTER%20%28%3FzbMATH_docID%20%21%3D%20%22None%22%29%0A%20%20%3Fmardi_item%20wdt%3AP27%20%3Fdoi%20.%0A%20%20BIND%28UCASE%28%3Fdoi%29%20AS%20%3FDOI%29%0A%20%20service%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%3Fwikidata%20wikidata_wdt%3AP356%20%3FDOI%20.%0A%20%20%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fwikidata%20wikidata_wdt%3AP894%20%3FzbMATH_docID%20%7D%20%0A%23%20%20%20%20%20%3Fwikidata%20rdfs%3Alabel%20%3Fwikidata_label%20.%0A%23%20%20%20%20%20FILTER%20%28LANG%28%3Fwikidata_label%29%20%3D%20%22en%22%29%0A%20%20%7D%0A%23%20%20%20%3Fmardi_item%20rdfs%3Alabel%20%3Fmardi_item_label%20.%0A%23%20%20%20FILTER%20%28LANG%28%3Fmardi_item_label%29%20%3D%20%22en%22%29%0A%7D%0A%23%20LIMIT%201000 Case-normalized]