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 upload of Canmore/HES records.
SELECT DISTINCT (?showLabel as ?layer) ?loc ?pic ?picLabel ?picURI ?picbyLabel ?genreLabel ?manufacturerLabel ?cooncilLabel WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
VALUES ?itemtypes {
wd:Q860861
wd:Q179700
wd:Q4989906
wd:Q483453
wd:Q1630622
wd:Q1759852
wd:Q557141
wd:Q427926
}
?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.}.
OPTIONAL { ?pic wdt:P136 ?genre. }.
OPTIONAL { ?pic wdt:P170 ?picCreatedBy. }.
OPTIONAL { ?pic wdt:P287 ?picDesignedBy. }.
OPTIONAL { ?pic wdt:P176 ?manufacturer. }.
BIND (IF (BOUND(?picCreatedBy), ?picCreatedBy, IF (BOUND(?picDesignedBy), ?picDesignedBy,"No producer details")) AS ?picby).
BIND (IF (BOUND(?picURI), ?itypeLabel, CONCAT ("Unimaged ", ?itypeLabel)) AS ?showLabel).
} LIMIT 1300
