Changeset 34756


Ignore:
Timestamp:
2021-01-30T09:47:43+13:00 (3 years ago)
Author:
davidb
Message:

extra filter added to guard against empty strings; resulting HTML files produced from queries updated also

Location:
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare
Files:
4 edited

Legend:

Unmodified
Added
Removed

  • main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/problem-songs-and-entrants.html

    r34752 r34756  
     1<html>
     2<head>
     3  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
     4</head>
     5<body>
     6 
    17<table class="sparql" border="1">
    28  <tr>
    … …  
    7783    <td><pre>"Shalom Olam"@en</pre></td>
    7884  </tr>
    79   <tr>
    80     <td><a href="http://dbpedia.org/resource/Cyprus_in_the_Eurovision_Song_Contest_2010">http://dbpedia.org/resource/Cyprus_in_the_Eurovision_Song_Contest_2010</a></td>
    81     <td><pre>2010</pre></td>
    82     <td><pre>"Cyprus"@en</pre></td>
    83     <td><pre>"Jon Lilygreen and The Islanders"@en</pre></td>
    84     <td><pre>""@en</pre></td>
    85   </tr>
    86 </table>
     85</table></body>
     86</html>

  • main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/problem-songs-and-entrants.sparql

    r34752 r34756  
    1212
    1313    ?country_in_year dbp:entrant ?entrant
    14       FILTER (isLITERAL(?entrant)).
     14      FILTER (isLITERAL(?entrant) && ?entrant != ""@en).
    1515
    1616    ?country_in_year dbp:song ?song
    17       FILTER (isLITERAL(?song)).
     17      FILTER (isLITERAL(?song) && ?song != ""@en).
    1818   
    1919}

  • main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/problem-songs.html

    r34752 r34756  
     1<html>
     2<head>
     3  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
     4</head>
     5<body>
     6 
    17<table class="sparql" border="1">
    28  <tr>
    … …  
    1622    <td><pre>1956</pre></td>
    1723    <td><pre>"Luxembourg"@en</pre></td>
    18     <td><pre>"&quot;Les Amants De Minuit"@en</pre></td>
     24    <td><pre>"Ne Crois Pas&quot; and"@en</pre></td>
    1925  </tr>
    2026  <tr>
    … …  
    2228    <td><pre>1956</pre></td>
    2329    <td><pre>"Luxembourg"@en</pre></td>
    24     <td><pre>"Ne Crois Pas&quot; and"@en</pre></td>
     30    <td><pre>"&quot;Les Amants De Minuit"@en</pre></td>
    2531  </tr>
    2632  <tr>
    … …  
    3440    <td><pre>1956</pre></td>
    3541    <td><pre>"Netherlands"@en</pre></td>
    36     <td><pre>"&quot;Voorgoed voorbij"@en</pre></td>
     42    <td><pre>"De vogels van Holland&quot; and"@en</pre></td>
    3743  </tr>
    3844  <tr>
    … …  
    4046    <td><pre>1956</pre></td>
    4147    <td><pre>"Netherlands"@en</pre></td>
    42     <td><pre>"De vogels van Holland&quot; and"@en</pre></td>
     48    <td><pre>"&quot;Voorgoed voorbij"@en</pre></td>
    4349  </tr>
    4450  <tr>
    … …  
    139145    <td><pre>22</pre></td>
    140146  </tr>
    141 </table>
     147</table></body>
     148</html>

  • main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/problem-songs.sparql

    r34752 r34756  
    1515
    1616    ?country_in_year dbp:song ?song
    17        FILTER (isLITERAL(?song))
     17       FILTER (isLITERAL(?song) && ?song != ""@en).
    1818}
    1919ORDER BY ASC(?countries_in_esc_by_year)
Note: See TracChangeset for help on using the changeset viewer.