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
Tag: SPARQL
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
Mechanics Institutes
As an experiment on whether affinity networks and inspirations can be explored using Wikidata, I created a small query capturing people and publications around the coming together of mechanics' Read more
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
The web page linked from the headline provides a view of the main populated places in a Council area, with the facility to obtain a list or a map of the Category A listed buildings in that area. Each Read more
Mushrooming: Points and networks
“… try to think your way into the main part of a fungus, the mycelium, a proliferating network of tiny white threads known as hyphae. Decentralised, inquisitive, exploratory and voracious, a mycelial network ranges through soil in search of food. It tangles itself in an intimate scrawl with the roots of plants, exchanging nutrients and sugars with them; it meets with the hyphae of other networks and has mycelial sex; messages from its myriad tips are reported rapidly across the whole network ...”The quotation is from Frances Gooding's article “From its Myriad Tips”, London Review of Books, 20 May 2021. It inspired me to prepare a Presentation pack at the time, whose text is copied here. Read more
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
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
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
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