Wikimedia Bugzilla is closed!

Heh, you were the first one adding tables with those fields as NOT NULL DEFAULT '0'.

I agree. Most other fields are NOT NULL with not-set stored as an empty string, but lat and long are doubles.

r1=736&r2=737">https://fisheye.toolserver.org/browse/erfgoed/erfgoedbot/sql/fill_table_monuments_all.sql?r1=736&r2=737 isn't very nice. Should probably fix it on the python import bot. If lat=0 and lon=0 insert NULL

Still need to fix some leftovers:

mysql> SELECT COUNT(*) FROM monuments_all WHERE lat='' OR lon='' OR lat=0 OR lon=0;
+----------+
| COUNT(*) |
+----------+
|      186 |
+----------+
1 row in set (12.71 sec)