Changeset 35037


Ignore:
Timestamp:
2021-04-06T00:17:05+12:00 (3 years ago)
Author:
davidb
Message:

Updated to newly expanded queries; moved some rough-cut text out to a .scrap file

Location:
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/about.xsl

    r35012 r35037  
    208208          this page to help you get started.
    209209       
    210         <!--
    211         or else
    212 
    213         want to produce
    214        
    215         learn more about how to query the underlying data to
    216         produce such visualizations, then you move over to the
    217        
    218         the underlying data the visualizations are based on,
    219        
    220         been extract
    221         the underlying data
    222        
    223         the underlying analysis
    224         data,
    225         -->
    226        
    227210        </p>
    228211        <ul>
    … …  
    249232          });
    250233      </gsf:script>
    251 
    252 <!--       
    253         can transform th
    254 
    255         &mdash;visualizing
    256 
    257 The voting data is probably the most interesting aspect
    258         voting data is particular interesting!&mdash;
    259        
    260         , but&mdash;more importantly&mdash;
    261        
    262 
    263 
    264         : by initiating a query
    265         to the digital library through a SPARQL (pronouced Sparkle) query that retrieves all
    266         the countries that have competed in the contest over the years, g
    267 
    268         This is how the
    269 
    270         allowing you
    271         to query it directly, meaning you can query and analyse it in ways
    272 
    273         to let you access and analyse the data
    274 
    275         and further, we have added in a data visualization layer to the
    276         digital library to aid presning the
    277 
    278         interpretting
    279 
    280         better understand what the data
    281 
    282 
    283                 To help you get started we have provided some
    284 
    285            
    286         Additionally we have provided some sample
    287 
    288         sa
    289 
    290         to help with this we have added in a data visualization layer to the
    291         digital library.  Additionally we have provided some sample
    292 
    293          The voting data is probably the most interesting aspect
    294          to dig into, and
    295          
    296         and we have
    297         to dig into the data
    298        
    299         way we source
    300        
    301         You can also dig into the data directly
    302 -->
    303234
    304235

  • main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/sgvizler.xsl

    r35010 r35037  
    1414    <xsl:import href="dataviz/made-the-final.xsl"/>
    1515    <xsl:import href="dataviz/got-nul-point.xsl"/>
     16    <xsl:import href="dataviz/got-nul-point-after-winning.xsl"/>
    1617    <xsl:import href="dataviz/voting-dataflow-jury.xsl"/>
    1718    <xsl:import href="dataviz/voting-dataflow-tele.xsl"/>
     19    <xsl:import href="dataviz/draw-bias.xsl"/>
    1820   
    1921    <xsl:variable name="groupPath"><xsl:value-of select="/page/pageRequest/paramList/param[@name='group']/@value"/></xsl:variable>
    … …  
    4345      -->
    4446      <gsf:script src="sites/{$site_name}/collect/{$collName}/js/eurovision.js"/>
     47      <gsf:script src="sites/{$site_name}/collect/{$collName}/js/dataviz.js"/>
    4548
    4649      <link rel="stylesheet" href="sites/{$site_name}/collect/{$collName}/css/eurovision.css" type="text/css" />
     50      <link rel="stylesheet" href="sites/{$site_name}/collect/{$collName}/css/dataviz.css" type="text/css" />
    4751      <style>
    48         XXXXdiv.page { padding-left: 12px; padding-right: 12px; padding-top: 6px; padding-bottom: 6px;}
    4952        div.page { margin-left: 12px; margin-right: 12px; margin-top: 6px; margin-bottom: 6px;}
    5053        p { padding-bottom: 12px;}
    … …  
    5659        <h2>Visualize the Eurovision Linked-Data</h2>
    5760
     61        <p>       
     62          Explore the Linked Data stored in this collection
     63          through the samples provided that produce a range of
     64          visualizations.  For a given sample visualization, the
     65          approach used is to first load in a SPARQL query that
     66          extracts and manipulates the linked data in the
     67          underlying triplestore that represents all the metadata
     68          stored in the collection.
     69          This is then passed on to
     70          <i>SGVizler</i>, a JavaScript visualization library, to
     71          display in graphical form the generated data.       
     72        </p>
     73
    5874        <p>
    59           SGVizler ...
     75          In terms of the user interface, this is achived by
     76          pressing the <i>Load query above</i> button for a sample
     77          visualization that has piqued your interested (listed
     78          below).  This causes a <i>Visualize Results</i> button
     79          appear alongside the load button you have just pressed,
     80          which when clicked runs the loaded in query and visualizes the result.
     81        </p>
     82
     83        <p>
     84          We use this two-step process so it is possible to
     85          change what query is run, and how the resulting data is visualized.
     86          The first text-box below is for the SPARQL query.  The following
     87          3 text-boxes control aspects of the visualization.
     88          If you haven't worked with the underlying tools before,
     89          we suggest you work your way through the sample visualizations
     90          provided, trying out small edits to see how that affects
     91          what is produced.
    6092        </p>
    6193       
    … …  
    76108<!-- -->
    77109<xsl:text>
    78 <!-- 
    79 PREFIX rdfs: &lt;http://www.w3.org/2000/01/rdf-schema#&gt;
    80 PREFIX gsdlextracted: &lt;http://greenstone.org/gsdlextracted#&gt;
    81 SELECT (?country) (COUNT(?country) AS ?freqCount)       
    82 WHERE {
    83     GRAPH &lt;http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>&gt;  {
    84         ?s gsdlextracted:Country ?country.
    85    }
    86 }
    87 GROUP BY ?country ORDER BY DESC(?freqCount)
    88 -->
    89110</xsl:text>
    90111          </textarea>
    91112
    92           <pre>data-sgvizler-endpoint:</pre>
    93           <textarea id="sample-data-sgvizler-endpoint" name="sgvizler-endpoint" class="sgvizler" rows="1">
     113          <div style="display:none;">
     114        <pre>data-sgvizler-endpoint:</pre>
     115        <textarea id="sample-data-sgvizler-endpoint" name="sgvizler-endpoint" class="sgvizler" rows="1">
    94116<!-- -->
    95117<xsl:text>
    96118//sowemustthink.space/greenstone3-lod3/greenstone/query
    97119</xsl:text>
    98           </textarea>
    99 
     120        </textarea>
     121          </div>
     122         
    100123          <pre>data-sgvizler-chart:</pre>
    101124          <textarea id="sample-data-sgvizler-chart" name="sgvizler-chart" class="sgvizler" rows="1">
    … …  
    147170
    148171      <div class="page">
    149         <h2>Sample Queries</h2>
     172        <h2>Sample Visualizations</h2>
    150173
    151174        <p>
    … …  
    208231        <xsl:call-template name="ssv-made-the-final"/>
    209232        <xsl:call-template name="ssv-got-nul-point"/>
     233        <xsl:call-template name="ssv-got-nul-point-after-winning"/>
    210234        <xsl:call-template name="ssv-voting-dataflow-jury"/>
    211235        <xsl:call-template name="ssv-voting-dataflow-tele"/>
     236        <xsl:call-template name="ssv-draw-bias"/>
    212237       
    213238       
    … …  
    232257        <button type="button" class="load-ssq" id="load-ssv-got-nul-point" onclick="ssv_load('ssv-got-nul-point')">Load query above</button>
    233258        <button type="button" class="exec-ssq" id="exec-ssv-got-nul-point" onclick="ssv_execute()">Visualize Results</button><br/>
    234         Plot as a bar graph the number of times each country has made it to the finals.
     259        Plot a bar graph showing which countries, and how often they have, competed in the final but received zero points as their final total score.
     260          </li>
     261
     262          <li>
     263        The even more galling circumstance of getting &quot;nul point&quot; having won the previous year:<br/>
     264        <button type="button" class="load-ssq" id="load-ssv-got-nul-point-after-winning" onclick="ssv_load('ssv-got-nul-point-after-winning')">Load query above</button>
     265        <button type="button" class="exec-ssq" id="exec-ssv-got-nul-point-after-winning" onclick="ssv_execute()">Visualize Results</button><br/>
     266        Have any countries been ever been in the situation of going from Hero (i.e., winning) to Zero (nul point) in back to back years in
     267        the contest.
    235268          </li>
    236269
    … …  
    238271          <li>
    239272        Dataflow Voting Patterns of Juries:<br/>
    240         <button type="button" class="load-ssq" id="load-ssv-voting-dataflow-jury" onclick="ssv_load('ssv-voting-dataflow-jury')">Load query above</button>
    241         <button type="button" class="exec-ssq" id="exec-ssv-voting-dataflow-jury" onclick="ssv_execute()">Visualize Results</button><br/>
    242 
     273        <div>
     274          <button type="button" class="load-ssq" id="load-ssv-voting-dataflow-jury" onclick="ssv_load('ssv-voting-dataflow-jury')">Load query above</button>
     275          <div style="display: inline-block; padding-right: 12px;">
     276            <label style="padding-right: 6px;" for="ssv-voting-dataflow-jury-startyear">Start Year:</label>
     277            <input type="text" id="ssv-voting-dataflow-jury-startyear" value="2010" style="width: 80px; padding-left: 6px"/>
     278            <label style="padding-right: 6px; padding-left: 12px;" for="ssv-voting-dataflow-jury-endyear">End Year:</label>
     279            <input type="text" id="ssv-voting-dataflow-jury-endyear"   value="2019" style="width: 80px; padding-left: 6px"/>
     280          </div>
     281          <button type="button" class="exec-ssq" id="exec-ssv-voting-dataflow-jury" onclick="ssv_execute('ssv-voting-dataflow-jury')">Visualize Results</button>
     282        </div>
    243283        Plot as a Sankey Dataflow Graph how juries allocate
    244284        their votes to countries over the years 2010-2019.
    … …  
    248288       
    249289        Experiment with editing the date range specified in
     290        the <i>Start Year</i> and <i>End Year</i> text-input
     291        boxes.  Alternatively, the the SPARQL query itself
     292        edit
    250293        the <tt>FILTER(xsd:integer(?year) &gt; 2010
    251294        &amp;&amp; xsd:integer(?year) &lt;= 2019)</tt> clause
    252295        in the above text box and then press <i>Show
    253296        Visualization</i> to see how the voting by jury has
    254         changed over the decades.
     297        changed over the decades.       
     298          </li>
     299
     300         
     301          <li>
     302        Dataflow Voting Patterns in Televoting:<br/>
     303        <div>
     304          <button type="button" class="load-ssq" id="load-ssv-voting-dataflow-tele" onclick="ssv_load('ssv-voting-dataflow-tele')">Load query above</button>
     305          <span style="padding-right: 12px;">
     306            Start Year: <input type="text" id="ssv-voting-dataflow-tele-startyear" value="2018" style="width: 80px; padding-left: 6px"/>
     307            End Year:   <input type="text" id="ssv-voting-dataflow-tele-endyear"   value="2019" style="width: 80px; padding-left: 6px"/>
     308          </span>
    255309       
    256 
    257           </li>
    258          
    259 
    260          
    261           <li>
    262         Dataflow Voting Patterns in Televoting:<br/>
    263         <button type="button" class="load-ssq" id="load-ssv-voting-dataflow-tele" onclick="ssv_load('ssv-voting-dataflow-tele')">Load query above</button>
    264         <button type="button" class="exec-ssq" id="exec-ssv-voting-dataflow-tele" onclick="ssv_execute()">Visualize Results</button><br/>
    265 
     310          <button type="button" class="exec-ssq" id="exec-ssv-voting-dataflow-tele" onclick="ssv_execute('ssv-voting-dataflow-tele')">Visualize Results</button><br/>
     311        </div>
    266312        Plot as a Sankey Dataflow Graph of the televoting
    267313        data by coutnry.  Years plotted are 2018-2019
    … …  
    271317        the <i>square</i> of the voting totals to
    272318        help emphasize where differences occur.
    273 
    274           </li>
    275          
    276 
     319          </li>       
     320
     321
     322          <li>
     323        The Curse of Being the Second Performer in the Lineup?<br/>
     324        <button type="button" class="load-ssq" id="load-ssv-draw-bias" onclick="ssv_load('ssv-draw-bias')">Load query above</button>
     325        <button type="button" class="exec-ssq" id="exec-ssv-draw-bias" onclick="ssv_execute()">Visualize Results</button><br/>
     326        Plot as a bar graph how many times an entrant performing in a given position in the lineup has gone on to win the competition.
     327          </li>
    277328
    278329         
Note: See TracChangeset for help on using the changeset viewer.