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
|