Wikimedia Bugzilla is closed!

A script should be created to be run once a day. This script should take monuments_all and use this to fill the admin_tree table.

Monuments_all contains adm0-4. Level 0:

mysql> SELECT DISTINCT(adm0) FROM `monuments_all`;
+------+
| adm0 |
+------+
| ad   |
| at   |
| be   |
| ch   |
| dk   |
| ee   |
| es   |
| fr   |
| gb   |
| ie   |
| it   |
| lu   |
| mt   |
| nl   |
| no   |
| pl   |
| pt   |
| se   |
| sk   |
| us   |
+------+

And deeper

mysql> SELECT DISTINCT(adm1) FROM `monuments_all` WHERE adm0='nl';
+-------+
| adm1  |
+-------+
| NL-UT |
| NL-NB |
| NL-ZH |
| NL-GE |
| NL-NH |
| NL-LI |
| NL-ZE |
| NL-GR |
| NL-FR |
| NL-OV |
| NL-DR |
| NL-FL |
+-------+
12 rows in set (1.21 sec)