View source for IxWiki:Uploading metadata to Wikidata

{{Information page}}

'''[[:wikidata:Help:QuickStatements|QuickStatements]]''' can be used to upload metadata (such as area and population figures about populated places) to Wikidata. Templates such as {{tl|Wikidata}} can be then used to retrieve the figures locally and feed them to fields in templates such as {{tl|Infobox settlement}}.

== Updating figures==
<div style="width:96%; margin:0 auto; padding:0.2em; border:1px solid grey; background-color:#F0FFF8;">
1. Updated population figures are usually published on the website of the national or local [[List of national and international statistical services|statistical office]] (in the example, the [https://www.statistik.at/web_de/klassifikationen/regionale_gliederungen/gemeinden/index.html Statistik Austria] website).

2a. A list of Wikidata properties for authority control for administrative subdivisions (lists all properties such as {{wpl|P507}}, {{wpl|P442}}, etc.) can be found [https://www.wikidata.org/w/index.php?title=Special%3AWhatLinksHere&target=Q55977691&namespace=120 here]. 

2b. The mappings between Austrian Wikidata IDs for municipalities and municipality keys are available through this [https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP964%20%3Fsubdivision_key.%20%7D%0A%7D Wikidata Query]. For other countries, just replace 'P964' in the query with the property found in the previous step (e.g. {{wpl|P771}} for Swiss municipalities). See the list of [[#QID - subdivision key mappings|QID - subdivision key mappings]] below.

2c. The two tables can then be linked through the [[VLOOKUP]] function in Excel (or any other spreadsheet program). 

3. [https://tools.wmflabs.org/quickstatements/#/batch QuickStatements] can be used to rapidly upload hundreds of statements in one go. Choosing the 'Run in background' option is advised, so that the process will continue even if the browser window crashes or is closed.
</div>

===Austria example===

====V1 syntax====
The example below uploads the updated population of {{Q|126321}} as of 1 January 2018, using the QuickStatements V1 syntax:

<pre><nowiki>
Q126321	P1082	14476	P585	+2018-01-01T00:00:00Z/11	S854	"https://www.statistik.at/web_de/klassifikationen/regionale_gliederungen/gemeinden/index.html"	S1476	de:"Einwohnerzahl 1.1.2018 nach Gemeinden mit Status, Gebietsstand 1.1.2018"	S813	+2019-03-09T00:00:00Z/11	S123	Q358870
</nowiki></pre>

====csv syntax====
The same command, using the csv syntax:

<pre><nowiki>
qid,P1082,qal585,S854,s1476,s813,s123
Q126321,14476,+2018-01-01T00:00:00Z/11,""""https://www.statistik.at/web_de/klassifikationen/regionale_gliederungen/gemeinden/index.html",de:"Einwohnerzahl 1.1.2018 nach Gemeinden mit Status Gebietsstand 1.1.2018",+2019-03-09T00:00:00Z/11,Q358870
</nowiki></pre>

'''Note''': csv commands cannot include commas.

This uploads this statement to the entity {{Q|126321}}:
* {{wpl|P1082}}: 14476

this qualifier:
* {{wpl|P585}}: +2018-01-01T00:00:00Z/11

and the following references:
* {{wpl|P854}}: "https://www.statistik.at/web_de/klassifikationen/regionale_gliederungen/gemeinden/index.html"
* {{wpl|P1476}}: de:"Einwohnerzahl 1.1.2018 nach Gemeinden mit Status, Gebietsstand 1.1.2018"
* {{wpl|P813}}: +2019-03-09T00:00:00Z/11
* {{wpl|P123}}: {{Q|358870}}

====Area====
The same procedure can be used to update the area figures:
<pre><nowiki>
qid,P2046,qal585,S854,s1476,s813,s123
Q126321,42.88U712226,+2018-01-01T00:00:00Z/11,""""http://www.statistik.at/web_de/klassifikationen/regionale_gliederungen/dauersiedlungsraum/index.html",de:"Dauersiedlungsraum der Gemeinden Politischen Bezirke und Bundesländer - Gebietsstand 1.1.2018",+2019-03-10T00:00:00Z/11,Q358870
</nowiki></pre>

This uploads this statement to the entity {{Q|126321}}:
* {{wpl|P2046}}: 42.88 {{Q|712226}}

this qualifier:
* {{wpl|P585}}: +2018-01-01T00:00:00Z/11

and the following references:
* {{wpl|P854}}: "http://www.statistik.at/web_de/klassifikationen/regionale_gliederungen/dauersiedlungsraum/index.html"
* {{wpl|P1476}}: de:"Dauersiedlungsraum der Gemeinden Politischen Bezirke und Bundesländer - Gebietsstand 1.1.2018"
* {{wpl|P813}}: +2019-03-10T00:00:00Z/11
* {{wpl|P123}}: {{Q|358870}}

==Retrieving Wikidata figures to populate infoboxes==
The following wikicode would transclude population and area statistics as of 1 January 2018 to a Wikipedia article using {{tl|Infobox Settlement}}:

<pre><nowiki>
| population_footnotes  = {{wikidata|reference|P1082|P585=2018-01-01}}
| population_total = {{wikidata|property|raw|P1082|P585=2018-01-01}}

| area_footnotes   = {{wikidata|reference|P2046|P585=2018-01-01}}
| area_total_km2   = {{wikidata|property|raw|P2046|P585=2018-01-01}}
</nowiki></pre>

==QID - subdivision key mappings==
{{Expand list|date=April 2019}} 
* Austria:
** Municipalities: {{wpl|P964}}: [https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP964%20%3Fsubdivision_key.%20%7D%0A%7D link to the query].
* France:
** Municipalities: {{wpl|P374}}: [https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP374%20%3FMunicipality_key.%20%7D%0A%7D link to the query].
* Germany:
** Municipalities: {{wpl|P439}}: [https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP439%20%3Fsubdivision_key.%20%7D%0A%7D link to the query].
* Italy:
** Municipalities, provinces and regions: {{wpl|P635}}: [https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP635%20%3Fsubdivision_key.%20%7D%0A%7D link to the query].
* Japan:
** Municipalities: {{wpl|P429}}: [https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP429%20%3Fsubdivision_key.%20%7D%0A%7D link to the query].
* Spain:
** Municipalities: {{wpl|P772}}: [https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP772%20%3Fsubdivision_key.%20%7D%0A%7D link to the query].
* Switzerland:
** Municipalities and districts: {{wpl|P771}}: [https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP771%20%3Fsubdivision_key.%20%7D%0A%7D link to the query].

==See also==
* [[:wikidata:Help:QuickStatements|QuickStatements guide]]
* [https://query.wikidata.org/#PREFIX%20xsd%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0A%0ASELECT%20%3Fmunicipality_of_Austria%20%3Fmunicipality_of_AustriaLabel%20%3Fpopulation%20%3Farea%20%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%20%20%3Fmunicipality_of_Austria%20wdt%3AP964%20%5B%5D.%0A%20%20%3Fmunicipality_of_Austria%20p%3AP1082%20_%3Ab2.%0A%20%20_%3Ab2%20ps%3AP1082%20%3Fpopulation.%0A%20%20_%3Ab2%20pq%3AP585%20%3FpopDate.%0A%20%20FILTER%28%3FpopDate%20%3D%20%222018-01-01T00%3A00%3A00Z%22%5E%5Exsd%3AdateTime%29%0A%20%20%3Fmunicipality_of_Austria%20p%3AP2046%20%3FareaSt.%0A%20%20%3FareaSt%20ps%3AP2046%20%3Farea.%0A%20%20%3FareaSt%20pq%3AP585%20%3FareaDate.%0A%20%20FILTER%28%3FareaDate%20%3D%20%222018-01-01T00%3A00%3A00Z%22%5E%5Exsd%3AdateTime%29%0A%7D Austrian municipalities with population and area as of 2018-01-01] - Wikidata Query

[[Category:Wikidata]]
[[Category:Template:Metadata Population| ]]