Institutional membership (2020) in wikidata

[nickynicolson]

(Of potential interest to TDWG website development due to use of multiple languages in institutional membership list (as per recent commit 7c1d0b6): I added TDWG institutional membership statements to wikidata, which also holds translations of institutional names, and location coordinates etc.

SPARQL query to retrieve these below:

# TDWG institutional members
# These have a varied mix of "instanceOf" (P31) values - here aggregated as "instanceLabels"
# Due to mix of instances, not all have coordinate locations (hence coordinates OPTIONAL)
SELECT ?item ?itemLabel ?geo
               (GROUP_CONCAT(DISTINCT ?instanceLabel; SEPARATOR=", ") AS ?instanceLabels)
WHERE
{
  # memberof TDWG
  ?item wdt:P463 wd:Q4914768.
  ?item wdt:P31 ?instance .
  OPTIONAL {?item wdt:P625 ?geo}
  FILTER NOT EXISTS { 
    # Exclude humans
    ?item wdt:P31 wd:Q5 
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". 
                         ?instance rdfs:label ?instanceLabel.
                         ?item rdfs:label ?itemLabel.
                         }
}
GROUP BY ?item ?itemLabel ?geo
ORDER BY ?itemLabel

This link loads the query in the wikidata query service - which supports map format results if coordinate location available for items (select "map" from drop-down above results panel, default is "table").

Two members are currently missing from wikidata, but can be added:

• Belgian Biodiversity Platform
• National Research Collections Australia

One is listed as a kind of consortium in the TDWG membership list (Harvard University/Ernst Mayr Library/Museum of Comparative Zoology), but each of the members have their own wikidata item:

• Harvard University (Q13371)
• Ernst Mayr Library (Q53528757)
• Museum of Comparative Zoology (Q1420782)

If this is useful, advice on how to handle this "consortium" welcomed - three separate statements are simple, but would give an inflated number of institutional members in the SPARQL query above.