query-587db46e2166a74b9690fdc915c41427

rq turtle/ttl

Map of third party funded projects on rdm, no inclusion of budget

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Map{"hide":"?geoLocs", "layer":"?FoerderprogrammLabel"}
#title: FDM-Projekte in Förderprogrammen
SELECT ?Projekt ?ProjektLabel ?InstitutionLabel ?Foerderprogramm ?FoerderprogrammLabel (MIN(?geoLoc) AS ?geoLocs) ?FunderLabel 
WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?Projekt wdt:P31 wd:Q170584 ;
           wdt:P101 wd:Q30089794 ;
           wdt:P361 ?Foerderprogramm ;
           wdt:P859 ?Funder ;
           wdt:P1416 ?Institution .
  OPTIONAL { ?Institution wdt:P625 ?geoLoc .}
  OPTIONAL { ?Institution(wdt:P159/wdt:P625) ?geoHead. }
  BIND(COALESCE(?geoLoc, ?geoHead) AS ?geoLoc)
}
GROUP BY  ?FunderLabel ?Foerderprogramm ?FoerderprogrammLabel ?InstitutionLabel ?Projekt  ?ProjektLabel

Query found at