Current Release

This documentation covers the latest release of VIVO, version 1.15.x.
If you are able to help contribute to this documentation, please contact vivo at lyrasis dot org
Looking for another version? See all documentation.

Note that these are CONSTRUCT queries designed to create a small Jena model for export as a whole after a series of queries has been run.  The PERSON_URI variable is substituted by VIVO at runtime.

advisee.sparql
PREFIX core: <http://vivoweb.org/ontology/core#>
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

CONSTRUCT {
     ?advisee ?property ?object .
} WHERE {
     PERSON_URI core:relatedBy ?advisingRelationship .
     ?advisingRelationship a core:AdvisingRelationship .
     ?advisingRelationship core:relates ?advisee .
     ?advisee a foaf:Person .
     ?advisee obo:RO_0000053 ?adviseeRole .
     ?adviseeRole a core:AdviseeRole .
     ?adviseeRole core:relatedBy ?advisingRelationship .
     ?advisee ?property ?object .
}
adviseesDegreeAlt.sparql
PREFIX core: <http://vivoweb.org/ontology/core#>
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

CONSTRUCT {
     ?degree ?property ?object
} WHERE {
     PERSON_URI core:relatedBy ?advisingRelationship .
     ?advisingRelationship a core:AdvisingRelationship .
     ?advisingRelationship core:relates ?advisee .
     ?advisee a foaf:Person .
     ?advisee obo:RO_0000053 ?adviseeRole .
     ?adviseeRole a core:AdviseeRole .
     ?adviseeRole core:relatedBy ?advisingRelationship .
     ?advisee core:relates ?educationalTraining .
     ?educationalTraining a core:EducationalProcess .
     ?educationalTraining obo:RO_0002234 ?awardedDegree .
     ?awardedDegree core:relates ?degree .
     ?degree a core:AcademicDegree .
     ?degree ?property ?object
}
adviseesEducationalInstitutionAlt.sparql
PREFIX core: <http://vivoweb.org/ontology/core#>
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

CONSTRUCT {
     ?educationalInstitution rdfs:label ?label
} WHERE {
     PERSON_URI core:relatedBy ?advisingRelationship .
     ?advisingRelationship a core:AdvisingRelationship .
     ?advisingRelationship core:relates ?advisee .
     ?advisee a foaf:Person .
     ?advisee obo:RO_0000053 ?adviseeRole .
     ?adviseeRole a core:AdviseeRole .
     ?adviseeRole core:relatedBy ?advisingRelationship .
     ?advisee core:relates ?educationalTraining .
     ?educationalTraining a core:EducationalProcess .
     ?educationalTraining obo:RO_0000057 ?educationalInstitution .
     ?educationalInstitution a foaf:Organization .
     ?educationalInstitution rdfs:label ?label
}
adviseesEducationalEndDate.sparql
PREFIX core: <http://vivoweb.org/ontology/core#>
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

CONSTRUCT {
     ?dateTimeValue ?property ?object .
} WHERE {
     PERSON_URI core:relatedBy ?advisingRelationship .
     ?advisingRelationship a core:AdvisingRelationship .
     ?advisingRelationship core:relates ?advisee .
     ?advisee a foaf:Person .
     ?advisee obo:RO_0000053 ?adviseeRole .
     ?adviseeRole a core:AdviseeRole .
     ?adviseeRole core:relatedBy ?advisingRelationship .
     ?advisee core:relates ?educationalTraining .
     ?educationalTraining a core:EducationalProcess .
     ?educationalTraining core:dateTimeInterval ?dateTimeInterval .
     ?dateTimeInterval core:end ?dateTimeValue .
     ?dateTimeValue ?property ?object .
}
associatedDegree.sparql
PREFIX core: <http://vivoweb.org/ontology/core#>
PREFIX obo: <http://purl.obolibrary.org/obo/>

CONSTRUCT {
     ?degree ?property ?object .
} WHERE {
     PERSON_URI core:relatedBy ?advisingRelationship .
     ?advisingRelationship a core:AdvisingRelationship .
     ?advisingRelationship core:degreeCandidacy ?degree .
     ?degree ?property ?object .
}
associatedEducationalTraining.sparql
PREFIX core: <http://vivoweb.org/ontology/core#>

CONSTRUCT {
     ?educationalTraining ?property ?object .
} WHERE {
     PERSON_URI core:relatedBy ?advisingRelationship .
     ?advisingRelationship a core:AdvisingRelationship .
     ?advisingRelationship core:advisingContributionTo ?educationalTraining .
     ?educationalTraining ?property ?object .
}
associatedEducationalTrainingAlt.sparql
PREFIX core: <http://vivoweb.org/ontology/core#>
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

CONSTRUCT {
     ?educationalTraining ?property ?object .
} WHERE {
     PERSON_URI core:relatedBy ?advisingRelationship .
     ?advisingRelationship a core:AdvisingRelationship .
     ?advisingRelationship core:relates ?advisee .
     ?advisee a foaf:Person .
     ?advisee obo:RO_0000053 ?adviseeRole .
     ?adviseeRole a core:AdviseeRole .
     ?adviseeRole core:relatedBy ?advisingRelationship .
     ?advisee core:relates ?educationalTraining .
     ?educationalTraining a core:EducationalProcess .
     ?educationalTraining ?property ?object .
}
  • No labels

All content on the LYRASIS Wiki is licensed under the CC BY (Attribution) license, unless otherwise noted.