Wikidata

Maxx

Joined 18 November 2012

P edit

instance of (P31) edit

Wikidata Query edit

Chybějící stromy edit 

#Chybejici stromy
SELECT ?usop ?drusop ?item ?itemLabel ?obrazek ?nic ?obecLabel ?lon ?lat ?druh ?obvod ?kod ?commons
WHERE
{
  ?item wdt:P31 wd:Q811534 .          #Památný strom
  ?item wdt:P131 ?obec . 
  ?obec wdt:P131 ?okres . 
  OPTIONAL{?item wdt:P677 ?usop . } 
  FILTER regex(?usop, "105301|105974") 
  OPTIONAL {                          #Dekódovat souřadnice
    ?item p:P625/psv:P625 ?node.
    ?node wikibase:geoLatitude ?lat.
    ?node wikibase:geoLongitude ?lon.
   }
  OPTIONAL{?item wdt:P2547 ?obvod . } 
  OPTIONAL{?item wdt:P18 ?obrazek . }
  OPTIONAL{?item wdt:P373 ?commons . }
  OPTIONAL{?item p:P31/pq:P580 ?datum . } 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs" }
}
ORDER BY DESC(?pocetDruhu)
Try it!

Památné stromy okresu ZR edit 

#Památné stromy okresu ZR
SELECT ?item ?itemLabel ?datum ?obecLabel ?lon ?lat ?usop ?obvod ?obrazek ?commons ?pocetDruhu ?druhy ?okresLabel
WHERE
{
  ?item wdt:P31 wd:Q811534 .          #Památný strom
  ?item wdt:P131 ?obec . 
  ?obec wdt:P131 ?okres . 
  ?obec wdt:P131 wd:Q579648 .         #Okres ZR
  OPTIONAL{?item wdt:P677 ?usop . } 
  OPTIONAL {                          #Dekódovat souřadnice
    ?item p:P625/psv:P625 ?node.
    ?node wikibase:geoLatitude ?lat.
    ?node wikibase:geoLongitude ?lon.
   }
  OPTIONAL{?item wdt:P2547 ?obvod . } 
  OPTIONAL{?item wdt:P18 ?obrazek . }
  OPTIONAL{?item wdt:P373 ?commons . }
  OPTIONAL{?item p:P31/pq:P580 ?datum . } 
  #Výpis druhů  
  OPTIONAL{SELECT ?item (COUNT(?druh) AS ?pocetDruhu) (GROUP_CONCAT(?druhLabel; SEPARATOR = " , ") AS ?druhy) WHERE { 
        ?item wdt:P31 ?druh .
        ?druh wdt:P31 wd:Q16521 .
      SERVICE wikibase:label {    bd:serviceParam wikibase:language "cs" . 
        ?druh rdfs:label ?druhLabel . 
        ?item rdfs:label ?itemLabel . }
    } GROUP BY ?item }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs" }
}

ORDER BY DESC(?pocetDruhu)
Try it!


Památné stromy s chybějícím USOP, nezaniklé edit 

#memorable trees without code - Existing only
SELECT DISTINCT ?item ?itemLabel ?sitelink ?exist
WHERE
{
	?item wdt:P31 wd:Q811534 .
    ?item wdt:P17 wd:Q213 .
	OPTIONAL { ?item wdt:P677 ?itemDescription  }
	FILTER (!BOUND(?itemDescription))
    OPTIONAL { ?sitelink schema:about ?item . ?sitelink schema:inLanguage "cs" } 
	SERVICE wikibase:label { bd:serviceParam wikibase:language "cs"}
    BIND(NOT EXISTS{ ?item wdt:P31 wd:Q15893266 } AS ?exist)     
    FILTER ( ?exist)
}
Try it!

Chybějící P131 edit 

# Chybějící P131
SELECT DISTINCT ?item ?itemLabel ?okrLabel ?L1Label ?L2Label ?L3Label ?USOP
WHERE
{
	?item wdt:P31 wd:Q811534  .
	?item wdt:P17 wd:Q213  .
    OPTIONAL {
      {
      ?okr wdt:P31 wd:Q548611 .
      ?item wdt:P131* ?okr .
      } UNION  { 
      ?okr wdt:P31 wd:Q5119 .
      ?item wdt:P131* ?okr .
      }
    }
	OPTIONAL{?item wdt:P131 ?L1 .}
    OPTIONAL{?item wdt:P131/wdt:P131 ?L2 .}
	OPTIONAL{?item wdt:P131/wdt:P131/wdt:P131 ?L3 .}
    FILTER NOT EXISTS { ?item wdt:P131 ?loc }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs" }
}
LIMIT 80
Try it!

Památné stromy s chybějícím DRUSOP edit 

#memorable trees without code - No DRUSOP
SELECT DISTINCT ?item ?USOP ?DRUSOP ?itemLabel ?sitelink ?exist
WHERE
{
	?item wdt:P31 wd:Q811534 .
    ?item wdt:P17 wd:Q213 .
    #?item wdt:P131/wdt:P131 wd:Q579648 .         #Okres ZR
	?item wdt:P677 ?USOP
	OPTIONAL { ?item wdt:P3296 ?DRUSOP  }
	FILTER (!BOUND(?DRUSOP))
    OPTIONAL { ?sitelink schema:about ?item . ?sitelink schema:inLanguage "cs" } 
	SERVICE wikibase:label { bd:serviceParam wikibase:language "cs"}
    BIND(NOT EXISTS{ ?item wdt:P31 wd:Q15893266 } AS ?exist)     
    #FILTER ( ?exist)
}
Try it!


