User:HLa01

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

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.

Helpful reading

Help:Ranking

Wikidata:WikiProject Municipalities of Germany/Taxonomy

User:Aeroid

rathaus (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)

Queries[edit]

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

subclass of (P279) representative assembly (Q2532278)[edit]

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)[edit]

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)[edit]

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)[edit]

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

list of public election (Q40231)[edit]

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)[edit]

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)[edit]

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)[edit]

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