Commons:Monuments database/Sql

You can directly access the Monuments database using Sql

Live database

The Monuments database lives on Toollabs and is publicly accessible in the cluster. The name of the database is s51138__heritage_p on the server tools-db.

Dump

Each update run of the database includes the creation of a fresh database dump. You can download this dump here. You can even access yesterdays dump. The dumps are currently about 150MB (zipped).

Layout

The database has 100+ tables.

  • monuments_<country>_(<lang>)
  • monuments_all
  • admin_tree
  • commonscat
  • image
  • prox_search
  • statistics
  • statisticsct
  • wlpa

Please take a look at the database structure for a more detailed explanation.

Using the database

The database layout might change without notice or move to another server. If possible you should use the API. Expect new fields to be added to monuments_all and maybe over time to have some legacy fields dropped.

Monuments database
ErfgoedBot
Category:Commons:Monuments database Category:Commons:Monuments database#Sql
Category:Commons:Monuments database