User:Daniel/Queries/Federated: Difference between revisions

← Older edit

VisualWikitext

Latest revision as of 16:18, 5 May 2024

MaRDI 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
  - more refined variant

MaRDI and OpenStreetMap

places

Wikidata and LinkedGeoData

Munich ATMs

Wikidata and OpenStreetMap

Berlin

Wikidata and WikiPathways

metabolites

@@ Line 1: / Line 1: @@
 == MaRDI and Wikidata ==
 * [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%0ASELECT%20%2a%20WHERE%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%3Fwd%20wikidata_wdt%3AP31%20wikidata_wd%3AQ976981%20.%0A%20%20%20%20%20%20%3Fwd%20wikidata_wdt%3AP31%20%3Ftype%20.%0A%20%20%20%20%20%20optional%20%7B%20%3Fwd%20rdfs%3Alabel%20%3Flabel.%20filter%28lang%28%3Flabel%29%20%3D%20%22en%22%29%20%7D%0A%20%20%20%20%20%20optional%20%7B%20%3Ftype%20rdfs%3Alabel%20%3Ftypelabel.%20filter%28lang%28%3Ftypelabel%29%20%3D%20%22en%22%29%20%7D%0A%20%20%20%7D%0A%0A%7D%0ALIMIT%2050 formulas]
+* [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%0ASELECT%20%2a%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP676%20%3FzbMATH_author%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem%20wdt%3AP12%20%3FWikidataID%20.%20%7D%0A%20%20%3Flink%20schema%3Aabout%20%3Fitem%20.%20%0A%20%20%3Flink%20schema%3AinLanguage%20%22en%22%20.%0A%20%20%20%20service%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%20%20%3Fwd%20wikidata_wdt%3AP1556%20%3FzbMATH_author%20.%0A%20%20%20%7D%0A%7D%0ALIMIT%205000 match between MaRDI and Wikidata by zbMATH author ID]
+** [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%0ASELECT%20%0A%23%20%20%20%3Fitem%0A%20%20%28REPLACE%28STR%28%3Fitem%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%20AS%20%3Fqid%29%20%0A%20%20%28%22P12%22%20AS%20%3Fproperty%29%0A%20%20%28CONCAT%28%22%5C%22%22%2C%20REPLACE%28STR%28%3Fwd%29%2C%20%22.%2aQ%22%2C%20%22Q%22%29%2C%20%22%5C%22%22%29%20AS%20%3Fqid_wd%29%20%0A%23%20%20%20%28%22S178%22%20AS%20%3Fheuristic%29%20%3D%3D%3E%20This%20does%20not%20work%20yet%0A%23%20%20%20%28%22Q3441661%22%20AS%20%3Fdeduced%29%0A%0AWHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP676%20%3FzbMATH_author%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem%20wdt%3AP12%20%3FWikidataID%20.%20%7D%0A%20%20%3Flink%20schema%3Aabout%20%3Fitem%20.%20%0A%20%20%3Flink%20schema%3AinLanguage%20%22en%22%20.%0A%20%20%20%20service%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%20%20%3Fwd%20wikidata_wdt%3AP1556%20%3FzbMATH_author%20.%0A%20%20%20%7D%0A%7D%0ALIMIT%205000 variant] that produces QuickStatements commands to be used on the [https://quickstatements.portal.mardi4nfdi.de/#/ MaRDI QuickStatements instance]
+*** [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]
 == MaRDI and OpenStreetMap ==
@@ Line 18: / Line 21: @@
 == See also ==
 * [https://wiki.openstreetmap.org/wiki/Sophox https://wiki.openstreetmap.org/wiki/Sophox]
+* [https://hhs.github.io/meshrdf/sample-queries MeSH RDF]
+* [https://github.com/frmichel/sparql-micro-service SPARQL Micro-Services]
+** [https://sparql-micro-services.org/service/pubmed/getArticleByPMId_sd/ demo]
+*** [https://github.com/frmichel/sparql-micro-services.org code for demo site]
+* [https://doi.org/10.5281/zenodo.8332776 Who is using Knowledge Graphs in NFDI? An overview by the Working Group "Knowledge Graphs"]
+** e.g. [https://nfdi4culture.de/resources/knowledge-graph.html#query=%23%20DataPortals-Standards%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX%20nfdicore%3A%20%3Chttps%3A%2F%2Fnfdi.fiz-karlsruhe.de%2Fontology%2F%3E%0APREFIX%20n4c%3A%20%3Chttps%3A%2F%2Fnfdi4culture.de%2Fid%2F%3E%0A%0ASELECT%20%3FdataPortal%20%3FdataPortalLabel%20%3Fstandard%20%3FstandardLabel%20WHERE%20%7B%0A%20%20%20%20VALUES%20%3FdataPortal%20%7Bn4c%3AE5232%20n4c%3AE5155%20n4c%3AE4115%20n4c%3AE4230%20n4c%3AE4254%20n4c%3AE4243%20n4c%3AE4256%20n4c%3AE4227%20n4c%3AE4234%20n4c%3AE4240%20n4c%3AE4242%20n4c%3AE4237%20n4c%3AE4239%20n4c%3AE3590%20n4c%3AE4245%20n4c%3AE4235%20n4c%3AE4247%20n4c%3AE4263%20n4c%3AE3594%20n4c%3AE4268%20n4c%3AE4269%20n4c%3AE4266%20n4c%3AE4238%20n4c%3AE4262%20n4c%3AE4250%20n4c%3AE4244%20n4c%3AE4261%20n4c%3AE4270%20n4c%3AE4265%20n4c%3AE3896%20n4c%3AE4252%20n4c%3AE4258%20n4c%3AE4249%20n4c%3AE4264%20n4c%3AE4251%20n4c%3AE4246%20n4c%3AE4259%20%7D%0A%20%20%20%20%3FdataPortal%20rdf%3Atype%20nfdicore%3ADataPortal%20.%0A%20%20%20%20%3FdataPortal%20rdfs%3Alabel%20%3FdataPortalLabel.%0A%20%20%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%20%20%3FdataPortal%20nfdicore%3Astandard%20%3Fstandard.%0A%20%20%20%20%20%20%20%20%3Fstandard%20rdfs%3Alabel%20%3FstandardLabel.%0A%20%20%20%20%7D%0A%0A%7D%20ORDER%20BY%20DESC(%3Fstandard)%0A&endpoint=https%3A%2F%2Fnfdi4culture.de%2Fsparql&requestMethod=POST&tabTitle=DataPortal-Standard&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq%3D0.9&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq%3D0.9&outputFormat=table NFDI4Culture's SPARQL endpoint]
+*** [https://nfdi.fiz-karlsruhe.de/shmarql?g=&e=_local_&s=%3Chttps%3A//nfdi4culture.de/id/E4872%3E sample entry for a MaRDI-indexed person]
+* [[Links]]