data-set-knowledge-graph/linking-to-ORCID/01SPARQL_author_profiles.txt at main · michaelfaerber/data-set-knowledge-graph · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
PREFIX dcat: <http://www.w3.org/ns/dcat#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX vcard: <http://www.w3.org/2006/vcard/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX adms: <https://www.w3.org/ns/adms#>

select
 ?creator
    (group_concat(distinct ?creatorName;separator=", ") as ?creatorName)
    (group_concat(distinct ?title;separator=", ") as ?title)
    (group_concat(distinct ?alternative;separator=", ") as ?alternative)
    (group_concat(distinct ?coAuthors;separator=", ") as ?coAuthors)
    (group_concat(distinct ?landingPage;separator=", ") as ?landingPage)
    (group_concat(distinct ?identifier;separator=", ") as ?identifier)
    (group_concat(distinct ?paper;separator=", ") as ?paper)

where {
    ?dataset rdf:type  dcat:Dataset .
    ?dataset dct:title ?title .
    ?dataset dct:creator ?creator.
    ?creator foaf:name ?creatorName .
    ?creator rdf:type foaf:Person .
    optional { ?dataset dct:creator ?coAuthorsid .
               ?coAuthorsid foaf:name ?coAuthors }

    optional { ?dataset dct:alternative ?alternative . }
    optional { ?dataset dcat:landingPage ?landingPage . }
    optional { ?dataset adms:identifier ?identifier . }
    ?dataset dct:isReferencedBy ?paper.

   }
group by ?creator