User:Christian Ferrer

From Wikidata
Jump to navigation Jump to search
Babel user information
fr-N Cet utilisateur a pour langue maternelle le français.
en-3 This user has advanced knowledge of English.
es-2 Esta persona tiene un conocimiento intermedio del español.
Users by language


Wikidata:WikiProject Taxonomy

Module:Taxobox

Sitelinks from synonyms (archive in Wikimedia Commons)

example of taxon synonym  : Rhodocybe nitellina (Q10434744)

https://tools.wmflabs.org/sourcemd/index_old.php

https://petscan.wmflabs.org/

{{Statement+}}


  • Examples of type specimens:
NHM 2011.2080 (Q54854611)
YPM IZ 003617.CR (Q65966126)
RUMF-ZC-01654 (Q66006968)
  • Exemple of a taxon that is currently accepted under the original combination and not under a new combination:
Harmothoe anderssoni (Q109829751) vs Eunoe anderssoni (Q2171168)

Queries

[edit]

Type specimens of Echinodermata in the MNHN

[edit]
SELECT distinct ?stype ?stypeLabel ?collec ?collecLabel ?role ?de ?deLabel {
   service <https://query.wikidata.org/sparql> {
     select ?stype ?stypeLabel ?collec ?collecLabel ?role ?de ?roleLabel ?deLabel { 
       ?stype wdt:P31/wdt:P279* wd:Q51255340 
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
       optional {
         ?stype wdt:P195 ?collec .
       }
       ?stype p:P2868 [ps:P2868 ?role ; pq:P642 ?de] .
       values ?collec {
        wd:Q838691 
             }
        ?de wdt:P171* wd:Q44631
     }
   }
}
Try it!

Images of type specimens stored in the Auckland Museum and in the Te Papa Tongarewa

[edit]
#defaultView:ImageGrid

SELECT ?file ?image ?stype ?stypeLabel ?collec ?collecLabel ?role ?roleLabel ?de ?deLabel
with {
  select ?stype ?stypeLabel ?collec ?collecLabel ?role ?de ?roleLabel ?deLabel {
   service <https://query.wikidata.org/sparql> {
     select ?stype ?stypeLabel ?collec ?collecLabel ?role ?de ?roleLabel ?deLabel { 
       ?stype wdt:P31/wdt:P279* wd:Q51255340 
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
       optional {
         ?stype wdt:P195 ?collec .
       }
       ?stype p:P2868 [ps:P2868 ?role ; pq:P642 ?de] .
       values ?collec {
        wd:Q16949336 # Auckland Institute and Museum 
        wd:Q915603 # Museum of New Zealand Te Papa Tongarewa
       }
     }
   }
  }
} as %types
WHERE {
  ?file wdt:P180 ?stype ; schema:contentUrl ?url .
  
  bind(iri(concat("http://commons.wikimedia.org/wiki/Special:FilePath/", replace(substr(str(?url),53),"_","%20"))) AS ?image) .
  
  #?file wdt:P180  wd:Q105607273  .
  include %types
}
Try it!

Items that have a reference for taxon name marked as recombination but are missing basionym and original combination

[edit]
SELECT ?item ?name ?basionym ?protonym WHERE 
{
  ?item wdt:P225 ?name .
  ?item p:P225 ?statement . 
  ?statement prov:wasDerivedFrom ?refnode .
  ?refnode pr:P248 ?ref . 
  ?refnode pr:P6184 wd:Q14594740 .
  OPTIONAL {?item wdt:P566 ?basionym }
  OPTIONAL {?item wdt:P1403 ?protonym }
  FILTER(!bound(?basionym) && !bound(?protonym))
}
ORDER BY ?name
Try it!

Taxa with Plazi IDs as a qualifiers for references

