Wikipedia:Uploading metadata to Wikidata

This is an information page.

It is not an encyclopedic article, nor one of Wikipedia's policies or guidelines; rather, its purpose is to explain certain aspects of Wikipedia's norms, customs, technicalities, or practices. It may reflect differing levels of consensus and vetting.

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}}.

Austria example

{{Austria metadata Wikidata}} works by checking if the Wikidata entity linked to the article has a population (P1082) statement dating to 1 January 2018 and sourced by an external reference (not imported from Wikimedia project (P143) or similar properties). If the condition is verified, the population figure is displayed.

Updating the figures

1. Updated population figures are published on the Statistik Austria website.

2. The mappings between Wikidata IDs for municipalities and municipality keys are available through this Wikidata Query. The two tables can 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.

V1 syntax

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

csv syntax

The same command, using the csv syntax:

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

This uploads this statement to the entity Eisenstadt (Q126321):

population (P1082): 14476

this qualifier:

point in time (P585): +2018-01-01T00: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-09T00:00:00Z/11
publisher (P123): Statistics Austria (Q358870)

Area

The same procedure can be used to update the area figures:

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