Project:SPARQL/admin: Difference between revisions

Project:SPARQL/admin (view source)

1,207 bytes added , 4 months ago

726

edits

@@ Line 356: / Line 356: @@
 ORDER BY ?itemLabel ?item
+</sparql>
+=== Localities in the UK that are in more than one P33 admin territory ===
+<sparql tryit="1">
+#title:UK localities in multiple P33 admin territories
+PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
+PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
+PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/>
+PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/>
+PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/>
+PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/>
+PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/>
+select ?item ?itemLabel  (count (distinct ?admin) as ?count)
+where {
+  values ?region { bnwd:Q1231 bnwd:Q67 bnwd:Q75 bnwd:Q200 bnwd:Q1202 bnwd:Q85 bnwd:Q204 bnwd:Q1215 bnwd:Q72 bnwd:Q425 bnwd:Q1224 bnwd:Q1740 }
+   # english regions; wales q425; scotland q1224; n.ire q1740
+  ?item bnwdt:P12 bnwd:Q2147 . # i/o locality
+  ?item bnwdt:P33* ?region. # in ?region
+  ?item bnwdt:P33 ?admin . # parent p33
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+group by ?item ?itemLabel
+having (?count>1)
+order by ?itemLabel
 </sparql>