Wikipedia georeferenced articles

New: The datasets have been updated with the latest DBPedia release, based on Wikipedia dumps dating July 2011

The Wikipedia articles can include a geographic location. In this page you can find datasets and services ready to be used in spatial applications.

All datasets were extracted from the DBpedia Geographic Coordinates dataset corresponding to the English version of Wikipedia. The original Wikipedia dump from where it was derived was generated on July 2011.

The latest version includes around 442.000 articles. If you need more complete and updated datasets, you can have a look at the Wikipedia-World project. It aggregates geographic information from all Wikipedia versions and provide services to query it, as well as data dumps.

Datasets

• CSV

  Good old Comma Separated Values. Light and flexible.

  tar.bz2 (9.3 MB) | zip (12.2 MB)
• Shapefile

  Shapefiles are widely supported in GIS applications.

  tar.bz2 (11.5 MB) | zip (16.8 MB)
• PostGIS SQL script

  Ready to be imported into a spatial enabled PostGIS database.

  tar.bz2 (10.6 MB) | zip (14.4 MB)

Services

• WMS

  The Web Map Service is an open standard for serving mapped data. It is commonly supported, both in javascript clients like OpenLayers or desktop applications like Quantum GIS or gvSIG.

  Service URL: http://flentic.net/wms/wikipedia (Capabilities 1.3.0 | Capabilities 1.1.1)
• Google Fusion Tables

  The dataset has been uploaded to Google Fusion Tables, but only around 51.000 records have been imported. Still, it is a good dataset to try its functionalities, which include linking with other datasets, heat maps or spatial queries.

  URL: http://www.google.com/fusiontables/DataSource?dsrcid=2148154

Licence

All datasets are licensed under the same terms of the original DBpedia datasets, that is the Creative Commons Attribution-ShareAlike License and the GNU Free Documentation License.

Known issues

• Remember, the articles were extracted on March 2010. The datasets may not reflect the current location of the articles, or even existing articles.
• Obviously, some articles are wrongly located, they just reflect the coordinates that the original Wikipedia editor entered.
• There are some articles, like Apollo 11 or Olympus Mons that have geographic coordinates, but are obviously not referred to the Earth. The DBpedia datasets provide no means of filtering this 'extraterrestrial' articles.
• You can contact me if you are interested in other non-English languages.