query-e285691ddd0c00bfb12535c661012cdd

rq turtle/ttl

مجمعة لكل بلدية على محور ي، أبجديا grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically seskupené podle obcí na ose x, abecedně grouped per municipality on x-axis, alphabetically gruppiert nach Gemeinde auf der x-Achse, geordnet nach Namen grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically groupées alphabétiquement par ville, sur les abscisses grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically raggruppati per comune sulle ascisse, in ordine alfabetico grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically gegroepeerd per gemeente op x-as, alfabetisch grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically grupperade efter kommun i en x-axel, alfabetiskt grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically згруповані за муніципалітетами по осі x в алфавітному порядку grouped per municipality on x-axis, alphabetically grouped per municipality on x-axis, alphabetically

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geof: <http://www.opengis.net/def/function/geosparql/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:ScatterChart
PREFIX var_muntype: <http://www.wikidata.org/entity/Q15284>
PREFIX var_area: <http://www.wikidata.org/entity/Q6308>
SELECT ?from (?distGrp1 AS ?kilometers) ?to WHERE {
  { SELECT ?mun (SAMPLE(?loc) AS ?loc)
    WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
                 wdt:P131 var_area:;
                 wdt:P625 ?loc. }
    GROUP BY ?mun
  }
  OPTIONAL {
    { SELECT (?mun AS ?mun2) (SAMPLE(?loc) AS ?loc2)
      WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
                   wdt:P131 var_area:;
                   wdt:P625 ?loc. }
      GROUP BY ?mun
    }
  }
  BIND(geof:distance(?loc, ?loc2) AS ?distNum).
  BIND(STR(ROUND(?distNum)) AS ?distGrp0).
  BIND(CONCAT(SUBSTR("000",STRLEN(?distGrp0)+1),?distGrp0,".",STR(ROUND((?distNum-FLOOR(?distNum))*10))," km") AS ?distGrp1).

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en".
    ?mun rdfs:label ?from.
    ?mun2 rdfs:label ?to.
  }
}
ORDER BY ?from ?kilometers

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?distGrp0") v9("?distGrp1"):::projected v7("?distNum") v1("?from"):::projected v11("?kilometers") v5("?loc") v6("?loc2") v3("?mun") v5("?mun2") v10("?to"):::projected a1((" ")) a2((" ")) c5([http://www.wikidata.org/entity/Q6308]):::iri c8(["bd:serviceParam"]):::iri c3([http://www.wikidata.org/entity/Q15284]):::iri c10(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal v3 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c3 v3 --"wdt:P131"--> c5 v3 --"wdt:P625"--> v5 bind1[/"sample(?loc)"/] v5 --o bind1 bind1 --as--o v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P31".-> a2 a2 --"wdt:P279"--> c3 v3 --"wdt:P131"--> c5 v3 --"wdt:P625"--> v5 bind3[/"?mun"/] v3 --o bind3 bind3 --as--o v5 bind4[/"sample(?loc)"/] v5 --o bind4 bind4 --as--o v6 end bind5[/"http://www.opengis.net/def/function/geosparql/distance(?loc,?loc2)"/] v5 --o bind5 v6 --o bind5 bind5 --as--o v7 bind6[/"str(numeric-round(?distNum))"/] v7 --o bind6 bind6 --as--o v8 bind7[/"concat(substring('000',string-length(?distGrp0) + '+1^^xsd:integer'),?distGrp0,'.',str(numeric-round(?distNum - numeric-floor(?distNum) * '10^^xsd:integer')),' km')"/] v8 --o bind7 v7 --o bind7 bind7 --as--o v9 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 v3 --"rdfs:label"--> v1 v5 --"rdfs:label"--> v10 end bind8[/"?distGrp1"/] v9 --o bind8 bind8 --as--o v11