NOSAD-POC: Difference between revisions

From oswald
Jump to navigation Jump to search
No edit summary
Line 10: Line 10:
** SPARQL Federation med Wikidata
** SPARQL Federation med Wikidata
*** [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20d%C3%A4r%20WD%20har%20GITHUB%20info%20-%20SPARQL%20Federation%0A%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3FspkrOswald%20%3FspkrOswaldLabel%20%20%3Ftwitter%20%3FGITHUB%20%3FWDs%20%3FWD%0AWHERE%20%7B%0A%20%20VALUES%20%20%3FPresentation%20%7Bod%3AQ157%7D%0A%20%20%3Fpres%20odt%3AP12%20%20%3FPresentation%20%20.%20%0A%20%20%3Fpres%20odt%3AP13%20%3FspkrOswald%20.%0A%20%20%3FspkrOswald%20odt%3AP44%20%3FWDs%0A%23%20%20BIND%28URI%28REPLACE%28str%28%3FWDs%29%2C%22https%3A%2F%2Fwww.wikidata.org%2Fwiki%2F%22%2C%20%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%29%29%20as%20%3FWD%29%0A%20%20%20BIND%28URI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%3FWDs%29%29%20as%20%3FWD%29%0A%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP19%20%3Fbirth%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP18%20%3Fimg%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP2002%20%3FtwitterID%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP2037%20%3FGITHUBid%7D%0A%20%20%20%20%7D%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Ftwitter.com%2F%22%2C%3FtwitterID%29%29%20AS%20%3Ftwitter%29%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fgithub.com%2F%22%2C%3FGITHUBid%29%29%20AS%20%3FGITHUB%29%0A%20%20%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrOswaldLabel%20%0A%0A Om Wikidata vet om dom har GITHUB] / [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20d%C3%A4r%20WD%20inte%20har%20GITHUB%20-%20SPARQL%20Federation%0A%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3FspkrOswald%20%3FspkrOswaldLabel%20%20%3Ftwitter%20%3FGITHUB%0AWHERE%20%7B%0A%20%20VALUES%20%20%3FPresentation%20%7Bod%3AQ157%7D%0A%20%20%3Fpres%20odt%3AP12%20%20%3FPresentation%20%20.%20%0A%20%20%3Fpres%20odt%3AP13%20%3FspkrOswald%20.%0A%20%20%3FspkrOswald%20odt%3AP44%20%3FWDs%0A%23%20%20BIND%28URI%28REPLACE%28str%28%3FWDs%29%2C%22https%3A%2F%2Fwww.wikidata.org%2Fwiki%2F%22%2C%20%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%29%29%20as%20%3FWD%29%0A%20%20%20BIND%28URI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%3FWDs%29%29%20as%20%3FWD%29%0A%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP19%20%3Fbirth%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP18%20%3Fimg%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP2002%20%3FtwitterID%7D%0A%20%20%20%20minus%20%7B%3FWD%20wdt%3AP2037%20%3FGITHUBid%7D%0A%20%20%20%20%7D%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Ftwitter.com%2F%22%2C%3FtwitterID%29%29%20AS%20%3Ftwitter%29%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fgithub.com%2F%22%2C%3FGITHUBid%29%29%20AS%20%3FGITHUB%29%0A%20%20%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrOswaldLabel%20%0A%0Asaknar GITHUB info]
*** [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20d%C3%A4r%20WD%20har%20GITHUB%20info%20-%20SPARQL%20Federation%0A%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3FspkrOswald%20%3FspkrOswaldLabel%20%20%3Ftwitter%20%3FGITHUB%20%3FWDs%20%3FWD%0AWHERE%20%7B%0A%20%20VALUES%20%20%3FPresentation%20%7Bod%3AQ157%7D%0A%20%20%3Fpres%20odt%3AP12%20%20%3FPresentation%20%20.%20%0A%20%20%3Fpres%20odt%3AP13%20%3FspkrOswald%20.%0A%20%20%3FspkrOswald%20odt%3AP44%20%3FWDs%0A%23%20%20BIND%28URI%28REPLACE%28str%28%3FWDs%29%2C%22https%3A%2F%2Fwww.wikidata.org%2Fwiki%2F%22%2C%20%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%29%29%20as%20%3FWD%29%0A%20%20%20BIND%28URI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%3FWDs%29%29%20as%20%3FWD%29%0A%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP19%20%3Fbirth%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP18%20%3Fimg%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP2002%20%3FtwitterID%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP2037%20%3FGITHUBid%7D%0A%20%20%20%20%7D%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Ftwitter.com%2F%22%2C%3FtwitterID%29%29%20AS%20%3Ftwitter%29%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fgithub.com%2F%22%2C%3FGITHUBid%29%29%20AS%20%3FGITHUB%29%0A%20%20%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrOswaldLabel%20%0A%0A Om Wikidata vet om dom har GITHUB] / [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20d%C3%A4r%20WD%20inte%20har%20GITHUB%20-%20SPARQL%20Federation%0A%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3FspkrOswald%20%3FspkrOswaldLabel%20%20%3Ftwitter%20%3FGITHUB%0AWHERE%20%7B%0A%20%20VALUES%20%20%3FPresentation%20%7Bod%3AQ157%7D%0A%20%20%3Fpres%20odt%3AP12%20%20%3FPresentation%20%20.%20%0A%20%20%3Fpres%20odt%3AP13%20%3FspkrOswald%20.%0A%20%20%3FspkrOswald%20odt%3AP44%20%3FWDs%0A%23%20%20BIND%28URI%28REPLACE%28str%28%3FWDs%29%2C%22https%3A%2F%2Fwww.wikidata.org%2Fwiki%2F%22%2C%20%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%29%29%20as%20%3FWD%29%0A%20%20%20BIND%28URI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%3FWDs%29%29%20as%20%3FWD%29%0A%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP19%20%3Fbirth%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP18%20%3Fimg%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP2002%20%3FtwitterID%7D%0A%20%20%20%20minus%20%7B%3FWD%20wdt%3AP2037%20%3FGITHUBid%7D%0A%20%20%20%20%7D%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Ftwitter.com%2F%22%2C%3FtwitterID%29%29%20AS%20%3Ftwitter%29%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fgithub.com%2F%22%2C%3FGITHUBid%29%29%20AS%20%3FGITHUB%29%0A%20%20%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrOswaldLabel%20%0A%0Asaknar GITHUB info]
*** TODO [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20d%C3%A4r%20WD%20har%20Twitter%20info%20-%20%20SPARQL%20federation%0A%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3FspkrOswald%20%3FspkrOswaldLabel%20%20%3Ftwitter%0AWHERE%20%7B%0A%20%20VALUES%20%20%3FPresentation%20%7Bod%3AQ157%7D%0A%20%20%3Fpres%20odt%3AP12%20%20%3FPresentation%20%20.%20%0A%20%20%3Fpres%20odt%3AP13%20%3FspkrOswald%20.%0A%20%20%3FspkrOswald%20odt%3AP2%20%3FWDs%0A%20%20BIND%28URI%28REPLACE%28str%28%3FWDs%29%2C%22https%3A%2F%2Fwww.wikidata.org%2Fwiki%2F%22%2C%20%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%29%29%20as%20%3FWD%29%0A%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP19%20%3Fbirth%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP18%20%3Fimg%7D%0A%20%20%20%20%7B%3FWD%20wdt%3AP2002%20%3FtwitterID%7D%0A%20%20%20%20%7D%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Ftwitter.com%2F%22%2C%3FtwitterID%29%29%20AS%20%3Ftwitter%29%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrOswaldLabel%20%0A%0A Presentatörer med twitter]
*** [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20d%C3%A4r%20WD%20har%20Twitter%20info%20-%20%20SPARQL%20federation%0A%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3FspkrOswald%20%3FspkrOswaldLabel%20%20%3Ftwitter%0AWHERE%20%7B%0A%20%20VALUES%20%20%3FPresentation%20%7Bod%3AQ157%7D%0A%20%20%3Fpres%20odt%3AP12%20%20%3FPresentation%20%20.%20%0A%20%20%3Fpres%20odt%3AP13%20%3FspkrOswald%20.%0A%20%20%20%3FspkrOswald%20odt%3AP44%20%3FWDs%0A%20%20%20BIND%28URI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%3FWDs%29%29%20as%20%3FWD%29%0A%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP19%20%3Fbirth%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP18%20%3Fimg%7D%0A%20%20%20%20%7B%3FWD%20wdt%3AP2002%20%3FtwitterID%7D%0A%20%20%20%20%7D%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Ftwitter.com%2F%22%2C%3FtwitterID%29%29%20AS%20%3Ftwitter%29%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrOswaldLabel%20%0A%0A Presentatörer med twitter]
***[https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20med%20ORCID%20och%20visa%20dom%20p%C3%A5%20Scholia%0A%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3FspkrOswaldLabel%20%20%3Forcid%20%3FScholia%0AWHERE%20%7B%0A%20%20VALUES%20%20%3FPresentation%20%7Bod%3AQ157%7D%0A%20%20%3Fpres%20odt%3AP12%20%20%3FPresentation%20%20.%20%0A%20%20%3Fpres%20odt%3AP13%20%3FspkrOswald%20.%0A%20%20%3FspkrOswald%20odt%3AP2%20%3FWDs%0A%20%20BIND%28URI%28REPLACE%28str%28%3FWDs%29%2C%22https%3A%2F%2Fwww.wikidata.org%2Fwiki%2F%22%2C%20%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%29%29%20as%20%3FWD%29%0A%20%20%0A%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%3FWD%20wdt%3AP496%20%3Forcid%0A%20%20%20%20%7D%0A%20BIND%28URI%28REPLACE%28str%28%3FWDs%29%2C%22https%3A%2F%2Fwww.wikidata.org%2Fwiki%2F%22%2C%20%22https%3A%2F%2Fscholia.toolforge.org%2Fauthor%2F%22%29%29%20as%20%3FScholia%29%0A%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrOswaldLabel%20%0A%0A Presentatörer vi har med ORCID] --> koppling Scholia - se [https://github.com/salgo60/NOSAD-POC-Wikidata/issues/10#issuecomment-1290532705 GITHUB]
***[https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20med%20ORCID%20och%20visa%20dom%20p%C3%A5%20Scholia%0A%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3FspkrOswaldLabel%20%20%3Forcid%20%3FScholia%0AWHERE%20%7B%0A%20%20VALUES%20%20%3FPresentation%20%7Bod%3AQ157%7D%0A%20%20%3Fpres%20odt%3AP12%20%20%3FPresentation%20%20.%20%0A%20%20%3Fpres%20odt%3AP13%20%3FspkrOswald%20.%0A%20%20%3FspkrOswald%20odt%3AP44%20%3FWDs%0A%23%20%20BIND%28URI%28REPLACE%28str%28%3FWDs%29%2C%22https%3A%2F%2Fwww.wikidata.org%2Fwiki%2F%22%2C%20%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%29%29%20as%20%3FWD%29%0A%20%20%20BIND%28URI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%3FWDs%29%29%20as%20%3FWD%29%0A%20%0A%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20%3FWD%20wdt%3AP496%20%3Forcid%0A%20%20%20%20%7D%0A%20BIND%28URI%28REPLACE%28str%28%3FWDs%29%2C%22https%3A%2F%2Fwww.wikidata.org%2Fwiki%2F%22%2C%20%22https%3A%2F%2Fscholia.toolforge.org%2Fauthor%2F%22%29%29%20as%20%3FScholia%29%0A%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrOswaldLabel%20%0A%0A Presentatörer vi har med ORCID] --> koppling Scholia - se [https://github.com/salgo60/NOSAD-POC-Wikidata/issues/10#issuecomment-1290532705 GITHUB]
*** [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20d%C3%A4r%20WD%20har%20Twitter%20info%20och%20bild%20i%20WD%0A%23defaultView%3AImageGrid%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3FspkrOswald%20%3FspkrOswaldLabel%20%20%3Ftwitter%20%3Fimg%20%3FLinkedin%0AWHERE%20%7B%0A%20%20VALUES%20%20%3FPresentation%20%7Bod%3AQ157%7D%0A%20%20%3Fpres%20odt%3AP12%20%20%3FPresentation%20%20.%20%0A%20%20%3Fpres%20odt%3AP13%20%3FspkrOswald%20.%0A%20%20%3FspkrOswald%20odt%3AP2%20%3FWDs%0A%20%20BIND%28URI%28REPLACE%28str%28%3FWDs%29%2C%22https%3A%2F%2Fwww.wikidata.org%2Fwiki%2F%22%2C%20%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%29%29%20as%20%3FWD%29%0A%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP19%20%3Fbirth%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP18%20%3Fimg%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP2002%20%3FtwitterID%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP6634%20%3FLinkedinId%7D%0A%20%20%20%20%7D%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Ftwitter.com%2F%22%2C%3FtwitterID%29%29%20AS%20%3Ftwitter%29%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fwww.linkedin.com%2Fin%2F%22%2C%3FLinkedinId%29%29%20AS%20%3FLinkedin%29%0A%20%20%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrOswaldLabel%20%0A%0A Presentatören har bild i Wikidata]
*** [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20d%C3%A4r%20WD%20har%20Twitter%20info%20och%20bild%20i%20WD%0A%23defaultView%3AImageGrid%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3FspkrOswald%20%3FspkrOswaldLabel%20%20%3Ftwitter%20%3Fimg%20%3FLinkedin%0AWHERE%20%7B%0A%20%20VALUES%20%20%3FPresentation%20%7Bod%3AQ157%7D%0A%20%20%3Fpres%20odt%3AP12%20%20%3FPresentation%20%20.%20%0A%20%20%3Fpres%20odt%3AP13%20%3FspkrOswald%20.%0A%20%20%3FspkrOswald%20odt%3AP44%20%3FWDs%0A%23%20%20BIND%28URI%28REPLACE%28str%28%3FWDs%29%2C%22https%3A%2F%2Fwww.wikidata.org%2Fwiki%2F%22%2C%20%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%29%29%20as%20%3FWD%29%0A%20%20%20BIND%28URI%28CONCAT%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%3FWDs%29%29%20as%20%3FWD%29%0A%20%20%20SERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP19%20%3Fbirth%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP18%20%3Fimg%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP2002%20%3FtwitterID%7D%0A%20%20%20%20OPTIONAL%20%7B%3FWD%20wdt%3AP6634%20%3FLinkedinId%7D%0A%20%20%20%20%7D%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Ftwitter.com%2F%22%2C%3FtwitterID%29%29%20AS%20%3Ftwitter%29%0A%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fwww.linkedin.com%2Fin%2F%22%2C%3FLinkedinId%29%29%20AS%20%3FLinkedin%29%0A%20%20%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrOswaldLabel%20%0A%0A Presentatören har bild i Wikidata]
** [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20som%20str%C3%A4ng%2C%20Oswald%20koppling%20Linked%20in%20och%20Sveriges%20Dataportal%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3Fspkr%20%20%3FspkrLabel%20%3FDataportalen%20%3FLinkedin%20%3FGITHUB%0AWHERE%20%7B%0A%20%20%3Fpres%20odt%3AP12%20od%3AQ157%20.%20%23%20a%20Presentation%0A%20%20%3Fpres%20odt%3AP13%20%3Fspkr%20.%0A%20%20OPTIONAL%20%7B%3Fspkr%20odt%3AP31%20%3FDPid%7D%0A%20%20OPTIONAL%20%7B%3Fspkr%20odt%3AP27%20%3FLid%7D%0A%20%20OPTIONAL%20%7B%3Fspkr%20odt%3AP32%20%3FGid%7D%0A%20%20%0A%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fcommunity.dataportal.se%2Fuser%2F%22%2C%3FDPid%29%29%20as%20%3FDataportalen%29%0A%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fwww.linkedin.com%2Fin%2F%22%2C%3FLid%29%29%20as%20%3FLinkedin%29%0A%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fgithub.com%2F%22%2C%3FGid%29%29%20as%20%3FGITHUB%29%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrLabel%20 Presentatörer som finns på Dataportalen] se [https://github.com/salgo60/NOSAD-POC-Wikidata/issues/19 #19]
** [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20som%20str%C3%A4ng%2C%20Oswald%20koppling%20Linked%20in%20och%20Sveriges%20Dataportal%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20distinct%20%3Fspkr%20%20%3FspkrLabel%20%3FDataportalen%20%3FLinkedin%20%3FGITHUB%0AWHERE%20%7B%0A%20%20%3Fpres%20odt%3AP12%20od%3AQ157%20.%20%23%20a%20Presentation%0A%20%20%3Fpres%20odt%3AP13%20%3Fspkr%20.%0A%20%20OPTIONAL%20%7B%3Fspkr%20odt%3AP31%20%3FDPid%7D%0A%20%20OPTIONAL%20%7B%3Fspkr%20odt%3AP27%20%3FLid%7D%0A%20%20OPTIONAL%20%7B%3Fspkr%20odt%3AP32%20%3FGid%7D%0A%20%20%0A%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fcommunity.dataportal.se%2Fuser%2F%22%2C%3FDPid%29%29%20as%20%3FDataportalen%29%0A%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fwww.linkedin.com%2Fin%2F%22%2C%3FLid%29%29%20as%20%3FLinkedin%29%0A%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fgithub.com%2F%22%2C%3FGid%29%29%20as%20%3FGITHUB%29%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3FspkrLabel%20 Presentatörer som finns på Dataportalen] se [https://github.com/salgo60/NOSAD-POC-Wikidata/issues/19 #19]
*** [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20som%20finns%20p%C3%A5%20Sveriges%20Dataportal%0A%23defaultView%3ABubbleChart%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%20%3Flayer%20%20%28count%28%3Fspkr%29%20AS%20%3Fnr%29%0AWHERE%20%7B%0A%20%20%3Fpres%20odt%3AP12%20od%3AQ157%20.%20%23%20a%20Presentation%0A%20%20%3Fpres%20odt%3AP13%20%3Fspkr%20.%0A%20%20OPTIONAL%20%7B%3Fspkr%20odt%3AP31%20%3FDPid%7D%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%0A%20%20%7D%0A%20BIND%28%0A%20%20%20IF%28BOUND%28%3FDPid%29%2C%20%22Dataportalen%20user%22%2C%22not%20a%20User%22%29%0A%20%20%20%20AS%20%3Flayer%29.%0A%7D%20Group%20by%20%3Flayer%0A%20 Bubble chart användare vs. inte]
*** [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20som%20finns%20p%C3%A5%20Sveriges%20Dataportal%0A%23defaultView%3ABubbleChart%0APREFIX%20od%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20odt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%20%3Flayer%20%20%28count%28%3Fspkr%29%20AS%20%3Fnr%29%0AWHERE%20%7B%0A%20%20%3Fpres%20odt%3AP12%20od%3AQ157%20.%20%23%20a%20Presentation%0A%20%20%3Fpres%20odt%3AP13%20%3Fspkr%20.%0A%20%20OPTIONAL%20%7B%3Fspkr%20odt%3AP31%20%3FDPid%7D%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%0A%20%20%7D%0A%20BIND%28%0A%20%20%20IF%28BOUND%28%3FDPid%29%2C%20%22Dataportalen%20user%22%2C%22not%20a%20User%22%29%0A%20%20%20%20AS%20%3Flayer%29.%0A%7D%20Group%20by%20%3Flayer%0A%20 Bubble chart användare vs. inte]

Revision as of 19:32, 5 November 2022

NOSAD Wikibase POC

Misc

SPARQL Frågor

Lista föreläsningar i omvänd tidsordning med ID, titel, videolänk osv.

#title: Presentations latest first with ID, event, title, start time, video link etc.
# https://beyond-notability.wikibase.cloud/wiki/Project:SPARQL/examples
PREFIX wd: <https://oswald.wikibase.cloud/entity/>
PREFIX wds: <https://oswald.wikibase.cloud/entity/statement/>
PREFIX wdv: <https://oswald.wikibase.cloud/value/>
PREFIX wdt: <https://oswald.wikibase.cloud/prop/direct/>
PREFIX p: <https://oswald.wikibase.cloud/prop/>
PREFIX ps: <https://oswald.wikibase.cloud/prop/statement/>
PREFIX pq: <https://oswald.wikibase.cloud/prop/qualifier/>
# 2022-w42-7
SELECT
?dt ?sess ?sessLabel ?agenda ?start
?pres ?presLabel ?org ?orgLabel ?spkr ?spkrLabel
?vurl_t ?yturl_t
WHERE {
  ?pres wdt:P12 wd:Q157 . # a Presentation
  OPTIONAL{?pres wdt:P14 ?org .}
  OPTIONAL{?pres wdt:P20 ?sess .}
  OPTIONAL{?sess wdt:P22 ?dt .}
  OPTIONAL{?pres wdt:P23 ?start .}
  OPTIONAL{?sess wdt:P16 ?vurl .}
  OPTIONAL{?sess wdt:P21 ?ytid .}
  OPTIONAL{?pres wdt:P13 ?spkr .}
  OPTIONAL{?sess wdt:P17 ?agenda .}
  # BIND expressions referring to variables need to be outside OPTIONAL for some reason?
  BIND(COALESCE(?start, 0) AS ?t0).
  BIND(IRI(CONCAT(STR(?vurl), IF(?t0 > 0, CONCAT("#t=", STR(?t0)), ""))) AS ?vurl_t) .
  BIND(IRI(CONCAT("https://www.youtube.com/watch?v=", ?ytid, IF(?t0 > 0, CONCAT("#t=", STR(?t0)), ""))) AS ?yturl_t) .

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "sv,no,en-gb,en".
  }
}
ORDER BY DESC(?dt) ?sessLabel (!BOUND(?start)) ?start ?presLabel

Try it!

Hämta alla organisationer i Oswald som har koppling WD och hämta från WD med SPARQL federation deras Organisationsnummer, visa det på Quickstatement format

#title:  org hos NOSAD där WD har Organisationsnr P6460 info som saknas lokalt P37 som QuickStatement - SPARQL Federation
PREFIX od: <https://oswald.wikibase.cloud/entity/>
PREFIX odt: <https://oswald.wikibase.cloud/prop/direct/>

SELECT DISTINCT ?Oswald ("P37" AS ?P) ?orgnr WHERE {

  VALUES ?Orgobj {
    od:Q76
  }
  ?org odt:P12 ?Orgobj.
  ?org odt:P2 ?WDs.
  BIND(URI(REPLACE(STR(?WDs), "https://www.wikidata.org/wiki/", "http://www.wikidata.org/entity/")) AS ?WD)
  SERVICE <https://query.wikidata.org/sparql> {
    ?WD wdt:P6460 ?wdorg.
    BIND(CONCAT("\"", str(?wdorg), "\"") AS ?orgnr)
  }
  BIND(REPLACE(STR(?org), "https://oswald.wikibase.cloud/entity/", "") AS ?Oswald)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}
ORDER BY (?spkrOswaldLabel)

Try it!