Changeset 35917 for main

Timestamp:

2022-01-08T12:20:46+13:00 (2 years ago)

Author:

davidb

Message:

Added in new SPARQL query that demonstrates access the Essentia computed key estimates

File:

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

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

@@ -254 +254 @@
 
 
+        
         <div id="ssq-esc-entrants" style="display: none;">
 <!-- -->
@@ -273 +274 @@
         </div>
 
+        <div id="ssq-esc-entrants-with-key" 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 ?esc_entrant_uri ?country ?year ?musical_key ?scale ?strength_estimate WHERE {
+  GRAPH &lt;</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>&gt;  {
+    ?esc_entrant_uri dc:Relation.isPartOf &lt;</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>&gt;.
+
+    ?esc_entrant_uri gsdlextracted:Year ?year.
+    ?esc_entrant_uri gsdlextracted:Country ?country.
+    ?esc_entrant_uri essentia:tonal_key_edma_key ?musical_key.
+    ?esc_entrant_uri essentia:tonal_key_edma_scale ?scale.
+    ?esc_entrant_uri essentia:tonal_key_edma_strength ?strength_estimate.
+  }
+}
+ORDER BY ASC(?year) ?country
+</xsl:text>
+        </div>
+        
 
         <div id="ssq-jury-votes-totals-1975" style="display: none;">
@@ -539 +563 @@
 
           <li>
+        <b>Eurovision Song Contest (ESC) entrants with (estimated) musical key:</b><br/>
+        <button type="button" class="load-ssq" id="load-ssq-esc-entrants-with-key" onclick="ssq_load('ssq-esc-entrants-with-key')">Load query above</button>
+        <button type="button" class="exec-ssq" id="exec-ssq-esc-entrants-with-key" onclick="ssq_execute()">Get Results</button><br/>
+        
+        <p>
+          Similar to the above query that list all the entrants (country and year) sorted by year, then by country, but also displays
+          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>Voting Totals in 1975:</b><br/>
         <button type="button" class="load-ssq" id="load-ssq-jury-votes-totals-1975" onclick="ssq_load('ssq-jury-votes-totals-1975')">Load query above</button>
@@ -546 +583 @@
         totals of this Single voting format, and orders them by that score.</p>
           </li>
+
+            
           
           <li>