query-67214f113b7e803d96b37ae293f4b462

rq turtle/ttl

Bathing water near me that is connected to Badkartan(P9615)Badkartan.se ID has reviews of the bath places = badkartan.se

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#>
#defaultView:Map
#title: Badplatser nära dig enligt Wikidata med recensioner hos badkartan
SELECT ?bath ?bathLabel ?location ?avst ?img ?badkartan WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en,de". }
  SERVICE wikibase:around {
    ?bath wdt:P625 ?location.
    bd:serviceParam wikibase:center "[AUTO_COORDINATES]".
    bd:serviceParam wikibase:radius "30".
    bd:serviceParam wikibase:distance ?dist.
  }
  ?bath  wdt:P6104/wdt:P361* wd:Q107096245.
  OPTIONAL{?bath  wdt:P18 ?img}
  {?bath  wdt:P9615 ?badkartanid}
  OPTIONAL {?bath  wdt:P856 ?URL}
  BIND(URI(CONCAT("https://www.badkartan.se/",?badkartanid)) AS ?badkartan)
  BIND (CONCAT("Distance (km) ",str(?dist)) AS ?avst)}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?URL") v8("?avst"):::projected v7("?badkartan"):::projected v5("?badkartanid") v1("?bath"):::projected v3("?dist") v4("?img"):::projected v2("?location"):::projected a1((" ")) c4(["sv,en,de"]):::literal c2(["bd:serviceParam"]):::iri c8(["#91;AUTO_COORDINATES#93;"]):::literal c10(["30"]):::literal c14(["wd:Q107096245"]):::iri subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c2 --"wikibase:language"--> c4 end subgraph s2["http://wikiba.se/ontology#around"] style s2 stroke-width:4px; v1 --"wdt:P625"--> v2 c2 --"wikibase:center"--> c8 c2 --"wikibase:radius"--> c10 c2 --"wikibase:distance"--> v3 end v1 --"wdt:P6104"--> a1 a1 --"wdt:P361"--> c14 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P18".-> v4 end v1 --"wdt:P9615"--> v5 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P856".-> v6 end bind0[/"concat('https://www.badkartan.se/',?badkartanid)"/] v5 --o bind0 bind0 --as--o v7 bind1[/"concat('Distance (km) ',str(?dist))"/] v3 --o bind1 bind1 --as--o v8