/
get_diseases_query.sparql
26 lines (25 loc) · 1.04 KB
/
get_diseases_query.sparql
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
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX category: <http://dbpedia.org/resource/Category:>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?d ?dn ?wikiPage ?icd9 ?icd10 ?disDB ?meshID ?mlp ?omim ?emed ?frbase
WHERE {
?d a <http://dbpedia.org/ontology/Disease>.
?d foaf:isPrimaryTopicOf ?wikiPage.
OPTIONAL { ?d <http://dbpedia.org/ontology/icd9> ?icd9. }
OPTIONAL { ?d <http://dbpedia.org/ontology/icd10> ?icd10. }
OPTIONAL { ?d <http://dbpedia.org/ontology/diseasesDb> ?disDB. }
OPTIONAL { ?d <http://dbpedia.org/ontology/meshId> ?meshID. }
OPTIONAL { ?d <http://dbpedia.org/property/medlineplus> ?mlp. }
OPTIONAL { ?d <http://dbpedia.org/ontology/omim> ?omim. }
OPTIONAL { ?d <http://dbpedia.org/property/emedicinetopic> ?emed. }
OPTIONAL {
?d owl:sameAs ?frbase.
FILTER(regex(str(?frbase), "freebase", "i")).
}
OPTIONAL {
?d rdfs:label ?dn.
FILTER (lang(?dn) = 'en')
}
}