User:Daniel/QuickStatements: Difference between revisions

From MaRDI portal
Line 17: Line 17:
* [https://query.portal.mardi4nfdi.de/#%23%20This%20query%20produces%20statements%20for%0A%23%20https%3A%2F%2Fquickstatements.portal.mardi4nfdi.de%2F%23%2Fbatch%2Fnew%0A%23%20Help%3A%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FHelp%3AQuickStatements%20.%0A%23%20Query%20purpose%3A%20add%20Wikidata%20QID%20to%20MaRDI%20items%20about%20journals%0A%23%20sample%20paper%20item%3A%20Q4616786%20%28MaRDI%29%20%2F%20Q50938572%20%28Wikidata%29%0A%23%20sample%20journal%20item%3A%20Q2713763%20%28MaRDI%29%20%2F%20Q15756967%20%28Wikidata%29%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%3Fpublished_in%0A%23%20%3FWikidata_paper_QID%0A%23%20%3FWikidata_paper_URI%0A%23%20%3FWikidata_journal%0A%23%23%23%23%23%23%23%0A%0A%28REPLACE%28STR%28%3Fpublished_in%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%20AS%20%3Fmardi_qid%29%20%0A%28%22P12%22%20AS%20%3Fproperty%29%0A%28CONCAT%28%22%5C%22%22%2C%20REPLACE%28STR%28%3FWikidata_journal%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%2C%20%22%5C%22%22%29%20AS%20%3Fwikidata_qid%29%20%0A%0AWHERE%20%7B%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fmardi_item%20wdt%3AP200%20%3Fpublished_in%20.%20bd%3AserviceParam%20bd%3Asample.limit%20800000%20%7D%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fpublished_in%20wdt%3AP12%20%3FWikidataQID%20%7D%0A%0A%20%20%3Fmardi_item%20wdt%3AP12%20%3FWikidata_paper_QID%20.%0A%20%20BIND%28URI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FWikidata_paper_QID%29%29%20AS%20%3FWikidata_paper_URI%29%0A%20%20service%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%3FWikidata_paper_URI%20wikidata_wdt%3AP1433%20%3FWikidata_journal%20.%0A%20%20%20%20%0A%20%20%7D%0A%7D%0A%23%20LIMIT%20500 Add Wikidata QID statements to MaRDI items about journals, based on matching "published in" statements of papers in both MaRDI and Wikidata]
* [https://query.portal.mardi4nfdi.de/#%23%20This%20query%20produces%20statements%20for%0A%23%20https%3A%2F%2Fquickstatements.portal.mardi4nfdi.de%2F%23%2Fbatch%2Fnew%0A%23%20Help%3A%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FHelp%3AQuickStatements%20.%0A%23%20Query%20purpose%3A%20add%20Wikidata%20QID%20to%20MaRDI%20items%20about%20journals%0A%23%20sample%20paper%20item%3A%20Q4616786%20%28MaRDI%29%20%2F%20Q50938572%20%28Wikidata%29%0A%23%20sample%20journal%20item%3A%20Q2713763%20%28MaRDI%29%20%2F%20Q15756967%20%28Wikidata%29%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%3Fpublished_in%0A%23%20%3FWikidata_paper_QID%0A%23%20%3FWikidata_paper_URI%0A%23%20%3FWikidata_journal%0A%23%23%23%23%23%23%23%0A%0A%28REPLACE%28STR%28%3Fpublished_in%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%20AS%20%3Fmardi_qid%29%20%0A%28%22P12%22%20AS%20%3Fproperty%29%0A%28CONCAT%28%22%5C%22%22%2C%20REPLACE%28STR%28%3FWikidata_journal%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%2C%20%22%5C%22%22%29%20AS%20%3Fwikidata_qid%29%20%0A%0AWHERE%20%7B%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fmardi_item%20wdt%3AP200%20%3Fpublished_in%20.%20bd%3AserviceParam%20bd%3Asample.limit%20800000%20%7D%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fpublished_in%20wdt%3AP12%20%3FWikidataQID%20%7D%0A%0A%20%20%3Fmardi_item%20wdt%3AP12%20%3FWikidata_paper_QID%20.%0A%20%20BIND%28URI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FWikidata_paper_QID%29%29%20AS%20%3FWikidata_paper_URI%29%0A%20%20service%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%3FWikidata_paper_URI%20wikidata_wdt%3AP1433%20%3FWikidata_journal%20.%0A%20%20%20%20%0A%20%20%7D%0A%7D%0A%23%20LIMIT%20500 Add Wikidata QID statements to MaRDI items about journals, based on matching "published in" statements of papers in both MaRDI and Wikidata]
* For authors with no label on MaRDI, add name from Wikidata if available
* For authors with no label on MaRDI, add name from Wikidata if available
** example: [[Item:Q6165511]]
** examples: [[Item:Q6165511]], [[Item:Q6157974]]
* For authors only known to MaRDI by their initials, add full name from Wikidata if available
* For authors only known to MaRDI by their initials, add full name from Wikidata if available
* Add [https://query.portal.mardi4nfdi.de/#%23%20This%20query%20produces%20statements%20for%0A%23%20https%3A%2F%2Fquickstatements.portal.mardi4nfdi.de%2F%23%2Fbatch%2Fnew%0A%23%20Help%3A%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FHelp%3AQuickStatements%20.%0A%23%20Query%20purpose%3A%20add%20MaRDI%20Profile%20type%20to%20MaRDI%20items%20about%20papers%0A%23%20sample%20paper%20item%3A%20Q5980529%20%28MaRDI%29%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%3Fmardi_item%0A%3Fmardi_item_label%0A%3Finstance%0A%23%23%23%23%23%23%23%0A%0A%23%20%28REPLACE%28STR%28%3Fmardi_item%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%20AS%20%3Fmardi_qid%29%20%0A%23%20%28%22P1460%22%20AS%20%3Fprofile_type%29%0A%23%20%28%22Q5976449%22%20AS%20%3Fpublication%29%20%0A%0AWHERE%20%7B%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fmardi_item%20wdt%3AP31%20%3Finstance%20.%20bd%3AserviceParam%20bd%3Asample.limit%2020000%20%7D%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fmardi_item%20wdt%3AP1460%20%3Fprofile_type%20.%20%7D%0A%20%20%3Fmardi_item%20rdfs%3Alabel%20%3Fmardi_item_label%20.%0A%20%20FILTER%20%28LANG%28%3Fmardi_item_label%29%20%3D%20%22en%22%29%0A%0A%7D%0A%23%20LIMIT%20500 missing MaRDI profile type] (see also [[Project:Profile types]]) to
* Add [https://query.portal.mardi4nfdi.de/#%23%20This%20query%20produces%20statements%20for%0A%23%20https%3A%2F%2Fquickstatements.portal.mardi4nfdi.de%2F%23%2Fbatch%2Fnew%0A%23%20Help%3A%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FHelp%3AQuickStatements%20.%0A%23%20Query%20purpose%3A%20add%20MaRDI%20Profile%20type%20to%20MaRDI%20items%20about%20papers%0A%23%20sample%20paper%20item%3A%20Q5980529%20%28MaRDI%29%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%3Fmardi_item%0A%3Fmardi_item_label%0A%3Finstance%0A%23%23%23%23%23%23%23%0A%0A%23%20%28REPLACE%28STR%28%3Fmardi_item%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%20AS%20%3Fmardi_qid%29%20%0A%23%20%28%22P1460%22%20AS%20%3Fprofile_type%29%0A%23%20%28%22Q5976449%22%20AS%20%3Fpublication%29%20%0A%0AWHERE%20%7B%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fmardi_item%20wdt%3AP31%20%3Finstance%20.%20bd%3AserviceParam%20bd%3Asample.limit%2020000%20%7D%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fmardi_item%20wdt%3AP1460%20%3Fprofile_type%20.%20%7D%0A%20%20%3Fmardi_item%20rdfs%3Alabel%20%3Fmardi_item_label%20.%0A%20%20FILTER%20%28LANG%28%3Fmardi_item_label%29%20%3D%20%22en%22%29%0A%0A%7D%0A%23%20LIMIT%20500 missing MaRDI profile type] (see also [[Project:Profile types]]) to

Revision as of 00:41, 3 May 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

Target: Wikidata

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