Skip to content

SPARQLing Scottish history

Aspects of Scottish history and culture using Wikidata and SPARQL

  • Home
  • Topical Query Resources

Type: Post

Industrial past

Seeking the extent to which Wikidata holds location traces of industrial locations (factories, mills, energy centres, distribution points), while trying to separate slightly from the HES Listed Read more
adminAuthor admin Posted on 28 May 2024 Category ScottishHistory Tags SPARQL

Rail disasters

The Wikipedia article about Wormit station mentioned a rail crash there in 1955. I looked at other crash articles and their corresponding Wikidata items to obtain the data items appropriate for one Read more
adminAuthor admin Posted on 08 April 2024 Category ScottishHistory Tags Events ScottishHistory Wikidata SPARQL

Sundials

There is a Wikipedia page here which indicates that sundials in Scotland had features distinct from those elsewhere. Here is a query which maps sundials across the country. Read more
adminAuthor admin Posted on 24 March 2024 Category ScottishHistory Tags SPARQL Wikidata map

Paintings in Scottish galleries

I remembered a page I previously created on Commons, which provides a view of paintings in Scottish public galleries: link. It is based on a Wikidata SPARQL query, which ListeriaBot runs every few Read more
adminAuthor admin Posted on 19 March 2024 Category ScottishCulture Tags Wikidata Listeria

Tolbooths

Last July I looked at Tolbooths in Scottish towns, including some Wikidata adjustments to distinguish them, as the data had become fankled with Tollbooths, which are not the same thing. I posted this Read more
adminAuthor admin Posted on 03 March 2024 Category ScottishInfrastructure Tags Wikidata ScottishHistory Civics map

Road and railway bridges

A SPARQL query to map category A & B listed road and rail bridges in Scotland: SELECT DISTINCT (?showLabel as ?layer) ?loc ?pic ?picLabel ?picURI ?herlistLabel ?cooncilLabel WHERE { SERVICE Read more
adminAuthor admin Posted on 17 February 2024 Category ScottishInfrastructure Tags SPARQL Wikidata ScottishHistory Civics map

Querying Scottish Government data

Although the focus here is on using Wikidata to visualise / understand aspects of the historical cultural environment in Scotland, this also leads into side-exploration of other data /visualisations Read more
adminAuthor admin Posted on 14 February 2024 Category ScottishInfrastructure Tags SPARQL

Looking for Scotland

Querying Wikidata on Scottish topics can be awkward, because it tends not to be represented as a Country / sovereign state (wdt:P17) in item properties but more often (at best) as an administrative Read more
adminAuthor admin Posted on 07 January 2024 Category SPARQL Tags SPARQL Wikidata DataProblems
« Page 4 of 4

About

This blog provides Wikidata and SPARQL views of aspects of Scottish history and culture. These have usually been previously posted to Mastodon (through which comments are welcome).
RSS notification of new posts is available using https://allyd.co.uk/scotdata/feed/rss

Recent posts

  • Tracing epidemics
  • Memory loss
  • Detriment to the built environment
  • Neeps and tatties
  • Disentangle and expand

Archives

  • ▼ 2026 (5)
    • April (2)
    • March (1)
    • January (2)
  • ► 2025 (17)
    • December (1)
    • October (1)
    • September (2)
    • August (2)
    • July (1)
    • June (2)
    • May (2)
    • April (2)
    • March (1)
    • February (2)
    • January (1)
  • ► 2024 (34)
    • December (1)
    • November (5)
    • October (1)
    • September (3)
    • August (1)
    • July (2)
    • June (2)
    • May (2)
    • April (2)
    • March (5)
    • February (6)
    • January (4)
  • ► 2023 (6)
    • December (6)

Categories

  • Fediverse
  • ScottishCulture
  • ScottishHistory
  • ScottishInfrastructure
  • SPARQL
  • Uncategorized
  • Visualisation

Tags

Archiving bot Botsinspace C18 chartscss Civics DataProblems Desktop migration energy-charts Events fediverse food Gaidhlig Glasgow Language Leaflet Listeria map Mastodon migration newspapers OpenStreetMap Petscan Quickstatements ScottishHistory societies SPARQL Wikidata WikimediaCommons Wikipedia
  • Home
  • Topical Query Resources
  • Twitter
SPARQLing Scottish history CC by NC No AI bots - respect robots.txt Powered by HTMLy