Modelling/Index term
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 main subject (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:
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)
}
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 .
}
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". }
}