From e5daaefe32379a22abfd332ee3ba7c139efb8458 Mon Sep 17 00:00:00 2001
From: lltommy
Date: Wed, 17 Jun 2020 19:49:29 +0200
Subject: 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?

---
 bh20simplewebuploader/main.py     | 3 ++-
 semantic_enrichment/countries.ttl | 3 +--
 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)" .
 
-- 
cgit v1.2.3