oswald

NOSAD-POC: Difference between revisions

Page Discussion

NOSAD-POC (view source)

Revision as of 12:58, 16 April 2023

7,766 bytes added ,  1 year ago
no edit summary
No edit summary
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
* '''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 ==
== POC using NOSAD metadata in a Wikibase.cloud instance ==
[https://nosad.se/ NOSAD] a "Network Open Source and Data" for swedish public organisations
[https://nosad.se/ NOSAD] a "Network Open Source and Data" for swedish public organisations
Line 109: Line 112:
</sparql>
</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]]
[[category:SPARQL]]
Retrieved from "https://oswald.wikibase.cloud/wiki/Special:MobileDiff/1428...1488"