This is project started as part of CTC21: Put Your City on the Map, which ran Saturday 28th Nov 2020 and Sunday 29th Nov 2020.
There are thousands of ship wrecks off the coast of Scotland which can be seen on Marine Scotland's website
In Wikidata the position is quite different with only a few wrecks being logged. The information for the image below was dervied from running the following queries in Wikidata : https://w.wiki/nDp and https://w.wiki/nDt
The project started by research various website to obtain the raw data required. Maps with shipwrecks plotted were found but finding the underlying data source was not so easy.
Data on Marine Scotland, Aberdeenshire Council's website and on Canmore's website were considered.
Once data was found, the next stage was finding out the licencing rights and whether or not the data could be uplifted. The data found on Canmore's website indicated that it was Open Government Licence hence could be uploaded to Wikidata. This is the data source which was then used on day two of the project.
A training session on how to use Wikidata was also required on day one to allow the team to understand how to upload the data to Wikidata and how the identifiers etc worked.
Deciding on the identifiers to use in Wikidata was the starting point, then the data had to be cleaned and manipulated. This involved translating Easting and Northings coordinates to latitude and longitude, matching the ship types between the Canmore file and Wikidata, extracting the reference to the ship from Canmore's URL and general overall common sense review of the data. To aid with this work a Python script was created.
A separate Python statement was then created to upload the information to Wikidata using quickstatements batch upload.