HLa01

Adding council Websites into Wikidata while making them accessible for other Bots.

Babel user information
hu-1 Ez a szerkesztő alapszinten beszéli a magyar nyelvet. en-2 This user has intermediate knowledge of English. de-2 Dieser Benutzer beherrscht Deutsch auf fortgeschrittenem Niveau. fr-1 Cet utilisateur dispose de connaissances de base en français.
Users by language

Helpful reading

Help:Ranking

Wikidata:WikiProject Municipalities of Germany/Taxonomy

User:Aeroid

rathaus (Q543654) (Valderrobres town hall (Q5754700))

Märkischer Kreis (District council) (Q28654743)

Hello, what's the use of this item? it is not linked from anywhere, and both descriptions (German, English) have errors. Holger1959 (talk) 17:09, 5 February 2017 (UTC)

@Holger1959:

• Usage

I'm aiming for the automated collection of council data like the data Märkischer_Kreis#Politics_and_administration. HLa01 (talk)

• Description Errors

On the Website of the council heading "Kreistagsinformationssystem" i concluded it's an district council. On the other hand on Märkischer Kreis (Q5937) it's name is rural district council. HLa01 (talk) 02:58, 30 March 2017 (UTC)

Queries

https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/P991

subclass of (P279) representative assembly (Q2532278)

The following query uses these:

• Items: representative assembly (Q2532278)   

• Properties: subclass of (P279)   

  select ?item ?Label
  where 
  {
    ?item wdt:P279 wd:Q2532278 .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,hu" . ?item rdfs:label ?Label }
  }
  

Try it!

city council (Q3154693)

city council (Q3154693)

The following query uses these:

• Items: city council (Q3154693)   , municipal council (Q701632)   

• Properties: instance of (P31)   , applies to jurisdiction (P1001)   , official website (P856)   

  #Councils P1001
  SELECT ?item ?placeLabel ?LabelEN ?LabelDE ?Label (SAMPLE(?Website) AS ?Website)
  WHERE
  {
  	?item wdt:P31 wd:Q3154693 . #or wd:Q701632
  	OPTIONAL{?item wdt:P1001 ?place .}
      OPTIONAL{?place rdfs:label ?placeLabel .}
      OPTIONAL{?item wdt:P856 ?Website .}
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
   . ?item rdfs:label ?Label }
  }
  GROUP BY ?item ?placeLabel ?LabelEN ?LabelDE ?Label
  limit 500
  

Try it!

The following query uses these:

• Items: language (Q315)   

• Properties: instance of (P31)   

  #Languages
  select ?l ?Label
  where 
  {
    ?l wdt:P31 wd:Q315 .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,hu,de" . ?l rdfs:label ?Label }
  }
  

Try it!

representative assembly (Q2532278)

council (Q4358176), representative assembly (Q2532278), "District council"(missing)

The following query uses these:

• Items: representative assembly (Q2532278)   

• Properties: subclass of (P279)   

  select ?item ?Label
  where 
  {
    ?l wdt:P279 wd:Q2532278 .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,hu" . ?l rdfs:label ?Label }
  }
  

Try it!

Councils in Bergen, Norway (yearly)

The following query uses these:

• Items: city council (Q3154693)   , Bergen (Q26793)   

• Properties: instance of (P31)   , part of (P361)   , inception (P571)   , applies to jurisdiction (P1001)   , official website (P856)   , number of seats (P1342)   

  #Councils in Bergen, Norway P1001
  SELECT ?item ?inception ?place ?LabelEN ?LabelDE ?Label (SAMPLE(?Website) AS ?Website) (COUNT(?Website) AS ?nWebsites) (SAMPLE(?nSeats) AS ?nSeats)
  WHERE
  {
  	?item wdt:P31 wd:Q3154693 .
      ?item wdt:P361 wd:Q26793 .
      ?item wdt:P571 ?inception .
  	OPTIONAL{?item wdt:P1001 ?place .}
      #OPTIONAL{?place rdfs:label ?placeLabel .}
      OPTIONAL{?item wdt:P856 ?Website .}
      OPTIONAL{?item wdt:P1342 ?nSeats .}
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
   . ?item rdfs:label ?Label }
  }
  GROUP BY ?item ?inception ?place ?LabelEN ?LabelDE ?Label
  order by ?inception
  

