Bristol
Bristol, City of Bristol, West of England, England, United Kingdom
category: place
—
type: city
—
OSM:
relation 5746665
Wikidata SPARQL query
SELECT ?place ?placeLabel (SAMPLE(?location) AS ?location) ?article WHERE {
SERVICE wikibase:box {
?place wdt:P625 ?location .
bd:serviceParam wikibase:cornerWest "Point(-2.7183704 51.3972838)"^^geo:wktLiteral .
bd:serviceParam wikibase:cornerEast "Point(-2.5104192 51.5444317)"^^geo:wktLiteral .
}
?article schema:about ?place .
?article schema:inLanguage "en" .
?article schema:isPartOf <https://en.wikipedia.org/> .
FILTER NOT EXISTS { ?place wdt:P31 wd:Q18340550 } . # ignore timeline article
FILTER NOT EXISTS { ?place wdt:P31 wd:Q13406463 } . # ignore list article
FILTER NOT EXISTS { ?place wdt:P31 wd:Q17362920 } . # ignore Wikimedia duplicated page
FILTER NOT EXISTS { ?place wdt:P31/wdt:P279* wd:Q192611 } . # ignore constituency
FILTER NOT EXISTS { ?place wdt:P31 wd:Q811683 } . # ignore proposed building or structure
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
GROUP BY ?place ?placeLabel ?article