SPARQL_CONSTRUCT_openAIRE_beta_version.txt

PREFIX mydata: <http://example.com/resource/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dcat: <http://www.w3.org/ns/dcat#>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX spif: <http://spinrdf.org/spif#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX vcard: <http://www.w3.org/2006/vcard/ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>

CONSTRUCT {
  ?datasetiri rdf:type dcat:Dataset ;
      dct:title ?title ;
      dct:description ?description ;
      dcat:keyword ?subject ;
      dct:language ?language ;
      dct:identifier ?doi ;
      dct:hasVersion ?doi_old ;
      dcat:theme ?makg_discipline;
      dct:issued ?storagedate ;
      dcat:landingPage ?originalId ;
      dct:accessRights ?bestaccessright ;
      dct:contributor ?contributorOrganizationiri ;
      dct:contributor ?contributorOtheriri ;
      dct:creator ?creatorPersoniri ;
      dct:creator ?creatorOrganizationiri ;
      dct:creator ?creatorOtheriri ;
      dcat:distribution ?distributioniri ;
      dct:publisher ?publisherOrganizationiri ;
      dct:publisher ?publisherOtheriri ;
      dcat:contactPoint ?contactpointiri ;
      dcat:modified ?relevantDate ;
      dct:source ?source ;
      dct:isReferencedBy ?MAGConnection.

 ?creatorPersoniri rdf:type foaf:Person ;
      foaf:name ?creatorPerson.

 ?creatorOrganizationiri rdf:type foaf:Organization ;
      foaf:name ?creatorOrganization.

 ?creatorOtheriri rdf:type foaf:Agent ;
      foaf:name ?creatorOther.

  ?distributioniri rdf:type dcat:Distribution ;
      dcat:byteSize ?size ;
      dct:format ?format ;
      dcat:accessURL ?originalId .

    ?publisherOrganizationiri rdf:type foaf:Organization ;
      foaf:name ?publisherOrganization .

    ?publisherOtheriri rdf:type foaf:Agent ;
      foaf:name ?publisherOther .
  
    ?contributorOrganizationiri rdf:type foaf:Organization ;
      foaf:name ?contributorOrganization .

       ?contributorOtheriri rdf:type foaf:Agent ;
         foaf:name ?contributorOther .
  
    ?contactpointiri rdf:type vcard:Kind ;
      vcard:fn ?contactperson ;
      vcard:hasEmail ?contactperson_email .
  

  
} WHERE {
    
  ?c mydata:title ?titleprep ;
      mydata:description ?descriptionprep ;
      mydata:openairedump ?source ;
      mydata:rowNumber ?rowNumber  .
  
      ?c mydata:MAGConnection ?MAGConnectionprep .
        bind(str(?MAGConnectionprep) as ?MAGConnectionprepstr)
         OPTIONAL { ?MAGConnectiona spif:split (?MAGConnectionprepstr ", ") 
        bind(iri(concat("http://ma-graph.org/entity/", spif:encodeURL(?MAGConnectiona))) as ?MAGConnection)  }
  
        OPTIONAL { ?c mydata:MAG_Disciplines_Absolute ?makg_disciplineprep .
        bind(str(?makg_disciplineprep) as ?makg_disciplineprepstr)
         OPTIONAL { ?makg_disciplinea spif:split (?makg_disciplineprepstr ", ") 
        bind(iri(concat("http://ma-graph.org/entity/", spif:encodeURL(?makg_disciplinea))) as ?makg_discipline)  } }
     
  
    bind(STRLANG(?descriptionprep, "en") AS ?description)
    bind(STRLANG(?titleprep, "en") AS ?title)
      
   OPTIONAL { ?c mydata:language ?languageprep .
    bind(STRLANG(?languageprep, "en") as ?language ) }
  
      Optional {?c mydata:doi ?doiprep .
          Optional { bind(str(?doiprep) as ?doiprepstr)
            Optional {  ?doia spif:split (?doiprepstr ", ") 
        bind(iri(?doia) as ?doi) } 
          }
       }
        Optional {?c mydata:doi_old ?doi_oldprep .
          Optional { bind(str(?doi_oldprep) as ?doi_oldprepstr)
            Optional {  ?doi_olda spif:split (?doi_oldprepstr ", ") 
        bind(iri(?doi_olda) as ?doi_old) } 
          }
       }

  
      Optional {?c mydata:storagedate ?storagedateprep 
  bind(spif:parseDate(?storagedateprep, "yyyy") as ?storagedate) }
  
        Optional {?c mydata:byteSize ?sizeprep 
    bind(xsd:decimal(?sizeprep) AS ?size) }
    
  
        Optional {?c mydata:format ?formatprep .   
    Optional { ?format spif:split (?formatprep ", ") } }
        


  
        Optional {?c mydata:originalId ?originalIdprep .
          Optional { bind(str(?originalIdprep) as ?originalIdprepstr)
            Optional {  ?originalIda spif:split (?originalIdprepstr ", ")
            bind(iri(?originalIda) as ?originalId) } 
          }
       }
  
        Optional {?c mydata:bestaccessright ?bestaccessright }
       Optional {?c mydata:relevantDate ?relevantDateprep 
      bind(spif:parseDate(?relevantDateprep , "yyyyMMdd") as ?relevantDate) }
      
       
  
        
  
        Optional {?c mydata:contactperson_email ?contactperson_email }
  
Optional {?c mydata:creatorPerson ?creatorPersonprep .   
          OPTIONAL { ?creatorPerson spif:split (?creatorPersonprep ", ") } 
         }
Optional {?c mydata:creatorOrganization ?creatorOrganizationprep .   
          OPTIONAL { ?creatorOrganization spif:split (?creatorOrganizationprep ", ") } 
         }
Optional {?c mydata:creatorOther ?creatorOtherprep .   
          OPTIONAL { ?creatorOther spif:split (?creatorOtherprep ", ") } 
         }
  
Optional {?c mydata:publisherOrganization ?publisherOrganization }
Optional {?c mydata:publisherOther ?publisherOther }
  
Optional {?c mydata:contributorOrganization ?contributorOrganization }
Optional {?c mydata:contributorOther ?contributorOther }
  
      Optional {?c mydata:subject ?subjectprep .
        OPTIONAL { ?subjecta spif:split (?subjectprep ",") 
        bind(STRLANG(?subjecta, "en") AS ?subject)
        } 
      }
      Optional {?c mydata:contactperson ?contactpersonprep .
        OPTIONAL { ?contactperson spif:split (?contactpersonprep ", '") } 
      } 
  
 
  
bind(iri(concat("http://dskgbeta.org/dataset/", spif:encodeURL(?rowNumber ))) as ?datasetiri)

  bind(iri(concat("http://dskgbeta.org/distribution/", spif:encodeURL(?rowNumber ))) as ?distributioniri) 
  
  OPTIONAL {
  bind(iri(concat("http://dskgbeta.org/contactpoint/", spif:encodeURL(?contactperson))) as ?contactpointiri) 
  }

  
  OPTIONAL {
 bind(iri(concat("http://dskgbeta.org/creator/", spif:encodeURL(?creatorPerson))) as ?creatorPersoniri) 
  }
    OPTIONAL {
 bind(iri(concat("http://dskgbeta.org/creator/", spif:encodeURL(?creatorOrganization))) as ?creatorOrganizationiri) 
  }
    OPTIONAL {
 bind(iri(concat("http://dskgbeta.org/creator/", spif:encodeURL(?creatorOther))) as ?creatorOtheriri) 
  }
  
     OPTIONAL {   
  bind(iri(concat("http://dskgbeta.org/contributor/", spif:encodeURL(?contributorOrganization))) as ?contributorOrganizationiri) 
  }
     OPTIONAL {   
  bind(iri(concat("http://dskgbeta.org/contributor/", spif:encodeURL(?contributorOther))) as ?contributorOtheriri) 
  }
  OPTIONAL {
  bind(iri(concat("http://dskgbeta.org/publisher/", spif:encodeURL(?publisherOrganization))) as ?publisherOrganizationiri) 
  }
  OPTIONAL {
  bind(iri(concat("http://dskgbeta.org/publisher/", spif:encodeURL(?publisherOther))) as ?publisherOtheriri) 
  }

} LIMIT 100