User:Fingerhuth/RDM-Projects

Queries on third party funding

Map of third party funded projects

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

#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

FDM-Projekte in Förderprogrammen

Map of third party funded projects on rdm including budget

#defaultView:Map{"hide":"?geoLocs", "layer":"?FoerderprogrammLabel"}
SELECT ?Projekt ?ProjektLabel ?InstitutionLabel ?Foerderprogramm ?FoerderprogrammLabel (MIN(?geoLoc) AS ?geoLocs) ?FunderLabel ?Cost_with_currency 
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 ;
           p:P1416 [ps:P1416 ?Institution ;
                    pq:P2769 ?Budget_EURO ;
                    ] ;
           p:P1416 [pqv:P2769 ?valuenode] .
  ?valuenode     wikibase:quantityUnit       ?Currency .
  ?Currency wdt:P498 ?CurrencyLabel .
  BIND(CONCAT(str(?Budget_EURO), " ", str(?CurrencyLabel)) as ?Cost_with_currency)
  OPTIONAL { ?Institution wdt:P625 ?geoLoc .}
  OPTIONAL { ?Institution(wdt:P159/wdt:P625) ?geoHead. }
  BIND(COALESCE(?geoLoc, ?geoHead) AS ?geoLoc)
}
GROUP BY  ?Cost_with_currency ?FunderLabel ?Foerderprogramm ?FoerderprogrammLabel ?InstitutionLabel ?Projekt  ?ProjektLabel

Try it!