Help:WikiPathways SPARQL queries

From WikiPathways

(Difference between revisions)
Jump to: navigation, search
(Example queries)
(Example queries)
Line 15: Line 15:
|-
|-
|Extract  contributors
|Extract  contributors
-
|
+
|<pre>SELECT DISTINCT ?contributor 
 +
WHERE {
 +
      ?pathway dc:contributor ?contributor
 +
}</pre>
|[http://sparqlbin.com/#ff17d4240f1c0848c21652d87576862b Execute]
|[http://sparqlbin.com/#ff17d4240f1c0848c21652d87576862b 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 Execute
find the pathways a user have edited so far. Change the name in the query Execute
Personal tools