Countries

3 files changed, 80 insertions, 28 deletions

diff --git a/scripts/db_enrichment/input_location.csv b/scripts/db_enrichment/input_location.csv
index eb5322a..a4246cd 100644
--- a/scripts/db_enrichment/input_location.csv
+++ b/scripts/db_enrichment/input_location.csv
@@ -1,5 +1,16 @@
-http://www.wikidata.org/entity/Q3289517
-http://www.wikidata.org/entity/Q79663
-http://www.wikidata.org/entity/Q2145339
-http://www.wikidata.org/entity/Q23197
-http://www.wikidata.org/entity/Q494755
+http://www.wikidata.org/entity/Q7960498
+http://www.wikidata.org/entity/Q692895
+http://www.wikidata.org/entity/Q928
+http://www.wikidata.org/entity/Q2722074
+http://www.wikidata.org/entity/Q25622187
+http://www.wikidata.org/entity/Q27684996
+http://www.wikidata.org/entity/Q2757125
+http://www.wikidata.org/entity/Q1922283
+http://www.wikidata.org/entity/Q490
+http://www.wikidata.org/entity/Q677037
+http://www.wikidata.org/entity/Q3037
+http://www.wikidata.org/entity/Q843
+http://www.wikidata.org/entity/Q183
+http://www.wikidata.org/entity/Q29
+http://www.wikidata.org/entity/Q17
+http://www.wikidata.org/entity/Q810
diff --git a/scripts/uthsc_samples/uthsc_samples.py b/scripts/uthsc_samples/uthsc_samples.py
index c18c07a..3ad2561 100644
--- a/scripts/uthsc_samples/uthsc_samples.py
+++ b/scripts/uthsc_samples/uthsc_samples.py
@@ -32,13 +32,13 @@ for index, row in table.iterrows():
           sample_name = sample
           collection_date = parse(str(row['Collection Date'])).strftime('%Y-%m-%d')
           locationx = row['City']+", "+row['State']+", USA"
-          location = "http://www.wikidata.org/enitity/Q16563" # Memphis by default
+          location = "http://www.wikidata.org/entity/Q16563" # Memphis by default
           map = {
-              "Pegram": "http://www.wikidata.org/enitity/Q3289517",
-              "Alexander": "http://www.wikidata.org/enitity/Q79663",
-              "Smithville": "http://www.wikidata.org/enitity/Q2145339",
-              "Nashville": "http://www.wikidata.org/enitity/Q23197",
-              "Madison": "http://www.wikidata.org/enitity/Q494755"
+              "Pegram": "http://www.wikidata.org/entity/Q3289517",
+              "Alexander": "http://www.wikidata.org/entity/Q79663",
+              "Smithville": "http://www.wikidata.org/entity/Q2145339",
+              "Nashville": "http://www.wikidata.org/entity/Q23197",
+              "Madison": "http://www.wikidata.org/entity/Q494755"
               }
 
           for name in map:
diff --git a/semantic_enrichment/countries.ttl b/semantic_enrichment/countries.ttl
index fe50b16..728877f 100644
--- a/semantic_enrichment/countries.ttl
+++ b/semantic_enrichment/countries.ttl
@@ -220,7 +220,6 @@
     ns1:P17 <http://www.wikidata.org/entity/Q30> ;
     ns1:P625 "Point(-120.0 37.0)" .
 
-
 <http://www.wikidata.org/entity/Q155> rdfs:label "Brazil" ;
     ns1:P17 <http://www.wikidata.org/entity/Q155> ;
     ns1:P30 <http://www.wikidata.org/entity/Q18> ;
@@ -1157,7 +1156,9 @@
     ns1:P625 "Point(28.0 -14.0)" .
 
 <http://www.wikidata.org/entity/Q96> rdfs:label "Mexico" ;
-    ns1:P30 <http://www.wikidata.org/entity/Q49> .
+    ns1:P17 <http://www.wikidata.org/entity/Q96> ;
+    ns1:P30 <http://www.wikidata.org/entity/Q49> ;
+    ns1:P625 "Point(-102.0 23.0)" .
 
 <http://www.wikidata.org/entity/Q1028> rdfs:label "Morocco" ;
     ns1:P17 <http://www.wikidata.org/entity/Q1028> ;
@@ -1170,32 +1171,17 @@
         <http://www.wikidata.org/entity/Q48> ;
     ns1:P625 "Point(94.25 66.416666666)" .
 
