Help:WikiPathways SPARQL queries
From WikiPathways
(Difference between revisions)
(→Example queries) |
(→Example queries) |
||
| Line 30: | Line 30: | ||
|- | |- | ||
|find the pathways a user have edited so far. Change the name in the query | |find the pathways a user have edited so far. Change the name in the query | ||
| - | | | + | |<pre>SELECT DISTINCT ?pathway, ?pathwayLabel |
| + | WHERE { | ||
| + | ?pathway dc:contributor wpuser:Andra . | ||
| + | ?pathway dc:contributor ?contributor . | ||
| + | ?pathway rdfs:label ?pathwayLabel . | ||
| + | } | ||
| + | </pre> | ||
|[http://sparqlbin.com/#11e121d4593914dfadb96916bf95feb5 Execute] | |[http://sparqlbin.com/#11e121d4593914dfadb96916bf95feb5 Execute] | ||
|- | |- | ||
|} | |} | ||
Revision as of 15:37, 18 October 2012
On sparql.wikipathways.org wikipathways content is replicated. Currently this SPARQL endpoint is being developed, with very irregular updates.
Example queries
| Get all datasource currently captured in WikiPathways | select distinct ?datasource count(?datasource) as ?numberEntries
where {?concept dc:source ?datasource}
| Execute |
| Get the number of entries per datasource in WikiPathways | select distinct ?datasource
where {?concept dc:source ?datasource}
| Execute |
| Extract contributors | SELECT DISTINCT ?contributor
WHERE {
?pathway dc:contributor ?contributor
}
| Execute |
| Extract the amount of pathways edited per contributor | SELECT DISTINCT ?contributor, count(?pathway) as ?pathwaysEdited
WHERE {
?pathway dc:contributor ?contributor
}
ORDER BY DESC(?pathwaysEdited)
| Execute |
| find the pathways a user have edited so far. Change the name in the query | SELECT DISTINCT ?pathway, ?pathwayLabel
WHERE {
?pathway dc:contributor wpuser:Andra .
?pathway dc:contributor ?contributor .
?pathway rdfs:label ?pathwayLabel .
}
| Execute |
