NOSAD-POC: Difference between revisions
Jump to navigation
Jump to search
Magnus Sälgö (talk | contribs) |
Magnus Sälgö (talk | contribs) No edit summary |
||
(34 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
* [https://github.com/salgo60/NOSAD-POC-Wikidata github.com NOSAD-POC-Wikidata] | * '''Vad behövs för att leverera länkade data och förvalta en kunskapsgraf''' se [https://github.com/salgo60/DiggUptime/issues/70#issuecomment-1438535775 DIGG bör vara tankeledande och kunna tekniker som kunskapsgrafer svar chatGPT] | ||
* [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Lista%20f%C3%B6rel%C3%A4sningar%20i%20omv%C3%A4nd%20tidsordning%20med%20ID%2C%20titel%2C%20videol%C3%A4nk%20osv.%0A%23%20https%3A%2F%2Fbeyond-notability.wikibase.cloud%2Fwiki%2FProject%3ASPARQL%2Fexamples%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%3Fsess%20%3FsessLabel%20%3Fagenda%20%3Fstart%0A%3Fpres%20%3FpresLabel%20%3Forg%20%3ForgLabel%20%3Fspkr%20%3FspkrLabel%0A%23%20%3Ft%20%3Ft0%20%3Ftest%20%3Fvurl%20%3Fytid%0A%3Fvurl_t%20%3Fyturl_t%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%20OPTIONAL%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(COALESCE(%3Fstart%2C%200)%20AS%20%3Ft0).%0A%23%20%20%20BIND(IF(%3Ft0%20%3E%203000%2C%20%22late%22%2C%20%22early%22)%20AS%20%3Ftest).%0A%20%20BIND(IRI(CONCAT(STR(%3Fvurl)%2C%20IF(%3Ft0%20%3E%200%2C%20CONCAT(%22%23t%3D%22%2C%20STR(%3Ft0))%2C%20%22%22)))%20AS%20%3Fvurl_t)%20.%0A%20%20BIND(IRI(CONCAT(%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D%22%2C%20%3Fytid%2C%20IF(%3Ft0%20%3E%200%2C%20CONCAT(%22%23t%3D%22%2C%20STR(%3Ft0))%2C%20%22%22)))%20AS%20%3Fyturl_t)%20.%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Csv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20DESC(%3Fdt)%20%3FsessLabel%20(!BOUND(%3Fstart))%20%3Fstart%20%3FpresLabel%0A%23GROUP%20BY%20%3FpLabel%20%3FvLabel%20%0A%23ORDER%20BY%20DESC(%3Fcount) Lista NOSAD föreläsningar i denna databas] | |||
** [https://oswald.wikibase.cloud/query/embed.html#%23%20https%3A%2F%2Fbeyond-notability.wikibase.cloud%2Fwiki%2FProject%3ASPARQL%2Fexamples%0A%23title%3A%20Kort%20lista%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%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%20OPTIONAL%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%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 kortlista] | |||
== POC using NOSAD metadata in a Wikibase.cloud instance == | |||
[https://nosad.se/ NOSAD] a "Network Open Source and Data" for swedish public organisations | |||
* [https://github.com/salgo60/NOSAD-POC-Wikidata github.com NOSAD-POC-Wikidata] se även [https://oswald.wikibase.cloud/wiki/Project:About Project:About Oswald] | |||
** [https://github.com/salgo60/NOSAD-POC-Wikidata/blob/main/data/NOSAD%20org.csv csv file created with metadata] | |||
* [https://github.com/salgo60/DiggUptime#-live-status---all-systems-operational UppTime Oswald] | |||
* om [https://www.wikibase.cloud wikibase.cloud] | |||
=== NOSAD Wikibase Queries === | |||
* [https://oswald.wikibase.cloud/query/embed.html#%23title%3A%20Lista%20f%C3%B6rel%C3%A4sningar%20i%20omv%C3%A4nd%20tidsordning%20med%20ID%2C%20titel%2C%20videol%C3%A4nk%20osv.%0A%23%20https%3A%2F%2Fbeyond-notability.wikibase.cloud%2Fwiki%2FProject%3ASPARQL%2Fexamples%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%3Fsess%20%3FsessLabel%20%3Fagenda%20%3Fstart%0A%3Fpres%20%3FpresLabel%20%3Forg%20%3ForgLabel%20%3Fspkr%20%3FspkrLabel%0A%23%20%3Ft%20%3Ft0%20%3Ftest%20%3Fvurl%20%3Fytid%0A%3Fvurl_t%20%3Fyturl_t%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%20OPTIONAL%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(COALESCE(%3Fstart%2C%200)%20AS%20%3Ft0).%0A%23%20%20%20BIND(IF(%3Ft0%20%3E%203000%2C%20%22late%22%2C%20%22early%22)%20AS%20%3Ftest).%0A%20%20BIND(IRI(CONCAT(STR(%3Fvurl)%2C%20IF(%3Ft0%20%3E%200%2C%20CONCAT(%22%23t%3D%22%2C%20STR(%3Ft0))%2C%20%22%22)))%20AS%20%3Fvurl_t)%20.%0A%20%20BIND(IRI(CONCAT(%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D%22%2C%20%3Fytid%2C%20IF(%3Ft0%20%3E%200%2C%20CONCAT(%22%23t%3D%22%2C%20STR(%3Ft0))%2C%20%22%22)))%20AS%20%3Fyturl_t)%20.%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Csv%2Cno%2Cen-gb%2Cen%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20DESC(%3Fdt)%20%3FsessLabel%20(!BOUND(%3Fstart))%20%3Fstart%20%3FpresLabel%0A%23GROUP%20BY%20%3FpLabel%20%3FvLabel%20%0A%23ORDER%20BY%20DESC(%3Fcount) Lista föreläsningar i omvänd tidsordning med ID, titel, videolänk osv.] | |||
* [https://oswald.wikibase.cloud/query/embed.html#%23%20https%3A%2F%2Fbeyond-notability.wikibase.cloud%2Fwiki%2FProject%3ASPARQL%2Fexamples%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%3Fsess%20%3FsessLabel%20%3Fagenda%20%3Fstart%0A%3Fpres%20%3FpresLabel%20%3Forg%20%3ForgLabel%20%3Fspkr%20%3FspkrLabel%0A%23%20%3Ft%20%3Ft0%20%3Ftest%20%3Fvurl%20%3Fytid%0A%3Fvurl_t%20%3Fyturl_t%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%20OPTIONAL%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 | |||
* [https://oswald.wikibase.cloud/query/embed.html#%23%20https%3A%2F%2Fbeyond-notability.wikibase.cloud%2Fwiki%2FProject%3ASPARQL%2Fexamples%0A%23title%3A%20Kort%20lista%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%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%20OPTIONAL%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%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 kortlista] | * [https://oswald.wikibase.cloud/query/embed.html#%23%20https%3A%2F%2Fbeyond-notability.wikibase.cloud%2Fwiki%2FProject%3ASPARQL%2Fexamples%0A%23title%3A%20Kort%20lista%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%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%20OPTIONAL%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%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 kortlista] | ||
** [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] | ||
Line 9: | Line 16: | ||
* [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] | * [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%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%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% | *** [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%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% | *** [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% | ***[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% | *** [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] | ** [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] | ||
** [https://oswald.wikibase.cloud/query/embed.html#PREFIX%20osd%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20osdt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fo%20%3FoLabel%20%3ForgNummer%20%3FallaBolag%20WHERE%20%7B%0A%3Fo%20osdt%3AP37%20%3ForgNummer.%0ABIND%20%28URI%28CONCAT%28%22https%3A%2F%2Fwikidata-externalid-url.toolforge.org%2F%3Fp%3D6460%26url_prefix%3Dhttps%3A%2F%2Fwww.allabolag.se%2F%26id%3D%22%2C%3ForgNummer%29%29%20AS%20%3FallaBolag%29%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D%20order%20by%20%3FoLabel Bolag på Oswald med organisationsnummer och koppling alla bolag] / samma men med [https://oswald.wikibase.cloud/query/embed.html#PREFIX%20osd%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20osdt%3A%20%3Chttps%3A%2F%2Foswald.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fo%20%3FoLabel%20%3ForgNummer%20%3FallaBolag%20%3FHandlingar_se%20%20WHERE%20%7B%0A%3Fo%20osdt%3AP37%20%3ForgNummer.%0ABIND%20%28URI%28CONCAT%28%22https%3A%2F%2Fwikidata-externalid-url.toolforge.org%2F%3Fp%3D6460%26url_prefix%3Dhttps%3A%2F%2Fwww.allabolag.se%2F%26id%3D%22%2C%3ForgNummer%29%29%20AS%20%3FallaBolag%29%0A%20%20%0AOPTIONAL%20%7B%3Fo%20osdt%3AP38%20%3FHandlingar_se%7D.%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D%20order%20by%20%3FoLabel länk handlingar.se för organisationen] | |||
=== Misc === | === Misc === | ||
* [https://github.com/salgo60/NOSAD-POC-Wikidata POC koppla Wikidata till Nosad Dataportalen Scholia] med Linked data.... | * [https://github.com/salgo60/NOSAD-POC-Wikidata POC koppla Wikidata till Nosad Dataportalen Scholia] med Linked data.... | ||
** [https://www.youtube.com/watch?v=m_9_23jXPoE What is Wikidata] | ** [https://www.youtube.com/watch?v=m_9_23jXPoE What is Wikidata] | ||
* Skapa [https://github.com/salgo60/NOSAD-POC-Wikidata/issues/18 entity schema #18 ] | * Skapa [https://github.com/salgo60/NOSAD-POC-Wikidata/issues/18 entity schema #18 ] | ||
=== SPARQL Frågor === | |||
==== Lista föreläsningar i omvänd tidsordning med ID, titel, videolänk osv. ==== | |||
<sparql tryit="1"> | |||
#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 | |||
</sparql> | |||
{{NOSAD-POC_Federation_Quick}} | |||
=== SPARQL Hämta datalistor motsvarande nosad.se === | |||
Test för jämförelse av innehåll som skiljer sig åt, och som exempel för datadrivet innehåll. | |||
==== nosad.se Organisationer "Inspelade NOSAD-event per organisation" ==== | |||
<sparql tryit="1"> | |||
#title: Motsv. https://nosad.se/organisationer/ "Inspelade NOSAD-event per organisation" | |||
PREFIX od: <https://oswald.wikibase.cloud/entity/> | |||
PREFIX odt: <https://oswald.wikibase.cloud/prop/direct/> | |||
SELECT ?pres ?presLabel ?orgLabel ?vurl ?ytid WHERE { | |||
?pres odt:P12 od:Q157. # instance of presentation | |||
?pres odt:P14 ?org. | |||
?pres odt:P20 ?sess. | |||
OPTIONAL {?sess odt:P16 ?vurl.} | |||
OPTIONAL {?sess odt:P21 ?ytid.} | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "sv,no,en". | |||
} | |||
} | |||
ORDER BY (lcase(?orgLabel)) | |||
</sparql> | |||
==== nosad.se Workshops ==== | |||
<sparql tryit="1"> | |||
#title: Motsv. https://nosad.se/workshops/ | |||
PREFIX od: <https://oswald.wikibase.cloud/entity/> | |||
PREFIX odt: <https://oswald.wikibase.cloud/prop/direct/> | |||
SELECT ?event ?eventLabel ?date ?agenda_url ?vurl ?ytid WHERE { | |||
?event odt:P12 od:Q162. # instance of session | |||
OPTIONAL {?event odt:P17 ?agenda_url.} | |||
OPTIONAL {?event odt:P16 ?vurl.} | |||
OPTIONAL {?event odt:P21 ?ytid.} | |||
OPTIONAL {?event odt:P22 ?date.} | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "sv,no,en". | |||
} | |||
} | |||
ORDER BY DESC(?date) | |||
</sparql> | |||
==== Talare som finns på Dartaportalens forum ==== | |||
<sparql tryit="1"> | |||
#title: Talare NOSAD som finns på Dataportalen | |||
PREFIX od: <https://oswald.wikibase.cloud/entity/> | |||
PREFIX odt: <https://oswald.wikibase.cloud/prop/direct/> | |||
SELECT distinct ?spkr ?spkrLabel ?Dataportalen ?Linkedin ?GITHUB | |||
WHERE { | |||
?pres odt:P12 od:Q157 . # a Presentation | |||
?pres odt:P13 ?spkr . | |||
?spkr odt:P31 ?DPid. | |||
OPTIONAL {?spkr odt:P27 ?Lid} | |||
OPTIONAL {?spkr odt:P32 ?Gid} | |||
BIND(URI(CONCAT("https://community.dataportal.se/user/",?DPid)) as ?Dataportalen) | |||
BIND(URI(CONCAT("https://www.linkedin.com/in/",?Lid)) as ?Linkedin) | |||
BIND(URI(CONCAT("https://github.com/",?Gid)) as ?GITHUB) | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "sv,en". | |||
} | |||
} | |||
ORDER BY ?spkrLabel | |||
</sparql> | |||
==== Inlägg Sveriges Dataportal skapat av talare per org ==== | |||
<sparql tryit="1"> | |||
#title: Talare NOSAD som finns på Sveriges Dataportal och har skapat inlägg per org | |||
#defaultView:BarChart | |||
PREFIX od: <https://oswald.wikibase.cloud/entity/> | |||
PREFIX odt: <https://oswald.wikibase.cloud/prop/direct/> | |||
PREFIX odp: <https://oswald.wikibase.cloud/prop/> | |||
PREFIX odpq: <https://oswald.wikibase.cloud/prop/qualifier/> | |||
SELECT ?orgLabel (sum(?NumberPosts) AS ?AkrivitetDataportalen) | |||
WHERE { | |||
?pres odt:P12 od:Q157 . # a Presentation | |||
?pres odt:P13 ?spkr . | |||
?pres odt:P14 ?org. | |||
?spkr odp:P31 ?DPidP. | |||
?DPidP odpq:P41 ?NumberPosts. | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "sv,en". | |||
} | |||
} group by ?orgLabel | |||
order by desc(xsd:integer(?AkrivitetDataportalen)) | |||
</sparql> | |||
==== Ämnen Sveriges NOSAD föredrag kandidater för autoGPT ==== | |||
* hitta kandidater för AutoGPT [https://github.com/salgo60/NOSAD-POC-Wikidata/issues/28#issuecomment-1509859220 #28] | |||
<sparql tryit="1"> | |||
#title: WDSubjects set in NOSAD Presentations --> candidates for autoGPT | |||
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/> | |||
SELECT distinct ?WD ?WDTopic | |||
WHERE { | |||
?org wdt:P24 ?WDt. #WD Topic | |||
BIND(URI(CONCAT("http://www.wikidata.org/entity/",?WDt)) AS ?WD) | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?WD rdfs:label ?WDTopic. FILTER(LANG(?WDTopic) ="en") | |||
} | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "en,sv". | |||
} | |||
} order by ?WDTopic | |||
</sparql> | |||
[[category:SPARQL]] |
Latest revision as of 12:58, 16 April 2023
- Vad behövs för att leverera länkade data och förvalta en kunskapsgraf se DIGG bör vara tankeledande och kunna tekniker som kunskapsgrafer svar chatGPT
- Lista NOSAD föreläsningar i denna databas
POC using NOSAD metadata in a Wikibase.cloud instance
NOSAD a "Network Open Source and Data" for swedish public organisations
NOSAD Wikibase Queries
- Presentatörerna som Oswald ID, Sträng, WD - snyggt mönster GITHUB kommentar där alla presentatörer får en persistemt identifierare dvs. FAIRDATA F1
- SPARQL Federation med Wikidata
- Presentatörer som finns på Dataportalen se #19
- Bolag på Oswald med organisationsnummer och koppling alla bolag / samma men med länk handlingar.se för organisationen
Misc
- POC koppla Wikidata till Nosad Dataportalen Scholia med Linked data....
- Skapa entity schema #18
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
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)
SPARQL Hämta datalistor motsvarande nosad.se
Test för jämförelse av innehåll som skiljer sig åt, och som exempel för datadrivet innehåll.
nosad.se Organisationer "Inspelade NOSAD-event per organisation"
#title: Motsv. https://nosad.se/organisationer/ "Inspelade NOSAD-event per organisation"
PREFIX od: <https://oswald.wikibase.cloud/entity/>
PREFIX odt: <https://oswald.wikibase.cloud/prop/direct/>
SELECT ?pres ?presLabel ?orgLabel ?vurl ?ytid WHERE {
?pres odt:P12 od:Q157. # instance of presentation
?pres odt:P14 ?org.
?pres odt:P20 ?sess.
OPTIONAL {?sess odt:P16 ?vurl.}
OPTIONAL {?sess odt:P21 ?ytid.}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "sv,no,en".
}
}
ORDER BY (lcase(?orgLabel))
nosad.se Workshops
#title: Motsv. https://nosad.se/workshops/
PREFIX od: <https://oswald.wikibase.cloud/entity/>
PREFIX odt: <https://oswald.wikibase.cloud/prop/direct/>
SELECT ?event ?eventLabel ?date ?agenda_url ?vurl ?ytid WHERE {
?event odt:P12 od:Q162. # instance of session
OPTIONAL {?event odt:P17 ?agenda_url.}
OPTIONAL {?event odt:P16 ?vurl.}
OPTIONAL {?event odt:P21 ?ytid.}
OPTIONAL {?event odt:P22 ?date.}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "sv,no,en".
}
}
ORDER BY DESC(?date)
Talare som finns på Dartaportalens forum
#title: Talare NOSAD som finns på Dataportalen
PREFIX od: <https://oswald.wikibase.cloud/entity/>
PREFIX odt: <https://oswald.wikibase.cloud/prop/direct/>
SELECT distinct ?spkr ?spkrLabel ?Dataportalen ?Linkedin ?GITHUB
WHERE {
?pres odt:P12 od:Q157 . # a Presentation
?pres odt:P13 ?spkr .
?spkr odt:P31 ?DPid.
OPTIONAL {?spkr odt:P27 ?Lid}
OPTIONAL {?spkr odt:P32 ?Gid}
BIND(URI(CONCAT("https://community.dataportal.se/user/",?DPid)) as ?Dataportalen)
BIND(URI(CONCAT("https://www.linkedin.com/in/",?Lid)) as ?Linkedin)
BIND(URI(CONCAT("https://github.com/",?Gid)) as ?GITHUB)
SERVICE wikibase:label {
bd:serviceParam wikibase:language "sv,en".
}
}
ORDER BY ?spkrLabel
Inlägg Sveriges Dataportal skapat av talare per org
#title: Talare NOSAD som finns på Sveriges Dataportal och har skapat inlägg per org
#defaultView:BarChart
PREFIX od: <https://oswald.wikibase.cloud/entity/>
PREFIX odt: <https://oswald.wikibase.cloud/prop/direct/>
PREFIX odp: <https://oswald.wikibase.cloud/prop/>
PREFIX odpq: <https://oswald.wikibase.cloud/prop/qualifier/>
SELECT ?orgLabel (sum(?NumberPosts) AS ?AkrivitetDataportalen)
WHERE {
?pres odt:P12 od:Q157 . # a Presentation
?pres odt:P13 ?spkr .
?pres odt:P14 ?org.
?spkr odp:P31 ?DPidP.
?DPidP odpq:P41 ?NumberPosts.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "sv,en".
}
} group by ?orgLabel
order by desc(xsd:integer(?AkrivitetDataportalen))
Ämnen Sveriges NOSAD föredrag kandidater för autoGPT
- hitta kandidater för AutoGPT #28
#title: WDSubjects set in NOSAD Presentations --> candidates for autoGPT
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/>
SELECT distinct ?WD ?WDTopic
WHERE {
?org wdt:P24 ?WDt. #WD Topic
BIND(URI(CONCAT("http://www.wikidata.org/entity/",?WDt)) AS ?WD)
SERVICE <https://query.wikidata.org/sparql> {
?WD rdfs:label ?WDTopic. FILTER(LANG(?WDTopic) ="en")
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en,sv".
}
} order by ?WDTopic