Wikidata:WikiProject Czech Republic/Maintenance Queries

From Wikidata
Jump to navigation Jump to search

Home

 


Czech Properties

 

Maintenance Queries

 

Showcase Queries

 

Interesting external databases

 

Events

 

Tools

 

Thematic areas

 

Projects

 




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!
#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 orcid discogs description Sitelinks
Magdaléna Jehlářová female Magdaléna 2000-01-16 volleyball player 1
Valentyna Kukova female show jumper 0
Jonáš Vala male Jonáš 2002 IT specialist IT specialist 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
Julian Fox male Dominik 1998-08-11 pornographic actor Czech pornographic actor and adult model. 0
Alena Marečková female Alena 1957-07-14 make-up artist
hairdresser
perukmakare
0
Drahomír Malovaný male Drahomír 1955-03-15 jx20080930052 Czech art teacher 0
Jiří Budín male Jiří 1935-10-17 make-up artist 0
Vladimír Kostínek male Vladimír 1949-03-19 disc jockey
presenter
Czech DJ 0
Vasil Simkovič male Vasil 1956 entrepreneur
sports fan
0
Adam Trunečka male Adam 1999-10-12 politician 1
Diana Bangoura female Diana 0
Vladimír Křešnička male Vladimír 1958-08-11 musician
school teacher
4156280 Czech musician, school teacher 0
Палуска, Ян 2005-06-23 1
Anna Mikulenková female Anna 1983 care worker
politician
0
Mariana Catwall female 1986 politician 0
Radka Miškovičová female 1977 economist
politician
0
Viera Hudečková female 1952 pensioner
politician
0
Lenka Goldšmídová female 1983 publisher
politician
0
Ivana Batthyany female 1985 care worker
politician
0
Anežka Michnová female 1990 politician 0
Markéta Juřicová female 2001 politician 0
Božena Jiříková female 1965 politician 0
Jaroslava Součková female 1966 economist
politician
0
Oldřiška Brandtlová female 1983 freelancer
politician
0
Jitka Kůtová female 1977 politician 0
Radmila Švejdová female 1970 economist
politician
0
Marcela Taubenhanslová female 1974 politician 0
Dana Hlouchová female 1980 politician 0
Karolína Lukavská female 1970 goldsmith
politician
0
Lenka Němcová female 1971 politician 0
Jana Slováková female 1960 freelancer
politician
0
Renata Vybíralová female 1973 politician 0
Jana Labudíková female 1971 politician 0
Renata Vikartová female 1953 animal protectionist
politician
0
Dana Doškářová female 1965 freelancer
politician
0
Romana Cerhová female 1966 politician 0
Adéla Cíchová female 1975 politician 0
Kateřina Křížová female 1981 politician 0
Nikola Vavřincová female 1994 politician 0
Lucie Vavříková female 1975 politician 0
Jana Johanidesová female 1979 animal protectionist
politician
0
Blanka Filipová female 1977 politician 0
Petra Bártová female 1964 jurist
politician
0
Oľga Bruncková female 1958 politician 0
Larisa Zankerová female 1980 politician 0
Vendula Wolfová female 1987 politician 0
Hana Janišová female 1962 politician 0
Anna Grabowská female 1959 expert witness
politician
0
Jaroslava Kamarytová Vršitá female 1988 politician 0
Tereza Čechová Humpolcová female 1987 politician 0
Kateřina Jirousová female 1988 politician 0
Renata Borecká female 1975 freelancer
politician
0
Jana Doležalová female 1965 politician 0
Marie Havránková female 1964 politician 0
Martina Doxanská female 1984 referent
politician
0
Dita Frantová female 1994 politician 0
Naděžda Holešová female 1974 nurse
politician
0
Lucie Červená Turzíková female 1988 politician 0
Monika Vymazalová female 1980 politician 0
Tereza Heczková female 2003 politician 0
Olga Schwarzerová female 1959 politician 0
Radka Březíková female 1981 politician 0
Olga Sejrková female 1981 politician 0
Zuzana Kudláčková female 1984 politician 0
Tereza Nislerová female 1984 politician 0
Eva Tichá female 1962 economist
politician
0
René Hladiš female 1977 businessperson
politician
0
Drahomíra Vokounová female 1968 politician 0
Alexandra Müllerová female 1983 politician 0
Veronika Saracino female 1976 politician 0
Simona Burešová female 1989 politician 0
Petra Šrámková Harantová female 1976 lawyer
politician
0
Andrea Lorková female 1977 politician 0
Adriana Chochelová female 1998 politician 0
Eva Volfová female 1979 politician 0
Alžběta Kálalová female 1992 politician 0
Věra Nenutilová female 1959 lawyer
politician
0
Ján Chlebo female 1958 politician 0
Monika Kaucká Hermannová female 1987 politician 0
Lenka Desatová female 1971 politician 0
Irena Steinhauserová female 1961 politician 0
Kateřina Bočková female 1977 politician 0
Ivana Burešová Marková female 1976 politician 0
Veronika Blažková female 1981 politician 0
Petra Křenková female 1978 laborer
politician
0
Dagmar Kornaková female 1973 chauffeur
politician
0
Veronika Khol female 1984 politician 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
Bývalá židovská škola v Kolíně Jewish school
former school building
0
kříž wayside cross 0
Silhouette of Karlov, Slovany and Vyšehrad sculpture sculpture in Prague 0
Obchodní zóna Krkonošská shopping center shopping center in Trutnov 1
Průmyslová zóna Krkonošská industrial zone industrial zone in Trutnov 1
Hitachi Energy factory, Průmyslová 137 factory factory in Trutnov 0
Kaple Zmrtvýchvstání Páně chapel xx0318169 0
Jakubisko Film film production company 0
J&J Jakubisko Film Europe film production company 0
Usedlost čp. 22 v Pavlovicích homestead 0
Atelier Tsunami architectural firm Czech architecture studio 1
Průmyslová 166 building building in Trutnov 0
Casia logistics building building building in Trutnov 0
LaConex logistics complex building building in Trutnov 0
Rabínský dům v Kolíně rabbi's house 0
Vinohrad souznění garden
vineyard
memory space
0
Sdružení soukromých gynekologů České republiky business Czech voluntary association 0
BD Škrochova business 0
DVR Investment business 0
Odbor archiv bezpečnostních složek Ministerstva vnitra ČR publisher 0
Lijst van voetbalinterlands Bosnië en Herzegovina - Tsjechië (vrouwen) Wikimedia list article Wikimedia list article 1
Plaque to Růžena Vacková commemorative plaque plaque in Prague 0
Cena města Veselí nad Moravou award 0
Doupě online magazine
magazine
1
kříž v remízku u Lukova wayside cross 0
památník Miroslava Přibila a Stanislava Štěpanovského v Lukově memorial 0
třetí památník v Lukově memorial 0
železniční přejezd P3980 Kozelkovy ulice v Chlumci nad Cidlinou level crossing 1
mokřadní biotop v Lesůňkách fish pond 0
Ústecké pivovary business former Czech brewing company 0
Pivovar Velké Březno brewery
building complex
mzk2013800705 Czech brewery 2
Dětřichov 8 Upper Lusatian house Upper Lusatian house in Dětřichov 0
Liga proti rakovině organization 0
League Against Cancer Prague organization 0
Fountain at Vila Na Libušince fountain fountain in Prague 0
nature of the Czech Republic nature 1
Mlýn Bahýnko watermill 0
kostel svatého Matouše church building 0
Kluk 5 Upper Lusatian house Upper Lusatian house in Kluk 0
Centrum ambulantní gynekologie a primární péče business 0
Cerná Svatý Petr piste 1
hotel na hlavním nádraží v Pardubicích hotel building 0
bývalá nádražní budova v Pardubicích station building 0
2024 Pardubice train accident train wreck train crash in the Czech Republic 4
NK Langa business pna20241227243 0
Silniční most ve Slaném road bridge 0
Hostivařský parní mlýn building
steam mill
0
Česká Asociace Dětských Bobath Terapeutů professional association 0
B & M Music spol. s r.o. business
record company
ko2002150854 Czech record company 0
městský hřbitov v Lovosicích cemetery 0
Ústav pro výzkum, výrobu a využití radioizotopů research institute
defunct organization
kn20051006025
ko2005304163
0
Apartmány Liška lodging accommodation facility in Trutnov District 0
Apartmány Hrádeček building complex building complex in Mladé Buky (Trutnov District) 0
Hlubocké obory Special Protection Area 1
Bridge over Úpa in Mladé Buky road bridge bridge in Trutnov District 0
Bridge of I/14 road over Úpa in Mladé Buky road bridge bridge in Trutnov District 0
Bridge of I/14 road in Javorník (east of house no. 152) road bridge bridge in Trutnov District 0
Bridge of I/14 road in Javorník (west of house no. 152) road bridge bridge in Trutnov District 0
Wayside cross in Hertvíkovice (near house no. 70) wayside cross cross in Trutnov District 0
Bridge of I/14 road over Žabí potok in Hertvíkovice road bridge bridge in Trutnov District 0
Bridge over Žabí potok in Hertvíkovice road bridge bridge in Trutnov District 0
Čermákova stezka educational trail
marked hiking route
2
Pérovna Hostivař factory 0
ohradní zeď wall 0
stodola fary barn 0
fara clergy house 0
areál kostela Povýšení svatého Kříže building complex 0
Za sklem business mzk20241227022 0
ATYP business mzk20241227008 0
Kozinec hill 0
věžová trafostanice ve Vodárenské ulici distribution substation
structure not registered in RÚIAN
1
věžová trafostanice v Havlíčkově ulici distribution substation 1
radnice v Týnci nad Labem rathaus 1
Podskalský mlýn watermill
factory
1
Masarykovo náměstí čp. 89 house 1
Masarykovo náměstí čp. 88 house 1
Masarykovo náměstí čp. 86 house 1
Masarykovo náměstí čp. 73 house 1
Masarykovo náměstí čp. 66 house 1
hostinec U Buřivalů restaurant 1
hospoda U Labe restaurant 1
Beseda building 1
alegorie zemědělské práce statue 0
alegorie průmyslové práce statue 0
bývalá spořitelna v Týnci nad Labem house 1
busta Aloise Rašína na budově bývalé spořitelny v Týnci nad Labem bust 1
kamenný stolec pod Melasovým kaštanem picnic table 0
hrob generála Michaela von Melasa grave 1
Synagoga ve Fryštátě synagogue 1
miniatura hradu před děkanstvím v Týnci nad Labem sculpture
model
1
Anphysia business Czech company 0
ZAT 41 business Czech company 0
Žatecká 4 building 1
Lípa u příležitosti 100 let vzniku Československa, Kružberk tilia of liberty tilia of liberty, Kružberk, Opava District, Czech Republic 1
Bethlehem Chapel building complex 0
Dostavba Náprstkova muzea building 1
Dům U zlaté váhy building 1
Přírodní park Melechov nature park in the Czech Republic 0
pamětní kámen na hoře Tábor memorial stone
pamětní deska projektu Bojovníci boží - 600 let
0
kříž na domě čp. 18 v Šebkovicích wayside cross 0
End of automatically generated list.