source: main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/about.xsl@ 34890

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE videocollection [
  <!ENTITY ndash "&#8211;">
  <!ENTITY mdash "&#8212;">
]>
<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:java="http://xml.apache.org/xslt/java"
    xmlns:util="xalan://org.greenstone.gsdl3.util.XSLTUtil"
    xmlns:gslib="http://www.greenstone.org/skinning"
    extension-element-prefixes="java util"
    exclude-result-prefixes="java util">


  <xsl:template name="coll-description">
        <div id="about-desc">
      <h2>Introduction</h2>
      <!--
      <p style="padding-bottom: 10px;">
        The <a href="https://eurovision.tv">Eurovision Song
        Content</a> is a live-broadcast televised event that
        was first held in 1956 featuring artists singing original songs from
        7 countries.  Since then it has grown into an event involving
        over 40 countries, and streamed all around the world. ...
        
      </p>
      -->
      
      <p style="padding-bottom: 10px;">
        The <a href="https://eurovision.tv">Eurovision Song
        Contest</a> is a live-broadcast televised multi-national
        competition with a collaborative mission, much like the
        Olympics.  A help to shore up a post war Europe in 1956 it
        all began, where there were only seven countries and one
        camera man! The contest has grown significantly from
        there, with 43 countries competing most years—even
        Australia takes part now. It's an annual celebration of
        European culture and the highlight of many people's
        year.
      </p>

      <p>       
        At Eurovision there is no division because wherever
        you come from Eurovision is home. The Eurovision song
        contest is widely known as a safe space for LGBTQIA+
        people and a platform for free expression. For example
        trans-woman
        <a href="https://en.wikipedia.org/wiki/Dana_International">Dana International</a>
        won as far back as 1998.
        There have been songs in many different languages over the
        years, although most are in English these days. This
        doesn't matter, however, because music is a language we all
        know how to speak.
      </p>
      <p>       
        In its latest incarnation, after
        all the performances are over, artists wait
        nervously as via the Internet the show's hosts visit each
        of the 43 countries in turn collecting all points cast.
        The scoring comprises votes from a combination of country appointed juries and
        &quot;the popular vote&quot;—including the all important
        top score that can be cast, 12 points (Douze Points!)—until a new winner is crowned.
      </p>
      
      <p>       
        The (unoffical) website has been developed by a group of Digital Library
        researchers who, unsurprisingly, turn out to be also <i>huge</i>
        fans of Eurovision.
        We wish to share both our love for the competition,
        and to demonstrate what is possible when (harnessing some of
        that passion!) the techniques of
        Linked Open Data are applied to the Open Source
        <a href="https://www.greenstone.org">Greenstone3</a>
        Digital Library platform.
      </p>
      <p>
        We suggest you initially
        start by exploring the assembled information through
        the browsing tabs, such as
        <a href="{$library_name}/collection/{$collName}/browse/CL3">browser by country</a>
        or else search the collection for a general term that you sparks
        interest, such as
        <a href="{$library_name}/collection/{$collName}/search/TextQuery?qs=1&amp;rt=rd&amp;s1.level=Doc&amp;startPage=1&amp;s1.query=love&amp;s1.index=ZZ">love</a>
        and
        <a href="{$library_name}/collection/{$collName}/search/TextQuery?qs=1&amp;rt=rd&amp;s1.level=Doc&amp;startPage=1&amp;s1.query=amore&amp;s1.index=ZZ">amore</a>,
        or perhaps something more frivolous such as
        <a href="{$library_name}/collection/{$collName}/search/TextQuery?qs=1&amp;rt=rd&amp;s1.level=Doc&amp;startPage=1&amp;s1.query=la&amp;s1.index=ZZ">la</a>.
        
      </p>
      

      <script type="text/javascript" src="//www.google.com/jsapi"><xsl:text> </xsl:text></script>
          <script type="text/javascript" src="//mgskjaeveland.github.io/sgvizler/v/0.6/sgvizler.js"><xsl:text> </xsl:text></script>
        
      <script type="text/javascript">
        <xsl:text disable-output-escaping="yes">
          $(document).ready(    
                function() {
          
                  sgvizler.prefix('dc','http://purl.org/dc/elements/1.1/');
              sgvizler.prefix('gsextracted','http://greenstone.org/gsextracted#');

                  //sgvizler.prefix('gsembedded','http://greenstone.org/gsembedded#');
          //sgvizler.prefix('greenstonedata','http://bedrock.resnet.cms.waikato.ac.nz:3030/greenstone/data/');


          // Exaple triple
          // "s": { "type": "uri" , "value": "http://127.0.0.1:8383/greenstone3/library/collection/eurovision/document/HASH0191e9cc7bfdf14743472257s10" } ,
          // "p": { "type": "uri" , "value": "gsextracted:Country" } ,
          // "o": { "type": "literal" , "value": "United Kingdom" }
          
          sgvizler.containerDrawAll();
        }
              );
        </xsl:text>
      </script>

      <div id="sgvzl_example1"
           data-sgvizler-endpoint="//sowemustthink.space/greenstone3-lod/greenstone/query"         
           data-sgvizler-chart="google.visualization.PieChart"
           data-sgvizler-loglevel="2"
           data-sgvizler-chart-options="title=Number of Songs from each Country"
           style="width:650px; height:500px; margin-left: auto; margin-right: auto">
        <xsl:attribute name="data-sgvizler-query">
              SELECT (?country) (COUNT(?country) AS ?freqCount)
              WHERE {
                  GRAPH &lt;http://localhost:3030/greenstone/data/eurovision&gt;  {
                    ?s gsextracted:Country ?country
                  }
              }
              GROUP BY ?country ORDER BY asc(?country)
        </xsl:attribute>
        <xsl:text> Loading ...</xsl:text>
      </div>


      <div id="technicaldev-turnstyle" style="margin-top: 12px;">
        <div class="turnstyle-header" style="background-image: none; background-color: hsl(195, 47%, 35%);">
          DL Technical Development
        </div>

        <div style="display: none; padding-left: 6px; padding-top: 6px; margin-left: 2px; margin-right: 2px; border-left: white solid 1px; border-right: white solid 1px; border-bottom: white solid 1px;">
          <p>
        In terms of how this collection was developed using the
        Greenstone DL architecture, the starting point is the
        formulation of a SPARQL query to retrieve from DBpedia
        entries about all the entrants in the contest over the
        years:
        <pre style="background-color: #fff; color: #000; padding: 12px; margin-right: 6px;">
