Skip to content

SPARQLing Scottish history

Aspects of Scottish history and culture using Wikidata and SPARQL

  • Home
  • Topical Query Resources

Category: ScottishInfrastructure

Articles on data views of present-day services in Scotland

Detriment to the built environment

After noting the Union Street fire in Wikidata, I revisited the previous query on disasters in the Glasgow area. It is now capturing more of the disastrous fires on the 1960s. A potential extension Read more
adminAuthor admin Posted on 10 March 2026 Category ScottishInfrastructure Tags Wikidata

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

Beeching and South Lanarkshire

Beeching and South Lanarkshire
Seeing in this OTD post the range of stations in South Lanarkshire which were closed on 4 January 1965, it was striking how much impact this must have made on the isolation of these communities. Read more
adminAuthor admin Posted on 05 January 2025 Category ScottishInfrastructure Tags Leaflet OpenStreetMap

Hydro-electric and wind power stations

Hydro-electric and wind power stations
I began looking at the Wikidata information on hydro-electric power stations, whose development was a feature of 20th century Scotland. Some of the date information is scant, and some is Read more
adminAuthor admin Posted on 25 September 2024 Category ScottishInfrastructure Tags Wikidata SPARQL energy-charts OpenStreetMap

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

Distilleries

After looking at a couple of Articles for Deletion on Wikipedia, I began looking at the information on Wikidata about distilleries, bonded warehouses, etc., and generated a map. Then I began to Read more
adminAuthor admin Posted on 20 July 2024 Category ScottishInfrastructure Tags Wikidata Quickstatements

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

Civic manufactures

In the 19th century several Scottish iron foundries became well-known for producing standardised objects, particularly civic fountains and bandstands. This Wikimedia Commons page utilises Listeria Read more
adminAuthor admin Posted on 25 June 2024 Category ScottishInfrastructure 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
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