Wikidata:WikiProject Czech Republic/Maintenance Queries

From Wikidata
Jump to navigation Jump to search

Home

 


Properties

 

Maintenance Queries

 

Showcase Queries

 

Interesting external databases

 

Events

 



Missing images[edit]

# 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 statements[edit]

Duplicates of monument IDs[edit]

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 cswiki[edit]

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 articles[edit]

#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 persons[edit]

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
Jan Pichl male Jan 1935-01-14 sculptor 12010 Czech sculptor 1
Jaroslav Hlavnička male 1953-08-23 politician Czech politician 0
Zuzana Schwarz Bařtipánová female 1978-02-24 politician Czech politician 0
Hana Večerková female politician Czech politician 0
Ondřej Zmeškal male Ondřej 1991-01-12 writer
athlete
xx0219700 1
Martin Cedidla male Martin 2001-11-22 association football player Czech footballer 1
Alois Pernička male Alois 1948-01-15 minister 1
Lukáš Rousek male Lukáš ice hockey player Czech ice hockey player 1
Matěj Chalupa male Matěj ice hockey player Czech ice hockey player 1
Pavel Vacek male Pavel 1947-11-22 university teacher
psychologist
pedagogue
politician
mzk2004222539 Czech psychologist, university educator, and politician 2
Veronika Jaborníková female sport cyclist Czech cyclist 2
Petr Mejzlík male Petr 1959 athlete
teacher
1
Aleš Čepek male Aleš 1954 academic
researcher
computer scientist
ntka174714 professor at the Department of Mapping and Cartography, Faculty of Civil Engineering of the Czech Technical University in Prague 1
Radek Novák male Radek 1972-07-05 athlete 1
Josef Zikmunda male Josef 1949-03-15 manager
businessperson
Czech businessman 0
Karel Muzikář male Karel 1963-07-01 lawyer
businessperson
manager
Czech lawyer and businessman 0
Zdeněk Pištora male Zdeněk 1963-12-12 politician
teacher
Czech politician 1
Václav Vrba male Václav researcher
teacher
physicist
0
Michal Marcisovsky male Michal physicist
researcher
0
Patrik Parizek male 1988-08-22 researcher
antiquarian
teacher
jx20120504002 art historian, antique dealer, teacher in Prague 1
Vera Neubauer female Vera 1948 animator
film director
university teacher
film producer
cinematographer
screenwriter
photographer
66831 Czech film director, editor and animator 0
Filip Císařovský male 1997-02-25 association football player Czech association football player 1
Martin Moravec male Martin 1971-12-23 manager
businessperson
Czech businessman 0
Jan Josef Budil male Jan
Josef
1928-03-07 minister 1
Jiří Hradil male keyboardist Czech keyboardist 0
David K. Pomahač male musician xx0064978 Czech musician 0
Tereza Štětinová female bass-guitarist Czech bass-guitarist 0
Andrea Jarolímková female trumpeter Czech trumpeter 0
Matěj Vejdělek male musician Czech musician 0
Veronika Linhartová female 1992-05-13 actor
violinist
99615 0
Ondřej Mataj male 1987-12-24 actor
musician
67291 0
Terezie Kovalová female 1989-09-10 cellist
singer
159607 Czech cellist and singer 0
Tomáš Neuwerth male drummer
record producer
Czech drummer and producer 0
Marie Puttnerová female singer Czech singer 0
Marie Kieslowski female singer
pianist
Czech vocalist and pianist 0
Aid Kid male Czech musician 0
Alexandr Zemek male Alexandr 1974-03-11 entrepreneur
manager
0
Zdeněk Zemek male Zdeněk 1974-03-11 entrepreneur
manager
Czech businessman (1974) 0
Ondřej Koupil male Ondřej 1972 Q71049101
latinist
jn20010309672 bohemicist and latinist 0
Šebestián Pavel Smrčina male Pavel 1966-08-07 priest
religious
friar minor
1
Kristýna Neubergová female Kristýna 1996-01-06 handball player Czech handball player 0
Stanislav Pacner male Stanislav 1969-07-21 theologian
minister
mzk2006363610 1
Jiří Malášek male 1938-08-01 journalist 1
Milan Hamerský male Milan 1973 politician xx0003721 Czech politician 0
Luboš Kafka male Luboš 1962 ethnologist xx0039450 czech etnologist 0
Jarmila Hlaváčková female Jarmila historian mzk20191057141 czech historian 0
Anna Hamrlová female Anna 1988 art historian xx0205352 czech art historian 0
Petra Hnilicová female Petra art historian czech art historian 0
Sune Frederiksen male 1983-04-22 curler
curling coach
Danish and Czech male curler and coach 1
Vladimír Müller male 1961-04-22 manager
businessperson
Czech businessman 0
Radek Švec male Radek 1968-06-07 manager
businessperson
Czech businessman 0
Miroslav Klinger male Miroslav 1922 sculptor Czech sculptor 0
Ivan Bierhanzl male Ivan 1956 musician xx0087388 465153 Czech musician 0
Marek Španěl male Marek 1973-02-27 manager
businessperson
0
Karl Schüller male 1852-06-13
1852-06-14
painter 51791 0
Martin Krčál male 1979-03-13 teacher jo2012705839 Czech teacher 2
Wenzel Schwertfer male Wenzel 1617 Jesuit
pedagogue
theologian
writer
rector
mzk2008459108 0
Jaroslav Kratka male 1947-06-18 minister
journalist
1
Vojtěch Veselý male teacher Czech teacher 1
Petr Chovanec male 1959-12-19 minister 1
Jan Rob male 1914-12-17 minister 1
Ludvík Otradovec male 1928-12-11 1
Jindřich Pulkrábek male Jindřich 1930-04-03 architect 12111 Czech architect 1
Eva Horáčková female Eva 1923-02-28 psychologist jx20080408023
xx0128559
Czech psychologist 0
Ivo Spilka male Ivo teacher 1
František Vaculík male František 1984-09-18 ski jumper
ski jumping coach
Czech ski jumper and ski jumping coach 2
Nikol Fischerová female Nikol 1977-04-22 police officer
actor
singer
37548 1
Petr Dufek male Petr 1974 economist xx0202717 Czech economist 0
Linda Fruhvirtová female Linda 2005-05-01 tennis player Czech tennis player 1
Miloš Malina male Miloš 1904-10-14 painter
graphic artist
xx0011349 6172 0
Jaromír Sobota male Jaromír 1935-09-08 epidemiologist
hygienist
xx0140142 0
Ildikó Csöle Putzová female Ildikó 1974-02-26 manager jo2015862378 0
Richard Kania male Richard 1929-01-16 surgeon
physician
athlete
nlk19990073337 1
Michaela Foitová female Michaela 1992-02-17 actor mzk2014827557 0
Radovan Procházka male Radovan 1927-05-11 soldier
military officer
jo2008464757 Czech soldier 0
DJ Skupla male disc jockey Czech DJ 0
DJ Smog male disc jockey Czech DJ 0
Rusty male rapper Czech rapper 0
Fugaz male Pavel rapper Czech rapper 0
Ba2s male Petr 1976-03-18 rapper
disc jockey
Czech rapper 0
Jaroslav Mrňa male Jaroslav 1983-12-23 historian jcu2012736793 1
Jiří Hrdý male Jiří 1961-12-26 translator
minister
kpwa2677 0
Jakub Cejchan male Jakub 1998-09-26 Nordic combined skier 1
Michal Stránský male Michal 1966-06-01 graphic artist
poet
mzk2004236890 Czech graphic artist and typographer, environmental activist, poet 1
František David male František 1913-10-25 sculptor
wood carver
medallist
jn20000728104 18 1
Jan Roith male 1951-09-24 sculptor 112969 Czech sculptor 0
Jiří Dobeš male Jiří 1965-10-17 parson
photographer
xx0083347 0
Václav Adolf Kovanič male Václav
Adolf
1911-09-27 sculptor
medallist
jn20000703132 108 1
Jitka Janíková female Jitka 1963-07-08 visual artist
illustrator
xx0064041 36334 1
Česlav Ludvík Malík male Ludvík
Česlav
1922-07-20 translator
minister
pna2008467019 1
František Pašek male František 1922-12-02 sculptor jo20000082882 1060 1
František Puchnar male František 1934-02-24 parson hka2013773772 0
Jan Pacner male Jan 1964-11-20 minister xx0231112 1
Karel Fron male Karel 1947-08-17 sculptor
painter
illustrator
xx0010986 1
Bohumil Robeš male Bohumil 1930-08-01 actor
writer
mzk2002142190 1
Jiří Váňa male Jiří 1979 traveller
photographer
1
Petr Piler male Petr 1965-12-26 minister jcu2011633220 0
Zdeněk Pospíšil male Zdeněk 1933-12-15 compiler
minister
writer
jx20090217029 0
Jan Kilian male Jan 1934-05-29 physician jk01060159 96649 1
Jan Starka male 1989-09-28 manager Czech manager 0
End of automatically generated list.

