query-70c4d9c345b32fed6bee82214de538fc

rq turtle/ttl

title: Coords by precision SELECT ?item ?itemLabel ?coord ?lon ?lat ?precision WHERE { ?item wdt:P131/wdt:P279 wd:Q1741. # in the administrative territory of Wien ?item wdt:P31/wdt:P279 wd:Q41176. # gebäude ?item p:P625 ?coordinate. ?coordinate ps:P625 ?coord. ?coordinate psv:P625 ?coordinate_node. ?coordinate_node wikibase:geoLongitude ?lon. ?coordinate_node wikibase:geoLatitude ?lat.
?coordinate_node wikibase:geoPrecision ?precision.
FILTER(?precision != 1.0E-8) . FILTER(?precision != 1.0E-7) . FILTER(?precision != 1.0E-6) . FILTER(?precision != 1.0E-5) . FILTER(?precision != 1.0E-4) . SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en". } } ORDER BY ASC(?precision) LIMIT 10000

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#>
#title: Coords by precision
SELECT ?item ?itemLabel ?coord ?lon ?lat ?precision
WHERE
{
 ?item wdt:P131/wdt:P279* wd:Q1741.   # in the administrative territory of Wien
 ?item          wdt:P31/wdt:P279*           wd:Q41176.    # gebäude
 ?item p:P625 ?coordinate.
 ?coordinate ps:P625 ?coord.
 ?coordinate psv:P625 ?coordinate_node.
 ?coordinate_node wikibase:geoLongitude ?lon.
 ?coordinate_node wikibase:geoLatitude ?lat.  
 ?coordinate_node wikibase:geoPrecision ?precision.  
  FILTER(?precision != 1.0E-8) .
  FILTER(?precision != 1.0E-7) .
  FILTER(?precision != 1.0E-6) .
  FILTER(?precision != 1.0E-5) .
  FILTER(?precision != 1.0E-4) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en". }
}
ORDER BY ASC(?precision)
LIMIT 10000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?coord"):::projected v3("?coordinate") v5("?coordinate_node") v2("?item"):::projected v7("?lat"):::projected v6("?lon"):::projected v1("?precision"):::projected a1((" ")) a2((" ")) c10(["wd:Q41176"]):::iri c18(["bd:serviceParam"]):::iri c20(["de,en"]):::literal c8(["wd:Q1741"]):::iri f0[["?precision != '1.0E-4^^xsd:double'"]] f0 --> v1 f1[["?precision != '1.0E-5^^xsd:double'"]] f1 --> v1 f2[["?precision != '1.0E-6^^xsd:double'"]] f2 --> v1 f3[["?precision != '1.0E-7^^xsd:double'"]] f3 --> v1 f4[["?precision != '1.0E-8^^xsd:double'"]] f4 --> v1 v2 --"p:direct/P131"--> a1 a1 --"p:direct/P279"--> c8 v2 --"p:direct/P31"--> a2 a2 --"p:direct/P279"--> c10 v2 --"p:P625"--> v3 v3 --"p:statement/P625"--> v4 v3 --"p:statement/value/P625"--> v5 v5 --"wikibase:geoLongitude"--> v6 v5 --"wikibase:geoLatitude"--> v7 v5 --"wikibase:geoPrecision"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c18 --"wikibase:language"--> c20 end