SELECT ?countries_in_esc_by_year ?country_in_year ?year as ?Year ?country as ?Country ?entrant ?entrant_label as ?Creator ?song ?song_label as ?Title ?was_derived_from as ?WikipediaURL
WHERE {
    ?countries_in_esc_by_year skos:broader dbc:Countries_in_the_Eurovision_Song_Contest_by_year.

    ?country_in_year dct:subject ?countries_in_esc_by_year.
    bind( REPLACE(str(?country_in_year), ".*(\\d{4})", "$1") as ?year).
    FILTER ( xsd:integer(?year) &lt; 2020).

    ?country_in_year dbp:country ?country.

    ?country_in_year dbp:entrant ?entrant.
    ?entrant rdfs:label ?entrant_label
      FILTER (lang(?entrant_label) = 'en').

    ?country_in_year dbp:song ?song.
    ?song rdfs:label ?song_label
      FILTER (lang(?song_label) = 'en').

    OPTIONAL {
      ?song prov:wasDerivedFrom ?was_derived_from
    }
}
ORDER BY DESC(?countries_in_esc_by_year)
        </pre>
          
          </p>
          
          <p>         
        The resulting SPARQL query result set (JSON format
        selected for output) is then ingested into a Greenstone
        DL collection, and used in a variety of ways.  For now
        an (admittedly cryptic) list of technical steps that
        were developed and/or deployed to provide the
        functionality encountered in interacting with this site.
        
        <ul>
          <li>New SPARQL plugin for <i>download_from.pl</i> developed, used in GLI to enter the above query</li>
          <li>New SPARQL <i>Document Processing</i> plugin developed</li>
          <li>Greenstone3 Apache Jena Triple Store Extension activated</li>
          <li>SGVizler used to display Google Visualizations such as the pie-chart above.</li>
          <li>Metadata in document view enhanced through Greenstone Format Statements micro-data</li>
          <li>Custom <i>interface</i> developed</li>
        </ul>
          </p>
          
          <p>
        Bullet points above to be expanded upon!
          </p>
          
          <p>
        Viewing the
        <a download="collectionConfig.xml"
               href="sites/{$site_name}/collect/{$collName}/etc/collectionConfig.xml">collection
        configuration file</a> provides a good insight into how
        all of these technical aspectcs are brought together.
          </p>
          
          <p>
        Full disclosure as to how the collection all ticks is
        provided through our Subversion repository.  Topping up
        our
        <a href="https//trac.greenstone.org/browser/main/trunk/greenstone3">Greenstone3
        code base</a> we have:
        
        <ul>
          <li>The site: <a href="https://trac.greenstone.org/browser/main/trunk/model-sites-dev/eurovision-lod">eurovision-lod</a></li>
          <li>The interface: <a href="https://trac.greenstone.org/browser/main/trunk/model-interfaces-dev/eurovision-lod">eurovision-lod</a></li>
          <li>The triplestore extension: <a href="https://trac.greenstone.org/browser/gs2-extensions/apache-jena/trunk/src">apache-jena</a></li>
        </ul>
            
          </p>
        </div>
      </div>
      
      <script>
        <xsl:text disable-output-escaping="yes">
              $(function(){
                transformToTurnstyleBlock("technicaldev");
              });
        </xsl:text>
      </script>
      
      <div id="LOD-turnstyle" style="margin-top: 12px;">
        <div class="turnstyle-header" style="background-image: none; background-color: hsl(195, 47%, 35%);">
          Linked Open Data
        </div>

        <div style="display: none; padding-left: 6px; padding-top: 6px; margin-left: 2px; margin-right: 2px; border-left: white solid 1px; border-right: white solid 1px; border-bottom: white solid 1px;">


          <h2>Eurovision LOD SPARQL Endpoints</h2>
          <p>
        The source data can be access vis the DBpedia SPARQL endpoint.  The ingested,
        data (with correction) is available through the collection's local
        SPARQL endpoint:
        <ul>
          <li>
            <a href="https://dbpedia.org/sparql/">DBpedia's SPARQL endpoint</a>
          </li>
          <li>
            <a href="{$library_name}/collection/{$collName}/page/sparql">DL's (local) SPARQL endpoint</a>
          </li>
        </ul>
          </p>
          
          <h2>Eurovision LOD Errata</h2>
          <p>
        Songs titles and Entrants (artists) that do not resolve to URIs:
        <ul>
          <li>
            <a href="sites/{$site_name}/collect/{$collName}/prepare/problem-lod-lists/dbpedia-problem-songs.html">Problem Songs (titles are string literals not IRIs)</a>
          </li>
          <li>
            <a href="sites/{$site_name}/collect/{$collName}/prepare/problem-lod-lists/dbpedia-problem-entrants.html">Problem Entrants (artists are string literals not IRIs)</a>
          </li>
        </ul>
          </p>
        </div>
      </div>
      
      <script>
        <xsl:text disable-output-escaping="yes">
              $(function(){
                transformToTurnstyleBlock("LOD");
              });
        </xsl:text>
      </script>

      <div id="voting-turnstyle" style="margin-top: 12px;">
        <div class="turnstyle-header" style="background-image: none; background-color: hsl(195, 47%, 35%);">
          Voting Data
        </div>

        <div style="display: none; padding-left: 6px; padding-top: 6px; margin-left: 2px; margin-right: 2px; border-left: white solid 1px; border-right: white solid 1px; border-bottom: white solid 1px;">
          <p>
        The Voting data used in this collection is sourced from the Kaggle, which in turn
        is derived from work available through Data Graver:
        <ul>
          <li><a href="https://www.kaggle.com/datagraver/eurovision-song-contest-scores-19752019">Kaggle Eurovision Voting dataset 1975-2019</a></li>
          <li><a href="https://data.world/datagraver/eurovision-song-contest-scores-1975-2019">Data Graver</a></li>
          <li><a href="https://docs.google.com/spreadsheets/d/1veXpiF54hQGP4OVuf1xjowumIe8HUOhI/edit#gid=528591420">Google Spreadsheet (internal use only)</a></li>
          
        </ul>
          </p>
        </div>    
      </div>

      <script>
        <xsl:text disable-output-escaping="yes">
              $(function(){
                transformToTurnstyleBlock("voting");
              });
        </xsl:text>
      </script>

      
    </div>
    
  </xsl:template>
    

</xsl:stylesheet>