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 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'bh20simplewebuploader/main.py')

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)
     }
-- 
cgit v1.2.3