Skip to content

SPARQLing Scottish history

Aspects of Scottish history and culture using Wikidata and SPARQL

  • Home
  • Topical Query Resources

Tag: map

Capital punishment

Capital punishment
Adjusting the Wikidata records for those executed after the 1820 Radical War led me to a broader query on the grim topic of people in Scotland who were subjected to judicial killing. Here is a map Read more
adminAuthor admin Posted on 20 June 2024 Category ScottishHistory Tags Wikidata map

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

Industrial past

Industrial past
From the 1750s until around 40 years ago, Scotland was marked by clusters of iron, steel and manufacturing heavy industries. Little remains. Attempting to map these using Wikidata and SPARQL shows Read more
adminAuthor admin Posted on 13 March 2024 Category ScottishHistory Tags SPARQL Wikidata map DataProblems

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

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

Mapping Scotland's hospitals

Mapping Scotland's hospitals
Seeking to create a view of hospitals across Scotland I found Wikidata a wee bit under-developed, with some but not all NHS Boards having hospitals associated, some but not all summarising their area Read more
adminAuthor admin Posted on 12 February 2024 Category ScottishInfrastructure Tags SPARQL Wikidata Civics map

Camping coaches at Scottish railway stations

Camping coaches at Scottish railway stations
From the 1930s until the 1960s, old railway coaches were used to provide camping accommodation at various stations around the country. Unfortunately, this is not queryable as a Wikidata Read more
adminAuthor admin Posted on 02 January 2024 Category ScottishHistory Tags ScottishHistory SPARQL map

Monumental street furniture

Monumental street furniture
A work-in-progress is to develop the data on fountains and monuments in Scottish towns. Often, one finds that photos exist in Commons but have not been linked to the Wikidata item which is based on Read more
adminAuthor admin Posted on 18 December 2023 Category ScottishHistory Tags Wikidata SPARQL Civics map

Fires and other disasters in Glasgow

Fires and other disasters in Glasgow
After reading about the Cheapside Street fire and thinking about other serious fires in Glasgow's history , I put together a Wikidata SPARQL / Openstreetmap query on fires, explosions and other Read more
adminAuthor admin Posted on 17 December 2023 Category ScottishHistory Tags Wikidata SPARQL map Glasgow Events

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