rete
playground
Select
🤝 Repositories shared by two institutions
Repository
Shared by
Sectors
+1
k8up
k8up + VSHN AG
Communities / IT
…
hitobito
Hitobito + Puzzle ITC
Communities / IT
…
mf-geoadmin3
Bundesamt für Landest…
Gov Federal
…
web-mapviewer
Bundesamt für Landest…
Gov Federal
…
Run this query →
no server · no download · no account
caviri.github.io/rete
Run this query in the playground →
30 rows · 353 ms · no server, no download — the query runs in your browser.
The query
PREFIX ossb: <https://w3id.org/rete/oss-benchmark#> PREFIX pulse: <https://open-pulse.epfl.ch/ontology#> PREFIX gme: <https://openpulse.science/git-metadata-extractor#> PREFIX org: <http://www.w3.org/ns/org#> PREFIX schema: <http://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?repoName (GROUP_CONCAT(DISTINCT ?in; SEPARATOR=' + ') AS ?institutions) (GROUP_CONCAT(DISTINCT ?sec; SEPARATOR=' / ') AS ?sectors) (SAMPLE(?st) AS ?stars) WHERE { ?repo a schema:SoftwareSourceCode ; schema:name ?repoName ; ossb:attributedToInstitution ?i ; pulse:githubRepoStars ?st . ?i schema:name ?in ; ossb:sector ?s . ?s skos:prefLabel ?sec . } GROUP BY ?repo ?repoName HAVING (COUNT(DISTINCT ?i) > 1) ORDER BY DESC(?stars) LIMIT 30
rete playground
·
documentation
·
github.com/caviri/rete