Tagishsimon added a comment.

  Per Laske, SPARQL for this issue in Germany 
[https://www.wikidata.org/wiki/Wikidata:Contact_the_development_team#Surplus_of_coordinates_-_T198078]
  
  SELECT ?item ?itemLabel ?stat ?lat ?long WITH {
  SELECT ?item ?stat (COUNT(?lat)+COUNT(?long) AS ?count) WHERE {
  VALUES ?countries { wd:Q183 }
  ?item wdt:P17 ?countries;
  
    p:P625 ?stat. ?stat psv:P625  [wikibase:geoLatitude ?lat ; 
wikibase:geoLongitude ?long ]  . 
  
  }
  GROUP BY ?item ?stat
  HAVING(?count>2)
  } AS %i WHERE {
  
    include %i
    ?stat psv:P625 [ wikibase:geoLatitude ?lat; wikibase:geoLongitude ?long ] .
    SERVICE wikibase:label { bd:serviceParam wikibase:language 
"[AUTO_LANGUAGE],en". }
  
  }
  ORDER BY ?item

TASK DETAIL
  https://phabricator.wikimedia.org/T198078

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Smalyshev, Tagishsimon
Cc: Tagishsimon, Pasleim, Smalyshev, Lucas_Werkmeister_WMDE, Nikki, 
darthmon_wmde, ET4Eva, DannyS712, Nandana, Lahi, Gq86, Darkminds3113, 
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, _jensen, 
rosalieper, Scott_WUaS, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, 
Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to