Wikidata:WikiProject Czech Republic/Maintenance Queries

Home

Czech Properties

Maintenance Queries

Showcase Queries

Interesting external databases

Events

Tools

Thematic areas

Projects

Missing images

# 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]

Duplicates of monument IDs

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

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)

#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

#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

Manually update list

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	orcid	discogs	description	Sitelinks
Robert Alger	male	Robert	1968	sculptor						Czech-American sculptor	1
Aleš Jirátko	male	Ales		gynaecologist	xx0098874					M.D., private gynecologist	0
Igor Jíra	male	Igor		head of department	xx0098872					MUDr., radiodiagnostician (in 1991-92 head of the Department of Paediatric Radiology of the University Hospital in Brno). Former director of the University Children's Hospital in Brno.	0
Pavel Jinoch	male	Pavel		hematologist	xx0098871					MUDr., hematologist (IHBT - coagulation laboratory), director of VIDIA. He publishes in the field	0
Bogna Jiravská Godula	female	Bogna		internist	xx0098868					M.D., internist, sports doctor (Sports Outpatient Clinic of Podlesí Hospital).	0
Miroslav Jíra	male	Miroslav		researcher	xx0098865					MUDr., Mgr., PhD, research and development worker (Institute of Physiology, Faculty of Medicine, Masaryk University, Brno).	0
Jitka Jindřišková	female	Jitka		nurse	xx0098864					Nurse (Department of Orthopaedics and Traumatology, University Hospital Královské Vinohrady, Prague)	0
Zuzana Jindráková	female	Zuzana		biologist	xx0098863					Mgr., biologist. Graduate of the Faculty of Science, Charles University, Department of Genetics and Microbiology	0
František Jimramovský	male	František		pediatrician	xx0098862					MUDr., paediatrician - specialist in gastroenterology and nutrition, head of the children's department of the Boskovice Hospital. He publishes in the field	0
Hana Jirků	female	Hana		nurse	xx0098860					Bc. Head nurse of the Spinal Unit at the Motol-Prague University Hospital. He publishes in nursing	0
Libor Jindrák	male	Libor		writer	xx0098859					Publications in the field of parasitology (formerly: Institute of Parasitology of the Czech Academy of Sciences, České Budějovice)	0
Hana Jičínská	female	Hana		pediatrician	xx0098856					MUDr., paediatrician, cardiologist at the Second Children's Clinic of the University Hospital Brno	0
Tomáš Tulinger	male	Tomas		university teacher	xx0098849					Mgr., teacher, editor and translator from English	0
Martin Kmínek	male	Martin		translator	xx0098848					Translator from English	0
Š. Vladařová	female			nurse						Nurse (1st Department of Internal Medicine, University Hospital and Faculty of Medicine, Palacký University, Olomouc). Author of articles in the fields of nursing and internal medicine	0
Andrea Šipková	female	Andrea		nurse	xx0098840					DiS., nurse (3rd Department of Internal Medicine - Department of Endocrinology and Metabolism, 1st Faculty of Medicine, Charles University and General Teaching Hospital, Prague). Author of articles in the field of nursing and internal medicine	0
Markéta Řehová	female	Markéta		nurse	xx0098819					Bc., nurse (3rd Department of Internal Medicine, General Teaching Hospital and 1st Faculty of Medicine, Charles University, Prague). Author of articles on the harmfulness of tobacco	0
Dušan Zábrodský	male	Dušan		writer	xx0098814					Czech author of publications from the textile industry	0
K. Tinl				writer	xx0098811					Author of a publication in the field of agriculture	0
Jan Jetmar	male	Jan		translator	xx0098808					Translator of publications from Spanish	0
S. Hauser				writer	xx0098807					Author of publications in the field of pedagogy and pioneer organization	0
František Šmíd	male	František		writer	xx0098806					Co-author of a publication on occupational safety	0
Josef Pezinek	male	Josef		writer	xx0098805					Co-author of a publication on occupational safety	0
Josef Šulc	male	Josef		writer	xx0098803					Co-author of a publication on occupational safety	0
J. Jirásek				writer	xx0098802					Author of publications in the field of mechanical engineering	0
Josef Dittert	male	Josef		writer	xx0098801					Ing., author of publications in mechanical engineering	0
Jitka Otrubová	female	Jitka		writer	xx0098796					Author of publications in healthcare	0
František Vosyka	male	František		writer	xx0098790					Author of publications in the field of geology	0
Milada Grossmannová	female	Milada		writer	xx0098789					Author of publications in the field of geology	0
Ilona Benušová	female	Ilona		nurse						Preventive Cardiology Nurse (1st Internal Clinic, University Hospital and Faculty of Medicine, Palacký University, Olomouc)	0
Boris Moravec ml.	male	Boris	1950-02-14	production designer							0
Adolf Šádek	male	Adolf	1975-03-04	entrepreneur							0
David Parish	male	David Anthony	1963-05-12							(* 1963) Canadian-Czech entrepreneur	1
Karel Pacovský	male	Karel		historian	pna20211121670					Czech historian and translator	0
Igor Kisch		Igor	1954-03-01 1954	politician physician official							1
Julie Paštiková	female	Julie	2008-05-31	tennis player						czech tennis player	1
Oliver Velich	male	Oliver	2001-06-17	association football player						Czech footballer	0
Xnapy	male	Petr	1996	online streamer YouTuber pundit professional gamer							1
Roman Miesler	male	Roman		writer	mzk2005309253					Author of works on bird breeding	0
Aleš Kolář	male	Ales		cyberneticist	mzk2005309250					MSc., thesis in the field of applied cybernetics	0
Marie Kalivodová	female	Marie		programmer	mzk2005309249					Programmer, thesis on programming languages	0
Irča Drápalová-Kulišťáková	female			local historian	mzk2005309235					Regional historian of the Rožnov region	0
Bohumila Slováková	female	Bohumila		poet	mzk2005309225					Poetess, bibliophile editions of poetry	0
Stanislav Palička	male	Stanislav		docent	mzk2005309196					MSc. in economics, university lecturer, professional works in financial mathematics	0
Jiří Maršík	male	Jiří		writer	mzk2005309193					Author of books of cooking recipes	0
Pavel Kaňovský	male	Pavel		nuclear engineer	mzk2005309187					Ing., professional work in nuclear energy	0
Ivan Kolomazník	male	Ivan		mathematician	mzk2005309178					Doc., Dr., Mgr., mathematician, university lecturer, work in the field of mathematics and computer technology	0
Helena Klečková	female	Helena		publisher	mzk2005309163					Publisher Editor	0
Aleš Varga	male	Ales		writer	mzk2005309162					Author of textbooks for professional German	0
Vilém Vostal	male	Vilém	2005-03-10	sport cyclist						Czech cyclist	0
Tomáš Novák	male	Tomáš	2005-02-17	sport cyclist						Czech cyclist	0
Miroslav Pýcha	male										0
Tomáš Podivinský	male		2005-02-04	student							0
Tomáš Podivinský	male		1973-12-04	chief executive officer manager							0
David Hofmann	male	David		cinematographer							0
Lukas Fischer	male		2006-09-09	ice hockey player						Czech-American ice hockey player	0
Dominik Badinka	male		2005-11-27	ice hockey player						Czech ice hockey player	1
Adam Jecho	male		2006-03-24	ice hockey player						Czech ice hockey player	0
Jakub Fibigr	male		2006-07-22	ice hockey player						Czech ice hockey player	0
Jakub Milota	male		2006-04-14	ice hockey player						Czech ice hockey player	0
Maxmilian Curran	male		2006-08-27	ice hockey player						Czech ice hockey player	0
Tomas Järvinen	male		2005-10-21	decathlete						Czech-Finnish decathlete	0
Pierre Fontane	male			pornographic actor						Czech pornographic actor and adult model	0
Yannis Paluan	male	Vojtěch	1997-04-10	bodybuilder pornographic actor webcam model						Czech bodybuilder, pornographic actor, adult and webcam model	0
Jiří Mikula	male	Jiří		film editor			206731				0
Petr Příkaský	male	Petr		cinematographer			145990				0
Simon Štekl	male	Simon	1977-07-26	manager businessperson						Czech businessman	0
Liam Efron	male		1996-08-08	pornographic actor						Czech Pornographic actor	0
Jarrod Lanvin	male	Martin	1997-09-09	pornographic actor						Czech Pornographic actor	0
Bjorn Nkyvist	male		1996-10-31	pornographic actor						Czech Pornographic actor	0
Adolf Řepa	male	Adolf	1896-06-23	teamster Czechoslovak legionary							0
Ignác Houška	male	Ignác	1914-01-24	official resistance fighter							0
Jiří Šustera	male	Jiří		drummer							0
Ivan Lytvynov	male		2000-07-12	ice hockey player						Ukrainian-Czech ice hockey player	0
Eva Vyplelová	female	Eva	1946-12-24	make-up artist wigmaker hairdresser							0
Niko Vangelis	male	Martin	1996-05-25	pornographic actor						Czech Pornographic actor	0
Roman West	male	Roman	1981-09-16	association football coach						Czech football coach	0
Martin Tučka	male	Martin	1980-11-15	mountaineer official	jo20241229616					Czech mountaineer and government official	0
Denisa Tomanová	female	Denisa		journalist translator						French-speaking Czech journalist	0
Jana Milec Jiřincová	female	Jana	1986-09-16	sport cyclist							0
Daniel Gracík	male	Daniel	2004-10-15	swimmer							3
Emiliia Okhrymovych-Holubovska	female	Emiliya	1903-05-30	painter						Ukrainian artist of decorative and applied arts	2
Tomáš Plhoň	male		1986	actor			63062				1
Magdaléna Jehlářová	female	Magdaléna	2000-01-16	volleyball player							1
Helena Tavelová	female	Helena		costume designer			364150				0
Ondřej Šošolík	male	Ondřej	1983-10-15	film editor			268305				0
Valentyna Kukova	female			show jumper							0
Ilona Sinzelle Poňavičová	female	Ilona		linguist librarian language teacher translator						Czech linguist	0
Martina Exnerová	female	Martina	2001-06-16	ice hockey player						Czech ice hockey player	0
Štěpánka Eibinová	female	Štěpánka	1994-07-26	ice hockey player						Czech ice hockey player	0
David Homer	male		1993-10-30	ice hockey player						Czech ice hockey player	1
Jan Vybíral	male	Jan		entomologist						Czech entomologist	1
Ondra Taryk	male	Daniel	1993-02-17	pornographic actor erotic photography model						Czech pornographic actor, CrossFit athlete, webcam and adult model.	0
Jana Václavíková	female			journalist						journalist in the Czech Republic	0
Edita Chrápavá	female	Edita	1999-04-03	swimmer						Czech swimmer	0
Jan Vianney Dohnal	male	Jan	1955-10-13	Latin Catholic priest religious							1
Milan Pastrňák	male	Milan	1961-12-09	ice hockey player						Czech ice hockey player	0
Michal Renok	male			pornographic actor						Czech pornographic actor	0
Denny Chriss	male	Dalibor	1983-01-24	pornographic actor disc jockey erotic photography model						Czech pornographic actor, disc jockey and adult model	0
Viktorie Bulínová	female	Viktorie	1998-04-21	Thai boxer kickboxer						Czech Muay Thai kickboxer	1

