Wikidata:WikiProject Czech Republic/Maintenance Queries

From Wikidata
Jump to navigation Jump to search

Home

 


Properties

 

Maintenance Queries

 

Showcase Queries

 

Interesting external databases

 

Events

 

Tools

 



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
Irena Storová female Irena pharmacist
official
manager
xx0224245 1
Jiří Engliš male Jiří 1960 translator mzk2003170389 Czech translator 0
Michal Kohút male Michal 2000-06-04 association football player Czech footballer 1
Milan Popelka male 1959-02-01 scenographer
visual artist
designer
illustrator
university teacher
painter
xx0257940 140619 0
Štěpánka Čechová female 1976-03-04 newspaper editor
reporter
press agent
xx0257923 0
Helena Hexnerová female 1972-07-13 architect
university teacher
ola20211105606 0
Radek Pohorský male 1969-08-22 manager
translator
xx0257828 0
Eva Pohlejová female teacher jo20211105421 0
Gabriela Těthalová female 1988-06-06 painter jo20211105411 0
Václav Křešnička male 1965-09-05 politician
writer
jo20211105373 0
Jaroslav Mičaník male 1924-11-16 trumpeter mzk20211105367 0
Miroslav Jaškovský male Miroslav 1926-06-02 konstruktér
mountaineer
2
Petr Kříž male 1992-07-09 publisher
designer
writer
xx0257786 0
Irena Pavelková female 1964-07-27 massage therapist
writer
hka20211105292 0
Lenka Kerdová female 1988-06-11 exhibition curator
visual artist
writer
hka20211105261 0
Jiří Bubeníček male Jiří 1958 photographer 1
Daniela Kuchtová female Daniela 0
Ivana Hronová female Ivana businessperson 0
Olga Chabr Grillová female Olga merchant
real estate developer
hotel manager
1
Radana Jařabáčová female 1957-03-12 painter mzk20211105186 0
Šimon Hlinovský male 1990-02-08 political scientist
journalist
mzk20211105066 0
Vít Kučera male 1988-04-19 lawyer hka20211104958 0
Barbora Rýdlová female 1976-10-23 economist
university teacher
hka20211104895 0
Iva Vašková female 1982-12-14 blogger
actor
xx0257623 0
Miriam Šumníková female 1979-03-28 ošetřovatel
blogger
poet
xx0257617 0
Kristýna Heroudková female 1991-03-26 biotechnologist xx0257616 0
Ilka Pacovská female 1954 librarian
writer
xx0149687 Czech librarian and writer 1
Jiří Vodrada male Jiří 1922-02-25 journalist xx0257581 0
Petra Roubalová female Petra 1990-03-12 graphic designer xx0257577 0
Jan Hromas male 1949-05-25 composer
musician
kapellmeister
singer
mzk2011636750 0
Karolína Urbánková female Karolína 1987-02-18 visual artist
illustrator
painter
xx0253638 0
Miroslav Dvořák male Miroslav 1998-12-18 association football player 1
Ondřej Čalovka male 1981-02-22 addictologist xx0257565 0
Lída Jakúbková female 1955-12-06 poet ola20211104669 0
Václav Poul male Václav 1951-08-20 puppeteer xx0257549 60124 0
Aneta Pijáčková female Aneta 2003-12-17 writer
teacher
jo20211104606 0
Martin Malina male Martin 1976-04-14 writer hka20211104590 0
Klaryče female 1989-11-08 painter xx0257522 0
Matoosh male 1985-08-15 economist
university teacher
teacher
jo20211104547 0
Karel Vaňura male Karel 1937-02-27 university teacher
painter
mzk20211104544 1517 0
Nataša Rybínová female 1923-10-02 dancer
ballet dancer
teacher
mzk20211104505 0
Zdeněk Pluhař male 1937-10-15 university teacher
physicist
uk20211104504 0
Zdeněk Bukáček male 1963-06-19 politician
writer
painter
av20211104482 0
Lubomír Filipec male Lubomír 1950 writer
poet
av20211104481 0
František Stoček male František 1957-11-23 translator
teacher
av20211104471 0
Daniela Messiereurová female Daniela 1966-07-30 painter hka20211104446 2962 0
Jan Kollár male 1991-01-23 pharmacist uk20211104442 0
Ladislav J. Janků male 1967-02-14 lawyer
teacher
hka20211104439 0
Margita Stehlíková female Margita YouTuber
influencer
2
Jiří Bosák male Jiří 1982 musician
lyricist
visual artist
animator
high school teacher
front person
accordionist
guitarist
2
Renata Kolibová female 1986-03-05 teacher ola20211104393 Czech teacher 0
Karel Tutsch male Karel 1941-12-05 gallerist js20080307002 28954 Czech gallerist 0
Jan Blüml male 1980 musicologist jo2008411540 150494 Czech musicologist 0
Antonín Koutný male Antonín 1977 video artist mzk2005272901 101670 Czech video artist 0
Kateřina Vokálová female Kateřina association football player Czech association football player 0
Aneta Malatová female Aneta association football player Czech association football player 0
Sára Vančurová female Sára 2001-07-20 association football player Czech association football player 0
Veronika Tůmová female Veronika 1993-06-05 association football player Czech association football player 0
Natália Skiba female 2004-10-24 association football player Czech association football player 0
Martina Mastníková female Martina 2001-04-03 association football player Czech association football player 0
Adéla Folprechtová female Adéla 2001-09-13 association football player Czech association football player 0
Veronika Černá female Veronika 1998-05-06 association football player Czech association football player 0
Marie Bohatová female Marie 1999-12-30 association football player Czech association football player 0
Kamila Švábová female Kamila 2000-06-14 association football player Czech association football player 0
Lucie Štichová female Lucie 2002-05-04 association football player Czech association football player 0
Daniela Prokopová female Daniela 1997-04-24 association football player Czech association football player 0
Barbora Polcarová female 2002-07-24 association football player Czech association football player 0
Simona Pacandová female 1996-10-03 association football player Czech association football player 0
Michaela Nesvedová female Michaela 1997-03-14 association football player Czech association football player 0
Eliška Němcová female 2001-06-28 association football player Czech association football player 0
Marie Mikešová female Marie 1998-06-10 association football player Czech association football player 0
Petra Markelová female Petra 1984-10-13 association football player Czech association football player 0
Lucie Knödlová female Lucie 1997-12-30 association football player Czech association football player 0
Adéla Horáčková female Adéla 2001-08-04 association football player Czech association football player 0
Jana Beštová female Jana 1993-08-25 association football player Czech association football player 0
Michaela Radová female Michaela 1998-04-30 association football player Czech association football player 0
Kristýna Pošvová female Kristýna 1992-03-30 association football player Czech association football player 0
Kristýna Mikulecká female Kristýna 2005-01-04 association football player Czech association football player 0
Bára Vrabcová female 2001-10-05 association football player Czech association football player 0
Martina Vlačihová female Martina 1993-02-14 association football player Czech association football player 0
Kristýna Růžičková female Kristýna 2002-11-05 association football player Czech association football player 0
Tereza Prokůpková female Tereza 2000-06-20 association football player Czech association football player 0
Dagmar Prášilová female 2000-02-13 association football player Czech association football player 0
Tereza Pavlasová female Tereza 2000-05-18 association football player Czech association football player 0
Bibiana Ninczová female 1988-06-16 association football player Czech association football player 0
Denisa Neradová female Denisa 2002-09-09 association football player Czech association football player 0
Kamila Martínková female Kamila 1995-09-13 association football player Czech association football player 0
Denisa Kupková female Denisa 1991-09-19 association football player Czech association football player 0
Silvia Kunáková female 1989-08-02 association football player Czech association football player 0
Barbora Kubečková female 1998-10-29 association football player Czech association football player 0
Adéla Kružíková female Adéla 2004-05-17 association football player Czech association football player 0
Sára Kabeláčová female Sára 1998-09-17 association football player Czech association football player 0
Veronika Hýlová female Veronika 2003-07-11 association football player Czech association football player 0
Kristýna Grundmannová female Kristýna 2002-03-25 association football player Czech association football player 0
Tereza Fialová female Tereza 2001-10-26 association football player Czech association football player 0
Dominika Černá female 1998-11-13 association football player Czech association football player 0
Tereza Prošková female Tereza 2002-05-03 association football player Czech association football player 0
Hana Pavlasová female Hana 2002-03-19 association football player Czech association football player 0
Michaela Novotná female Michaela 2001-09-06 association football player Czech association football player 0
Michaela Beránková female Michaela 1992-11-26 association football player Czech association football player 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
Depozitář Artex museum storage 0
bývalý klášter ve Frýdlantu nad Ostravicí building 1
Mezioborová skupina pro epidemické situace advisory council
task force
Czech advisory council 0
Brouskův mlýn watermill
sawmill
1
Bunkr Zkušební/VII/A bunker 0
Consortium of Migrants Assisting Organizations consortium umbrella organization that brings together non-governmental organizations, which either directly assist migrants or are involved in the integration of foreigners in other ways 0
Dolní Chřibská ev. č. 65 Upper Lusatian house 0
Online Encyclopedia of Migration, z.s. non-governmental organization
nonprofit organization
non-governmental non-profit organization 0
Dolní Chřibská 330 Upper Lusatian house 0
památník bezdomovecké osady Dýmová hora monument
stone
1
Sdružení knihoven ČR business 0
2008 World Orienteering Championships – Women's sprint orienteering competition 0
2008 World Orienteering Championships – Men's sprint orienteering competition 0
2008 World Orienteering Championships – Women's relay orienteering competition 0
2008 World Orienteering Championships – Men's relay orienteering competition 0
2008 World Orienteering Championships – Women's short distance orienteering competition 0
2008 World Orienteering Championships – Men's short distance orienteering competition 0
2008 World Orienteering Championships – Women's long distance orienteering competition 0
2008 World Orienteering Championships – Men's long distance orienteering competition 0
Bunkr VI./115a/A bunker 0
Dolní Chřibská 107 Upper Lusatian house 0
Column shrine "Kostelík" column shrine
pilgrimage site
Column shrine near Hrádek by Trhové Sviny 1
Jan Neruda plaque commemorative plaque 1
kynologické cvičiště dog sport 0
hospoda tavern 0
pomník monument 0
kříž wayside cross 0
zvonička small bell tower 0
mlýn watermill 0
jez weir 0
jez weir 0
hřbitov cemetery 0
Pomník monument 0
kaple chapel 0
kříž wayside cross 0
Stará myslivna hermitage 0
AMERFO o.p.s. obecně prospěšná společnost 0
Dolní Chřibská 124 Upper Lusatian house 0
Dolní Chřibská ev. č. 93 house
Vernacular architecture in the Czech Republic
0
Rothschildovy studny spring
well
2
Sportcentrum Duo sports venue
indoor swimming pool
health club
bowling alley
sports venue in Prague 0
plaque to Jaroslav Heyrovský commemorative plaque plaque in Prague 0
Seznam jezuitských institucí na Slovensku Wikimedia list article 1
Seznam jezuitských institucí v Česku Wikimedia list article 1
Dolní Chřibská 60 Upper Lusatian house 0
Dolní Chřibská 246 Upper Lusatian house 0
Dolní Chřibská ev. č. 18 Upper Lusatian house 0
Dolní Chřibská ev. č. 63 Upper Lusatian house 0
Dolní Chřibská ev. č. 33 Upper Lusatian house 0
Dolní Chřibská 149 Upper Lusatian house 0
Dolní Chřibská 150 Upper Lusatian house 0
Dolní Chřibská 154 Upper Lusatian house 0
Chlapec s rybou statue statue by Johann Adolf Mayerl 1
Dolní Chřibská 243 Upper Lusatian house 0
Dolní Chřibská 180 Upper Lusatian house 0
Dolní Chřibská 189 Upper Lusatian house 0
Dolní Chřibská 184 Upper Lusatian house 0
Dolní Chřibská ev. č. 71 Upper Lusatian house 0
Vysílač Bradlec transmitter station 1
Raněný statue statue in Velký Šenov 1
Na lhotech 34 building building in Prague 0
Maria column near Vojnice Maria column 1879 Maria column 1
Statue of Saint Hedwig in Orlová statue 1871 statue in Orlová 1
Statue of John of Nepomuk in Třebosice statue 1869 statue in Třebosice 1
Naučná stezka Les Svíb educational trail 1
Statue of Saint Mark in Vítkov statue 1861 statue in Vítkov 1
Sčítání lidu, domů a bytů 2001 v Česku census 1
kazatelská stanice Českobratrské církve evangelické v Radonicích nad Ohří kazatelská stanice 0
Česká demografická společnost organization
publisher
0
Markův mlýn watermill 2
Butovice fortified house
destroyed building or structure
1
Dolní Chřibská 192 Upper Lusatian house 0
Dolní Chřibská ev. č. 89 Upper Lusatian house 0
kříž Na Strážné wayside cross 0
Dolní Chřibská ev. č. 95 Upper Lusatian house 0
Dolní Chřibská 195 Upper Lusatian house 0
Dolní Chřibská 196 Upper Lusatian house 0
Golden Road part 3 long-distance trail
hiking trail
hiking trail in Germany and Czech Republic 0
Dolní Chřibská 193 Upper Lusatian house 0
Alej k lipám allée 2
Hubálka homestead
destroyed building or structure
1
E-Commerce and Media Investments business Czech holding company 0
Tymon business Czech holding company 0
Stadium Arcadium business Czech media company 0
Golden Road long-distance trail
hiking trail
hiking trail in Germany and Czech Republic 0
Dolní Chřibská 190 Upper Lusatian house 0
Dolní Chřibská 212 Upper Lusatian house 0
Dolní Chřibská 208 Upper Lusatian house 0
Dolní Chřibská 199 Upper Lusatian house 0
Chřibská 189 Upper Lusatian house 0
Kartotéka padlých v 1. světové válce fonds 0
Chřibská 180 house
Vernacular architecture in the Czech Republic
0
Chřibská 179 Upper Lusatian house 0
Svatojánská street 1
Kaple sv. Jana Nepomuckého v Příbrami chapel 1
Chřibská 175 Upper Lusatian house 0
Chřibská ev. č. 63 Upper Lusatian house 0
Chřibská 155 Upper Lusatian house 0
Chřibská ev. č. 33 Upper Lusatian house 0
Chřibská 3 Upper Lusatian house 0
End of automatically generated list.