Here are a few things that people might be interested in. They all might require tweaking for your particular guide; don't run them unless you understand them.

First of all, an importer thingy that reads data from a YAML file and uses WWW::Mechanize to add it to a guide. (It won't overwrite existing data; it checks first and warns you if you're attempting to create a page that already exists.) Because it's YAML, you can't use asterisks in the content or it gets confused. If you don't use streetmap x/y links and OS x/y coords then you'll need to change that part. You can include any fields in the YAML file that are present in the edit form. This is mainly useful for creating stub pages so a location search will find them. I've used it to add all London's Tube stations and Good Beer Guide pubs.

rgl.pl is the importer and rgldata is an example datafile.

Secondly, a search thingy that finds all things in category A within N metres of things in Category B. It's quite fast and efficient because it uses raw SQL rather than the abstraction layers. It may be Postgres-specific, and it's certainly OS X/Y specific, but it should be obvious how to change that to suit your own guide. An example (plan your own Circle Line pub crawl): http://london.randomness.org.uk/find.cgi?cat1=Circle+Line&distance=650&a...

This is, unsurprisingly, find.cgi.

Finally, a javascript snippet to find nearest Tube stations and show what lines they're on. Again, will need tweaking for non-London guides.

show_tube_stations.html goes somewhere in node.tt and show_tube_stations.js goes in header.tt. nearest-tube.cgi lives in the same directory as wiki.cgi

Hope these are of interest.

Kake