Modelling/Index term

Modelling guidelines for Metabase Documents — Index terms — Humans — Events and activities (Conferences) — Projects — Content uploads (Resource types)

Modeling topics

An index term (Q12) is a keyword that we use to describe e.g. the topic of a document or the focus area of a project (using keyword (P15)).

Within the scope of Metabase, the label is enough to tag documents; we do not concern ourselves with e.g. expressing the relationships between index terms. Those live in Wikidata, and if necessary, can be queried using federated queries.

That's why the only the only data we provide is:

• instance of (P5) → index term (Q12)
• same as on Wikidata (P1) → Q ID

For example: museum collection (Q18), public art (Q39), authority control (Q17).

Of course, sometimes you'll want to use an item that also is something else (e.g. a location (Q66) or a Wikimedia content project (Q22)) as a topic. In this case, add instance of (P5) : index term (Q12) to the item.

For example: Gothenburg (Q21935), Swedish Wikipedia (Q26).

SPARQL

All index terms with their labels and descriptions in Swedish and English

PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>

SELECT ?item ?itemLabelEN ?itemLabelSV ?wikidata_iri
WHERE
{
?item wbt:P5 wb:Q12 .
OPTIONAL {?item wbt:P1 ?wikidataQ}
OPTIONAL {?item rdfs:label ?itemLabelEN filter (lang(?itemLabelEN) = "en")}.
OPTIONAL {?item rdfs:label ?itemLabelSV filter (lang(?itemLabelSV) = "sv")}.
BIND(URI(concat("http://www.wikidata.org/entity/", ?wikidataQ)) AS ?wikidata_iri)
}

Try it!

Count the index terms

PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>

SELECT (COUNT(*) AS ?count_index_terms)
WHERE
{
?item wbt:P5 wb:Q12 .
}

Try it!

Timeline of everything published or presented about Structured Data on Commons

#defaultView:Timeline
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
SELECT ?item ?itemLabel ?time
WHERE
{
?item wbt:P15 wb:Q90 # SDC
{?item wbt:P23 ?time} # point in time
UNION
{?item wbt:P18 ?time} # publication date
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,sv". }
}

Try it!