Submitted by johnh on November 21, 2006 - 14:58.
As promised, another Vovo update. I'm now sitting on a truly enormous database of addresses in Ireland. The database-minded among you will spot some horrific query times (and, for that matter, horrific queries) in what follows, and you'd be right in thinking that this database is pretty raw and needs some work. Right now I've got a seven-figure number of rows in one table.
Still... here's some screenshots of my terminal window to whet your appetites in the meantime.
Tipperary is counted twice, since you asked.
Handy info for figuring out who's a councillor of what.
Since all the addresses in this Cork street are in the same electoral division, we can replace 11 database records with just one, and still correctly identify the electoral representatives for the whole street.