From 6c654dd60f98d473ba94fda6143d8b8b00f99586 Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Fri, 6 Nov 2020 12:58:38 +0000
Subject: Add country entries that miss coordinates

---
 scripts/db_enrichment/country_enrichment.py |  2 +-
 semantic_enrichment/countries.ttl           | 30 ++++++++++++++++++++++++-----
 2 files changed, 26 insertions(+), 6 deletions(-)

diff --git a/scripts/db_enrichment/country_enrichment.py b/scripts/db_enrichment/country_enrichment.py
index f62a64e..37329fb 100644
--- a/scripts/db_enrichment/country_enrichment.py
+++ b/scripts/db_enrichment/country_enrichment.py
@@ -72,7 +72,6 @@ construct {
 } WHERE
 {
     BIND (XXX as ?a) .
-    ?a wdt:P625 ?c.
     ?a rdfs:label ?label .
     ?a wdt:P17 ?country.
     ?country rdfs:label ?country_label .
@@ -81,6 +80,7 @@ construct {
     FILTER (lang(?continent_label)='en')
     FILTER (lang(?country_label)='en')
     FILTER (lang(?label)='en')
+    OPTIONAL { ?a wdt:P625 ?c }
 }
 """""
 
diff --git a/semantic_enrichment/countries.ttl b/semantic_enrichment/countries.ttl
index 728877f..b0651cf 100644
--- a/semantic_enrichment/countries.ttl
+++ b/semantic_enrichment/countries.ttl
@@ -348,11 +348,6 @@
     ns1:P30 <http://www.wikidata.org/entity/Q538> ;
     ns1:P625 "Point(137.0 -28.0)" .
 
-<http://www.wikidata.org/entity/Q668> rdfs:label "India" ;
-    ns1:P17 <http://www.wikidata.org/entity/Q668> ;
-    ns1:P30 <http://www.wikidata.org/entity/Q48> ;
-    ns1:P625 "Point(83.0 22.8)" .
-
 <http://www.wikidata.org/entity/Q739> rdfs:label "Colombia" ;
     ns1:P17 <http://www.wikidata.org/entity/Q739> ;
     ns1:P30 <http://www.wikidata.org/entity/Q18> ;
@@ -1389,6 +1384,31 @@
     ns1:P30 <http://www.wikidata.org/entity/Q48> ;
     ns1:P625 "Point(123.0 12.0)" .
 
+<http://www.wikidata.org/entity/Q25622187> rdfs:label "Bayad" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q668> ;
+    ns1:P625 "Point(73.0 20.8)" .
+
+<http://www.wikidata.org/entity/Q2757125> rdfs:label "Choryasi Taluka" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q668> ;
+    ns1:P625 "Point(73.0 20.8)" .
+
+<http://www.wikidata.org/entity/Q27684996> rdfs:label "Daskroi" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q668> ;
+    ns1:P625 "Point(72.0 22.0)" .
+
+<http://www.wikidata.org/entity/Q692895> rdfs:label "Wairarapa" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q664> ;
+    ns1:P625 "Point(174.0 -41.2)" .
+
+<http://www.wikidata.org/entity/Q7960498> rdfs:label "Waitemata City" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q664> ;
+    ns1:P625 "Point(174.0 -41.2)" .
+
+<http://www.wikidata.org/entity/Q668> rdfs:label "India" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q668> ;
+    ns1:P30 <http://www.wikidata.org/entity/Q48> ;
+    ns1:P625 "Point(83.0 22.8)" .
+
 <http://www.wikidata.org/entity/Q538> rdfs:label "Oceania" .
 <http://www.wikidata.org/entity/Q49> rdfs:label "North America" .
 <http://www.wikidata.org/entity/Q18> rdfs:label "South America" .
-- 
cgit v1.2.3