Try it!

municipal election (Q152450)

https://en.wikipedia.org/wiki/Category:Local_and_municipal_elections

The following query uses these:

• Items: municipal election (Q152450)   

• Properties: instance of (P31)   , start time (P580)   , applies to jurisdiction (P1001)   , official website (P856)   , number of seats (P1342)   

  #municipal election
  SELECT ?item ?start ?place ?LabelEN ?LabelDE ?Label #(SAMPLE(?Website) AS ?Website) (COUNT(?Website) AS ?nWebsites) (SAMPLE(?nSeats) AS ?nSeats)
  WHERE
  {
  	?item wdt:P31 wd:Q152450 .
      OPTIONAL{?item wdt:P580 ?start .}
  	#OPTIONAL{?item wdt:P1001 ?place .}
      #OPTIONAL{?place rdfs:label ?placeLabel .}
      OPTIONAL{?item wdt:P856 ?Website .}
      OPTIONAL{?item wdt:P1342 ?nSeats .}
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
   . ?item rdfs:label ?Label }
  }
  

Try it!

public election (Q40231)

• public election (Q40231) -> municipal election (Q152450)

list of public election (Q40231)

The following query uses these:

• Items: public election (Q40231)   

• Properties: instance of (P31)   , start time (P580)   , applies to jurisdiction (P1001)   , official website (P856)   , number of seats (P1342)   

  #municipal election
  SELECT ?item ?start ?place ?LabelEN ?LabelDE ?Label #(SAMPLE(?Website) AS ?Website) (COUNT(?Website) AS ?nWebsites) (SAMPLE(?nSeats) AS ?nSeats)
  WHERE
  {
  	?item wdt:P31 wd:Q40231 .
      OPTIONAL{?item wdt:P580 ?start .}
  	#OPTIONAL{?item wdt:P1001 ?place .}
      #OPTIONAL{?place rdfs:label ?placeLabel .}
      OPTIONAL{?item wdt:P856 ?Website .}
      OPTIONAL{?item wdt:P1342 ?nSeats .}
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
   . ?item rdfs:label ?Label }
  }
  

Try it!

subclass of (P279)(aka typs) public election (Q40231)

The following query uses these:

• Items: public election (Q40231)   

• Properties: subclass of (P279)   , country (P17)   , start time (P580)   , applies to jurisdiction (P1001)   

  #election types
  SELECT ?item ?start ?country ?countryLabel ?place ?placeLabel ?LabelEN ?LabelDE ?Label
  WHERE
  {
  	?item wdt:P279 wd:Q40231 .
      OPTIONAL{?item wdt:P17 ?country .}
      OPTIONAL{?item wdt:P580 ?start .}
  	OPTIONAL{?item wdt:P1001 ?place .}
      #OPTIONAL{?place rdfs:label ?placeLabel .}
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN . ?country rdfs:label ?countryLabel . ?place rdfs:label ?placeLabel } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
   . ?item rdfs:label ?Label }
  }
  ORDER BY ?countryLabel ?placeLabel ?item
  

Try it!

legislature (Q11204)

• https://en.wikipedia.org/wiki/Legislature (Infobox [chambers [form of election])
• Category:Legislature stubs (Q8586964) (TODO)
• parliament (Q35749) <-> council (Q4358176) <-> city council (Q3154693) <-> municipal election (Q152450) (TODO show / maybe wrong items?...)

The following query uses these:

• Items: legislature (Q11204)   , electoral system (Q182985)   , democracy (Q7174)   

• Properties: subclass of (P279)   , part of (P361)   

  #parliament legislature
  SELECT ?item ?LabelEN ?LabelDE ?Label
  WHERE
  {
  	?item wdt:P279 wd:Q11204 .
  	?item wdt:P279 wd:Q182985 .
  	?item wdt:P361 wd:Q7174 .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
   . ?item rdfs:label ?Label }
  }
  

Try it!

unicameralism (Q140247)

The following query uses these:

• Items: unicameralism (Q140247)   

