Skip to content

SPARQLing Scottish history

Aspects of Scottish history and culture using Wikidata and SPARQL

  • Home
  • Topical Query Resources

Tag: Civics

Memory loss

A recent International Journal of Digital Curation article discussed the longer term threats to archives, not least what happens to an asset created under project funding? For digital as for physical Read more
adminAuthor admin Posted on 10 April 2026 Category ScottishHistory Tags Archiving Civics

Disentangle and expand

Disentangle and expand
Yesterday I spent some time distinguishing and expanding Wikidata on the various magazines named Edinburgh Review published over the past 280 years. There had been one portmanteau item but with a Read more
adminAuthor admin Posted on 04 January 2026 Category ScottishCulture Tags Civics

Pub crawl

Pub crawl
Seeing in the Wikidata update that CAMRA Pub IDs had now been loaded as an identifier, I queried for those with the ID in Scotland. It is quite a detailed map, with colour-coding often designating Read more
adminAuthor admin Posted on 09 May 2025 Category ScottishInfrastructure Tags Civics

Postwar rail network contraction

Today was the first actual return from the Bot program which seeks to present On this Day information on the closures of Scottish railway stations. The first former station was Alyth Junction between Read more
adminAuthor admin Posted on 04 September 2024 Category ScottishInfrastructure Tags Wikidata Civics

Postwar rail network contraction

Creating an on-this-day Mastodon post to highlight the loss of an area service (usually associated with the Beeching cuts) has needed additional activity to extract information held in Wikipedia and Read more
adminAuthor admin Posted on 18 July 2024 Category ScottishInfrastructure Tags Wikidata Civics

Theatre groups and people

Theatre groups and people
Attempting to diagram theatre groups, with their founders and associated people where these can be identified. Still a work-in-progress. It may be that once more data are populated, this view becomes Read more
adminAuthor admin Posted on 08 May 2024 Category ScottishCulture Tags SPARQL Civics

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

Co-operative societies

Co-operative societies
Attempting to visualise how Co-operative Societies spread then consolidated through the 19th and 20th centuries was only partially successful. The data available were rather lacking. For example, Read more
adminAuthor admin Posted on 27 February 2024 Category ScottishHistory Tags SPARQL Wikidata Wikipedia Civics

Observatories

Observatories
Another visualisation using Wikidata to show aspects of Scottish Culture. This map highlights the various Observatory buildings around Scotland. Query Read more
adminAuthor admin Posted on 19 February 2024 Category ScottishHistory Tags SPARQL Wikidata 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
Page 1 of 2 ยป

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