User:Daniel/Queries/Federated: Difference between revisions
From MaRDI portal
< User:Daniel | Queries
| (5 intermediate revisions by the same user not shown) | |||
| Line 10: | Line 10: | ||
*** [https://query.portal.mardi4nfdi.de/#PREFIX%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%0APREFIX%20zbmath_candidate_string%3A%20%3Chttps%3A%2F%2Fzbmath.org%2Fauthors%2Faaberge.rolf%3E%0A%0ASELECT%20%0A%3Fitem%0A%3Fwikidata%0A%28REPLACE%28STR%28%3Fitem%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%20AS%20%3Fqid%29%20%0A%28%22P12%22%20AS%20%3Fproperty%29%0A%3FzbMATH_author%0A%0AWHERE%20%7B%0A%20%20BIND%20%28STRAFTER%28STR%28zbmath_candidate_string%3A%29%2C%20%22https%3A%2F%2Fzbmath.org%2Fauthors%2F%22%29%20AS%20%3FzbMATH_author%29%0A%20%20%3Fitem%20wdt%3AP676%20%3FzbMATH_author%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20service%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%20%20%3Fwikidata%20wikidata_wdt%3AP1556%20%3FzbMATH_author%20.%0A%20%20%20%20%7D%0A%20%20%7D%0A%7D%0ALIMIT%2010 more refined variant] | *** [https://query.portal.mardi4nfdi.de/#PREFIX%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%0APREFIX%20zbmath_candidate_string%3A%20%3Chttps%3A%2F%2Fzbmath.org%2Fauthors%2Faaberge.rolf%3E%0A%0ASELECT%20%0A%3Fitem%0A%3Fwikidata%0A%28REPLACE%28STR%28%3Fitem%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%20AS%20%3Fqid%29%20%0A%28%22P12%22%20AS%20%3Fproperty%29%0A%3FzbMATH_author%0A%0AWHERE%20%7B%0A%20%20BIND%20%28STRAFTER%28STR%28zbmath_candidate_string%3A%29%2C%20%22https%3A%2F%2Fzbmath.org%2Fauthors%2F%22%29%20AS%20%3FzbMATH_author%29%0A%20%20%3Fitem%20wdt%3AP676%20%3FzbMATH_author%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20service%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%20%20%3Fwikidata%20wikidata_wdt%3AP1556%20%3FzbMATH_author%20.%0A%20%20%20%20%7D%0A%20%20%7D%0A%7D%0ALIMIT%2010 more refined variant] | ||
* check MaRDI items for Wikidata ID, then check Wikidata for images | * check MaRDI items for Wikidata ID, then check Wikidata for images | ||
== MaRDI portal and DBLP == | |||
* [https://sparql.dblp.org/sparql https://sparql.dblp.org/sparql] needs to be added to [https://github.com/MaRDI4NFDI/portal-compose/blob/main/wdqs/allowlist.txt allowlist] | |||
* [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%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%20dblp%3A%20%3Chttps%3A%2F%2Fdblp.org%2Frdf%2Fschema%23%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%3FDBLP%0A%3FDBLP_label%0A%3FDOI%0A%23%23%23%23%23%23%23%0A%0A%28REPLACE%28STR%28%3Fmardi_item%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%20AS%20%3Fmardi_qid%29%20%0A%28%22P1635%22%20AS%20%3Fproperty%29%0A%28CONCAT%28%22%5C%22%22%2C%20REPLACE%28STR%28%3FDBLP%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%2C%20%22%5C%22%22%29%20AS%20%3FDBLP4MaRDI%29%20%0A%0AWHERE%20%7B%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fmardi_item%20wdt%3AP27%20%3Fdoi%20.%20bd%3AserviceParam%20bd%3Asample.limit%2022000%20%7D%0A%23%20%20%20BIND%28UCASE%28%3Fdoi%29%20AS%20%3FDOI%29%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fmardi_item%20wdt%3AP1635%20%5B%5D%20%7D%20%0A%20%20service%20%3Chttps%3A%2F%2Fsparql.dblp.org%2Fsparql%3E%20%7B%0A%20%20%20%20%3FDBLP%20dblp%3Adoi%20%3Fdoi%20.%0A%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%7D%0A%23%20LIMIT%201000 sample query] | |||
== Wikidata and DBLP == | |||
* DBLP has to be added to Wikidata's allowlist | |||
* [https://w.wiki/BxqL Sample query] | |||
== MaRDI portal and FactGrid == | == MaRDI portal and FactGrid == | ||
| Line 56: | Line 66: | ||
* [https://nomisma.org/sparql/ Nomisma SPARQL endpoint] and [https://nomisma.org/documentation/sparql/ query examples] as well as [https://numishare.blogspot.com/2024/09/more-than-4000-monograms-published-to.html blog posts] | * [https://nomisma.org/sparql/ Nomisma SPARQL endpoint] and [https://nomisma.org/documentation/sparql/ query examples] as well as [https://numishare.blogspot.com/2024/09/more-than-4000-monograms-published-to.html blog posts] | ||
* [https://wb.manorhouses.tibwiki.io/wiki/Menschen Manor wiki & Wikidata] | * [https://wb.manorhouses.tibwiki.io/wiki/Menschen Manor wiki & Wikidata] | ||
** | ** [https://query.wb.manorhouses.tibwiki.io/#PREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wdqs%3A%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%0A%0A%23Show%20me%20all%20people%20in%20the%20database%20who%20have%20a%20Wikidata%20ID%20match%20and%20use%20this%20match%20to%20request%20zbMATH%20author%20IDs%20and%20images%20from%20Wikidata%20via%20federation%0A%23%20defaultView%3AImageGrid%0ASELECT%20Distinct%20%3Fperson%20%3FpersonLabel%20%3FzbMATH_author_id%20%3Fimage%0AWHERE%7B%0A%3Fperson%20tibt%3AP1%20tib%3AQ5.%0A%3Fperson%20tibt%3AP104%20%3FWikidata_id.%0A%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%0ABIND%28IRI%28CONCAT%28STR%28wd%3A%29%2C%20%3FWikidata_id%29%29%20AS%20%3FWikidata_item%29%0A%0ASERVICE%20wdqs%3A%20%7B%0A%20%20%3FWikidata_item%20wdt%3AP1556%20%3FzbMATH_author_id.%0A%20%20Optional%20%7B%3FWikidata_item%20wdt%3AP18%20%3Fimage.%7D%0A%7D%0A%7D%0AOrder%20by%20%3FpersonLabel%0ALimit%201000 this query] gives two intersections with MaRDI, including Friedrich II (with image) and Pehr Elvius (without) | ||
* [https://wp.dev.kgi.services.base4nfdi.de/kg_registry/ KGI4NFDI Registry] | |||
* [https://www.wikidata.org/wiki/User:ProteinBoxBot/SPARQL_Examples#Select_all_human_UniProt_entries_with_a_sequence_variant_that_leads_to_a_'loss_of_function'_and_also_physically_interact_with_(P129)_a_drug_with_a_qualifier_of_%22use%22_(P366)_of_%22enzyme_inhibitor%22_(Q427492) UniProt/ Wikidata examples] | |||
* [https://sparql.uniprot.org/.well-known/sparql-examples/ UniProt query examples] | |||
Latest revision as of 14:50, 3 April 2025
MaRDI portal and MathAlgodDB
MaRDI portal and Wikidata
- formulas
- match between MaRDI and Wikidata by zbMATH author ID
- variant that produces QuickStatements commands to be used on the MaRDI QuickStatements instance
- check MaRDI items for Wikidata ID, then check Wikidata for images
MaRDI portal and DBLP
- https://sparql.dblp.org/sparql needs to be added to allowlist
- sample query
Wikidata and DBLP
- DBLP has to be added to Wikidata's allowlist
- Sample query
MaRDI portal and FactGrid
FAQ
- Shall there be a "MaRDI item ID"/ "MaRDI property ID"/ "MaRDI entity ID" on FactGrid?
- Which MaRDI items should get a FactGrid ID?
- How many would that be?
- What properties can be used to mediate between MaRDI and FactGrid?
- Wikidata ID
- zbMATH author ID
- Should FactGrid-based information be included in MaRDI profiles?
- What about using sitelinks rather than external identifiers for mapping to other Wikibase instances? (example: Wilhelm Friedrich Ostwald in MaRDI (which maps to Wikidata via external ID) and in FactGrid (which uses sitelinks)
- What about magic links to other Wikibase instances, e.g. something like
factgrid:Item:Q865262for https://database.factgrid.de/wiki/Item:Q865262?
MaRDI portal and OpenStreetMap
FAIRJupyter and MaRDI portal
Wikidata and LinkedGeoData
Wikidata and OpenStreetMap
Wikidata and WikiPathways
See also
- https://wiki.openstreetmap.org/wiki/Sophox
- MeSH RDF
- SPARQL Micro-Services
- Who is using Knowledge Graphs in NFDI? An overview by the Working Group "Knowledge Graphs"
- Links
- Nomisma SPARQL endpoint and query examples as well as blog posts
- Manor wiki & Wikidata
- this query gives two intersections with MaRDI, including Friedrich II (with image) and Pehr Elvius (without)
- KGI4NFDI Registry
- UniProt/ Wikidata examples
- UniProt query examples
