Help:WikiPathways SPARQL queries
From WikiPathways
(Difference between revisions)
(→Prefixes) |
|||
| Line 4: | Line 4: | ||
Below are example queries. For readability we have omitted the prefixes. We use the following prefixes | Below are example queries. For readability we have omitted the prefixes. We use the following prefixes | ||
| + | <pre> | ||
| + | PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> | ||
| + | PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | ||
| + | PREFIX dc: <http://purl.org/dc/elements/1.1/> | ||
| + | PREFIX foaf: <http://xmlns.com/foaf/0.1/> | ||
| + | PREFIX schema: <http://schema.org/> | ||
| + | </pre> | ||
= Example queries = | = Example queries = | ||
Revision as of 15:39, 18 October 2012
On sparql.wikipathways.org wikipathways content is replicated. Currently this SPARQL endpoint is being developed, with very irregular updates.
Prefixes
Below are example queries. For readability we have omitted the prefixes. We use the following prefixes
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX dc: <http://purl.org/dc/elements/1.1/> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX schema: <http://schema.org/>
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 |
