API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
324
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SPARQL 6.57 KB | None | 0 0
raw download clone embed print report
  1. PREFIX rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
  2. PREFIX rdfs:     <http://www.w3.org/2000/01/rdf-schema#>
  3. PREFIX xsd:      <http://www.w3.org/2001/XMLSchema#>
  4. PREFIX owl:      <http://www.w3.org/2002/07/owl#>
  5. PREFIX swrl:     <http://www.w3.org/2003/11/swrl#>
  6. PREFIX swrlb:    <http://www.w3.org/2003/11/swrlb#>
  7. PREFIX vitro:    <http://vitro.mannlib.cornell.edu/ns/vitro/0.7#>
  8. PREFIX wgs84:    <http://www.w3.org/2003/01/geo/wgs84_pos#>
  9. PREFIX bibo:     <http://purl.org/ontology/bibo/>
  10. PREFIX c4o:      <http://purl.org/spar/c4o/>
  11. PREFIX cito:     <http://purl.org/spar/cito/>
  12. PREFIX event:    <http://purl.org/NET/c4dm/event.owl#>
  13. PREFIX fabio:    <http://purl.org/spar/fabio/>
  14. PREFIX foaf:     <http://xmlns.com/foaf/0.1/>
  15. PREFIX geo:      <http://aims.fao.org/aos/geopolitical.owl#>
  16. PREFIX obo:      <http://purl.obolibrary.org/obo/>
  17. PREFIX ocrer:    <http://purl.org/net/OCRe/research.owl#>
  18. PREFIX ocresd:   <http://purl.org/net/OCRe/study_design.owl#>
  19. PREFIX skos:     <http://www.w3.org/2004/02/skos/core#>
  20. PREFIX vcard:    <http://www.w3.org/2006/vcard/ns#>
  21. PREFIX vitro-public: <http://vitro.mannlib.cornell.edu/ns/vitro/public#>
  22. PREFIX vivo:     <http://vivoweb.org/ontology/core#>
  23. PREFIX scires:   <http://vivoweb.org/ontology/scientific-research#>
  24.  
  25. SELECT ?URI ?city ?first_name ?last_name ?display_name ?zip ?title ?home_page ?overview ?name_suffix ?phone ?state ?street_address ?research_areas ?country ?orcid ?middle_name ?name_prefix ?email ?types
  26. WHERE {
  27.     ?URI a foaf:Person .
  28.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?city_2 . ?city_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?city_2 <http://www.w3.org/2006/vcard/ns#hasAddress> ?city_1 . ?city_1 a <http://www.w3.org/2006/vcard/ns#Address> . ?city_1 <http://www.w3.org/2006/vcard/ns#locality> ?city .    }
  29.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?first_name_2 . ?first_name_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?first_name_2 <http://www.w3.org/2006/vcard/ns#hasName> ?first_name_1 . ?first_name_1 a <http://www.w3.org/2006/vcard/ns#Name> . ?first_name_1 <http://www.w3.org/2006/vcard/ns#givenName> ?first_name .    }
  30.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?last_name_2 . ?last_name_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?last_name_2 <http://www.w3.org/2006/vcard/ns#hasName> ?last_name_1 . ?last_name_1 a <http://www.w3.org/2006/vcard/ns#Name> . ?last_name_1 <http://www.w3.org/2006/vcard/ns#familyName> ?last_name .    }
  31.     OPTIONAL {  ?URI <http://www.w3.org/2000/01/rdf-schema#label> ?display_name .  }
  32.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?zip_2 . ?zip_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?zip_2 <http://www.w3.org/2006/vcard/ns#hasAddress> ?zip_1 . ?zip_1 a <http://www.w3.org/2006/vcard/ns#Address> . ?zip_1 <http://www.w3.org/2006/vcard/ns#postalCode> ?zip .    }
  33.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?title_2 . ?title_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?title_2 <http://www.w3.org/2006/vcard/ns#hasTitle> ?title_1 . ?title_1 a <http://www.w3.org/2006/vcard/ns#Title> . ?title_1 <http://www.w3.org/2006/vcard/ns#title> ?title .    }
  34.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?home_page_2 . ?home_page_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?home_page_2 <http://www.w3.org/2006/vcard/ns#hasURL> ?home_page_1 . ?home_page_1 a <http://www.w3.org/2006/vcard/ns#URL> . ?home_page_1 <http://www.w3.org/2006/vcard/ns#url> ?home_page .  ?url rdfs:label "Home Page" .  }
  35.     OPTIONAL {  ?URI <http://vivoweb.org/ontology/core#overview> ?overview .  }
  36.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?name_suffix_2 . ?name_suffix_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?name_suffix_2 <http://www.w3.org/2006/vcard/ns#hasName> ?name_suffix_1 . ?name_suffix_1 a <http://www.w3.org/2006/vcard/ns#Name> . ?name_suffix_1 <http://www.w3.org/2006/vcard/ns#honorificSuffix> ?name_suffix .    }
  37.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?phone_2 . ?phone_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?phone_2 <http://www.w3.org/2006/vcard/ns#hasTelephone> ?phone_1 . ?phone_1 a <http://www.w3.org/2006/vcard/ns#Telephone> . ?phone_1 <http://www.w3.org/2006/vcard/ns#telephone> ?phone .  NOT EXISTS { ?telephone_number a vcard:Code }  }
  38.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?state_2 . ?state_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?state_2 <http://www.w3.org/2006/vcard/ns#hasAddress> ?state_1 . ?state_1 a <http://www.w3.org/2006/vcard/ns#Address> . ?state_1 <http://www.w3.org/2006/vcard/ns#region> ?state .    }
  39.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?street_address_2 . ?street_address_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?street_address_2 <http://www.w3.org/2006/vcard/ns#hasAddress> ?street_address_1 . ?street_address_1 a <http://www.w3.org/2006/vcard/ns#Address> . ?street_address_1 <http://www.w3.org/2006/vcard/ns#streetAddress> ?street_address .    }
  40.     OPTIONAL {  ?URI <http://vivoweb.org/ontology/core#hasResearchArea> ?research_areas .  }
  41.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?country_2 . ?country_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?country_2 <http://www.w3.org/2006/vcard/ns#hasAddress> ?country_1 . ?country_1 a <http://www.w3.org/2006/vcard/ns#Address> . ?country_1 <http://www.w3.org/2006/vcard/ns#country> ?country .    }
  42.     OPTIONAL {  ?URI <http://vivoweb.org/ontology/core#orcid> ?orcid .  }
  43.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?middle_name_2 . ?middle_name_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?middle_name_2 <http://www.w3.org/2006/vcard/ns#hasName> ?middle_name_1 . ?middle_name_1 a <http://www.w3.org/2006/vcard/ns#Name> . ?middle_name_1 <http://www.w3.org/2006/vcard/ns#additionalName> ?middle_name .    }
  44.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?name_prefix_2 . ?name_prefix_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?name_prefix_2 <http://www.w3.org/2006/vcard/ns#hasName> ?name_prefix_1 . ?name_prefix_1 a <http://www.w3.org/2006/vcard/ns#Name> . ?name_prefix_1 <http://www.w3.org/2006/vcard/ns#honorificPrefix> ?name_prefix .    }
  45.     OPTIONAL {  ?URI <http://purl.obolibrary.org/obo/ARG_2000028> ?email_2 . ?email_2 a <http://www.w3.org/2006/vcard/ns#Kind> . ?email_2 <http://www.w3.org/2006/vcard/ns#hasEmail> ?email_1 . ?email_1 a <http://www.w3.org/2006/vcard/ns#Email> . ?email_1 <http://www.w3.org/2006/vcard/ns#email> ?email .    }
  46.     OPTIONAL {  ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> ?types .  }
  47. }
  48. ORDER BY ?display_name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!