Op 25-8-2012 13:56, Platonides schreef:
On 25/08/12 09:23, Андрій Бондаренко wrote:
Just one more question, I'm interested to see
what region is the most
succesful with geo-coordinates. I suppose Lwów won't be first with this
parameter ;)
select municipality, count(*) as count from `monuments_ua_(uk)` where
lat is not null and lon is not null group by municipality order by count
desc;
Thanks to Nuno we already have most of these statistics in a nice
webinterface, see
you can see this for all countries in the database.
Maarten
Ps. The countries we added to the database yesterday and today will show
up tomorrow after the nightly run