aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorlltommy2020-06-17 19:49:29 +0200
committerlltommy2020-06-17 19:49:29 +0200
commite5daaefe32379a22abfd332ee3ba7c139efb8458 (patch)
treec91cf7adb5130464d76ac15b02a44de24597fda7
parentae6b95d8e3053e9a446702d77e7ad56a321acda7 (diff)
downloadbh20-seq-resource-e5daaefe32379a22abfd332ee3ba7c139efb8458.tar.gz
bh20-seq-resource-e5daaefe32379a22abfd332ee3ba7c139efb8458.tar.lz
bh20-seq-resource-e5daaefe32379a22abfd332ee3ba7c139efb8458.zip
Slighlty alter SPARQL query to truley sumarize locations for contients. Most likley this number must be combined with what is assigned directly to a country? (instead of e.g.) a city?
-rw-r--r--bh20simplewebuploader/main.py3
-rw-r--r--semantic_enrichment/countries.ttl3
2 files changed, 3 insertions, 3 deletions
diff --git a/bh20simplewebuploader/main.py b/bh20simplewebuploader/main.py
index 40046c8..3100dfd 100644
--- a/bh20simplewebuploader/main.py
+++ b/bh20simplewebuploader/main.py
@@ -598,7 +598,8 @@ def getSEQCountbyLocation():
def getSEQCountbyContinent():
query="""SELECT DISTINCT ?continent ?continent_label (count(?fasta) as ?fastaCount) WHERE {
?fasta ?x[ <http://purl.obolibrary.org/obo/GAZ_00000448> ?location] .
- ?location <http://www.wikidata.org/prop/direct/P30> ?continent .
+ ?location <http://www.wikidata.org/prop/direct/P17> ?country .
+ ?country <http://www.wikidata.org/prop/direct/P30> ?continent .
OPTIONAL { ?continent rdfs:label ?key_tmp_label }
BIND(IF(BOUND(?key_tmp_label),?key_tmp_label, ?location) as ?continent_label)
}
diff --git a/semantic_enrichment/countries.ttl b/semantic_enrichment/countries.ttl
index 416567f..b56740f 100644
--- a/semantic_enrichment/countries.ttl
+++ b/semantic_enrichment/countries.ttl
@@ -338,7 +338,6 @@
<http://www.wikidata.org/entity/Q30> rdfs:label "United States of America" ;
ns1:P17 <http://www.wikidata.org/entity/Q30> ;
- ns1:P30 <http://www.wikidata.org/entity/Q49>,
- <http://www.wikidata.org/entity/Q538> ;
+ ns1:P30 <http://www.wikidata.org/entity/Q49> ;
ns1:P625 "Point(-98.5795 39.828175)" .