User:Jacksonj04/sandbox/countries/Ireland/Cities/cities outline data

List of Cities

Manually update list

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT ?item ?headofgov (GROUP_CONCAT(?headofgovinstanceof; SEPARATOR = "<br />") AS ?hoginstancelist) ?council ?member (GROUP_CONCAT(?memberinstanceof; SEPARATOR = "<br />") AS ?memberinstancelist) ?numberconstituencies (COUNT(?constituency) AS ?countconstituencies) (GROUP_CONCAT(?constituencyLab; SEPARATOR = "<br />") AS ?constituencyList) ?constype WHERE { ?item wdt:P31/wdt:P279* wd:Q515 . ?item wdt:P17 wd:Q27 . MINUS {?item wdt:P31/wdt:P279* wd:Q10864048 } MINUS {?item p:P31 ?node . ?node ps:P31 ?citytypes ; pq:P582 []} ?item wdt:P1082 ?population . FILTER (?population > 500000) . OPTIONAL {?item wdt:P1313 ?headofgov . ?headofgov wdt:P31 ?headofgovinstanceof MINUS { ?headofgov wdt:P576 [] } } OPTIONAL {?item wdt:P194 ?council OPTIONAL { ?council wdt:P4253 ?numberconstituencies } OPTIONAL {?member wdt:P361 ?council . ?member wdt:P279 wd:Q4175034 . ?member wdt:P31 ?memberinstanceof MINUS {?member wdt:P576 [] } } OPTIONAL { ?statement ps:P279 wd:Q192611 ; pq:P642 ?council. ?constype p:P279 ?statement . ?constituency wdt:P31/wdt:P279* ?constype ; rdfs:label ?constituencyLab . FILTER(lang(?constituencyLab) = 'en') MINUS { ?constituency wdt:P576 [] } } MINUS { ?council wdt:P576 [] } } MINUS { ?item wdt:P576 [] } MINUS { ?item wdt:P31/wdt:P279* wd:Q10864048 } } GROUP BY ?item ?headofgov ?headofgovinstanceof ?council ?member ?memberinstanceof ?numberconstituencies ?constype ORDER BY ?item ?constituency

End of automatically generated list.