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

city hall (Q543654) (Valderrobres town hall (Q5754700))

Märkischer Kreis (District council) (Q28654743)Edit

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)

QueriesEdit

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

subclass of (P279) representative assembly (Q2532278)Edit

The following query uses these:

  • Properties: subclass of (P279)    
    1 select ?item ?Label
    2 where 
    3 {
    4   ?item wdt:P279 wd:Q2532278 .
    5 	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,hu" . ?item rdfs:label ?Label }
    6 }
    

city council (Q3154693)Edit

city council (Q3154693)Edit

The following query uses these:

  • Properties: instance of (P31)    , applies to jurisdiction (P1001)    , official website (P856)    
     1 #Councils P1001
     2 SELECT ?item ?placeLabel ?LabelEN ?LabelDE ?Label (SAMPLE(?Website) AS ?Website)
     3 WHERE
     4 {
     5 	?item wdt:P31 wd:Q3154693 . #or wd:Q701632
     6 	OPTIONAL{?item wdt:P1001 ?place .}
     7     OPTIONAL{?place rdfs:label ?placeLabel .}
     8     OPTIONAL{?item wdt:P856 ?Website .}
     9 	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
    10 	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
    11 	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
    12 	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" 
    13  . ?item rdfs:label ?Label }
    14 }
    15 GROUP BY ?item ?placeLabel ?LabelEN ?LabelDE ?Label
    16 limit 500
    

The following query uses these:

  • Properties: instance of (P31)    
    1 #Languages
    2 select ?l ?Label
    3 where 
    4 {
    5   ?l wdt:P31 wd:Q315 .
    6 	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,hu,de" . ?l rdfs:label ?Label }
    7 }
    

representative assembly (Q2532278)

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

The following query uses these:

  • Properties: subclass of (P279)    
    1 select ?item ?Label
    2 where 
    3 {
    4   ?l wdt:P279 wd:Q2532278 .
    5 	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,hu" . ?l rdfs:label ?Label }
    6 }
    

Councils in Bergen, Norway (yearly)

The following query uses these:

  • Properties: instance of (P31)    , part of (P361)    , inception (P571)    , applies to jurisdiction (P1001)    , official website (P856)    , number of seats (P1342)    
     1 #Councils in Bergen, Norway P1001
     2 SELECT ?item ?inception ?place ?LabelEN ?LabelDE ?Label (SAMPLE(?Website) AS ?Website) (COUNT(?Website) AS ?nWebsites) (SAMPLE(?nSeats) AS ?nSeats)
     3 WHERE
     4 {
     5 	?item wdt:P31 wd:Q3154693 .
     6     ?item wdt:P361 wd:Q26793 .
     7     ?item wdt:P571 ?inception .
     8 	OPTIONAL{?item wdt:P1001 ?place .}
     9     #OPTIONAL{?place rdfs:label ?placeLabel .}
    10     OPTIONAL{?item wdt:P856 ?Website .}
    11     OPTIONAL{?item wdt:P1342 ?nSeats .}
    12 	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
    13 	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
    14 	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
    15 	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" 
    16  . ?item rdfs:label ?Label }
    17 }
    18 GROUP BY ?item ?inception ?place ?LabelEN ?LabelDE ?Label
    19 order by ?inception
    

municipal election (Q152450)Edit

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

The following query uses these:

  • Properties: instance of (P31)    , start time (P580)    , applies to jurisdiction (P1001)    , official website (P856)    , number of seats (P1342)    
     1 #municipal election
     2 SELECT ?item ?start ?place ?LabelEN ?LabelDE ?Label #(SAMPLE(?Website) AS ?Website) (COUNT(?Website) AS ?nWebsites) (SAMPLE(?nSeats) AS ?nSeats)
     3 WHERE
     4 {
     5 	?item wdt:P31 wd:Q152450 .
     6     OPTIONAL{?item wdt:P580 ?start .}
     7 	#OPTIONAL{?item wdt:P1001 ?place .}
     8     #OPTIONAL{?place rdfs:label ?placeLabel .}
     9     OPTIONAL{?item wdt:P856 ?Website .}
    10     OPTIONAL{?item wdt:P1342 ?nSeats .}
    11 	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
    12 	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
    13 	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
    14 	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" 
    15  . ?item rdfs:label ?Label }
    16 }
    

