Difference between revisions of "Q0.6"

From BITPlan cr Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
{{Query
 
{{Query
 
|id=6
 
|id=6
|name=All_institutions
+
|name=AllInstitutions
 
|title=All [[Concept:Institution| institutions]]
 
|title=All [[Concept:Institution| institutions]]
 
|description=List all institutions from which at least one scholar has once (co-)authored a paper or proceeding that has been published through CEUR-WS.
 
|description=List all institutions from which at least one scholar has once (co-)authored a paper or proceeding that has been published through CEUR-WS.
Line 28: Line 28:
 
   OPTIONAL{?institution rdfs:label ?institutionLabel. Filter(lang(?institutionLabel)="en")}  
 
   OPTIONAL{?institution rdfs:label ?institutionLabel. Filter(lang(?institutionLabel)="en")}  
 
   OPTIONAL{?institution wdt:P154 ?_logoImage.}  
 
   OPTIONAL{?institution wdt:P154 ?_logoImage.}  
   OPTIONAL{?institution wdt:P1816 ?_shortName.}  
+
   OPTIONAL{?institution wdt:P1813 ?_shortName.}  
 
   OPTIONAL{?institution wdt:P17 ?_country.}  
 
   OPTIONAL{?institution wdt:P17 ?_country.}  
 
   OPTIONAL{?institution wdt:P625 ?_coordinateLocation.}  
 
   OPTIONAL{?institution wdt:P625 ?_coordinateLocation.}  
Line 35: Line 35:
 
}
 
}
 
GROUP BY ?institution ?institutionLabel
 
GROUP BY ?institution ?institutionLabel
|tryiturl=DtK3UQ
+
|tryiturl=z7hnKG
|wdqsurl=6UGm
+
|wdqsurl=6UKK
 
|relevance=1
 
|relevance=1
 
|task=Task0
 
|task=Task0
 
|storemode=property
 
|storemode=property
 
}}
 
}}
=Freitext=
+
= result LIMIT 7 =
 +
{| class="wikitable" style="text-align: left;"
 +
|+ <!-- caption -->
 +
|-
 +
! institution                            !! institutionLabel                            !! logoImage                                                                                        !! country                            !! coordinateLocation                !! officialWebsite                  !! gndId      !! shortName
 +
|-
 +
| http://www.wikidata.org/entity/Q154561  || University of Jena                          || http://commons.wikimedia.org/wiki/Special:FilePath/Logo%20UniJena.svg                            || http://www.wikidata.org/entity/Q183 || Point(11.582222222 50.928333333)  || https://www.uni-jena.de/          || 36164-1    ||
 +
|-
 +
| http://www.wikidata.org/entity/Q1065414 || Free University of Amsterdam                || http://commons.wikimedia.org/wiki/Special:FilePath/Maagd%20in%20de%20tuin.gif                    || http://www.wikidata.org/entity/Q55  ||                                  || http://www.vu.nl/                || 80108-2    ||
 +
|-
 +
| http://www.wikidata.org/entity/Q793867  || Scripps Research                            ||                                                                                                  || http://www.wikidata.org/entity/Q30  || Point(-117.242457 32.896092)      || https://www.scripps.edu/          || 1085823946 ||
 +
|-
 +
| http://www.wikidata.org/entity/Q49108  || Massachusetts Institute of Technology      || http://commons.wikimedia.org/wiki/Special:FilePath/MIT%20logo.svg                                || http://www.wikidata.org/entity/Q30  || Point(-71.091944444 42.359722222) || https://web.mit.edu/              || 2179-9    || MIT
 +
|-
 +
| http://www.wikidata.org/entity/Q278044  || Vienna University of Economics and Business || http://commons.wikimedia.org/wiki/Special:FilePath/Logo%20Wirtschaftsuniversit%C3%A4t%20Wien.svg || http://www.wikidata.org/entity/Q40  || Point(16.4082 48.2141)            || https://www.wu.ac.at/            || 115001-7  ||
 +
|-
 +
| http://www.wikidata.org/entity/Q7058064 || Khoury College of Computer Sciences        ||                                                                                                  || http://www.wikidata.org/entity/Q30  || Point(-71.0903 42.3389)          || http://www.ccis.northeastern.edu/ ||            ||
 +
|-
 +
| http://www.wikidata.org/entity/Q214341  || University of Amsterdam                    || http://commons.wikimedia.org/wiki/Special:FilePath/Uva%C2%AEmerken%20ENG.png                    || http://www.wikidata.org/entity/Q55  || Point(4.890277777 52.368333333)  || http://www.uva.nl/                || 1010694-7  ||
 +
|}

