query-f16f5a90c0cd3a39b3bd8c44d2f35d35

rq turtle/ttl

Geocoord

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#fehlende HOVs (Ortsteile) mit Geokoordinate
#defaultView:Map
SELECT ?item ?itemLabel ?what ?whatLabel ?coord ?hov
WHERE 
{
  optional {
    ?item wdt:P7046 ?hov.
  }
  ?item wdt:P31 wd:Q253019;
           p:P625 [
           psv:P625 [
             wikibase:geoLatitude ?lat ;
             wikibase:geoLongitude ?lon ;
           ] ;
           ps:P625 ?coord;
         ]
  FILTER( ?lon >=11.9 && ?lon <= 15.1 && ?lat >= 50.18 && ?lat <= 51.67 )
  MINUS {
    ?item wdt:P7046 []
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?coord"):::projected v4("?hov"):::projected v3("?item"):::projected v2("?lat") v1("?lon") a3((" ")) a2((" ")) a1((" ")) c14(["bd:serviceParam"]):::iri c7(["wd:Q253019"]):::iri c16(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["?lon >= '11.9^^xsd:decimal'?lon <= '15.1^^xsd:decimal'?lat >= '50.18^^xsd:decimal'?lat <= '51.67^^xsd:decimal'"]] f0 --> v1 f0 --> v2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P7046".-> v4 end v3 --"p:direct/P31"--> c7 a1 --"wikibase:geoLatitude"--> v2 a1 --"wikibase:geoLongitude"--> v1 a2 --"p:statement/value/P625"--> a1 a2 --"p:statement/P625"--> v5 v3 --"p:P625"--> a2 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v3 --"p:direct/P7046"--> a3 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c14 --"wikibase:language"--> c16 end