[edit]
SELECT DISTINCT ?PlaziID ?PlaziID_URL ?publication ?publicationLabel ?referenceHasRole ?referenceHasRoleLabel  ?item ?itemLabel
WHERE
{
  {?item p:P225 ?statement .
    ?statement prov:wasDerivedFrom ?reference .
    ?reference pr:P1992 ?PlaziID
  BIND(IRI(CONCAT("http://treatment.plazi.org/id/",?PlaziID)) as ?PlaziID_URL)
  }
  OPTIONAL { ?item p:P225 ?statement .
    ?statement prov:wasDerivedFrom ?reference .
    ?reference pr:P248 ?publication.
              OPTIONAL { ?item p:P225 ?statement .
    ?statement prov:wasDerivedFrom ?reference .
    ?reference pr:P248 ?publication.
    ?reference pr:P6184 ?referenceHasRole}
}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
order by ?itemLabel
Try it!

All the articles published in Zookeys within the year 2018 and showing potential categories in Wikimedia Commons

[edit]
SELECT ?item ?itemLabel ?date ?commonscat ?commonssitelink WHERE {
  ?item wdt:P1433 wd:Q219980; wdt:P577 ?date; wdt:P31 wd:Q13442814 .
  FILTER(YEAR(?date) = 2018) .
  OPTIONAL { ?item wdt:P373 ?commonscat }
  OPTIONAL { ?commonssitelink schema:about ?item; schema:isPartOf <https://commons.wikimedia.org/> }
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
} ORDER BY ASC(?date)
Try it!

Echinodermata taxa

[edit]
SELECT ?item ?itemLabel ?rankLabel
WHERE 
{
  ?item wdt:P171/wdt:P171* wd:Q44631.
  ?item wdt:P105 ?rank.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} order by ?rankLabel ?itemLabel
Try it!

Echinodermata subgenera

[edit]
SELECT ?item ?itemLabel ?rankLabel
WHERE 
{
  ?item wdt:P171/wdt:P171* wd:Q44631.
  ?item wdt:P105 ?rank.
  ?item wdt:P105 wd:Q3238261.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} order by ?rankLabel ?itemLabel
Try it!

Images in Wikimedia Commons depicting items of type specimens

[edit]
#defaultView:ImageGrid

SELECT ?file ?image ?stype ?stypeLabel ?collec ?collecLabel ?role ?roleLabel ?de ?deLabel
with {
  select ?stype ?stypeLabel ?collec ?collecLabel ?role ?de ?roleLabel ?deLabel {
   service <https://query.wikidata.org/sparql> {
     select ?stype ?stypeLabel ?collec ?collecLabel ?role ?de ?roleLabel ?deLabel { 
       ?stype wdt:P31/wdt:P279* wd:Q51255340 
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
       optional {
         ?stype wdt:P195 ?collec .
       }
       ?stype p:P2868 [ps:P2868 ?role ; pq:P642 ?de] .
       #remove the # below to specify one or more collections
       #values ?collec {
       # wd:Q122945 # example with the Yale Peabody Museum of Natural History 
       #}
       #?de wdt:P171* wd:Q15711568 . # choose a taxon whose types are sought, including the types of its sub-taxa 
     }
   }
  }
} as %types
WHERE {
  ?file wdt:P180 ?stype ; schema:contentUrl ?url .
  
  bind(iri(concat("http://commons.wikimedia.org/wiki/Special:FilePath/", replace(substr(str(?url),53),"_","%20"))) AS ?image) .
  
  #?file wdt:P180  wd:Q105607273  .
  include %types
}
Try it!

To check

[edit]
SELECT distinct ?item ?itemLabel ?taxon_name ?derived ?derivedLabel WITH { SELECT ?cand ?tname ?label
WHERE 
{
  VALUES ?tname {"Antipathes hypnoides"} .
  BIND(STRLANG(?tname,"en") as ?label)
  {?cand wdt:P225 ?tname . }
  UNION
  {?cand rdfs:label ?label . }
  } } as %i
WITH { SELECT ?item WHERE
{
  INCLUDE %i
  ?cand wdt:P225 ?taxonname .
  BIND(STRLANG(?taxonname,"en") as ?label2)
  {?item wdt:P225 ?tname . }
  UNION
  {?item rdfs:label ?label . }
  UNION
  {?item wdt:P225 ?taxonname . }
  UNION
  {?item rdfs:label ?label2 . }
  }  } as %j
WHERE
{
  INCLUDE %j
  ?item p:P225 ?stat . 
  ?stat prov:wasDerivedFrom/pr:P248 ?derived.
  ?stat ps:P225 ?taxon_name
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 
}
Try it!

QuickStatements [1]

[edit]

(from Wikidata:Project chat/Archive/2020/05#QuickStatements) Code for [2] and [3] is:

Q22703892 [tab] P225 [tab] "Sibogaster" [tab] P405 [tab] Q91510 [tab] P574 [tab] +1924-00-00T00:00:00Z/9 [tab] S248 [tab] Q94383917 [tab] S6184 [tab] Q1361864

To create taxa items:

The code below created Qianguimon elongatum (Q100700188) Qianguimon rongxianense (Q100700189) Qianguimon splendidum (Q100700190)

V1

CREATE||LAST|Len|"Qianguimon elongatum"||LAST|Den|"species of crustacean"||LAST|P31|Q16521||LAST|P225|"Qianguimon elongatum"||LAST|P105|Q7432||LAST|P171|Q100605554||LAST|P850|"1062897"||CREATE||LAST|Len|"Qianguimon rongxianense"||LAST|Den|"species of crustacean"||LAST|P31|Q16521||LAST|P225|"Qianguimon rongxianense"||LAST|P105|Q7432||LAST|P171|Q100605554||LAST|P850|"1389612"||CREATE||LAST|Len|"Qianguimon splendidum"||LAST|Den|"species of crustacean"||LAST|P31|Q16521||LAST|P225|"Qianguimon splendidum"||LAST|P105|Q7432||LAST|P171|Q100605554||LAST|P850|"1062898"


As above + author + year + reference (first description)

The code below created Ligia dante (Q101208723) Ligia eleluensis (Q101208724)

V1

CREATE||LAST|Len|"Ligia dante"||LAST|Den|"species of crustacean"||LAST|P31|Q16521||LAST|P225|"Ligia dante"|P405|Q89596299|P574|+2019-00-00T00:00:00Z/9|S248|Q92761099|S6184|Q1361864||LAST|P105|Q7432||LAST|P171|Q148814||LAST|P850|"1460701"||CREATE||LAST|Len|"Ligia eleluensis"||LAST|Den|"species of crustacean"||LAST|P31|Q16521||LAST|P225|"Ligia eleluensis"|P405|Q89596299|P574|+2019-00-00T00:00:00Z/9|S248|Q92761099|S6184|Q1361864||LAST|P105|Q7432||LAST|P171|Q148814||LAST|P850|"1460702"


The code below created

V1 ZMKU-ANN-0006 (Q105636456)

CREATE||LAST|Len|"ZMKU-ANN-0006"||LAST|Den|"holotype of Placobdelloides sirikanchanae"||LAST|P31|Q51255340||LAST|P276|Q57204521||LAST|P195|Q57204521||LAST|P217|"ZMKU-ANN-0006"|P195|Q57204521||LAST|P189|Q133861||LAST|P2868|Q1061403|P642|Q87702777|S248|Q75060070


To create type specimens items:

The code below created USNM E7122 (Q121372596)

V1

CREATE||LAST|Len|"USNM E7122"||LAST|Den|"paratype of Ophiura fisheri"||LAST|P31|Q51255340|S248|Q109207712||LAST|P276|Q148554|S248|Q109207712||LAST|P195|Q148554|S248|Q109207712||LAST|P217|"USNM E7122"|P195|Q148554|S248|Q109207712||LAST|P2699|"http://n2t.net/ark:/65665/34c7c79e6-812d-43ff-a68b-148d1781f8c7"||LAST|P2868|Q926578|P642|Q105400462|S248|Q109207712