Cleaning of themes

[adibaba]

Themes should use a limited set of URIs.
If localized (german, french, ...) URIs are used, international (english) URIs should be added.
Alternatively, localized URIs could be replaced by international ones.

List of theme translations:
http://publications.europa.eu/resource/dataset/data-theme
(source: https://ec.europa.eu/isa2/dcat-ap-key-european-data-publishers-reach-data-consumers-and-create-european-open-data-ecosystem_en)

[adibaba]

English terms for the 14 categories are listed here: http://publications.europa.eu/resource/cellar/dca1f05f-261c-11e8-ac73-01aa75ed71a1.0001.04/DOC_6

The respective theme URIs have the form http://publications.europa.eu/resource/authority/data-theme/AGRI

[adibaba]

For EDP data, a list of themes can be generated with this query:

PREFIX dcat: <http://www.w3.org/ns/dcat#>
PREFIX dct: <http://purl.org/dc/terms/>

SELECT DISTINCT (?theme as ?dcattheme) (COUNT(?theme) as ?count)
# FROM <http://projekt-opal.de>
WHERE {
  ?s dcat:theme ?theme .
}
GROUP BY ?theme
ORDER BY DESC(?count)

(source: https://github.com/projekt-opal/statistics/blob/master/src/main/resources/queries/number-of-themes.txt)

It can be executed here: https://www.europeandataportal.eu/sparql

The resulting list can be dowloaded here: https://www.justbeamit.com/kzgv3

[adibaba]

Overview now in wiki: https://github.com/projekt-opal/catfish/wiki/Themes