Changeset 35920 for main

Timestamp:

2022-01-08T22:34:42+13:00 (2 years ago)

Author:

davidb

Message:

Example SPARQL query added in that tabulates the number of major scale and minor scale entries that won Eurovision

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/sparql.xsl (modified) (2 diffs)

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

@@ -298 +298 @@
         
 
+        <div id="ssq-esc-winners-freq-count-scale" style="display: none;">
+<!-- -->
+<xsl:text>
+PREFIX gsdlextracted: &lt;http://greenstone.org/gsdlextracted#&gt;
+PREFIX xsd: &lt;http://www.w3.org/2001/XMLSchema#&gt;
+PREFIX dc: &lt;http://purl.org/dc/elements/1.1/&gt;
+PREFIX essentia: &lt;http://upf.edu/essentia#&gt;
+
+
+SELECT ?scale (STR(COUNT(?scale)) as ?number_in_scale) WHERE {
+#SELECT ?scale ?country ?year WHERE {
+  GRAPH &lt;</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>&gt;  {
+     
+    ?esc_entrant_uri gsdlextracted:Place "1".
+    # ?esc_entrant_uri essentia:tonal_key_edma_key ?musical_key.
+    ?esc_entrant_uri essentia:tonal_key_edma_scale ?scale.
+
+    ?esc_entrant_uri gsdlextracted:Year ?year.
+    ?esc_entrant_uri gsdlextracted:Country ?country.    
+  }
+}
+GROUP BY ?scale
+ORDER BY DESC(?number_in_scale)
+</xsl:text>
+        </div>
+
+        
         <div id="ssq-jury-votes-totals-1975" style="display: none;">
 <!-- -->
@@ -571 +598 @@
           the estimated key signature of the song, which is pre-computed using the Essentia audio content analysis toolkit
           when the collection is built.
+        </p>
+          </li>
+
+          <li>
+        <b>Musical scale comparison of winning entries:</b><br/>
+        <button type="button" class="load-ssq" id="load-ssq-esc-winners-freq-count-scale" onclick="ssq_load('ssq-esc-winners-freq-count-scale')">Load query above</button>
+        <button type="button" class="exec-ssq" id="exec-ssq-esc-winners-freq-count-scale" onclick="ssq_execute()">Get Results</button><br/>
+        
+        <p>
+          Frequency count of the scale (major or minor) that
+          winning songs were in.  The estimated musical scale
+          of the song is an estimate, pre-computed using the
+          Essentia audio content analysis toolkit when the
+          collection is built.
         </p>
           </li>