query-8c00675f7d9d1b8a05e6f9367fc41abf

rq turtle/ttl

Human settlement and HASC. Like (P8119)HASC I want every human settlement in a country and the --> DE.SN.MT(Q70946)Dorfchemnitz near Sayda --> DE.RP.TI (the town Trier)(Q3138)Trier --> DE.RP.TI (part of town Trier)(Q885323)Olewig --> DE.SN.SS (part of town Freital)(Q6366)Pesterwitz (P439)German municipality key I try different ways, but I get every time a timeout. And I never get all in one query. For example this was the test for Germany to get all settlements over the

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Table;Map
SELECT  ?item ?itemLabel ?hasc
WHERE
{
  ?item wdt:P439 ?ags.  # hat amtlichen Gemeindekennschlüssel
  ?item wdt:P131 ?subregion.
  ?subregion wdt:P8119 ?hasc .         # hasc
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?ags") v4("?hasc"):::projected v1("?item"):::projected v3("?subregion") c5(["bd:serviceParam"]):::iri c7(["#91;AUTO_LANGUAGE#93;,en,de"]):::literal v1 --"wdt:P439"--> v2 v1 --"wdt:P131"--> v3 v3 --"wdt:P8119"--> v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end