Latest revision as of 17:23, 21 March 2023

Query

Query
edit
id  6
name  AllInstitutions
title  All institutions
description  List all institutions from which at least one scholar has once (co-)authored a paper or proceeding that has been published through CEUR-WS.
sparql  
# Q0.6 List all institutions
SELECT DISTINCT ?institution ?institutionLabel
  (SAMPLE(?_logoImage) as ?logoImage) 
  (SAMPLE(?_shortName) as ?shortName) 
  (SAMPLE(?_country) as ?country) 
  (SAMPLE(?_coordinateLocation) as ?coordinateLocation) 
  (SAMPLE(?_officialWebsite) as ?officialWebsite)
  (SAMPLE(?_gndId) as ?gndId)  
WHERE{
  ?proceeding wdt:P31 wd:Q1143604.
  ?proceeding wdt:P179 wd:Q27230297.
  {
    # authors
    ?paper wdt:P1433 ?proceeding.
    ?paper p:P50/pq:P1416 ?institution.
  }UNION{
    # editors
    ?proceeding p:P98/pq:P1416 ?institution.
  }
  
  OPTIONAL{?institution rdfs:label ?institutionLabel. Filter(lang(?institutionLabel)="en")} 
  OPTIONAL{?institution wdt:P154 ?_logoImage.} 
  OPTIONAL{?institution wdt:P1813 ?_shortName.} 
  OPTIONAL{?institution wdt:P17 ?_country.} 
  OPTIONAL{?institution wdt:P625 ?_coordinateLocation.} 
  OPTIONAL{?institution wdt:P856 ?_officialWebsite.}  
  OPTIONAL{?institution wdt:P227 ?_gndId.} 
}
GROUP BY ?institution ?institutionLabel
tryiturl  z7hnKG→z7hnKG
wdqsurl  6UKK→6UKK
scholia  →
relevance  1
comment  
task  Task0→Task0

result LIMIT 7

institution institutionLabel logoImage country coordinateLocation officialWebsite gndId shortName
http://www.wikidata.org/entity/Q154561 University of Jena http://commons.wikimedia.org/wiki/Special:FilePath/Logo%20UniJena.svg http://www.wikidata.org/entity/Q183 Point(11.582222222 50.928333333) https://www.uni-jena.de/ 36164-1
http://www.wikidata.org/entity/Q1065414 Free University of Amsterdam Maagd%20in%20de%20tuin.gif http://www.wikidata.org/entity/Q55 http://www.vu.nl/ 80108-2
http://www.wikidata.org/entity/Q793867 Scripps Research http://www.wikidata.org/entity/Q30 Point(-117.242457 32.896092) https://www.scripps.edu/ 1085823946
http://www.wikidata.org/entity/Q49108 Massachusetts Institute of Technology http://commons.wikimedia.org/wiki/Special:FilePath/MIT%20logo.svg http://www.wikidata.org/entity/Q30 Point(-71.091944444 42.359722222) https://web.mit.edu/ 2179-9 MIT
http://www.wikidata.org/entity/Q278044 Vienna University of Economics and Business http://commons.wikimedia.org/wiki/Special:FilePath/Logo%20Wirtschaftsuniversit%C3%A4t%20Wien.svg http://www.wikidata.org/entity/Q40 Point(16.4082 48.2141) https://www.wu.ac.at/ 115001-7
http://www.wikidata.org/entity/Q7058064 Khoury College of Computer Sciences http://www.wikidata.org/entity/Q30 Point(-71.0903 42.3389) http://www.ccis.northeastern.edu/
http://www.wikidata.org/entity/Q214341 University of Amsterdam Uva%C2%AEmerken%20ENG.png http://www.wikidata.org/entity/Q55 Point(4.890277777 52.368333333) http://www.uva.nl/ 1010694-7