Changeset 34845

Timestamp:

2021-02-14T15:09:45+13:00 (3 years ago)

Author:

davidb

Message:

Explicit filters added in to resolve song titles/entrants that resolve to identical integer vals

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/errata/local--countries-in-esc-by-year-after-1956--with-errata.sparql (modified) (1 diff)

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

@@ -55 +55 @@
   BIND (IF(isIRI(?song),?song,?song_errata_uri) AS ?song_robust)
 
-
-#    BIND(REPLACE(REPLACE(str(?entrant_robust), "^.*/", "", "i"),"_"," ","i") AS ?entrant_label_raw).
-#    # Create more DL friendly entrant-title metadata from Wikipedia entrant-uri/label
-#    BIND(REPLACE(?entrant_label_raw, "\\s*\\(.*?singer\\)$", "", "i") AS ?entrant_label_p1).
-#    BIND(REPLACE(?entrant_label_p1, "\\s*\\(.*?duo\\)$", "", "i") AS ?entrant_label_p2).
-#    BIND(REPLACE(?entrant_label_p2, "\\s*\\(.*?band\\)$", "", "i") AS ?entrant_label_p3).
-#    BIND(REPLACE(?entrant_label_p3, "\\s*\\(.*?group\\)$", "", "i") AS ?entrant_label_p4).
-#    BIND(REPLACE(?entrant_label_p4, "\\s*\\(.*?musician\\)$", "", "i") AS ?entrant_label).
-
   # Create more DL friendly entrant-title metadata from Wikipedia entrant-uri/label
   BIND(REPLACE(REPLACE(str(?entrant_robust), "^.*/(.*?)(_+\\(.*(singer|duo|band|group|musician)\\))?$", "$1"),"_"," ") AS ?entrant_label).
 
-
-#    BIND(REPLACE(REPLACE(str(?song_robust), "^.*/", "", "i"),"_"," ","i") AS ?song_label_raw).
-#    # Create more DL friendly song-title metadata from Wikipedia song-uri/label
-#    BIND(REPLACE(?song_label_raw, "\\s*\\(.*?song\\)$", "", "i") AS ?song_label).
-##    BIND(REPLACE(?song_label_p1, "\\s*\\(.*?band\\)$", "", "i") AS ?song_label_p2).
-##    BIND(REPLACE(?song_label_p2, "\\s*\\(.*?duo\\)$", "", "i") AS ?song_label).
-
   # Create more DL friendly song-title metadata from Wikipedia song-uri/label
   BIND(REPLACE(REPLACE(str(?song_robust), "^.*/(.*?)(_+\\(.*song\\))?$", "$1"),"_"," ") AS ?song_label).
+
+# DBpedia incorrectly maps some songs/entrants to integer numbers
+# Most of these can be fixed with the usual errata approach,
+# however there are a few examples that map to identical
+# integer vals, and therefore are not unique.
+#
+# The chosen solution to address this is to include some
+# bespoke filtering to explicitly rule in the song+entrant combination
+# we want (i.e., the filter has the affect of ruling out the
+# (incorrect) combination we don't want.
+
+#dbr:Macedonia_in_the_Eurovision_Song_Contest_2000
+# song: "100"^^xsd:integer
+#   dbr:100%25_te_ljubam 
+#   dbr:XXL_\(Macedonian_band\))
+#
+#Luxembourg_in_the_Eurovision_Song_Contest_1984
+# song: "100"^^xsd:integer
+#   dbr:100%25_d%27amour
+#   dbr:Sophie_Carle
+
+#dbr:Belarus_in_the_Eurovision_Song_Contest_2010
+# entrant: "3"^^xsd:integer
+#   dbr:3%2B2_\(band\)
+#   dbr:Butterflies_\(3%2B2_song\)
+#
+#dbr:Netherlands_in_the_Eurovision_Song_Contest_2011
+# entrant: "3"^^xsd:integer
+#   dbr:3JS
+#   dbr:Je_vecht_nooit_alleen
+    
+  FILTER(
+    (?song != "100"^^xsd:integer && ?entrant != "3"^^xsd:integer)
+    ||
+    (?song = "100"^^xsd:integer
+      && ?song_robust = dbr:100%25_te_ljubam && ?entrant = dbr:XXL_\(Macedonian_band\))
+    ||
+    (?song = "100"^^xsd:integer
+      && ?song_robust = dbr:100%25_d%27amour && ?entrant = dbr:Sophie_Carle)
+    ||
+    (?entrant = "3"^^xsd:integer
+      && ?entrant_robust = dbr:3\+2_\(band\) && ?song_robust = dbr:Butterflies_\(3\+2_song\))
+    ||
+    (?entrant = "3"^^xsd:integer
+      && ?entrant_robust = dbr:3JS && ?song_robust = dbr:Je_vecht_nooit_alleen)
+  ).
+
+#      && ?entrant_robust = dbr:3%2B2_\(band\) && ?song_robust = dbr:Butterflies_\(3%2B2_song\))
+
 
   SERVICE <https://dbpedia.demo.openlinksw.com/sparql> {