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 wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

VALUES ?itemtypes { wd:Q12280 wd:Q537127 wd:Q1210334 }

?pic wdt:P31 ?itemtypes.

?pic wdt:P131 ?cooncil.

{ ?cooncil wdt:P131 wd:Q22} UNION {?cooncil wdt:P31 wd:Q15060255.}.

?pic wdt:P625 ?loc .

?pic wdt:P31 ?itype.

?itype rdfs:label ?itypeLabel.

FILTER(LANG(?itypeLabel) = "en").

FILTER (?itype = ?itemtypes).

OPTIONAL {?pic wdt:P18 ?picURI.}.

?pic wdt:P1435 ?herlist.

FILTER (?herlist != wd:Q10729142).

BIND (IF (BOUND(?picURI), ?itypeLabel, CONCAT ("Unimaged ", ?itypeLabel)) AS ?showLabel).

} LIMIT 2000

While the filtered mapping might be useful to identify unphotographed bridges, the map overall is too crowded to be particularly useful.


Author: admin

Mastodon account where these were first posted: link