• Properties: instance of (P31)   , applies to jurisdiction (P1001)   , country (P17)   

  #unicameral parliament legislature
  #unicameral parliament legislature
  SELECT ?item ?applies_jurisdiction ?LabelEN ?LabelDE ?Label
  (GROUP_CONCAT(?applies_jurisdictionLabel; separator=", ") as ?applies_jurisdictionLabels)
  (GROUP_CONCAT(?countryLabel; separator=", ") as ?countryLabels)
  WHERE
  {
  	?item wdt:P31 wd:Q140247 .
      OPTIONAL{?item wdt:P1001 ?applies_jurisdiction .}
      OPTIONAL{?item wdt:P17 ?country .}
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
   . ?item rdfs:label ?Label . ?applies_jurisdiction rdfs:label ?applies_jurisdictionLabel . ?country rdfs:label ?countryLabel }
  }
  GROUP BY ?item ?applies_jurisdiction ?LabelEN ?LabelDE ?Label
  ORDER BY ?countryLabels ?item 
  #LIMIT 100
  

Try it!

administrative units

• KOATUU ID (P1077)
• CANTIC ID (former scheme) (P1273) (León City Council (Q5714869))
• VIAF ID (P214) (Seattle City Council (Q7442079))
• Library of Congress authority ID (P244) (Los Angeles City Council (Q1870447))
• National Library of Spain ID (P950) (Seville City Council (Q8210808))
• GND ID (P227) (Seville City Council (Q8210808))
• Union List of Artist Names ID (P245) (Seville City Council (Q8210808))
• CANTIC ID (former scheme) (P1273) (Seville City Council (Q8210808))
• CCAB ID (P1890) (Seville City Council (Q8210808))
• Inventari del Patrimoni Arquitectònic de Catalunya code (P1600) (Palafrugell Town Hall (Q11904557))
• German municipality key (P439)

Places id

• WOEID (P1281) (Traunstein (Q253119))
• GeoNames ID (P1566) (Traunstein (Q253119))
• OpenStreetMap relation ID (P402) (Traunstein (Q253119))
• Treccani ID (P3365) (Kerch (Q157065))

Informativ/slic

https://www.boston.gov/departments/city-council

Examples

city commission government (Q19592272) -> city council (Q3154693) (Phoenix City Council (Q7186810))

• -> municipal council (Q701632) (Alytus city council (2003-2007) (Q16443575))

Baltimore (Q5092) -> legislative body (P194): Baltimore City Council (Q4852810)

Stadtrat von Bakersfield im US-Bundesstaat Kalifornien

Stadtrat in Burlington in der kanadischen Provinz Ontario

https://en.wikipedia.org/wiki/Baltimore_City_Archives

Vote Smart candidate ID (P3344)

Palafrugell (Q13490) -> Palafrugell Town Hall (Q11904557) -> Palafrugell city council (Q28004656) -> city councillor of Palafrugell (Q27949864) -> mayor of Palafrugell (Q26690869) (list of mayors of Palafrugell (Q11932440))

electoral system (Q182985) -> ranked voting (Q1078003):

• at-large (Q3682992) (Boise City Council (Q4938444)) (TODO: make SPARQL query)
• plurality block voting (Q2746726) (Phoenix City Council (Q7186810))
• unicameralism (Q140247) (Islamic City Council of Tehran (Q5123141))
• single-member district (Q1052894) (Cleveland City Council (Q5132092))
  • mayor–council government (Q3308596) (Houston City Council (Q5916428))
  • council–manager government (Q946819) ()
  • unicameralism (Q140247) (Kyiv City Council (Q4220207))
• instant-runoff voting (Q1491219) (Minneapolis City Council (Q6867972))
• nonpartisanism (Q7049542) (Omaha City Council (Q7089412))
• unicameralism (Q140247) (Omaha City Council (Q7089412))

mayor–council government (Q3308596)

Commons Institution page (P1612) (TODO: make SPARQL query)

https://en.wikipedia.org/wiki/Ontario_municipal_elections,_2006#External_links via https://en.wikipedia.org/wiki/Burlington_City_Council

Cape Town City Council (Q5035091): https://www.westerncape.gov.za/your_gov/33

native label (P1705) (Islamic City Council of Tehran (Q5123141) (TODO: make SPARQL query)

member states of the United Nations (Q160016) (Monaco (Q235))

Edmonton City Council (Q5339025), Bucharest (Q19660) (Nice)

https://en.wikipedia.org/wiki/Category:City_councils