Wikidata:WikiProject Czech Republic/Showcase Queries

From Wikidata
Jump to navigation Jump to search

Home

 


Properties

 

Maintenance Queries

 

Showcase Queries

 

Interesting external databases

 



Map of Czech castles[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

 1 # Map of Czech castles
 2 #defaultView:Map
 3 SELECT ?item ?itemLabel ?coord ?img ?styleLabel
 4 WHERE
 5 {
 6 	?item wdt:P31/wdt:P279* wd:Q23413 .
 7 	?item wdt:P17 wd:Q213 .
 8 	?item wdt:P625 ?coord .
 9 	OPTIONAL { ?item wdt:P18 ?img } .
10 	OPTIONAL { ?item wdt:P149 ?style } .
11 	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,cs,en". }
12 }

List of Czech companies[edit]

The following query uses these:

Parts of the cultural monument of the Prague Castle[edit]

The following query uses these:

Features: ImageGrid (Q24515278) View with Reasonator View with SQID

1 # Parts of the cultural monument of the Prague Castle 
2 #defaultView:ImageGrid
3 SELECT ?objectLabel ?img WHERE {
4   ?object p:P1435 [ ps:P1435 wd:Q30118385; pq:P642 wd:Q193369 ] .
5   ?object wdt:P625 ?coord .
6   ?object wdt:P18 ?img .
7   SERVICE wikibase:label { bd:serviceParam wikibase:language "cs" } .
8 }

Municipalities colour-coded by rising or falling population between 1930 and 1950[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

 1 # Municipalities colour-coded by rising or falling population between 1930 and 1950
 2 #defaultView:Map
 3 SELECT ?item ?coord ?populace1930 ?populace2001 ?prirustek (IF(?prirustek > 4, ">4x", IF(?prirustek > 3, ">3x", IF(?prirustek > 2, ">2x", IF(?prirustek > 1, ">1x", "prirustek")))) AS ?layer) WHERE {
 4   ?item wdt:P31 wd:Q5153359; wdt:P625 ?coord .
 5   ?item p:P1082 [ ps:P1082 ?populace1930; pq:P585 ?datum1930 ] .
 6   FILTER (YEAR(?datum1930) = 1930) .
 7   ?item p:P1082 [ ps:P1082 ?populace2001; pq:P585 ?datum2001 ] .
 8   FILTER (YEAR(?datum2001) = 1950) .
 9   BIND ( ?populace1930 / ?populace2001 AS ?prirustek ) .
10 }

Male/female ratio in Czech municipalities[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, population (P1082) View with Reasonator View with SQID, male population (P1540) View with Reasonator View with SQID, female population (P1539) View with Reasonator View with SQID
     1 #Male/female ratio in Czech municipalities
     2 #defaultView:BarChart
     3 SELECT DISTINCT ((?zeny / ?muzi) AS ?result) ?item ?itemLabel ?muzi ?zeny 
     4 WHERE
     5 {
     6     ?item wdt:P31 wd:Q5153359 .
     7     ?item p:P1082 ?populace .
     8     ?populace pq:P1540 ?muzi .
     9     ?populace pq:P1539 ?zeny .
    10     SERVICE wikibase:label { bd:serviceParam wikibase:language "cs"}
    11 }
    12 ORDER BY DESC(?result)
    13 LIMIT 50
    

Map of Czech villages with name ending with -no[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

 1 #Map of Czech villages with name ending with -no
 2 #defaultView:Map
 3 SELECT ?item ?itemLabel ?coord WHERE {
 4   ?item (wdt:P31/wdt:P279*) wd:Q486972.
 5   ?item wdt:P17 wd:Q213.
 6   ?item wdt:P625 ?coord.
 7   ?item rdfs:label ?itemLabel.
 8   FILTER((LANG(?itemLabel)) = "cs")
 9   FILTER(STRENDS(?itemLabel, "no"))
10 }

Number of descendants of Bořivoj I.[edit]

15734 📈
End of automatically generated list.