query-52fc7e03830668410e839de66def6f37
06:58, 11 June 2020 (UTC)) talk (Herzi Pinkiany idea? --07:08, 11 June 2020 (UTC)) talk (SCIdude. --WDumper there are >8 million P625 claims in WD. This is beyond the WDQS capabilities. You need to work with a full WD dump yourself or use Wikidata:Database_reports/List_of_properties/Top100According to
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?globeLabel ?lon
WHERE
{
{
SELECT ?stv ?lon
{
?stv wikibase:geoLongitude ?lon .
FILTER ( abs (?lon) > 180 )
}
limit 10000
}
?item p:P625 [ psv:P625 ?stv ] .
?stv wikibase:geoGlobe ?globe
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;
v4("?globe")
v3("?item"):::projected
v1("?lon"):::projected
v2("?stv")
a1((" "))
c7(["bd:serviceParam"]):::iri
c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["numeric-abs(?lon) > '180^^xsd:integer'"]]
f0 --> v1
v2 --"wikibase:geoLongitude"--> v1
a1 --"p:statement/value/P625"--> v2
v3 --"p:P625"--> a1
v2 --"wikibase:geoGlobe"--> v4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end