query-2a8add10c1c77401d2cff3bf297e638f

rq turtle/ttl

Bauwerke-Typen in Dresden (Bubble Chart)

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#>
#-------------------------------------------------------------------------------
# Bauwerke-Typen in Dresden (Bubble Chart)
#-------------------------------------------------------------------------------
#defaultView:BubbleChart; Table; 
select ?bautyp ?bautypLabel  (COUNT(?bautyp) AS ?anzahl)
where {

      SELECT distinct ?item ?itemLabel ?bautyp ?bautypLabel 
                        WHERE {
                          ?item wdt:P31 ?bautyp.
                          ?item (wdt:P131/wdt:P279*) wd:Q1731 .
                          ?item (wdt:P31/wdt:P279*) wd:Q811979.

                          SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en,[AUTO_LANGUAGE]". }
                        } 
}
group by ?bautyp ?bautypLabel

order by desc(?anzahl)
#order by  ?bautypLabel ?item
limit 50

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?anzahl") v3("?bautyp"):::projected v2("?item") a1((" ")) a2((" ")) c7(["bd:serviceParam"]):::iri c5(["wd:Q811979"]):::iri c4(["wd:Q1731"]):::iri c9(["de,en,#91;AUTO_LANGUAGE#93;"]):::literal v2 --"wdt:P31"--> v3 v2 --"wdt:P131"--> a1 a1 --"wdt:P279"--> c4 v2 --"wdt:P31"--> a2 a2 --"wdt:P279"--> c5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end bind1[/"count(?bautyp)"/] v3 --o bind1 bind1 --as--o v4