NOSAD-POC: Difference between revisions

From oswald
Jump to navigation Jump to search
Line 5: Line 5:
** [https://oswald.wikibase.cloud/query/embed.html#%23%20https%3A%2F%2Fbeyond-notability.wikibase.cloud%2Fwiki%2FProject%3ASPARQL%2Fexamples%0A%23title%3A%20Presentationer%20utan%20startv%C3%A4rden%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wds%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2Fstatement%2F%3E%0APREFIX%20wdv%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fvalue%2F%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0APREFIX%20p%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fstatement%2F%3E%0APREFIX%20pq%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fqualifier%2F%3E%0A%23%202022-w42-7%0ASELECT%0A%3Fdt%20%3Fstart%0A%3Fpres%20%3FpresLabel%20%3ForgLabel%20%3FspkrLabel%0A%3Fvurl_t%20%0AWHERE%20%7B%0A%20%20%3Fpres%20wdt%3AP12%20wd%3AQ157%20.%20%23%20a%20Presentation%0A%20%20OPTIONAL%7B%3Fpres%20wdt%3AP14%20%3Forg%20.%7D%0A%20%20OPTIONAL%7B%3Fpres%20wdt%3AP20%20%3Fsess%20.%7D%0A%20%20OPTIONAL%7B%3Fsess%20wdt%3AP22%20%3Fdt%20.%7D%0A%20%20minus%7B%3Fpres%20wdt%3AP23%20%3Fstart%20.%7D%0A%20%20OPTIONAL%7B%3Fsess%20wdt%3AP16%20%3Fvurl%20.%7D%0A%20%20OPTIONAL%7B%3Fsess%20wdt%3AP21%20%3Fytid%20.%7D%0A%20%20OPTIONAL%7B%3Fpres%20wdt%3AP13%20%3Fspkr%20.%7D%0A%20%20OPTIONAL%7B%3Fsess%20wdt%3AP17%20%3Fagenda%20.%7D%0A%20%20%23%20BIND%20expressions%20referring%20to%20variables%20need%20to%20be%20outside%20OPTIONAL%20for%20some%20reason%3F%0A%20%20BIND%28COALESCE%28%3Fstart%2C%200%29%20AS%20%3Ft0%29.%0A%23%20%20%20BIND%28IF%28%3Ft0%20%3E%203000%2C%20%22late%22%2C%20%22early%22%29%20AS%20%3Ftest%29.%0A%20%20BIND%28IRI%28CONCAT%28STR%28%3Fvurl%29%2C%20IF%28%3Ft0%20%3E%200%2C%20CONCAT%28%22%23t%3D%22%2C%20STR%28%3Ft0%29%29%2C%20%22%22%29%29%29%20AS%20%3Fvurl_t%29%20.%0A%20%20BIND%28IRI%28CONCAT%28%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D%22%2C%20%3Fytid%2C%20IF%28%3Ft0%20%3E%200%2C%20CONCAT%28%22%23t%3D%22%2C%20STR%28%3Ft0%29%29%2C%20%22%22%29%29%29%20AS%20%3Fvurl_t%20%29%20.%0A%0A%20%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%20%23%20FILTER%20%28%3Fstart%20%3D%20%22%22%29%0A%7D%0AORDER%20BY%20DESC%28%3Fdt%29%20%3FsessLabel%20%28%21BOUND%28%3Fstart%29%29%20%3Fstart%20%3FpresLabel%0A%23GROUP%20BY%20%3FpLabel%20%3FvLabel%20%0A%23ORDER%20BY%20DESC%28%3Fcount%29 presentationer utan starttid]
** [https://oswald.wikibase.cloud/query/embed.html#%23%20https%3A%2F%2Fbeyond-notability.wikibase.cloud%2Fwiki%2FProject%3ASPARQL%2Fexamples%0A%23title%3A%20Presentationer%20utan%20startv%C3%A4rden%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wds%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2Fstatement%2F%3E%0APREFIX%20wdv%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fvalue%2F%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0APREFIX%20p%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fstatement%2F%3E%0APREFIX%20pq%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fqualifier%2F%3E%0A%23%202022-w42-7%0ASELECT%0A%3Fdt%20%3Fstart%0A%3Fpres%20%3FpresLabel%20%3ForgLabel%20%3FspkrLabel%0A%3Fvurl_t%20%0AWHERE%20%7B%0A%20%20%3Fpres%20wdt%3AP12%20wd%3AQ157%20.%20%23%20a%20Presentation%0A%20%20OPTIONAL%7B%3Fpres%20wdt%3AP14%20%3Forg%20.%7D%0A%20%20OPTIONAL%7B%3Fpres%20wdt%3AP20%20%3Fsess%20.%7D%0A%20%20OPTIONAL%7B%3Fsess%20wdt%3AP22%20%3Fdt%20.%7D%0A%20%20minus%7B%3Fpres%20wdt%3AP23%20%3Fstart%20.%7D%0A%20%20OPTIONAL%7B%3Fsess%20wdt%3AP16%20%3Fvurl%20.%7D%0A%20%20OPTIONAL%7B%3Fsess%20wdt%3AP21%20%3Fytid%20.%7D%0A%20%20OPTIONAL%7B%3Fpres%20wdt%3AP13%20%3Fspkr%20.%7D%0A%20%20OPTIONAL%7B%3Fsess%20wdt%3AP17%20%3Fagenda%20.%7D%0A%20%20%23%20BIND%20expressions%20referring%20to%20variables%20need%20to%20be%20outside%20OPTIONAL%20for%20some%20reason%3F%0A%20%20BIND%28COALESCE%28%3Fstart%2C%200%29%20AS%20%3Ft0%29.%0A%23%20%20%20BIND%28IF%28%3Ft0%20%3E%203000%2C%20%22late%22%2C%20%22early%22%29%20AS%20%3Ftest%29.%0A%20%20BIND%28IRI%28CONCAT%28STR%28%3Fvurl%29%2C%20IF%28%3Ft0%20%3E%200%2C%20CONCAT%28%22%23t%3D%22%2C%20STR%28%3Ft0%29%29%2C%20%22%22%29%29%29%20AS%20%3Fvurl_t%29%20.%0A%20%20BIND%28IRI%28CONCAT%28%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D%22%2C%20%3Fytid%2C%20IF%28%3Ft0%20%3E%200%2C%20CONCAT%28%22%23t%3D%22%2C%20STR%28%3Ft0%29%29%2C%20%22%22%29%29%29%20AS%20%3Fvurl_t%20%29%20.%0A%0A%20%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%20%23%20FILTER%20%28%3Fstart%20%3D%20%22%22%29%0A%7D%0AORDER%20BY%20DESC%28%3Fdt%29%20%3FsessLabel%20%28%21BOUND%28%3Fstart%29%29%20%3Fstart%20%3FpresLabel%0A%23GROUP%20BY%20%3FpLabel%20%3FvLabel%20%0A%23ORDER%20BY%20DESC%28%3Fcount%29 presentationer utan starttid]


* [https://oswald.wikibase.cloud/query/embed.html#%23%20https%3A%2F%2Fbeyond-notability.wikibase.cloud%2Fwiki%2FProject%3ASPARQL%2Fexamples%0A%23title%3A%20Talare%20NOSAD%20som%20str%C3%A4ng%2C%20WIkibase%20Q%20nummer%20%2C%20optional%20WD%20nummer%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%3FWD%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%3AP2%20%3FWDs%7D%0A%20%20BIND%28URI%28%3FWDs%29%20as%20%3FWD%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%3FspkrLabel%20 Presentatörerna som Oswald ID, Sträng, WD] - snyggt mönster [https://github.com/salgo60/NOSAD-POC-Wikidata/issues/8#issuecomment-1290477644 GITHUB kommentar]
* [https://oswald.wikibase.cloud/query/embed.html#%23%20https%3A%2F%2Fbeyond-notability.wikibase.cloud%2Fwiki%2FProject%3ASPARQL%2Fexamples%0A%23title%3A%20Talare%20NOSAD%20som%20str%C3%A4ng%2C%20WIkibase%20Q%20nummer%20%2C%20optional%20WD%20nummer%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%3FWD%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%3AP2%20%3FWDs%7D%0A%20%20BIND%28URI%28%3FWDs%29%20as%20%3FWD%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%3FspkrLabel%20 Presentatörerna som Oswald ID, Sträng, WD] - snyggt mönster [https://github.com/salgo60/NOSAD-POC-Wikidata/issues/8#issuecomment-1290477644 GITHUB kommentar] där alla presentatörer får en persistemt identifierare dvs. [https://www.go-fair.org/fair-principles/f1-meta-data-assigned-globally-unique-persistent-identifiers/ FAIRDATA F1]
** SPARQL Federation med Wikidata
** SPARQL Federation med Wikidata
*** [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Talare%20NOSAD%20d%C3%A4r%20WD%20har%20Twitter%20info%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%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%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%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]
*** Presentatörer vi har kopplade till företag med koordinat P625 eller säte xxx
*** Presentatörer vi har kopplade till företag med koordinat P625 eller säte xxx

Revision as of 13:40, 25 October 2022

NOSAD Wikibase POC