Wikidata:WikiProject Czech Republic/Maintenance Queries

Home

 


Properties

 

Maintenance Queries

 

Showcase Queries

 

Interesting external databases

 

Events

 

Tools

 



Missing imagesEdit

# Items in the Czech Republic that have coordinates missing an image
SELECT ?item ?itemLabel ?coord
WHERE
{
  ?item wdt:P17 wd:Q213; wdt:P625 ?coord .
  MINUS { ?item wdt:P18 ?image } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs" } .
}

Try it!

Also works with "WikiData Free Image Search Tool": [1]


Items without statementsEdit

Duplicates of monument IDsEdit

See also /Duplicates of monument IDs
#Find duplicate monument IDs
SELECT * WHERE {
  {
    SELECT ?id (COUNT(?obj) AS ?count) (GROUP_CONCAT(?obj; SEPARATOR = " , ") AS ?items) WHERE { 
      ?obj wdt:P762 ?id. 
    }
    GROUP BY ?id
  }
  FILTER(?count > 1)
}

Try it!

Missing articles on cswikiEdit

See also User:Matěj Suchánek/Czech not on cswiki
SELECT ?item ?sitelinks WHERE {
  ?item wdt:P17 wd:Q213 .
  MINUS { ?item ^schema:about/schema:isPartOf <https://cs.wikipedia.org/> } .
  ?item wikibase:sitelinks ?sitelinks .
} ORDER BY DESC(?sitelinks)

Try it!

Possible duplicates with zanikleobce.cz abandoned objects ID (P3003)Edit

#defaultView:Map
SELECT DISTINCT ?item ?itemLabel ?coord ?layer {
  ?item1 wdt:P3003 []; wdt:P625 ?coord1; rdfs:label ?label .
  BIND( STRLANG( STR( IF( CONTAINS( ?label, ' (' ), STRBEFORE( ?label, ' (' ), ?label ) ), 'cs' ) AS ?itemLabel ) .
  ?itemLabel ^rdfs:label ?item2 .
  FILTER( ?item1 != ?item2 ) .
  FILTER EXISTS {
    ?item2 wdt:P17 wd:Q213; wdt:P625 ?coord2; wdt:P31/wdt:P279* wd:Q486972 .
    FILTER( geof:distance( ?coord1, ?coord2 ) < 2 ) .
  } .
  OPTIONAL { ?item2 wdt:P625 ?coord2 } .
  VALUES ?x { 1 2 } .
  BIND( IF( ?x = 1, ?item1, ?item2 ) AS ?item ) .
  BIND( IF( ?x = 1, ?coord1, ?coord2 ) AS ?coord ) .
  BIND( IF( ?x = 1, 'zaniklá', 'druhá' ) AS ?layer ) .
} ORDER BY ?itemLabel

Try it!

Possible duplicates with sv/cebwiki articlesEdit

#defaultView:Map
SELECT DISTINCT ?item ?itemLabel ?coord ?layer WITH {
  SELECT DISTINCT ?item1 ?coord1 ?itemLabel {
    VALUES ?links { 1 2 3 } .
    VALUES ?wikis { <https://ceb.wikipedia.org/> <https://sv.wikipedia.org/> } .
    ?item1 wdt:P17 wd:Q213; wikibase:sitelinks ?links; wdt:P625 ?coord1;
           ^schema:about/schema:isPartOf ?wikis; rdfs:label ?label .
    MINUS { ?item1 ^schema:about/schema:isPartOf <https://cs.wikipedia.org/> } .
    BIND( STRLANG( STR( IF( CONTAINS( ?label, ' (' ), STRBEFORE( ?label, ' (' ), ?label ) ), 'cs' ) AS ?itemLabel ) .
  }
} AS %sub WHERE {
  INCLUDE %sub .
  ?itemLabel ^rdfs:label ?item2 .
  FILTER( ?item2 != ?item1 ) .
  FILTER EXISTS {
    ?item2 wdt:P17 wd:Q213; wdt:P625 ?coord2 .
    FILTER( geof:distance( ?coord1, ?coord2 ) < 2 ) .
  } .
  OPTIONAL { ?item2 wdt:P625 ?coord2 } .
  VALUES ?x { 1 2 } .
  BIND( IF( ?x = 1, ?item1, ?item2 ) AS ?item ) .
  BIND( IF( ?x = 1, ?coord1, ?coord2 ) AS ?coord ) .
  BIND( IF( ?x = 1, 'sv/ceb', 'ok' ) AS ?layer ) .
} ORDER BY ?itemLabel

Try it!

New Czech personsEdit

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images Recent changes
label Gender Given name Date of birth occupation NKCR abart csfd description Sitelinks
Anna Marie Veselá female Anna
Marie
2004-03-21 YouTuber
singer
1
Natálie Halouzková female 2001-01-08 actor 117850 1
Jiří Bárta male Jiří chief marketing officer Czech marketing executive 1
Petr Roškaňuk male Petr 1958-11-19 guitarist
Q16516756
film score composer
composer
2
Miloslav Srovnal male 1945-01-11 athlete 1
Jaroslav Knittl male Jaroslav 1922-04-27 teacher
minister
155177 1
Jan Přikryl male Jan 1950-08-09 athlete 1
Ivan Vosecký male 1963-03-30 architect
painter
jo20000075294 1083 Czech artist 0
Ashley Robbins female Ashley 1979s pornographic actor Czech pornographic actress 0
Radka Prokopová female Radka 1969-11-15 manager
businessperson
Czech businesswoman 0
Iveta Koulová female Iveta 2000s politician
mayor
1
Viktor Krištof male Viktor 1979-01-31 film producer
actor
screenwriter
Czech film producer 0
Lada Semecká female Lada 1973 glass artist mzk2006355833 43056 Czech glass artist 0
Tomáš Hlavina male Tomáš 1966-08-15 sculptor jo20000080446 9035 Czech sculptor 0
Václav Vaculovič male 1957 painter js20050711005 3051 Czech painter 0
Pavel Benes male 1973 chess player 0
Jana Sobotová female Jana 1964-03-11 manager
businessperson
Czech businesswoman 0
Matěj Pekr male Matěj 1988-03-27 ice hockey player 1
František Fabičovic male businessperson
manager
Czech businessman 0
Zdeněk Ptáček male 1947-06-24 businessperson
manager
Czech businessman 0
Milan Teplý male businessperson
manager
Czech businessman 0
Ondřej Fryc male businessperson
manager
Czech businessman 0
Jiří Dragoun male businessperson
manager
Czech businessman 0
František Studénka male businessperson
manager
Czech businessman 0
Jiří Trávníček male businessperson
manager
Czech businessman 0
Ludvík Karl male businessperson
manager
Czech businessman 0
Jaroslav Nosek male businessperson
manager
Czech businessman 0
Jiří Mareš male businessperson
manager
Czech businessman 0
Lubomír Stoklásek male 1950-01-28 businessperson
manager
Czech businessman 0
Jaroslav Beran male 1956-11-14 businessperson
manager
Czech businessman 0
Marcel Manigati male Marcel 2000s pornographic actor Czech pornographic actor 0
Jana Bartošová female 1971 historian pna2007403574 82370 0
Tomáš Fiala male Tomáš 1957-03-25 politician
physician
1
Simona Luftová female Simona 1973-03-05 teacher
politician
1
Dušan Skala male Dušan 1979 photographer mzk2005274799 30749 Czech photographer 0
Daniela Švandová female Daniela 1944-10-30 photographer mzk2006337073 94319 Czech photographer 0
Radim Hladík male Radim 1971-05-15 sound designer xx0073284 92572 Czech sound designer 0
Lenka Zlámalová female Lenka 1972 economist
opinion journalist
journalist
xx0234645 2
Irena Brabcová female Irena 1958-07-09 mayor 1
Jiří Denner male 1986-06-10 manager
businessperson
Czech businessman 0
Jaja Vankova female 1992-03-21 actor
dancer
choreographer
actress 0
Zdeněk Sobotka male Zdeněk 1973-07-26 manager
businessperson
Czech businessman 0
Petr Švec male Petr 1978-05-25 dramaturge
journalist
1
Miroslav Koliba male Miroslav 1980-10-07 physician
diabetologist
podiatrist
1
Jiří Nepala male Jiří 1974-03-16 manager
businessperson
Czech businessman 0
Jiří Kniha male Jiří 1981-05-07 actor xx0142575 63783 0
Tadeáš Bednarz male Tadeáš 2002-10-13 photographer
association football referee
Wikimedian
Czech photographer and football referee 1
Soňa Gurská female researcher 0
Anie Darling female 1998-07-01 pornographic actor Czech pornographic actress 0
Stacy Cruz female 1999-03-24 pornographic actor Czech pornographic actress 1
Božena Řežábová female 1981-09-16 manager
businessperson
Czech manager 0
Ondřej Hodboď male Ondřej 2001-06-01 athletics competitor Czech athlete 1
Martin Selner male Martin 1984-04-15 special educator
writer
jo2017967709 1
Lenka Elbe female 1979-06-01 writer xx0251588 Czech author 1
Vojtěch Vovesný male Vojtěch 2007 actor 73784 0
Jan Jakubec male 1915-01-18 soldier 1
Josef Fanta male Josef 1894-08-31 legionary 1
Irena Kocí female 1974 dramaturge
screenwriter
ola20191033325 592653 1
Jiří Kaucký male Jiří 1973-06-09 jurist ola2003167435 1
Jaromír Hanačík male Jaromír 1949-02-02 athlete 1
Category:Marek Totušek male Marek 2002-08-06 athlete 2
Dana Harem female Dana 1983 glamour model 289754 Czech glamour model 0
Klára Vojtíková female Klára 1994-06-16 basketball player 1
Renata Pudláková female Renata 1992-03-18 basketball player 1
Beáta Adamcová female Beáta 1993-01-13 basketball player 1
Marcela Hrdá female 1971-11-27 manager Czech manager 0
Michael Gaspar male Michael 1999-10-31 ice hockey player Czech Ice hockey player 1
Anna Svobodova 1944 visual artist 0
Pavel Pokorny 1976 visual artist 0
Filip Pavlik 1986 visual artist 0
Jan Hora 1965 visual artist 41208 0
Martin Klaus 1976 visual artist 0
Jakub Rafl 1973 visual artist 32758 0
Karima Al-Mukhtarová female 1989 visual artist ola2018998411 105771 0
Miroslav Hrstka 1933 visual artist 0
Paulina Haberstock Paulina 1967 visual artist 0
Magdaléna Bursová female 1974 visual artist xx0248664 70025 0
Petr Svarc 1973 visual artist 0
Drahoslav Solta 1960 visual artist 0
Daniel Skrivan 1963 visual artist 0
Klára Horová female Klára 1969 visual artist xx0248182 41437 0
Irena Fafková Solanová female 1928 visual artist 10737 0
Pavel Tomečko male 1948 visual artist 1451 0
Marie Toyon 1902 visual artist 0
Dana Kovaříková female Dana 1960 visual artist 39442 0
Michal Dana 1949 visual artist 0
Eva Slačálková female 2009 visual artist 163603 0
Marcela Halousková female 1946 visual artist 450 0
Otto Janecek Otto 1919 visual artist 0
Marcela Pasulkova 1980 visual artist 0
Markéta Paurová female 1945 visual artist 11968 0
Milan Halousek Milan 1946 visual artist 0
Jaroslava Setelkova 1946 visual artist 0
Jakub Halousek 1978 visual artist 0
Miroslav Hanák male Miroslav 1946 visual artist
painter
459 0
Michael Matzenauer male Michael 1947 visual artist 1
Jiro Novotny 1943 visual artist 0
Tereza Bredlerová female Tereza 1975 visual artist 146153 0
Ladislav Vořechovský male 1914 visual artist
painter
13164 0
Ladislav Placatka male Ladislav 1923 visual artist 179 0
End of automatically generated list.

New Czech entitiesEdit

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images Recent changes
label instance NKCR description Sitelinks
Krásné Pole 50 Upper Lusatian house 0
Krásné Pole 53 Upper Lusatian house 0
Krásné Pole ev. č. 2 Upper Lusatian house 0
Krásné Pole 64 Upper Lusatian house 0
Turistická značená trasa 6656 marked tourist trail 1
Popiš památku 2018 Wikimedia Czech Republic competition 2018 Wikimedia Czech Republic competition 0
Popiš památku 2019 Wikimedia Czech Republic competition 2019 Wikimedia Czech Republic competition 0
Hvězda svobody Wikimedia Czech Republic competition
edit-a-thon
Wikimedia Czech Republic competition 1
Kočvarova vila villa 1
Střelecká revue magazine Czech/Czechoslovak magazine 0
pomník Marie Terezie v Praze statue 1
Mateřská škola Chytrá Sovička kindergarten kindergarten in Prague 0
Železniční trať Týniště nad Orlicí – Meziměstí railway line 2
chytrá karanténa project 1
LitFin business Czech litigation financing company 0
Vila Aloise Švorčíka villa 1
Chřibská ev. č. 45 Upper Lusatian house 0
Chřibská 64 Upper Lusatian house 0
Korupční skandál v českém fotbale 2020 scandal 1
Živě.cz online magazine Czech webzine 1
Mlýn Perner watermill 1
Místní akční skupina Stolové hory business 1
Divesoft business 1
Základní škola a střední škola waldorfská primary school
secondary school
elementary and secondary school in Prague 0
Komunitní centrum Mezi Domy community center community center in Prague 1
Ymkárium Dům dětí a mládeže youth center in Prague 0
Mateřská škola Křejpského kindergarten kindergarten in Prague 0
Q100600621 sculpture 1
Obchodní centrum Řepy building 1
Policejní zásah na Staroměstském náměstí 18. října 2020 occurrence 1
Římská 16 building building in Prague 1
vila Chopin building 2
Východočeský památník celnictví museum museum in Králíky 2
Pražská radiála road 1
Základní škola Vitae primary school elementary school in Prague 0
Poliklinika Chomutovická policlinic health center in Prague 0
Mateřská škola Vodnická kindergarten kindergarten in Prague 0
Palas Athéna medical facility medical center in Prague 0
Montessori Lesní Školka kindergarten kindergarten in Prague 0
Veverská Bítýška wharf 1
Skály wharf 0
Mečkov wharf 0
Hrad Veveří wharf 1
Hrad Veveří wharf
destroyed building or structure
1
Zouvalka wharf
destroyed building or structure
0
Obora wharf
destroyed building or structure
0
Pod Trnůvkou wharf 1
Rokle wharf 1
Osada wharf
destroyed building or structure
1
U kotvy wharf 1
Sokolské koupaliště wharf
destroyed building or structure
1
Sokolské koupaliště wharf 1
Kozí horka wharf 1
Bystrc wharf 1
Horní Chřibská ev. č. 33 Upper Lusatian house 0
Chřibská 68 Upper Lusatian house 0
Chřibská ev. č. 21 Upper Lusatian house 0
Chřibská 72 Upper Lusatian house 0
Chřibská ev. č. 18 Upper Lusatian house 0
Zahradnický tunel railway tunnel 1
Dětský klub Maata voluntary association 0
kříž v ulici U větrolamu wayside cross 0
MGM COMPRO enterprise
technology company
2
Chřibská 83 Upper Lusatian house 0
Chřibská 233 Upper Lusatian house 0
Chřibská 234 house
Q12033488
0
Chřibská 235 Upper Lusatian house 0
Horní Chřibská 175 Upper Lusatian house 0
Horní Chřibská ev. č. 23 house
Q12033488
0
Vila Václava a Luisy Tesařových villa 1
Horní Chřibská 153 Upper Lusatian house 0
Chřibská 215 Upper Lusatian house 0
Chřibská 82 Upper Lusatian house 0
Horní Chřibská 7 Upper Lusatian house 0
Horní Chřibská ev. č. 29 Upper Lusatian house 0
Chřibská 78 Upper Lusatian house 0
Chřibská ev. č. 25 Upper Lusatian house 0
Horní Chřibská 12 Upper Lusatian house 0
Horní Chřibská 14 Upper Lusatian house 0
Horní Chřibská 129 Upper Lusatian house 0
Horní Chřibská ev. č. 38 Upper Lusatian house 0
Horní Chřibská 114 Upper Lusatian house 0
Horní Chřibská ev. č. 30 Upper Lusatian house 0
Horní Chřibská ev. č. 50 Upper Lusatian house 0
pomník padlým ve Vidhosticích monument 0
Vidhostice Reservoir reservoir lake in the Czech Republic 1
plaque to Dobroslav Líbal commemorative plaque plaque in Prague 0
Šubertova 4 building building in Prague 1
váza ze zámku sculpture 0
Horní Chřibská ev. č. 41 Upper Lusatian house 0
Horní Chřibská ev. č. 51 Upper Lusatian house 0
Horní Chřibská 20 Upper Lusatian house 0
Horní Chřibská 120 Upper Lusatian house 0
Horní Chřibská ev. č. 26 house
Q12033488
0
Horní Chřibská 33 Upper Lusatian house 0
Horní Chřibská 141 Upper Lusatian house 0
Horní Chřibská 35 Upper Lusatian house 0
Horní Chřibská 36 Upper Lusatian house 0
Horní Chřibská 133 Upper Lusatian house 0
Horní Chřibská ev. č. 37 Upper Lusatian house 0
End of automatically generated list.