election (Q40231)Edit

list of election (Q40231)Edit

The following query uses these:

  • Properties: instance of (P31)    , start time (P580)    , applies to jurisdiction (P1001)    , official website (P856)    , number of seats (P1342)    
     1 #municipal election
     2 SELECT ?item ?start ?place ?LabelEN ?LabelDE ?Label #(SAMPLE(?Website) AS ?Website) (COUNT(?Website) AS ?nWebsites) (SAMPLE(?nSeats) AS ?nSeats)
     3 WHERE
     4 {
     5 	?item wdt:P31 wd:Q40231 .
     6     OPTIONAL{?item wdt:P580 ?start .}
     7 	#OPTIONAL{?item wdt:P1001 ?place .}
     8     #OPTIONAL{?place rdfs:label ?placeLabel .}
     9     OPTIONAL{?item wdt:P856 ?Website .}
    10     OPTIONAL{?item wdt:P1342 ?nSeats .}
    11 	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
    12 	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
    13 	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
    14 	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" 
    15  . ?item rdfs:label ?Label }
    16 }
    

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

The following query uses these:

  • Properties: subclass of (P279)    , country (P17)    , start time (P580)    , applies to jurisdiction (P1001)    
     1 #election types
     2 SELECT ?item ?start ?country ?countryLabel ?place ?placeLabel ?LabelEN ?LabelDE ?Label
     3 WHERE
     4 {
     5 	?item wdt:P279 wd:Q40231 .
     6     OPTIONAL{?item wdt:P17 ?country .}
     7     OPTIONAL{?item wdt:P580 ?start .}
     8 	OPTIONAL{?item wdt:P1001 ?place .}
     9     #OPTIONAL{?place rdfs:label ?placeLabel .}
    10 	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN . ?country rdfs:label ?countryLabel . ?place rdfs:label ?placeLabel } .
    11 	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
    12 	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" 
    13  . ?item rdfs:label ?Label }
    14 }
    15 ORDER BY ?countryLabel ?placeLabel ?item
    

legislature (Q11204)Edit

The following query uses these:

  • Properties: subclass of (P279)    , part of (P361)    
     1 #parliament legislature
     2 SELECT ?item ?LabelEN ?LabelDE ?Label
     3 WHERE
     4 {
     5 	?item wdt:P279 wd:Q11204 .
     6 	?item wdt:P279 wd:Q182985 .
     7 	?item wdt:P361 wd:Q7174 .
     8 	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
     9 	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
    10 	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" 
    11  . ?item rdfs:label ?Label }
    12 }
    

unicameral legislature (Q140247)Edit

The following query uses these:

  • Properties: instance of (P31)    , applies to jurisdiction (P1001)    , country (P17)    
     1 #unicameral parliament legislature
     2 #unicameral parliament legislature
     3 SELECT ?item ?applies_jurisdiction ?LabelEN ?LabelDE ?Label
     4 (GROUP_CONCAT(?applies_jurisdictionLabel; separator=", ") as ?applies_jurisdictionLabels)
     5 (GROUP_CONCAT(?countryLabel; separator=", ") as ?countryLabels)
     6 WHERE
     7 {
     8 	?item wdt:P31 wd:Q140247 .
     9     OPTIONAL{?item wdt:P1001 ?applies_jurisdiction .}
    10     OPTIONAL{?item wdt:P17 ?country .}
    11 	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
    12 	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
    13 	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" 
    14  . ?item rdfs:label ?Label . ?applies_jurisdiction rdfs:label ?applies_jurisdictionLabel . ?country rdfs:label ?countryLabel }
    15 }
    16 GROUP BY ?item ?applies_jurisdiction ?LabelEN ?LabelDE ?Label
    17 ORDER BY ?countryLabels ?item 
    18 #LIMIT 100
    

administrative unitsEdit

Places idEdit

Informativ/slicEdit

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

ExamplesEdit

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

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 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):

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) (Tehran City Council (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