End of automatically generated list.

New Czech entities

Manually update list

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
ČSAD ÚAN Praha Florenc	business		former Czech company (1992-2000)	0
ČSAD ÚAN Praha Florenc	business		former Czech company (2000-2004)	0
Evanjelická škola Humpolec	school building			1
PRE CR Akviziční	business		Czech company	0
Rextim holding	business		Czech company	0
ČSAD Praha holding	business		Czech company	0
Mufloni v Thomayerově nemocnici	herd			1
Koně Převalského, Dívčí hrady	pen			1
Základní škola Zábřeh, Boženy Němcové 1503/15	primary school		Elementary school in Zábřeh, Czechia	0
Voice of Municipalities	political party		Czech political party	1
3.ZŠ Zábřeh	primary school		Elementary school in Zábřeh, Czechia	0
Válcový mlýn	watermill			1
Minizoo Kunratice, Praha	minizoo			1
kiosek ve Stromovce	building coffeehouse public toilet			1
Hujerova švestka	remarkable tree			1
Panskodomská čp. 651	house			1
Na Závodí čp. 631	villa			1
tenisová hala v Humpolci	indoor tennis venue			1
sokolovna v Humpolci	Sokol house structure not registered in RÚIAN			1
pekařství a cukrárna Adélka č. 515	bakery confectionery			1
Kaufland Humpolec	hypermarket			1
Sport bar Humpolec	bar			1
Restaurace s příběhem	restaurant			1
značková prodejna pivovaru Bernard	shop			1
Pizzeria Zanzi	pizzeria			1
Papa's Garden Restaurant	restaurant			1
kavárna U Janičky	coffeehouse			1
Hotel U Jiřího	hotel restaurant			1
Hospůdka Na Mlýnku	restaurant			1
Istanbul KEBAB PIZZA	snack bar			1
Hospůdka Zálesí	restaurant			1
Hospůdka Jiřická	restaurant			1
hotel Černý kůň	hotel restaurant			1
lékárna U Bílého anděla	house pharmacy			1
fontána na Dolním náměstí v Humpolci	fountain			1
Panský dům Humpolec	house			1
Komenského čp. 133	house			1
pomník rodného domu Aleše Hrdličky	monument place of birth			1
kulturní dům Humpolec	house of culture movie theater			1
Hotel Orlík - Jirmásek	hotel restaurant			1
hotel Kotyza	hotel restaurant			1
Hotel a konferenční centrum Fabrika	hotel convention center			1
Poliklinika čp. 389 Humpolec	policlinic			1
Poliklinika čp. 885 Humpolec	policlinic			1
Kozlovna Na Baronce	restaurant			1
informační terminál před poliklinikou v Humpolci	interactive kiosk			1
Hálkova čp. 1888	villa			1
Penzion Růže	building pension shop			1
Rodinné řeznictví Zajíček	butcher shop snack bar			1
hasičská stanice Humpolec	fire station			1
Podhrad čp. 1521	villa			1
Vrchnostenská punčochářská valcha Humpolec	factory			1
Aluminiová	fictional street			0
Ekocentrum Prales, Kbely	garden			1
The House of the Mother of the Suicide	sculpture		sculpture by John Hejduk	0
The House of the Suicide	sculpture		sculpture by John Hejduk	0
amyra	business	xx0319854		0
Cinema Svět	movie theater		cinema in Louny, Czech Republic	1
obecní studna Stračí	water well spring structure not registered in RÚIAN			1
požární nádrž ve Stračí	fire-fighting pond			1
Ptačí oblast Pálava	Special Protection Area			0
podchod pod ulicí Karla IV.	subway		underpass in Pardubice, Czechia	0
of the Seventh-day Adventist Church in Sedlčany	house house of prayer		prayer room in Sedlčany, Czechia	0
Sedlčany municipal police station	police station		municipal police in Sedlčany, Czechia	0
Brno Planet Festival	science festival			0
Bar u Albrechta	restaurant		restaurant in Budišov nad Budišovkou	0
SAM73	business online shop		online marketplace that provides leisure sports clothes	0
Obrázkový slovník moravskoslezského nářečí	bike path educational trail			2
labyrint Vyšehrad	labyrinth			0
St. Anna	church building destroyed building or structure			1
vysílač Tupadly	transmitter mast			1
Christuskirche	church building destroyed building or structure			1
Evangelische Kirche Smržovka	church building destroyed building or structure			1
restaurace Tupadly	restaurant			1
obecní úřad Tupadly	municipal building			1
zářez cesty k zámku Slavín	cut			1
pamětní deska Antonína Vorálka	commemorative plaque			0
Jesenická kyselka	Kyselka mineral water spring			2
Evangelische Kirche Věšťany	church building destroyed building or structure			1
Inspired by Sutnar	mural		mural in Plzeň	1
Plzeňská 5	building		building in Prague	0
A.LT Architekti	architectural firm		Czech architecture studio	1
BLUMI	business		Czech company	0
MyMozart	building		building in Prague	1
futurego	electric vehicle charging network		network of EV charging stations	0
Česká komora živnostníků	business			0
Night club Afrodita	nightclub			0
BM reality	business			0
MANAKO	business			0
Stolpersteine of Werfel family	stumbling stone		stolpersteine in Prague	0
Allegory of Machinery	statue		statue in Prague	0
Allegory of Construction	statue		statue in Prague	0
Allegory of Architecture	statue		statue in Prague	0
Česká komora firem a živnostníků	business			0
ČKFaŽ	business			0
Kříž severně od Libčic	wayside cross			0
socha svatého Huberta u Chotilska	statue			0
socha svatého Petra u Chotilska	statue			0
kaple v Korkyni	chapel			0
kříž v Korkyni	wayside cross			0

End of automatically generated list.