Difference between revisions of "Q0.10"

From BITPlan cr Wiki
Jump to navigation Jump to search
 
(6 intermediate revisions by the same user not shown)
Line 6: Line 6:
 
|title=Locations of all CEUR-WS proceedings [[Concept:Proceedings|proceedings]] [[Concept:Event|events]]
 
|title=Locations of all CEUR-WS proceedings [[Concept:Proceedings|proceedings]] [[Concept:Event|events]]
 
|description=Map of all CEUR-WS event locations
 
|description=Map of all CEUR-WS event locations
|wdqsurl=8gRt
+
|sparql=# Query 10 of Task 0
 +
# see https://cr.bitplan.com/index.php/Q0.10
 +
#defaultView:Map
 +
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
 +
PREFIX p: <http://www.wikidata.org/prop/>
 +
PREFIX schema: <http://schema.org/>
 +
PREFIX wd: <http://www.wikidata.org/entity/>
 +
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
 +
PREFIX wikibase: <http://wikiba.se/ontology#>
 +
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 +
SELECT
 +
?event
 +
?title
 +
?url
 +
?coordinates
 +
WHERE {
 +
  # Instance of Proceedings
 +
  ?item wdt:P31 wd:Q1143604.
 +
  # Part of the series
 +
  ?item p:P179 ?partOfTheSeries.
 +
  ?item wdt:P953 ?url.
 +
  # CEUR Workshop proceedings
 +
  ?partOfTheSeries ps:P179 wd:Q27230297.
 +
  # Acronym
 +
  OPTIONAL {?item wdt:P1813 ?short_name.}
 +
 
 +
  ?item wdt:P4745 ?event.
 +
  ?event wdt:P1476 ?title.
 +
  OPTIONAL{
 +
    ?event wdt:P276 ?location.
 +
    OPTIONAL{?location wdt:P625 ?coordinates}
 +
    ?location rdfs:label ?locationLabel.
 +
    FILTER(LANG(?locationLabel) = "en")
 +
  }
 +
}
 +
|wdqsurl=8gRw
 
|relevance=1
 
|relevance=1
 +
|comment=[[File:CEUR-WSLocationMap2023-12-31.png|400px]]
 
|task=Task0
 
|task=Task0
 
|storemode=property
 
|storemode=property
 
}}
 
}}
=Freitext=
 

Latest revision as of 10:16, 31 December 2023

Query

Query
edit
id  10
name  LocationOfEvents
title  Locations of all CEUR-WS proceedings proceedings events
description  Map of all CEUR-WS event locations
sparql  
# Query 10 of Task 0
# see https://cr.bitplan.com/index.php/Q0.10
#defaultView:Map
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX schema: <http://schema.org/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT
?event
?title
?url
?coordinates
WHERE {
  # Instance of Proceedings
  ?item wdt:P31 wd:Q1143604.
  # Part of the series
  ?item p:P179 ?partOfTheSeries.
  ?item wdt:P953 ?url.
  # CEUR Workshop proceedings
  ?partOfTheSeries ps:P179 wd:Q27230297.
  # Acronym
  OPTIONAL {?item wdt:P1813 ?short_name.}

  ?item wdt:P4745 ?event.
  ?event wdt:P1476 ?title.
  OPTIONAL{
    ?event wdt:P276 ?location.
    OPTIONAL{?location wdt:P625 ?coordinates}
    ?location rdfs:label ?locationLabel.
    FILTER(LANG(?locationLabel) = "en")
  }
}
tryiturl  →
wdqsurl  8gRw→8gRw
scholia  →
relevance  1
comment  CEUR-WSLocationMap2023-12-31.png
task  Task0→Task0