Wikipedia:Uploading metadata to Wikidata
QuickStatements can be used to upload metadata (such as area and population figures about populated places) to Wikidata. Templates such as {{Wikidata }} can be then used to retrieve the figures locally and feed them to fields in templates such as {{Infobox settlement }}.
Updating figures
[edit ]1. Updated population figures are usually published on the website of the national or local statistical office (in the example, the Statistik Austria website).
2a. A list of Wikidata properties for authority control for administrative subdivisions (lists all properties such as Swedish county code (P507), China administrative division code (P442), etc.) can be found Wikidata Query. For other countries, just replace 'P964' in the query with the property found in the previous step (e.g. Swiss municipality code (P771) for Swiss municipalities). See the list of 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. 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.
Austria example
[edit ]V1 syntax
[edit ]The example below uploads the updated population of Eisenstadt (Q126321) as of 1 January 2018, using the QuickStatements V1 syntax:
Q126321 P1082 14476 P585 +2018年01月01日T00: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月09日T00:00:00Z/11 S123 Q358870
csv syntax
[edit ]The same command, using the csv syntax:
qid,P1082,qal585,S854,s1476,s813,s123 Q126321,14476,+2018年01月01日T00: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月09日T00:00:00Z/11,Q358870
Note: csv commands cannot include commas.
This uploads this statement to the entity Eisenstadt (Q126321):
- population (P1082): 14476
this qualifier:
- point in time (P585): +2018年01月01日T00:00:00Z/11
and the following references:
- reference URL (P854): "https://www.statistik.at/web_de/klassifikationen/regionale_gliederungen/gemeinden/index.html"
- title (P1476): de:"Einwohnerzahl 1.1.2018 nach Gemeinden mit Status, Gebietsstand 1.1.2018"
- retrieved (P813): +2019年03月09日T00:00:00Z/11
- publisher (P123): Statistics Austria (Q358870)
Area
[edit ]The same procedure can be used to update the area figures:
qid,P2046,qal585,S854,s1476,s813,s123 Q126321,42.88U712226,+2018年01月01日T00: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月10日T00:00:00Z/11,Q358870
This uploads this statement to the entity Eisenstadt (Q126321):
this qualifier:
- point in time (P585): +2018年01月01日T00:00:00Z/11
and the following references:
- reference URL (P854): "http://www.statistik.at/web_de/klassifikationen/regionale_gliederungen/dauersiedlungsraum/index.html"
- title (P1476): de:"Dauersiedlungsraum der Gemeinden Politischen Bezirke und Bundesländer - Gebietsstand 1.1.2018"
- retrieved (P813): +2019年03月10日T00:00:00Z/11
- publisher (P123): Statistics Austria (Q358870)
Retrieving Wikidata figures to populate infoboxes
[edit ]The following wikicode would transclude population and area statistics as of 1 January 2018 to a Wikipedia article using {{Infobox Settlement }}:
| 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日}}
QID - subdivision key mappings
[edit ]- Austria:
- Municipalities: Austrian municipality key (P964): link to the query.
- France:
- Municipalities: INSEE municipality code (P374): link to the query.
- Germany:
- Municipalities: German municipality key (P439): link to the query.
- Italy:
- Municipalities, provinces and regions: ISTAT ID (P635): link to the query.
- Japan:
- Municipalities: dantai code (P429): link to the query.
- Spain:
- Municipalities: INE code (P772): link to the query.
- Switzerland:
- Municipalities and districts: Swiss municipality code (P771): link to the query.