New Czech entities[edit]

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
Konsolidační banka Praha business former Czech state-owned bank 0
Plaque to the 1st Ukrainian Front and Ivan Konev in Prague commemorative plaque 1
PeopleComm publisher Czech publishing house 0
kříž Pasekovy rodiny v Koněšíně wayside cross 0
kaplička v Koněšíně chapel
wayside shrine
0
kříž u cesty v Koněšíně wayside cross 0
Kříž ke 100 letům Československa wayside cross 1
kříž rodiny Musilovy u Koněšína wayside cross 0
křížek u domu 102 v Koněšíně wayside cross 0
hřbitov v Koněšíně cemetery 1
kříž u kostela sv. Bartoloměje v Koněšíně wayside cross 0
kříž u domu 149 v Koněšíně wayside cross 0
kříž u Jindřichova dvora v Koněšíně wayside cross 0
kříž ve Vladislavi wayside cross 0
hřbitovní kříž na hřbitově ve Vladislavi cemetery cross 0
Hřbitov ve Vladislavi cemetery 1
Kříž u Prachovny wayside cross 0
Hrobka Kleinů tomb 2
Hřbitov u svatého Rocha cemetery 2
Kostel svatého Petra a Pavla church building 2
Praga Studios business Czech company 0
rondel se sochou kočky roundel 1
Praga Studios office building Office building in Prague, Karlín district 1
Dům kultury Kladno house of culture house of culture in Kladno, Czech Republic 0
Witkowitz business Czech company 0
Vítkovické strojírny business Czech company 0
U Volbrechtů building
coffeehouse
restaurant
2
Bridge over the Elbe river between Valy and Mělice bridge Bridge over the Elbe river in Czechia between Valy and Mělice in Pardubice Region, built in 2020 2
Socha Nicholase Wintona na Hlavním nádraží v Praze statue 1
pplk. Sochora čp. 727 building 0
Rav PropCo Rentals II. business 0
Činžovní domy U Bubeníčků building complex 0
U Bubeníčků building house in Prague 0
Křemencova 6 building 0
Pštrossova 13 school building 0
Vojtěšská 9 building 0
památník obětem salašské tragédie memorial 1
památník americkým letcům memorial 1
pomník válečných zajatců 1. světové války war memorial 1
památník a hrob rudoarmějců memorial 1
náhrobek Josefa a Františky Vosmíkových tombstone 1
Basketbalista statue a 1985 bronze statue by František Mrázek, situated in front of the sports hall in České Budějovice, South Bohemian Region, Czechia 1
Na paměť padlých hrdinů memorial 1
Monument to the three emperors memorial 1
Monument to the battle near Tongrund war memorial 1
Monument to Red Army at Kobylisy cemetery memorial 1
Monument to Alexander Bogdanov memorial 1
Monument near O2 Arena memorial 1
Mirovice memorial memorial 1
minimuzeum československého opevnění museum 1
Mikhail Kutuzov monument in Křenovice memorial 1
Staré Hutě ghost town 0
Hotelová škola Frenštát pod Radhoštěm dual education system
hospitality school
1
Memorial to the Deportees from Ostrava to Nisko memorial 1
Memorial to Jindřich Bujok memorial 1
Memorial to Alois Kádura and Adolf Wajner memorial 1
Čestné občanství města Nový Jičín award 0
opendata.praha.eu open data portal Open data portal Prague 0
pamětní kámen 750 let obce monument 0
kříž obětem násilí wayside cross 0
kříž u kostela wayside cross 0
kříž u silnice na Černý Dub wayside cross 0
kříž v ulici K Pilotovi wayside cross 0
Cycling route A218 long-distance cycling route cycling route in Czechia 1
socha 17. dubna 1945 statue 0
World Wars I and II memorial in Křeslice memorial memorial in Prague 0
NUTRA Factory factory factory in Prague 1
socha čápa sculpture
statue
0
busta Karla Ančerla monument
bust
0
Lísecký potok stream 1
pamětní deska Tomáše Garriguea Masaryka v Pelhřimově commemorative plaque 0
Pelhřimovská lípa important tree
Tilia cordata
1
Základní umělecká škola primary art school 0
Smilkovský potok stream 0
Zdebořský potok stream 0
Tvrzník fish pond 0
Betonové koule v parku u ulice V hůrkách sculpture 0
Brána do parku u ulice V hůrkách gate 0
kříž u MÚK wayside cross 0
Lávka přes ulici V hůrkách footbridge 0
Solutia business company in Prague, Czechia 0
Dekra (Czechia) business company in Prague, Czechia 0
train accident in Pernink, Czechia train wreck 3
sokolovna v Ledči nad Sázavou Sokol House 1
Památník hasičům v New Yorku memorial 0
Geoportal of the South Moravian Region open data portal 0
pomník Václava Tuttera monument 0
pomník v Poříčí monument 0
kříž v Poříčí wayside cross 0
Praha-Křeslice municipal office Q12041905 municipal district office in Prague 0
Základní škola Formanská primary school elementary school in Prague 0
FotbalPark Praha sports venue sports venue in Prague 0
Praha-Újezd municipal office Q12041905 municipal district office in Prague 0
MiG 23 MiG-23ML
monument
0
kříž v poli wayside cross 0
pomník osvobození monument 1
kříž u obalovny wayside cross 0
kaple v Dasném chapel 0
kaplička u vlečky Wayside shrine 0
kříž u vlečky wayside cross 0
End of automatically generated list.