The LOD pilot project ‘Berner Ortsgeschichten’ is a collaboration between Digital Scholarship and the ZHB (Historical Collections Center), both part of the University Library Bern. While Digital Scholarship was seeking suitable data to acquire some initial experience with a linked data project, ZHB aimed to make the data of the Bibliography of Bernese History (BBG) more accessible. However, as the dataset of this bibliography includes more than 30,000 records, a decision was made to begin by focusing on the nearly 600 Bernese local histories dedicated to specific villages and towns (German: Ortsgeschichten).
Since these texts narrate the history of one specific place, not only should they be enriched with external links by means of the places’ GND identifiers (GND-IDs), obtained from the library catalogue (Alma), but they should also be georeferenced and made accessible on a map.
The first step involved selecting around 40 Bernese local histories from the nineteenth century, which are fully digitised and available on DigiBern, enriching the corresponding metadata, which was extracted from the catalogue, and georeferencing it on a map.
Many obstacles had to be overcome: First of all, GND-IDs cannot be easily retrieved from Alma. The complete metadata had to be extracted via the SRU API, and then the GND-IDs had to be extracted with Python. Second, the GND-IDs do not directly point to the desired linked data. Using muenzfunde.ch, it was possible to obtain many of the desired links to Wikidata (Q-IDs), the Historical Dictionary of Switzerland (HLS-DHS) and ortsnamen.ch. Finally, the IT department had no time to display the data on a map, so Google My Maps was chosen as a workaround, despite its highly limited functionalities. Nevertheless, the more than 8,400 views of the map ‘Berner Ortsgeschichten aus dem 19. Jahrhundert’ on DigiBern indicate significant interest in this kind of resource.
The Python script was then adapted for the larger dataset of Bernese local histories dedicated to specific villages and towns from 1975 onwards (500+). Furthermore, a separate data table was created as a concordance, replacing the table from muenzfunde.ch that had been used for the 40 nineteenth-century histories.
Thanks to the Q-IDs that were added during this process, links to the coats of arms of villages/towns and to the official websites of municipalities, as well as other desired links, can now be reliably extracted from Wikidata with a few lines of Python, alongside the geographic coordinates. The IT department managed to create a proof of concept for the map, which is accessible via the university network (Citrix). Automatic updates to the data from the catalogue are planned, but unlikely to be carried out this year.
Other planned steps include, first, the continuous expansion of the Bernese local table (BEOT) – which contains the Q-IDs, links to HLS-DHS and ortsnamen.ch, and the GND-IDs – and, second, the direct enrichment of the GND records with the Q-IDs. Additionally, there are plans to supplement/correct the location data in Wikidata and make the project’s data available on GitHub.