Modelling/Index term: Difference between revisions

From MetaBase
Jump to navigation Jump to search
No edit summary
Line 11: Line 11:
For example: {{Q|Q18}}, {{Q|Q39}}, {{Q|Q17}}.
For example: {{Q|Q18}}, {{Q|Q39}}, {{Q|Q17}}.
==SPARQL==
==SPARQL==
Query to find all index terms with their labels and descriptions in Swedish and English:
===Query to find all index terms with their labels and descriptions in Swedish and English===
<SPARQL tryit="1">
<SPARQL tryit="1">
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
Line 24: Line 24:
OPTIONAL {?item rdfs:label ?itemLabelSV filter (lang(?itemLabelSV) = "sv")}.
OPTIONAL {?item rdfs:label ?itemLabelSV filter (lang(?itemLabelSV) = "sv")}.
BIND(URI(concat("http://www.wikidata.org/entity/", ?wikidataQ)) AS ?wikidata_iri)
BIND(URI(concat("http://www.wikidata.org/entity/", ?wikidataQ)) AS ?wikidata_iri)
}
</SPARQL>
===Count the index terms===
<SPARQL tryit="1">
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 .
}
}
</SPARQL>
</SPARQL>
[[Category:Documentation|i]]
[[Category:Documentation|i]]

Revision as of 14:53, 22 November 2023


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).

SPARQL

Query to find 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!