query-ba0e7aa873b6492168a0f4577c6ba363

rq turtle/ttl

Propertiesinstance of (P31)area (P2046)German district key (P440)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?land (avg(?flaeche) as ?avgflaeche) 
WHERE 
{
  ?kreis wdt:P31 wd:Q106658.
  ?kreis wdt:P2046 ?flaeche.
  ?kreis wdt:P440 ?kreisschl.
  BIND(SUBSTR(?kreisschl, 1, 2) AS ?land)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de" }
 }
GROUP BY ?land
ORDER BY ?land

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?avgflaeche") v3("?flaeche"):::projected v2("?kreis") v4("?kreisschl") v5("?land"):::projected c2(["wd:Q106658"]):::iri c8(["de"]):::literal c6(["bd:serviceParam"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P2046"--> v3 v2 --"wdt:P440"--> v4 bind0[/"substring(?kreisschl,'1^^xsd:integer','2^^xsd:integer')"/] v4 --o bind0 bind0 --as--o v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end bind2[/"average(?flaeche)"/] v3 --o bind2 bind2 --as--o v5