- Timestamp:
- 2021-03-22T22:13:52+13:00 (3 years ago)
- Location:
- main/trunk/model-sites-dev/eurovision-lod/collect/eurovision
- Files:
-
- 1 added
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/css/eurovision.css
r34956 r34972 96 96 } 97 97 98 99 100 .showmore-button { 101 cursor: pointer; 102 background-color: #999; 103 color: white; 104 /* text-transform: uppercase; */ 105 text-align: center; 106 /* padding: 7px 5px 5px 5px; */ 107 /* margin-top: 5px; */ 108 padding: 4px 2px 2px 2px; 109 110 margin-bottom: 7px; 111 width: 120px; 112 } -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/about.xsl
r34942 r34972 9 9 xmlns:util="xalan://org.greenstone.gsdl3.util.XSLTUtil" 10 10 xmlns:gslib="http://www.greenstone.org/skinning" 11 xmlns:gsf="http://www.greenstone.org/greenstone3/schema/ConfigFormat" 11 12 extension-element-prefixes="java util" 12 13 exclude-result-prefixes="java util"> … … 14 15 15 16 <xsl:template name="coll-description"> 16 <div id="about-desc"> 17 <gsf:style src="sites/{$site_name}/collect/{$collName}/css/eurovision.css"/> 18 <gsf:script src="sites/{$site_name}/collect/{$collName}/js/jquery.show-more.js"/> 19 20 <div id="about-desc"> 17 21 <h2>Introduction</h2> 18 22 <!-- … … 44 48 </p> 45 49 46 <p> 47 At Eurovision there is no division because wherever 48 you come from Eurovision is home. The Eurovision song 49 contest is widely known as a safe space for LGBTQIA+ 50 people and a platform for free expression. For example 51 trans-woman 52 <a href="https://en.wikipedia.org/wiki/Dana_International">Dana International</a> 53 won as far back as 1998. 54 There have been songs in many different languages over the 55 years, although most are in English these days. This 56 doesn't matter, however, because music is a language we all 57 know how to speak. 58 </p> 59 <p> 60 In its latest incarnation, after 61 all the performances are over, artists wait 62 nervously as via the Internet the show's hosts visit each 63 of the 40+ countries in turn collecting all points cast 64 by the country appointed juries. This includes 65 the all important top score that can be cast, 12 points 66 (douze points!), a double-increment up from the 67 10 points awarded to the song a country ranks second, 68 followed by 8, 7, 6 ⊠1 points awarded. 69 Next comes the "the popular vote" 70 where fans, still grouped by country, have 71 the votes they cast by phone, SMS or the Eurovision app 72 tallied and mapped into the same format of 12 points for 1st 73 place, and so on. 74 This all culminates in a new winner being crowned, with 75 the competition usually being hosted the following year 76 by that country. 77 </p> 78 50 <div id="about-show-more"> 51 <p> 52 At Eurovision there is no division because wherever 53 you come from Eurovision is home. The Eurovision song 54 contest is widely known as a safe space for LGBTQIA+ 55 people and a platform for free expression. For example 56 trans-woman 57 <a href="https://en.wikipedia.org/wiki/Dana_International">Dana International</a> 58 won as far back as 1998. 59 There have been songs in many different languages over the 60 years, although most are in English these days. This 61 doesn't matter, however, because music is a language we all 62 know how to speak. 63 </p> 64 <p> 65 In its latest incarnation, after 66 all the performances are over, artists wait 67 nervously as via the Internet the show's hosts visit each 68 of the 40+ countries in turn collecting all points cast 69 by the country appointed juries. This includes 70 the all important top score that can be cast, 12 points 71 (douze points!), a double-increment up from the 72 10 points awarded to the song a country ranks second, 73 followed by 8, 7, 6 ⊠1 points awarded. 74 Next comes the "the popular vote" 75 where fans, still grouped by country, have 76 the votes they cast by phone, SMS or the Eurovision app 77 tallied and mapped into the same format of 12 points for 1st 78 place, and so on. 79 This all culminates in a new winner being crowned, with 80 the competition usually being hosted the following year 81 by that country. 82 </p> 83 </div> 84 <gsf:script> 85 $('#about-show-more').showMore({ 86 minheight: 0, 87 buttontxtmore:"show more ...", 88 buttontxtless:"... show less" 89 }); 90 </gsf:script> 91 92 79 93 <h2>Features of this Website</h2> 80 94 … … 131 145 132 146 //sgvizler.prefix('dc','http://purl.org/dc/elements/1.1/'); 133 //sgvizler.prefix('gs extracted','http://greenstone.org/gsextracted#');147 //sgvizler.prefix('gsdlextracted','http://greenstone.org/gsdlextracted#'); 134 148 135 149 136 150 // Exaple triple 137 151 // "s": { "type": "uri" , "value": "http://127.0.0.1:8383/greenstone3/library/collection/eurovision/document/HASH0191e9cc7bfdf14743472257s10" } , 138 // "p": { "type": "uri" , "value": "gs extracted:Country" } ,152 // "p": { "type": "uri" , "value": "gsdlextracted:Country" } , 139 153 // "o": { "type": "literal" , "value": "United Kingdom" } 140 154 … … 148 162 </script> 149 163 150 <!--151 <div id="sgvizler1-country-count"152 data-sgvizler-endpoint="//sowemustthink.space/greenstone3-lod/greenstone/query"153 data-sgvizler-chart="google.visualization.PieChart"154 data-sgvizler-loglevel="2"155 data-sgvizler-chart-options="title=Number of Songs from each Country"156 style="width:650px; height:500px; margin-left: auto; margin-right: auto">157 <xsl:attribute name="data-sgvizler-query">158 PREFIX gsextracted: <http://greenstone.org/gsextracted#>159 SELECT (?country) (COUNT(?country) AS ?freqCount)160 WHERE {161 GRAPH <http://localhost:3030/greenstone/data/eurovision> {162 ?s gsextracted:Country ?country163 }164 }165 GROUP BY ?country ORDER BY asc(?country)166 </xsl:attribute>167 <xsl:text> Loading ...</xsl:text>168 </div>169 170 -->171 164 <div id="sgvizler2-country-count" 172 data-sgvizler-endpoint="//sowemustthink.space/greenstone3-lod /greenstone/query"165 data-sgvizler-endpoint="//sowemustthink.space/greenstone3-lod3/greenstone/query" 173 166 data-sgvizler-chart="google.visualization.BarChart" 174 167 data-sgvizler-chart-options="title=Number of Songs from each Country|legend.position=none|height=900|chartArea.height=840|fontSize=11" … … 177 170 <xsl:attribute name="data-sgvizler-query"> 178 171 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> 179 PREFIX gs extracted: <http://greenstone.org/gsextracted#>172 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 180 173 SELECT (?country) (COUNT(?country) AS ?freqCount) 181 174 WHERE { 182 GRAPH <http://localhost: 3030/greenstone/data/eurovision> {183 ?s gs extracted:Country ?country175 GRAPH <http://localhost:4040/greenstone/data/<xsl:value-of select="$collName"/>> { 176 ?s gsdlextracted:Country ?country 184 177 } 185 178 } -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/sgvizler.xsl
r34956 r34972 66 66 <div class="page moreindent"> 67 67 <form class="sgvizler-form" id="sample-sparql-query-form" 68 action="/greenstone3-lod /greenstone/query" target="_blank"68 action="/greenstone3-lod3/greenstone/query" target="_blank" 69 69 method="GET" accept-charset="UTF-8"> 70 70 <pre>data-sgvizler-query:</pre> … … 73 73 <xsl:text> 74 74 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> 75 PREFIX gs extracted: <http://greenstone.org/gsextracted#>75 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 76 76 SELECT (?country) (COUNT(?country) AS ?freqCount) 77 77 WHERE { 78 GRAPH <http://localhost: 3030/greenstone/data/eurovision> {79 ?s gs extracted:Country ?country.78 GRAPH <http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> { 79 ?s gsdlextracted:Country ?country. 80 80 } 81 81 } … … 89 89 <xsl:text> 90 90 <div id="sgvizler-div" 91 data-sgvizler-endpoint="//sowemustthink.space/greenstone3-lod /greenstone/query"91 data-sgvizler-endpoint="//sowemustthink.space/greenstone3-lod3/greenstone/query" 92 92 data-sgvizler-chart="google.visualization.BarChart" 93 93 data-sgvizler-chart-options="title=Number of Songs from each Country (sorted by size)|legend.position=none|height=900|chartArea.height=840|fontSize=11" … … 103 103 <!-- --> 104 104 <xsl:text> 105 //sowemustthink.space/greenstone3-lod /greenstone/query105 //sowemustthink.space/greenstone3-lod3/greenstone/query 106 106 </xsl:text> 107 107 </textarea> … … 177 177 <xsl:text> 178 178 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> 179 PREFIX gs extracted: <http://greenstone.org/gsextracted#>179 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 180 180 SELECT (?country) (COUNT(?country) AS ?freqCount) 181 181 WHERE { 182 GRAPH <http://localhost: 3030/greenstone/data/eurovision> {183 ?s gs extracted:Country ?country.184 ?s gs extracted:Final "true"182 GRAPH <http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> { 183 ?s gsdlextracted:Country ?country. 184 ?s gsdlextracted:Final "true" 185 185 } 186 186 } -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/sparql.xsl
r34960 r34972 52 52 53 53 <p> 54 Using this page you can query the linked-data in the Greenstone3 <i>eurovision</i> triple -store54 Using this page you can query the linked-data in the Greenstone3 <i>eurovision</i> triplestore 55 55 graph using <a href="https://en.wikipedia.org/wiki/SPARQL">SPARQL</a> query syntax. 56 56 The default query provided in the text box below is effectively issuing a query that … … 69 69 70 70 </p> 71 72 <p> 73 Alternatively, you might be interested in downloading the complete Triplestore in 74 TriG syntax. In which case, 75 <a href="/greenstone3-lod3/greenstone/query" download="greenstone3-eurovision-lod.ttl">click here</a> 76 to initiate the download. 77 </p> 71 78 72 79 </div> … … 82 89 83 90 <div class="moreindent"> 84 <form id="sample-sparql-query-form" action="/greenstone3-lod /greenstone/query" target="_blank"91 <form id="sample-sparql-query-form" action="/greenstone3-lod3/greenstone/query" target="_blank" 85 92 method="GET" accept-charset="UTF-8"> 86 93 … … 88 95 <!-- --> 89 96 <xsl:text> 90 PREFIX gs extracted: <http://greenstone.org/gsextracted#>97 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 91 98 92 99 SELECT ?subject ?predicate ?object WHERE { 93 GRAPH <http://localhost: 3030/greenstone/data/eurovision> {100 GRAPH <http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> { 94 101 ?subject ?predicate ?object 95 102 96 103 # The following removed a triple that stores JSON data that 97 104 # is voluminous but not very interesting to look at 98 FILTER (?predicate != gs extracted:JSON).105 FILTER (?predicate != gsdlextracted:JSON). 99 106 } 100 107 } … … 155 162 <!-- --> 156 163 <xsl:text> 157 PREFIX gs extracted: <http://greenstone.org/gsextracted#>164 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 158 165 159 166 SELECT ?subject ?predicate ?object WHERE { 160 GRAPH <http://localhost: 3030/greenstone/data/eurovision> {167 GRAPH <http://localhost:4040/greenstone/data/eurovision-dev> { 161 168 ?subject ?predicate ?object 162 169 163 170 # The following removed a triple that stores JSON data that 164 171 # is voluminous but not very interesting to look at 165 FILTER (?predicate != gs extracted:JSON).166 ?subject gs extracted:Year "2000".172 FILTER (?predicate != gsdlextracted:JSON). 173 ?subject gsdlextracted:Year "2000". 167 174 } 168 175 } … … 175 182 <!-- --> 176 183 <xsl:text> 177 PREFIX gs extracted: <http://greenstone.org/gsextracted#>184 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 178 185 PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 179 186 180 187 SELECT ?subject ?predicate ?object WHERE { 181 GRAPH <http://localhost: 3030/greenstone/data/eurovision> {188 GRAPH <http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> { 182 189 ?subject ?predicate ?object 183 190 184 191 # The following removed a triple that stores JSON data that 185 192 # is voluminous but not very interesting to look at 186 FILTER (?predicate != gs extracted:JSON).187 188 ?subject gs extracted:Year ?year.189 ?subject gs extracted:Country ?country.193 FILTER (?predicate != gsdlextracted:JSON). 194 195 ?subject gsdlextracted:Year ?year. 196 ?subject gsdlextracted:Country ?country. 190 197 FILTER (?country = "France"). 191 198 FILTER (xsd:integer(?year) >= 1996 && xsd:integer(?year) <= 2000). … … 201 208 <!-- --> 202 209 <xsl:text> 203 PREFIX gs extracted: <http://greenstone.org/gsextracted#>210 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 204 211 PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 205 212 PREFIX dc: <http://purl.org/dc/elements/1.1/> 206 213 207 214 SELECT ?esc_entrant_uri ?country ?year WHERE { 208 GRAPH <http://localhost: 3030/greenstone/data/eurovision> {215 GRAPH <http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> { 209 216 ?esc_entrant_uri dc:Relation.isPartOf <http://127.0.0.1:8383/greenstone3/library/collection/eurovision>. 210 217 211 ?esc_entrant_uri gs extracted:Year ?year.212 ?esc_entrant_uri gs extracted:Country ?country.218 ?esc_entrant_uri gsdlextracted:Year ?year. 219 ?esc_entrant_uri gsdlextracted:Country ?country. 213 220 } 214 221 } … … 221 228 <!-- --> 222 229 <xsl:text> 223 PREFIX gs extracted: <http://greenstone.org/gsextracted#>230 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 224 231 PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 225 232 PREFIX dc: <http://purl.org/dc/elements/1.1/> 226 233 227 234 SELECT ?country ?year ?total WHERE { 228 GRAPH <http://localhost: 3030/greenstone/data/eurovision> {235 GRAPH <http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> { 229 236 ?esc_entrant_uri dc:Relation.isPartOf <http://127.0.0.1:8383/greenstone3/library/collection/eurovision>. 230 237 231 ?esc_entrant_uri gs extracted:SingVotesTotal ?total.238 ?esc_entrant_uri gsdlextracted:SingVotesTotal ?total. 232 239 BIND(xsd:integer(?total) AS ?total_int). 233 240 234 ?esc_entrant_uri gs extracted:Year ?year241 ?esc_entrant_uri gsdlextracted:Year ?year 235 242 FILTER(xsd:integer(?year) = 1975). 236 ?esc_entrant_uri gs extracted:Country ?country.243 ?esc_entrant_uri gsdlextracted:Country ?country. 237 244 } 238 245 } … … 245 252 <!-- --> 246 253 <xsl:text> 247 PREFIX gs extracted: <http://greenstone.org/gsextracted#>254 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 248 255 PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 249 256 PREFIX dc: <http://purl.org/dc/elements/1.1/> 250 257 251 258 SELECT ?country ?year ?jury_country ?jury_vote WHERE { 252 GRAPH <http://localhost: 3030/greenstone/data/eurovision> {259 GRAPH <http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> { 253 260 ?esc_entrant_uri dc:Relation.isPartOf <http://127.0.0.1:8383/greenstone3/library/collection/eurovision>. 254 261 255 ?esc_entrant_uri ?gs extracted_jury_country_uri ?jury_vote.256 BIND(STRENDS(str(?gs extracted_jury_country_uri),"-J") AS ?is_jury_vote)262 ?esc_entrant_uri ?gsdlextracted_jury_country_uri ?jury_vote. 263 BIND(STRENDS(str(?gsdlextracted_jury_country_uri),"-J") AS ?is_jury_vote) 257 264 FILTER (?is_jury_vote). 258 BIND(REPLACE(str(?gs extracted_jury_country_uri), ".*#(.*?)-J$", "$1") AS ?jury_country).259 260 ?esc_entrant_uri gs extracted:Year ?year265 BIND(REPLACE(str(?gsdlextracted_jury_country_uri), ".*#(.*?)-J$", "$1") AS ?jury_country). 266 267 ?esc_entrant_uri gsdlextracted:Year ?year 261 268 FILTER(xsd:integer(?year) = 1975). 262 ?esc_entrant_uri gs extracted:Country ?country.269 ?esc_entrant_uri gsdlextracted:Country ?country. 263 270 264 271 … … 273 280 <!-- --> 274 281 <xsl:text> 275 PREFIX gs extracted: <http://greenstone.org/gsextracted#>282 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 276 283 PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 277 284 PREFIX dc: <http://purl.org/dc/elements/1.1/> … … 279 286 280 287 SELECT ?year ?country ?total_max WHERE { 281 GRAPH <http://localhost: 3030/greenstone/data/eurovision> {288 GRAPH <http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> { 282 289 283 290 { 284 291 SELECT ?year (STR(MAX(?total_int_inner)) as ?total_max) WHERE { 285 292 286 ?esc_entrant_uri gs extracted:VoteGrandTotal ?total.293 ?esc_entrant_uri gsdlextracted:VoteGrandTotal ?total. 287 294 BIND(xsd:integer(?total) AS ?total_int_inner). 288 295 289 ?esc_entrant_uri gs extracted:Year ?year.296 ?esc_entrant_uri gsdlextracted:Year ?year. 290 297 } 291 298 GROUP BY ?year 292 299 } 293 300 294 ?esc_entrant_uri gs extracted:VoteGrandTotal ?total_max.295 ?esc_entrant_uri gs extracted:Year ?year.296 ?esc_entrant_uri gs extracted:Country ?country.301 ?esc_entrant_uri gsdlextracted:VoteGrandTotal ?total_max. 302 ?esc_entrant_uri gsdlextracted:Year ?year. 303 ?esc_entrant_uri gsdlextracted:Country ?country. 297 304 298 305 BIND(xsd:integer(?total_max) as ?total_int). … … 308 315 <xsl:text> 309 316 310 PREFIX gs extracted: <http://greenstone.org/gsextracted#>317 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 311 318 PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 312 319 PREFIX dc: <http://purl.org/dc/elements/1.1/> … … 314 321 315 322 SELECT ?country (STR(COUNT(?country)) as ?number_of_vote_wins) WHERE { 316 GRAPH <http://localhost: 3030/greenstone/data/eurovision> {323 GRAPH <http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> { 317 324 318 325 … … 321 328 322 329 323 ?esc_entrant_uri gs extracted:VoteGrandTotal ?total.330 ?esc_entrant_uri gsdlextracted:VoteGrandTotal ?total. 324 331 BIND(xsd:integer(?total) AS ?total_int). 325 332 326 ?esc_entrant_uri gs extracted:Year ?year.333 ?esc_entrant_uri gsdlextracted:Year ?year. 327 334 } 328 335 GROUP BY ?year 329 336 } 330 337 331 ?esc_entrant_uri gs extracted:VoteGrandTotal ?total_max.332 ?esc_entrant_uri gs extracted:Year ?year.333 ?esc_entrant_uri gs extracted:Country ?country.338 ?esc_entrant_uri gsdlextracted:VoteGrandTotal ?total_max. 339 ?esc_entrant_uri gsdlextracted:Year ?year. 340 ?esc_entrant_uri gsdlextracted:Country ?country. 334 341 } 335 342 } … … 349 356 <xsl:text> 350 357 351 PREFIX gs extracted: <http://greenstone.org/gsextracted#>358 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 352 359 353 360 PREFIX dbo: <http://dbpedia.org/ontology/> … … 388 395 } 389 396 390 ?esc_entrant_uri gs extracted:CountryDBURI ?country_uri_str.397 ?esc_entrant_uri gsdlextracted:CountryDBURI ?country_uri_str. 391 398 392 399 }
Note:
See TracChangeset
for help on using the changeset viewer.