User:Christian Ferrer/miscellaneous

From Wikispecies
Jump to navigation Jump to search

Various links[edit]

Querries[edit]

SELECT * WHERE {
  ?item wdt:P105 wd:Q7432;
        wdt:P171+ wd:Q59256 .
  ?article schema:about ?item; schema:isPartOf <https://species.wikimedia.org/>; schema:name ?title .
}

Try it!

  • Taxa with author in Wikidata, but no Wikispecies sitelink:
#taxa with author, but no Wikispecies sitelink
#by Jura1, August 28, 2020


SELECT ?author ?authorLabel ?taxa ?count
WITH
{
  SELECT ?author
         (GROUP_CONCAT(DISTINCT ?taxon; separator=", ") as ?taxa)
         (COUNT(?taxon) as ?count)
  WHERE
  {
    ?st pq:P405 ?author .
    FILTER NOT EXISTS { [] schema:about ?author ; schema:isPartOf <https://species.wikimedia.org/> }
    ?st ps:P225 ?taxon .
  }
  GROUP BY ?author
} as %new
WHERE
{
  INCLUDE %new
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?count)
LIMIT 100

Try it!

  • Taxa of Ophiuroidea with author in Wikidata, but no Wikispecies sitelink:
#taxa of wd:Q59256 with author, but no Wikispecies sitelink
#by Jura1, August 29, 2020

SELECT ?author ?authorLabel ?taxa ?count
WITH
{
  SELECT ?author
         (GROUP_CONCAT(DISTINCT ?taxon; separator=", ") as ?taxa)
         (COUNT(?taxon) as ?count)
  WHERE
  {
    hint:Query hint:optimizer "None".
    ?taxonitem wdt:P171+ wd:Q59256 .
    ?taxonitem p:P225 ?st . 
    ?st pq:P405 ?author .
    FILTER NOT EXISTS { [] schema:about ?author ; schema:isPartOf <https://species.wikimedia.org/> }
    ?st ps:P225 ?taxon .
  }
  GROUP BY ?author
} as %new
WHERE
{
  INCLUDE %new
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?count)
LIMIT 100

Try it!

#all taxa with the same author 
#by Jura1, Aug 29, 2020

SELECT (YEAR(?date) as ?year) ?taxonitem ?taxonitemLabel ?taxonitemDescription ?rank ?rankLabel ?img ?wikispecies
WHERE
{
    ?st pq:P405 wd:Q2418660 . 
    ?st ps:P225 ?taxon .
    ?taxonitem p:P225 ?st . 
    OPTIONAL { ?st pq:P574 ?date }
    OPTIONAL { ?taxonitem wdt:P105 ?rank }
    OPTIONAL { ?taxonitem wdt:P18 ?img }
    OPTIONAL { ?wikispecies schema:about ?taxonitem ; schema:isPartOf <https://species.wikimedia.org/> }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Stuff[edit]

to check :

Thetis Expedition: {{Whitelegge, 1906}} {{Whitelegge, 1907}} {{Clark, 1909a}}{{Stebbing, 1910a}} {{Clark, 1911a}} {{Thomson & Mackinnon, 1911}} {{Coleman, 1911}} {{Ritchie, 1911}}
to upload https://doi.org/10.15560/12.1.1836
[6]
  • Look at last image [7], not yet uploaded

Unclear WoRMS quotes[edit]