gsergiu / music-genres Goto Github PK

Create SKOS RDF file for classical compositions from https://docs.google.com/spreadsheets/d/1hKAZWPEz_FtKj1PjE8JMZICiQLR4pltR6BEP8nX4VkA/edit#gid=837319921 CSV file. Enrich with Wikidata IDs, descriptions and international labels.

Retrieve artist tags from Musikbrainz and store results in a CSV format.

the query to use is the following:
[{
"type": "/music/instrument",
"/music/instrument/family": [],
"key": [{
"value": "Cembalo",
"namespace": null
}],
"id": null,
"mid": null
}]

Get Musicbrainz, DBPedia, Internet Archive, VIAF, Wikidata IDs.

Todos:

• enrich vocabulary with wikidata urls
• check wikidata id 1 problem
• manualy search for missing wikidata links
• set exactMatch to wikidata urls
• move dbpedia urls to close match

Use Wikidata ID.

Having a MIMO exact and broad match links for instruments we download data in JSON-LD format.

Load original instrumens overview file. Parse Cultuurlink RDF XML and extract MIMO links. Retrieve IDs and PrefLabel from MIMO by IDs.

Having bands and artists overview - aggregate instruments from Wikidata and Musicbrainz.

Retrieve descriptions in EN, DE and IT language and aliases.

The Instruments ot the ONB_flat.csv needs to be converted first to skos format (using the same template as Instruments of the ONB_list_SKOS.xml), and the resulting file needs to be used to mappng terms with cultuurlink.

Useful resources:

Here some tutorial on how to use cultuurlink
https://basecamp.com/1936492/projects/4984360/messages/50700771#events_message_50700771

There is a strategy.xml.template document in the test resources which hopefully can be reused for defining the cultuurlink mappings.

the master rdf.xml representation has to be submitted in the resources.
This should be always in an consistent state
see also #1

The instrument name goes to prefLabel and the "Andere Sprachen" goes to altLabel:
https://github.com/gsergiu/music-genres/blob/master/music-genre/src/test/resources/MIMO/onb/Instruments%20of%20the%20ONB_list.csv

Employ Freebase dump.

Use europeana search API to find ONB items that match the SKOS labels (preffered and alternative) in Title or Description (title and dcDescription).
The search needs to be performed in this collection: http://www.europeana.eu/portal/search?q=europeana_collectionName%3A%282059216_Ag_EU_eSOUNDS_1001_ONB%29

Sample query in portal: http://www.europeana.eu/portal/search?q=%28europeana_collectionName%3A%282059216_Ag_EU_eSOUNDS_1001_ONB%29%20AND%20%28title:%22trombe%22%20OR%20proxy_dc_description:%22trombe%22%29%29

The labels need to be taken from following skos file: https://github.com/hugomanguinhas/music-genres/blob/d1e9691b4a12f2f386281322f500f89db34f669e/music-genre/src/test/resources/MIMO/onb/Instruments%20of%20the%20ONB_list_SKOS.xml

Output: csv. File
Searched label; Skos_resource;title; description;europeanaId;

Values taken from skos file:
<skos:inScheme rdf:resource="http://localhost/DDB/music+genres"/>
skos:prefLabelCello/skos:prefLabel
skos:altLabelVioloncell/skos:altLabel
skos:altLabelVioloncello/skos:altLabel

Values taken from search response:
Title, description, europeanaId