Changeset 35967

Timestamp:

2022-01-11T14:56:30+13:00 (2 years ago)

Author:

davidb

Message:

Now working with all-caps on 3letter title disambiguation for better consistency

Location:

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/errata-lod

Files:

• local--countries-in-esc-by-year-in-1956--with-errata.json (modified) (6 diffs)
• local--countries-in-esc-by-year-in-1956--with-errata.sparql (modified) (1 diff)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/errata-lod/local--countries-in-esc-by-year-in-1956--with-errata.json

@@ -10 +10 @@
         "Year": { "type": "literal" , "value": "1956" } ,
         "Country": { "type": "literal" , "xml:lang": "en" , "value": "Germany" } ,
-        "TitleDisambiguation": { "type": "literal" , "value": "Sog" } ,
+        "TitleDisambiguation": { "type": "literal" , "value": "SOG" } ,
         "entrant_robust": { "type": "uri" , "value": "http://dbpedia.org/resource/Freddy_Quinn" } ,
         "Creator": { "type": "literal" , "value": "Freddy Quinn" } ,
@@ -25 +25 @@
         "Year": { "type": "literal" , "value": "1956" } ,
         "Country": { "type": "literal" , "xml:lang": "en" , "value": "Germany" } ,
-        "TitleDisambiguation": { "type": "literal" , "value": "ImW" } ,
+        "TitleDisambiguation": { "type": "literal" , "value": "IMW" } ,
         "entrant_robust": { "type": "uri" , "value": "http://dbpedia.org/resource/Walter_Andreas_Schwarz" } ,
         "Creator": { "type": "literal" , "value": "Walter Andreas Schwarz" } ,
@@ -40 +40 @@
         "Year": { "type": "literal" , "value": "1956" } ,
         "Country": { "type": "literal" , "xml:lang": "en" , "value": "Netherlands" } ,
-        "TitleDisambiguation": { "type": "literal" , "value": "Voo" } ,
+        "TitleDisambiguation": { "type": "literal" , "value": "VOO" } ,
         "entrant_robust": { "type": "uri" , "value": "http://dbpedia.org/resource/Corry_Brokken" } ,
         "Creator": { "type": "literal" , "value": "Corry Brokken" } ,
@@ -55 +55 @@
         "Year": { "type": "literal" , "value": "1956" } ,
         "Country": { "type": "literal" , "xml:lang": "en" , "value": "Netherlands" } ,
-        "TitleDisambiguation": { "type": "literal" , "value": "Dev" } ,
+        "TitleDisambiguation": { "type": "literal" , "value": "DEV" } ,
         "entrant_robust": { "type": "uri" , "value": "http://dbpedia.org/resource/Jetty_Paerl" } ,
         "Creator": { "type": "literal" , "value": "Jetty Paerl" } ,
@@ -70 +70 @@
         "Year": { "type": "literal" , "value": "1956" } ,
         "Country": { "type": "literal" , "xml:lang": "en" , "value": "Switzerland" } ,
-        "TitleDisambiguation": { "type": "literal" , "value": "Das" } ,
+        "TitleDisambiguation": { "type": "literal" , "value": "DAS" } ,
         "entrant_robust": { "type": "uri" , "value": "http://dbpedia.org/resource/Lys_Assia" } ,
         "Creator": { "type": "literal" , "value": "Lys Assia" } ,
@@ -85 +85 @@
         "Year": { "type": "literal" , "value": "1956" } ,
         "Country": { "type": "literal" , "xml:lang": "en" , "value": "Switzerland" } ,
-        "TitleDisambiguation": { "type": "literal" , "value": "Ref" } ,
+        "TitleDisambiguation": { "type": "literal" , "value": "REF" } ,
         "entrant_robust": { "type": "uri" , "value": "http://dbpedia.org/resource/Lys_Assia" } ,
         "Creator": { "type": "literal" , "value": "Lys Assia" } ,

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/errata-lod/local--countries-in-esc-by-year-in-1956--with-errata.sparql

@@ -75 +75 @@
   BIND(REPLACE(REPLACE(str(?song_robust), "^.*/(.*?)(_+\\(.*song\\))?$", "$1"),"_"," ") AS ?song_label).
 
-  BIND(SUBSTR(REPLACE(?song_label," ",""),1,3) AS ?song_label_3char).
+  BIND(UCASE(SUBSTR(REPLACE(?song_label," ",""),1,3)) AS ?song_label_3char).