Commons:Monuments database/Sql
Jump to navigation
Jump to search
You can directly access the Monuments database using Sql
Live database[edit]
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[edit]
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[edit]
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[edit]
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
|
||