Skip to content

Instantly share code, notes, and snippets.

@mayurbhangale
Forked from NTerpo/person.sparql
Created February 10, 2019 10:34
Show Gist options
  • Select an option

  • Save mayurbhangale/9a62c2ce2e6d8536956fd61152e1c810 to your computer and use it in GitHub Desktop.

Select an option

Save mayurbhangale/9a62c2ce2e6d8536956fd61152e1c810 to your computer and use it in GitHub Desktop.
SELECT ?PermID ?hasPermId ?rank ?prefLabel ?hasReportedTitle ?hasHolder ?hasPositionType ?hasPublicationStatus ?isPositionIn ?to ?familyName ?givenName ?holdsPosition ?hasTenureInOrganization ?additionalName ?hasGender ?bday ?honorificPrefix ?from ?hasQualification ?preferredName ?honorificSuffix ?withDegree ?fromInstitutionName ?inSubject ?isTenureIn ?dateOfDeath
WHERE { OPTIONAL { ?PermID <http://permid.org/ontology/common/hasPermId> ?hasPermId }
OPTIONAL { ?PermID <http://permid.org/ontology/person/rank> ?rank }
OPTIONAL { ?PermID <http://www.w3.org/2004/02/skos/core#prefLabel> ?prefLabel }
OPTIONAL { ?PermID <http://permid.org/ontology/person/hasReportedTitle> ?hasReportedTitle }
OPTIONAL { ?PermID <http://permid.org/ontology/person/hasHolder> ?hasHolder }
OPTIONAL { ?PermID <http://permid.org/ontology/person/hasPositionType> ?hasPositionType }
OPTIONAL { ?PermID <http://permid.org/ontology/common/hasPublicationStatus> ?hasPublicationStatus }
OPTIONAL { ?PermID <http://permid.org/ontology/person/isPositionIn> ?isPositionIn }
OPTIONAL { ?PermID <http://permid.org/ontology/common/to> ?to }
OPTIONAL { ?PermID <http://www.w3.org/2006/vcard/ns#family-name> ?familyName }
OPTIONAL { ?PermID <http://www.w3.org/2006/vcard/ns#given-name> ?givenName }
OPTIONAL { ?PermID <http://permid.org/ontology/person/holdsPosition> ?holdsPosition }
OPTIONAL { ?PermID <http://permid.org/ontology/person/hasTenureInOrganization> ?hasTenureInOrganization }
OPTIONAL { ?PermID <http://www.w3.org/2006/vcard/ns#additional-name> ?additionalName }
OPTIONAL { ?PermID <http://www.w3.org/2006/vcard/ns#hasGender> ?hasGender }
OPTIONAL { ?PermID <http://www.w3.org/2006/vcard/ns#bday> ?bday }
OPTIONAL { ?PermID <http://www.w3.org/2006/vcard/ns#honorific-prefix> ?honorificPrefix }
OPTIONAL { ?PermID <http://permid.org/ontology/common/from> ?from }
OPTIONAL { ?PermID <http://permid.org/ontology/person/hasQualification> ?hasQualification }
OPTIONAL { ?PermID <http://permid.org/ontology/vcard/#preferred-name> ?preferredName }
OPTIONAL { ?PermID <http://www.w3.org/2006/vcard/ns#honorific-suffix> ?honorificSuffix }
OPTIONAL { ?PermID <http://permid.org/ontology/person/withDegree> ?withDegree }
OPTIONAL { ?PermID <http://permid.org/ontology/person/fromInstitutionName> ?fromInstitutionName }
OPTIONAL { ?PermID <http://permid.org/ontology/person/inSubject> ?inSubject }
OPTIONAL { ?PermID <http://permid.org/ontology/person/isTenureIn> ?isTenureIn }
OPTIONAL { ?PermID <http://permid.org/ontology/vcard/#date-of-death> ?dateOfDeath }
}
@mayurbhangale
Copy link
Author

/mnt/372CF7A40F31F1C0/mayur/onobrain/apache-jena-3.7.0/bin/arq --data permid_org.nt --query /mnt/4tb/permid_neo4j/queries/get_orgs.rq --results csv > orgs.csv

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment