Help:WikiPathways SPARQL queries
From WikiPathways
(Difference between revisions)
(→Example queries) |
(→Example queries) |
||
| Line 22: | Line 22: | ||
|- | |- | ||
|Extract the amount of pathways edited per contributor | |Extract the amount of pathways edited per contributor | ||
| - | | | + | |<pre>SELECT DISTINCT ?contributor, count(?pathway) as ?pathwaysEdited |
| + | WHERE { | ||
| + | ?pathway dc:contributor ?contributor | ||
| + | } | ||
| + | ORDER BY DESC(?pathwaysEdited)</pre> | ||
|[http://sparqlbin.com/#1d70dbc532f8d785b57a42b5d2d92ad4 Execute] | |[http://sparqlbin.com/#1d70dbc532f8d785b57a42b5d2d92ad4 Execute] | ||
|- | |- | ||
Revision as of 15:36, 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 | Execute |
