Wikidata:Dataset Imports/Libris Library Database

You may find these related resources helpful:

• Dataset Imports
• Why import data into Wikidata.
• Learn how to import data
• Bot requests
• Ask a data import question

Guidelines for using this page

Documenting the import

• Guidelines on how to import a dataset into Wikidata are available at Wikidata:Data Import Guide.
• Please include notes on all steps of the process.
• Once a dataset has been imported into Wikidata please edit the page to change the progress status from in progress to complete.
• It is strongly recommended to use Visual Editor when making changes to this page, particularly for editing any of the tables.

Creating a Wikidata item for the dataset

• Please create a Wikidata item for the dataset, this will allow us to improve the coverage of datasets on Wikidata and understand what datasets are available on that topic and which of them have been added to Wikidata.
• If you are working with very large dataset you can break it into smaller Mix n' Match catalogues, but only create one Wikidata item.
• Link the dataset Wikidata item to this page using Wikidata Dataset Imports URL (P5195)

Getting help

• If your dataset import runs into issues please edit the page to change the progress status from in progress to help needed.
• You can ask for help on Wikidata:Project chat.

Overview

Dataset name

Libris Library Database

Source

National Library of Sweden

Link

https://biblioteksdatabasen.libris.kb.se/exportinfo/

Dataset description

Database of libraries (public, school, etc) in Sweden.

Progress of import

The table below is used to track the progress of importing this dataset. The suggested column headings are most applicable to data being imported from a spreadsheet - you can change some column headings or add new columns as required to best describe the progress of this import.

Wikidata item for the dataset	Import data into spreadsheet	Format the spreadsheet to import the data	Structure of data within Wikidata	Match the dataset to Wikidata	Importing data into Wikidata	Visualisations	Maintainance queries and expected results
Libris library database (Q55502519)	yes	yes	yes	yes

Edit history

Use the table below to list batches of edits that have been completed for this dataset. Ideally each entry should have all applicable columns filled out, but at a minimum please make to add a date and description to give an idea of what was added to Wikidata and when.

Date	Description	Method	Properties	Qualifiers	References	Statements added	Statements removed	Link to import sheet
2019-02-18	Create items for ~1000 public libraries	OpenRefine (direct upload)
2019-02-18	Create items for ~900 school libraries	OpenRefine (direct upload)
2019-02-18	Create items for ~190 academic libraries	OpenRefine (direct upload)

Discussion of import

These headings are generally useful, please change this section to suit your needs.

Wikidata item for dataset

• Libris library database (Q55502519)

Import data into spreadsheet

We downloaded the data in spreadsheet format from the link provided at https://biblioteksdatabasen.libris.kb.se/exportinfo/.

Format the spreadsheet to import the data

We used OpenRefine to view and edit the data, thus no extra formatting was necessary.

Structure of data within Wikidata

Field name	Wikidata property	Notes
Bibliotek	Label in Swedish
Alternativt biblioteksnamn	Alias in Swedish
Sigel		Used to create reference URL (P854) in sources, i.e. 8fit → https://biblioteksdatabasen.libris.kb.se/library/8fit/
Bibliotekstyp	instance of (P31)	busbib – company library (Q2498389) folkbib – public library (Q28564) friskol – school library (Q1076099) frisgym – school library (Q1076099) gymbib – school library (Q1076099) musbib – museum library (Q13866185) musstat – museum library (Q13866185) muslan – museum library (Q13866185) muskom – museum library (Q13866185) sjukbib – hospital library (Q1786555) skolbib – school library (Q1076099) specbib – special library (Q385994) univbib – academic library (Q856234)
Ort	location (P276)
Latitud	part of coordinate location (P625)
Longitud	part of coordinate location (P625)
Kommunkod	located in the administrative territorial entity (P131)	This field contains the Swedish municipality code (P525)
—	country (P17)	Not present in source data – set to Sweden (Q34) if a Swedish municipality was matched.

Match the dataset to Wikidata

The matching and reconciling was done in OpenRefine.

Before we started working with the dataset, there were only ca. 90 items for libraries (of any type) on Wikidata.

We decided to not touch those and instead focus on creating new items for the remaining thousands.

Because of problems with data quality, we removed some of the columns from the source data:

• Website – examining a sample showed these were often inaccurate, i.e. by pointing at a dead page, or an irrelevant one, such as the main page of the municipality rather than the library's page.
• Phone/e-mail – we knew from our communication with the data provider that the database was not well maintained, thus the risk of this data being outdated was higher than the possible benefit of including it.
• Gatuadress/Postnummer/Geocode – we decided to omit address data at this stage, again because of the known problems with updating the database. Also it is not clear which of these fields were most appropriate to include. However, we will discuss this with the data provider and hopefully will be able to include some sort of address data in a later run.

In order to set the located in the administrative territorial entity (P131) property, we used the kommunkod column, which contains the Swedish municipality code (P525) of the municipality.

A bunch of entries did not have a municipality code, or had an incorrect one.

If a Swedish municipality was matched succesfully, country (P17) → Sweden (Q34) was added. No country was added to entries without a matched municipality.

The database also included a bunch of libraries outside Sweden (mostly in Norway, Denmark), because they're connected to the Libris system. Those were excluded.

Importing data into Wikidata

The import was done using OpenRefine and its upload functionality.

We uploaded one library type at a time.

Import completion notes

The following batches have been ran so far

1. Create school libraries
2. Create public libraries 1 2
3. Create academic libraries

Visualisations

• Libraries in Sweden on a map

Maintenance

Queries and expected results

Query link	Description	Expected results
Libraries in Sweden without municipality	Instance of subclass of library without located in the administrative territorial entity (P131)	Should be edited down to zero
Libraries in Sweden without location	Instance of subclass of library without location (P276)	Should be edited down to zero
Libraries in Sweden without coords	Instance of subclass of library without coordinate location (P625)	Should be edited down to zero