Changeset 35056
- Timestamp:
- 2021-04-11T17:56:13+12:00 (3 years ago)
- Location:
- main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform
- Files:
-
- 12 edited
Legend:
- Unmodified
- Added
- Removed
-
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/draw-bias-normalized.xsl
r35046 r35056 24 24 SELECT ?draw_int (SUM(?is_winner) AS ?freqCount) (COUNT(?is_winner) AS ?maxPossibleFreqCount) (100.0 * ?freqCount/?maxPossibleFreqCount AS ?normFreqCount) 25 25 WHERE { 26 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {27 ?esc_entrant_uri dc:Relation.isPartOf <http://127.0.0.1:8383/greenstone3/library/collection/</xsl:text><xsl:value-of select="$collName"/><xsl:text>>.26 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 27 # ?esc_entrant_uri dc:Relation.isPartOf <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>>. 28 28 29 29 ?esc_entrant_uri gsdlextracted:Country ?country. -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/draw-bias.xsl
r35036 r35056 24 24 #(COUNT(?is_winner) AS ?maxPossibleFreqCount) (100.0 * ?freqCount/?maxPossibleFreqCount AS ?normFreqCount) 25 25 WHERE { 26 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {27 ?esc_entrant_uri dc:Relation.isPartOf <http://127.0.0.1:8383/greenstone3/library/collection/</xsl:text><xsl:value-of select="$collName"/><xsl:text>>.26 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 27 # ?esc_entrant_uri dc:Relation.isPartOf <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>>. 28 28 29 29 ?esc_entrant_uri gsdlextracted:Country ?country. -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/got-nul-point-after-winning.xsl
r35036 r35056 23 23 SELECT (?country) (COUNT(?country) AS ?freqCount) 24 24 WHERE { 25 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {26 ?esc_entrant_uri dc:Relation.isPartOf <http://127.0.0.1:8383/greenstone3/library/collection/</xsl:text><xsl:value-of select="$collName"/><xsl:text>>.25 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 26 # ?esc_entrant_uri dc:Relation.isPartOf <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>>. 27 27 28 28 ?esc_entrant_uri gsdlextracted:Country ?country. -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/got-nul-point.xsl
r35036 r35056 23 23 SELECT (?country) (COUNT(?country) AS ?freqCount) 24 24 WHERE { 25 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {26 ?esc_entrant_uri dc:Relation.isPartOf <http://127.0.0.1:8383/greenstone3/library/collection/</xsl:text><xsl:value-of select="$collName"/><xsl:text>>.25 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 26 # ?esc_entrant_uri dc:Relation.isPartOf <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>>. 27 27 28 28 ?esc_entrant_uri gsdlextracted:Country ?country. -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/list-of-losers.xsl
r35050 r35056 24 24 SELECT (?selected_year AS ?Year) (?country AS ?Country) (?title AS ?Title) (GROUP_CONCAT(?creator; SEPARATOR="; ") AS ?Artist) 25 25 WHERE { 26 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {26 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 27 27 28 28 { … … 41 41 } 42 42 43 44 45 46 43 ?esc_entrant_uri gsdlextracted:Country ?country. 44 ?esc_entrant_uri gsdlextracted:Place ?place. 45 BIND(xsd:integer(?place) AS ?place_int). 46 FILTER(?place_int = ?max_selected_place_int). 47 47 48 ?esc_entrant_uri gsdlextracted:Year ?selected_year. 49 ?esc_entrant_uri gsdlextracted:Title ?title. 50 ?esc_entrant_uri gsdlextracted:Creator ?creator. 51 48 ?esc_entrant_uri gsdlextracted:Year ?selected_year. 49 ?esc_entrant_uri gsdlextracted:Title ?title. 50 ?esc_entrant_uri gsdlextracted:Creator ?creator. 52 51 } 53 52 } -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/list-of-winners.xsl
r35050 r35056 10 10 11 11 <xsl:template name="ssv-list-of-winners"> 12 13 14 15 12 16 13 <div id="ssv-list-of-winners" style="display: none;"> … … 24 21 SELECT (?year AS ?Year) (?country AS ?Country) (?title as ?Title) (GROUP_CONCAT(?creator; SEPARATOR="; ") AS ?Artist) 25 22 WHERE { 26 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {23 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 27 24 ?esc_entrant_uri gsdlextracted:Country ?country. 28 25 ?esc_entrant_uri gsdlextracted:Year ?year. -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/made-the-final.xsl
r35036 r35056 8 8 extension-element-prefixes="java util" 9 9 exclude-result-prefixes="java util"> 10 10 11 11 <xsl:template name="ssv-made-the-final"> 12 13 12 14 13 <div id="ssv-made-the-final" style="display: none;"> … … 22 21 SELECT (?country) (COUNT(?country) AS ?freqCount) 23 22 WHERE { 24 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {23 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 25 24 ?esc_entrant_uri gsdlextracted:Country ?country. 26 25 # ?esc_entrant_uri gsdlextracted:Final "true" … … 28 27 ?esc_entrant_uri gsdlextracted:VoteGrandTotal ?total. 29 28 BIND(xsd:integer(?total) AS ?total_int). 30 FILTER(?total_int >= 0).29 FILTER(?total_int >= 0). 31 30 32 31 } -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/voting-dataflow-jury.xsl
r35055 r35056 11 11 <xsl:template name="ssv-voting-dataflow-jury"> 12 12 13 14 13 <div id="ssv-voting-dataflow-jury" style="display: none;"> 15 14 … … 22 21 23 22 SELECT (?jury_country AS ?jury_vote_from_country) (?country AS ?to_country) (SUM(?jury_vote_int) * SUM(?jury_vote_int) AS ?country_jury_to_country_total_squared) (SUM(?jury_vote_int) AS ?jury_vote_total) WHERE { 24 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {25 ?esc_entrant_uri dc:Relation.isPartOf <http://127.0.0.1:8383/greenstone3/library/collection/</xsl:text><xsl:value-of select="$collName"/><xsl:text>>.23 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 24 # ?esc_entrant_uri dc:Relation.isPartOf <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>>. 26 25 27 26 ?esc_entrant_uri ?gsdlextracted_jury_country_uri ?jury_vote. -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/voting-dataflow-tele.xsl
r35036 r35056 22 22 23 23 SELECT (?tele_country AS ?tele_vote_from_country) (?country AS ?to_country) (SUM(?tele_vote_int) * SUM(?tele_vote_int) AS ?country_tele_to_country_total_squared) (SUM(?tele_vote_int) AS ?tele_vote_total) WHERE { 24 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {25 ?esc_entrant_uri dc:Relation.isPartOf <http://127.0.0.1:8383/greenstone3/library/collection/</xsl:text><xsl:value-of select="$collName"/><xsl:text>>.24 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 25 # ?esc_entrant_uri dc:Relation.isPartOf <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>>. 26 26 27 27 ?esc_entrant_uri ?gsdlextracted_tele_country_uri ?tele_vote. -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/about.xsl
r35047 r35056 180 180 ); 181 181 </gsf:script> 182 182 183 <xsl:variable name="graphURI">https://so-we-must-think.space<xsl:value-of select="$siteURL"/><xsl:value-of select="$library_name"/>/collection/<xsl:value-of select="$collName"/></xsl:variable> 183 184 <div id="sgvizler2-country-count" 184 185 data-sgvizler-endpoint="//sowemustthink.space/greenstone3-lod3/greenstone/query" … … 192 193 SELECT (?country) (COUNT(?country) AS ?freqCount) 193 194 WHERE { 194 GRAPH < http://localhost:4040/greenstone/data/<xsl:value-of select="$collName"/>> {195 GRAPH <<xsl:value-of select="$graphURI"/>> { 195 196 ?s gsdlextracted:Country ?country 196 197 } -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/sgvizler.xsl
r35054 r35056 9 9 exclude-result-prefixes="java util"> 10 10 11 12 11 <!-- use the 'main' layout --> 13 12 <xsl:import href="layouts/main.xsl"/> 14 13 15 <xsl:import href="dataviz/made-the-final.xsl"/> 16 <xsl:import href="dataviz/list-of-winners.xsl"/> 17 <xsl:import href="dataviz/list-of-losers.xsl"/> 18 <xsl:import href="dataviz/got-nul-point.xsl"/> 19 <xsl:import href="dataviz/got-nul-point-after-winning.xsl"/> 20 <xsl:import href="dataviz/voting-dataflow-jury.xsl"/> 21 <xsl:import href="dataviz/voting-dataflow-tele.xsl"/> 22 <xsl:import href="dataviz/draw-bias.xsl"/> 23 <xsl:import href="dataviz/draw-bias-normalized.xsl"/> 14 15 <xsl:variable name="graphURI">https://so-we-must-think.space<xsl:value-of select="$siteURL"/><xsl:value-of select="$library_name"/>/collection/<xsl:value-of select="$collName"/></xsl:variable> 16 17 <xsl:include href="dataviz/made-the-final.xsl"/> 18 <xsl:include href="dataviz/list-of-winners.xsl"/> 19 <xsl:include href="dataviz/list-of-losers.xsl"/> 20 <xsl:include href="dataviz/got-nul-point.xsl"/> 21 <xsl:include href="dataviz/got-nul-point-after-winning.xsl"/> 22 <xsl:include href="dataviz/voting-dataflow-jury.xsl"/> 23 <xsl:include href="dataviz/voting-dataflow-tele.xsl"/> 24 <xsl:include href="dataviz/draw-bias.xsl"/> 25 <xsl:include href="dataviz/draw-bias-normalized.xsl"/> 24 26 25 27 <xsl:variable name="groupPath"><xsl:value-of select="/page/pageRequest/paramList/param[@name='group']/@value"/></xsl:variable> … … 116 118 117 119 <script type="text/javascript" src="ext/jena/sgvizler2/sgvizler2.js"><xsl:text> </xsl:text></script> 118 119 120 <div class="page moreindent"> 120 121 <form class="sgvizler-form" id="sample-sparql-query-form" … … 216 217 SELECT (?country) (COUNT(?country) AS ?freqCount) 217 218 WHERE { 218 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {219 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 219 220 ?s gsdlextracted:Country ?country. 220 221 } -
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/sparql.xsl
r35047 r35056 121 121 </div> 122 122 123 <xsl:variable name="graphURI">https://so-we-must-think.space<xsl:value-of select="$siteURL"/><xsl:value-of select="$library_name"/>/collection/<xsl:value-of select="$collName"/></xsl:variable> 124 123 125 <div class="moreindent"> 124 126 <form id="sample-sparql-query-form" action="/greenstone3-lod3/greenstone/query" target="_blank" … … 131 133 132 134 SELECT ?subject ?predicate ?object WHERE { 133 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {135 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 134 136 ?subject ?predicate ?object. 135 137 } … … 194 196 195 197 SELECT ?subject ?predicate ?object WHERE { 196 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {198 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 197 199 ?subject ?predicate ?object. 198 200 ?subject gsdlextracted:Year "2000". … … 209 211 210 212 SELECT ?subject ?predicate ?object WHERE { 211 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {213 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 212 214 ?subject ?predicate ?object. 213 215 ?subject gsdlextracted:Year "2000". … … 230 232 231 233 SELECT ?subject ?predicate ?object WHERE { 232 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {234 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 233 235 ?subject ?predicate ?object 234 236 … … 257 259 258 260 SELECT ?esc_entrant_uri ?country ?year WHERE { 259 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {260 ?esc_entrant_uri dc:Relation.isPartOf < http://127.0.0.1:8383/greenstone3/library/collection/</xsl:text><xsl:value-of select="$collName"/><xsl:text>>.261 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 262 ?esc_entrant_uri dc:Relation.isPartOf <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>>. 261 263 262 264 ?esc_entrant_uri gsdlextracted:Year ?year. … … 277 279 278 280 SELECT ?country ?year ?total WHERE { 279 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {280 ?esc_entrant_uri dc:Relation.isPartOf < http://127.0.0.1:8383/greenstone3/library/collection/</xsl:text><xsl:value-of select="$collName"/><xsl:text>>.281 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 282 ?esc_entrant_uri dc:Relation.isPartOf <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>>. 281 283 282 284 ?esc_entrant_uri gsdlextracted:SingVotesTotal ?total. … … 301 303 302 304 SELECT ?country ?year ?jury_country ?jury_vote WHERE { 303 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {304 ?esc_entrant_uri dc:Relation.isPartOf < http://127.0.0.1:8383/greenstone3/library/collection/</xsl:text><xsl:value-of select="$collName"/><xsl:text>>.305 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 306 ?esc_entrant_uri dc:Relation.isPartOf <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>>. 305 307 306 308 ?esc_entrant_uri ?gsdlextracted_jury_country_uri ?jury_vote. … … 328 330 PREFIX dc: <http://purl.org/dc/elements/1.1/> 329 331 330 331 332 SELECT ?year ?country ?total_max WHERE { 332 GRAPH < http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> {333 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 333 334 334 335 { … … 365 366 366 367 SELECT ?country (STR(COUNT(?country)) as ?number_of_vote_wins) WHERE { 367 GRAPH <http://localhost:4040/greenstone/data/</xsl:text><xsl:value-of select="$collName"/><xsl:text>> { 368 369 368 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 370 369 { 371 SELECT ?year (STR(MAX(?total_int)) as ?total_max) WHERE { 372 373 370 SELECT ?year (STR(MAX(?total_int)) as ?total_max) WHERE { 374 371 ?esc_entrant_uri gsdlextracted:VoteGrandTotal ?total. 375 372 BIND(xsd:integer(?total) AS ?total_int). … … 412 409 ?currency ?gdpPppPerCapita ?giniCoefficient WHERE { 413 410 414 # SERVICE <https://dbpedia.demo.openlinksw.com/sparql> {415 411 SERVICE <https://dbpedia.org/sparql> { 416 412
Note:
See TracChangeset
for help on using the changeset viewer.