-<http://www.wikidata.org/entity/Q183> rdfs:label "Germany" ;
-    ns1:P30 <http://www.wikidata.org/entity/Q46> .
-
-<http://www.wikidata.org/entity/Q29> rdfs:label "Spain" ;
-    ns1:P30 <http://www.wikidata.org/entity/Q46> .
-
-<http://www.wikidata.org/entity/Q38> rdfs:label "Italy" ;
-    ns1:P30 <http://www.wikidata.org/entity/Q46> .
-
 <http://www.wikidata.org/entity/Q55> rdfs:label "Netherlands" ;
     ns1:P17 <http://www.wikidata.org/entity/Q29999> ;
     ns1:P30 <http://www.wikidata.org/entity/Q27611>,
         <http://www.wikidata.org/entity/Q46> ;
     ns1:P625 "Point(5.55 52.316666666)" .
 
-<http://www.wikidata.org/entity/Q810> rdfs:label "Jordan" ;
-    ns1:P30 <http://www.wikidata.org/entity/Q48> .
-
 <http://www.wikidata.org/entity/Q1044> rdfs:label "Sierra Leone" ;
     ns1:P17 <http://www.wikidata.org/entity/Q1044> ;
     ns1:P30 <http://www.wikidata.org/entity/Q15> ;
     ns1:P625 "Point(-11.916667 8.5)" .
 
-<http://www.wikidata.org/entity/Q17> rdfs:label "Japan" ;
-    ns1:P30 <http://www.wikidata.org/entity/Q48> .
-
 <http://www.wikidata.org/entity/Q948> rdfs:label "Tunisia" ;
     ns1:P17 <http://www.wikidata.org/entity/Q948> ;
     ns1:P30 <http://www.wikidata.org/entity/Q15> ;
@@ -1348,6 +1334,61 @@
     ns1:P17 <http://www.wikidata.org/entity/Q30> ;
     ns1:P625 "Point(-85.936008 32.933157)" .
 
+<http://www.wikidata.org/entity/Q1922283> rdfs:label "Mehsana" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q668> ;
+    ns1:P625 "Point(72.4 23.6)" .
+
+<http://www.wikidata.org/entity/Q3037> rdfs:label "Kathmandu" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q837> ;
+    ns1:P625 "Point(85.366666666 27.716666666)" .
+
+<http://www.wikidata.org/entity/Q490> rdfs:label "Milan" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q38> ;
+    ns1:P625 "Point(9.19 45.466944444)" .
+
+<http://www.wikidata.org/entity/Q677037> rdfs:label "Telangana" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q668> ;
+    ns1:P625 "Point(79.59 17.99)" .
+
+<http://www.wikidata.org/entity/Q928> rdfs:label "Philippines" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q928> ;
+    ns1:P30 <http://www.wikidata.org/entity/Q48> ;
+    ns1:P625 "Point(123.0 12.0)" .
+
+<http://www.wikidata.org/entity/Q1922283> rdfs:label "Mehsana" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q668> ;
+    ns1:P625 "Point(72.4 23.6)" .
+
+<http://www.wikidata.org/entity/Q17> rdfs:label "Japan" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q17> ;
+    ns1:P30 <http://www.wikidata.org/entity/Q48> ;
+    ns1:P625 "Point(136.0 35.0)" .
+
+<http://www.wikidata.org/entity/Q183> rdfs:label "Germany" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q183> ;
+    ns1:P30 <http://www.wikidata.org/entity/Q46> ;
+    ns1:P625 "Point(10.0 51.0)" .
+
+<http://www.wikidata.org/entity/Q29> rdfs:label "Spain" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q29> ;
+    ns1:P30 <http://www.wikidata.org/entity/Q46> ;
+    ns1:P625 "Point(-3.5 40.2)" .
+
+<http://www.wikidata.org/entity/Q810> rdfs:label "Jordan" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q810> ;
+    ns1:P30 <http://www.wikidata.org/entity/Q48> ;
+    ns1:P625 "Point(36.5 31.2)" .
+
+<http://www.wikidata.org/entity/Q843> rdfs:label "Pakistan" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q843> ;
+    ns1:P30 <http://www.wikidata.org/entity/Q48> ;
+    ns1:P625 "Point(71.0 30.0)" .
+
+<http://www.wikidata.org/entity/Q928> rdfs:label "Philippines" ;
+    ns1:P17 <http://www.wikidata.org/entity/Q928> ;
+    ns1:P30 <http://www.wikidata.org/entity/Q48> ;
+    ns1:P625 "Point(123.0 12.0)" .
+
 <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" .