NOSAD-POC: Difference between revisions

NOSAD-POC (view source)

781 bytes added , 1 year ago

798

edits

@@ Line 109: / Line 109: @@
 </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>
 [[category:SPARQL]]