Wednesday 30 September 2020

 Querey

SELECT ?image 

WITH

{

  SELECT ?item

  WHERE

  {

    SERVICE <https://query.wikidata.org/sparql>

    {

      ?item wdt:P39 wd:Q11696 .  # position held: President of the United States

    }

  } 

} AS %get_items

WHERE

{

  INCLUDE %get_items

  ?image wdt:P180 ?item .

  FILTER NOT EXISTS { ?image rdfs:label ?label. FILTER (LANG(?label) = "ml") }

}

Wednesday 23 September 2020

Constructive feedback

 














Sunday 20 September 2020

Map of railway stations

 https://query.wikidata.org/#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fcd%22%2C%22%3Fl%22%2C%22%3Frgb%22%5D%7D%0ASELECT%20DISTINCT%20%3Fcd%20%3Fl%20%3Fi%20%3FiLabel%20%3Fct%20%3FctLabel%20%3Frgb%20WITH%7BSELECT%20%3Fi%20%3Fcd%20%3Flat1%20%3Flon1%20%3Floc%28sample%28%3Fop%29as%3Fop%29WHERE%7BVALUES%20%3Fc1%7Bwd%3AQ878%7D%3Fi%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ55488%3Bwdt%3AP625%20%3Fcd%3Bwdt%3AP17%20%3Fc1%3Bp%3AP625%2Fpsv%3AP625%20%3Fy.%3Fy%20wikibase%3AgeoLatitude%20%3Flat1%3Bwikibase%3AgeoLongitude%20%3Flon1.OPTIONAL%7B%3Fi%20wdt%3AP131%20%3Floc%7DOPTIONAL%7B%3Fi%20wdt%3AP137%20%3Fop%7D%7DGROUP%20BY%20%3Fi%20%3Fcd%20%3Flat1%20%3Flon1%20%3Floc%7DAS%25s%0AWITH%7BSELECT%20%3Fl%20%3Fct%20%3Fo%20%3Ft%20WHERE%7BINCLUDE%20%25s.%3Fi%20p%3AP197%20%3Fnss.%3Fnss%20ps%3AP197%20%3Fns.%3Fns%20p%3AP625%2Fpsv%3AP625%20%3Fz.%3Fz%20wikibase%3AgeoLatitude%20%3Flat2%3Bwikibase%3AgeoLongitude%20%3Flon2.OPTIONAL%7B%3Fnss%20pq%3AP81%20%3Fct.OPTIONAL%7B%3Fct%20wdt%3AP127%20%3Fo%7D%7DOPTIONAL%7B%3Fnss%20pq%3AP5051%20%3Ft%7DFILTER%28STR%28%3Fi%29%3C%20STR%28%3Fns%29%29.BIND%28CONCAT%28%27LINESTRING%28%27%2CSTR%28%3Flon1%29%2C%27%20%27%2CSTR%28%3Flat1%29%2C%27%2C%27%2CSTR%28%3Flon2%29%2C%27%20%27%2CSTR%28%3Flat2%29%2C%27%29%27%29AS%3Fstr%29.BIND%28STRDT%28%3Fstr%2Cgeo%3AwktLiteral%29AS%3Fl%29%7D%7DAS%25l%0AWHERE%7B%7BINCLUDE%25s%7DUNION%7BINCLUDE%25l%7D.BIND%28IF%28BOUND%28%3Fl%29%2CIF%28BOUND%28%3Fct%29%2CIF%28BOUND%28%3Ft%29%2CIF%28BOUND%28%3Fo%29%2C%2200f%22%2C%224682b4%22%29%2C%2240e0d0%22%29%2C%220f0%22%29%2CIF%28BOUND%28%3Floc%29%2CIF%28BOUND%28%3Fop%29%2C%2200f%22%2C%224682b4%22%29%2C%2240e0d0%22%29%29AS%3Frgb%29SERVICE%20wikibase%3Alabel%7Bbd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cja%22.%7D%7D%23%20%0A

Sunday 13 September 2020

Starting with one "Word" Find in different items in wiki

 https://w.wiki/c24