Project:SPARQL/examples: Difference between revisions

From T-rex Taxonomy
Jump to navigation Jump to search
No edit summary
No edit summary
Line 10: Line 10:
GROUP BY ?class ?classLabel
GROUP BY ?class ?classLabel
</sparql>
</sparql>
== Jeremy's visualization ==
#defaultView:Dimensions
PREFIX ps: <http://trex-taxonomy.wiki.opencura.com/prop/statement/>
PREFIX p: <http://trex-taxonomy.wiki.opencura.com/prop/>
PREFIX pr: <http://trex-taxonomy.wiki.opencura.com/prop/reference/>
PREFIX wdt: <http://trex-taxonomy.wiki.opencura.com/prop/direct/>
PREFIX wd: <http://trex-taxonomy.wiki.opencura.com/entity/>
SELECT ?taxonLabel  ?scientific_nameLabel ?authorityLabel ?doi ?year WHERE {
  ?taxon wdt:P1 wd:Q19 ;
          wdt:P8 ?scientific_name .
  ?specimen wdt:P1 wd:Q24 ;
            p:P8 [
              ps:P8 ?scientific_name ;
              prov:wasDerivedFrom [
                  pr:P31 ?authority ;
              ]
    ] .
    ?authority wdt:P7 ?date ;
              wdt:P19 ?doi .
    bind (str(year(?date)) as ?year)
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }     
} ORDER BY ?year

Revision as of 10:31, 3 January 2021

Counts of classes

The following query uses these:

PREFIX wbt: <http://trex-taxonomy.wiki.opencura.com/prop/direct/>
 
SELECT DISTINCT ?class ?classLabel (COUNT(?class) AS ?counts) WHERE {
   ?item wbt:P1 ?class .
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }     
}
GROUP BY ?class ?classLabel

Try it!


Jeremy's visualization

  1. defaultView:Dimensions

PREFIX ps: <http://trex-taxonomy.wiki.opencura.com/prop/statement/> PREFIX p: <http://trex-taxonomy.wiki.opencura.com/prop/> PREFIX pr: <http://trex-taxonomy.wiki.opencura.com/prop/reference/> PREFIX wdt: <http://trex-taxonomy.wiki.opencura.com/prop/direct/> PREFIX wd: <http://trex-taxonomy.wiki.opencura.com/entity/>

SELECT ?taxonLabel ?scientific_nameLabel ?authorityLabel ?doi ?year WHERE {

  ?taxon wdt:P1 wd:Q19 ;
         wdt:P8 ?scientific_name .
  ?specimen wdt:P1 wd:Q24 ;
            p:P8 [
              ps:P8 ?scientific_name ;
              prov:wasDerivedFrom [
                  pr:P31 ?authority ;
              ]
    ] .
   ?authority wdt:P7 ?date ;
              wdt:P19 ?doi .
   bind (str(year(?date)) as ?year)
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }      

} ORDER BY ?year