Create a Wikidata Query using SPARQL- example using Shipwrecks data

Create a query in Wikidata to extract data- a follow along example. Here, the data of where ships are considered to have been wrecked off the coast of Scotland, UK has been used. Wikidata query created in the video can be found at https://w.wiki/4oVa.

In separate videos I have shown how the data can be brought into:
- Power BI for plotting on an esri map -    • Bring Wikidata into Power BI using a ...  
- R Shiny app for plotting on a OpenStreet map using leaflet -    • Map Wikidata in an R Shiny App using ...  

Timings:
00:00 Introduction
00:50 In Wikidata look at example of a ship wreck record
03:00 Go to Wikidata Query Service
03:30 Using SPARQL to create the query
05:20 Create instances of shipwreck
07:25 Create list of coordinates
09:40 Filter query to only ships mentioned on Canmore
11:30 Add ship name to query
14:00 Remove the limit
14:30 View results of query on a map
15:10 Return to table view
15:20 Options for exporting the data

The Canmore website mentioned in this video is part of Historic Environment Scotland - https://canmore.org.uk/

If you have used Wikidata location data in a project, I would be keen to hear in the comments below what you have used the data for.

The query in the video formed the basis of creating the R Script for this project https://community.powerbi.com/t5/R-Sc... in Microsoft's Power BI community.

#wikidata #wikidataquery #opendata #SPARQL #data