Last modified: 2013-07-25 10:31:38 UTC
At the moment it's 0.
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)