This is the back-end data crunching scripts used to find all the "Long Names of OpenStreetMap"

The bash script longnames.sh peforms the outline steps. It calls a couple of dinky ruby scripts.

I typically run this on the dev server and then copy over the resulting sqlite database to have it displayed (php logic to show a table) on my website here:
http://harrywood.co.uk/maps/longnames/