Památné stromy doplnit do seznamů edit 

SELECT ?item ?itemLabel ?okresLabel ?pocet
WHERE {
  ?item wdt:P31 wd:Q811534 .
  ?item wdt:P17 wd:Q213 .
  ?item wdt:P677 ?USOP . 
  {?item wdt:P131/wdt:P131 ?okres .}
  OPTIONAL{ ?item p:P527/pq:P1114 ?pocet .}
  FILTER (?pocet>1)
  #?item wdt:P131/wdt:P131 wd:Q579648 .         #Okres ZR
  FILTER regex(?USOP, "106049|106055|106086|106095|106094|106078|105947|106102|106101|106103|106114|105884|105990|105977|105882|105958|105975|105976|105991|105928|106060|105893|106070|106071|106127|105943|105944|106044|105883|106087|105945|105935|105996|106007|106010|106092|105921|106061|106063|105880|14672|106043|105931|106072|106085|105951|106106|105962|106042|106019|106024|106023|106031|106112|105992|105842|105879|105956|105913|105911|105912|105933|105901|105940|106068|106109|105936|105938|105937|106057|106062|106124|105878|106032|106034|106033|105919|105906|105918|105905|105952|105949|106111|105881|105954|105953|105955|103731|103714|106082|106022|106005|106121|106123|105902|105989|106118|103822|105907|106089|106091|106100|105891|105968|105967|105969|105970|106014|106020|105916|106069|106125|106065|105988|105053|104628|104928|104627|105118|104860|105114|105732|105734|103943|103937|103949|103950|103946|103947|103951|103954|103953|103968|103998|103994|103995|105535|105892|106036|106035|105948|106048|105965|106008|106009|105900|106058|106113|105966|105934|105930|106084|105899|106051|106046|106050|106056|105939|105874|106030|106028|106029|105917|106090|105972|106079|106088|105946|105973|106052|106081|102091|106126|105909|105910|106080|106107|106108|106116|106117|105873|105877|105886|105887|105885|105890|105888|105889|105960|105959|105301|106110|105974|103215|106045|106054|105876|106006|106073|105929|106064|106067|105897|105896|106040|105961|106025|106041|106099|106038|106115|105923|105924|105927|105925|105926|105932|106096|106083|106003|106105|104271") 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs" }
}
#ORDER BY (?itemLabel)
ORDER BY DESC(?okresLabel)
Try it!

Obce okresu ZR edit 

#Obce okresu ZR
SELECT ?item ?label ?sitelink ?okresLabel 
WHERE
{
  ?item wdt:P31 wd:Q5153359 .          #Obec ČR
  ?item wdt:P131 wd:Q579648 .         #Okres ZR
  ?item wdt:P131 ?okres .    
  ?item rdfs:label ?label FILTER (lang(?label) = "cs") .
  FILTER REGEX(str(?label), "Vír|Prosetín") .
  ?sitelink schema:about ?item . ?sitelink schema:inLanguage "cs" .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs" }
}
LIMIT 50
Try it!

Památné stromy podle data vyhlášení edit 

#memorable tree
#defaultView:BarChart
SELECT DISTINCT ?datum (count(?datum) AS ?pocet)
WHERE
{
  ?item wdt:P31 wd:Q811534 .
  ?item wdt:P17 wd:Q213 .
  ?item wdt:P677 ?usop .
  ?item p:P31/pq:P580 ?datum .
}
group by ?datum
Try it! 
#memorable tree - by year
#defaultView:BarChart
SELECT DISTINCT ?year (count(?year) AS ?pocet)
WHERE
{
  ?item wdt:P31 wd:Q811534 .
  ?item wdt:P17 wd:Q213 .
  ?item wdt:P677 ?usop .
  ?item p:P31/pq:P580 ?datum .
  BIND( str(year(?datum)) as ?year ).
}
group by ?year
Try it! 
SELECT 
  #?item 
  (SAMPLE (?USOP) AS ?USOP)
  (COUNT(?druh) AS ?pocet) 
  (GROUP_CONCAT(?druhLabel; SEPARATOR = "&") AS ?druhy) 
  (SAMPLE (?itemLabel) AS ?Nazev)
  (SAMPLE (?datum) AS ?Datum)
  (SAMPLE (?obecLabel) AS ?Obec)
  (SAMPLE (?GPS) AS ?GPS)
  (SAMPLE (?obvod) AS ?Obvod)
  (SAMPLE (?obrazek) AS ?image)
WHERE { 
        ?item wdt:P677 ?usop . 
        ?item wdt:P31 ?druh .
        ?druh wdt:P31 wd:Q16521 .
        ?item wdt:P131 ?obec . 
        ?obec wdt:P131 ?Okres . 
        ?obec wdt:P131 wd:Q579648 . 
    OPTIONAL{?item wdt:P625 ?GPS } . 
    OPTIONAL{?item wdt:P677 ?USOP } . 
    OPTIONAL{?item wdt:P2547 ?obvod } . 
    OPTIONAL{?item wdt:P18 ?obrazek } . 
    OPTIONAL{?item p:P31/pq:P580 ?datum } .
  SERVICE wikibase:label {    bd:serviceParam wikibase:language "cs" . 
    ?druh rdfs:label ?druhLabel .  
    ?obec rdfs:label ?obecLabel .  
    ?item rdfs:label ?itemLabel .  
  }
}
GROUP BY ?item
ORDER BY DESC(?pocet)
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Maxx&oldid=506180964"