I’ve been involved in doing this review of bicycle parking in Olympia at places that have been built in the last 5 years, to see if the inspectors are catching parking that isn’t installed to code. (Or at all.)
I had an Excel spreadsheet — or rather, two spreadsheets — with the names of the locations, street addresses, application ID numbers, date of inspection and a few other bits. I imported them with Node Import, which was really easy, and tried a bunch of stuff to get the locations plotted on a map. Finally got it tonight! With this tutorial: http://drupal.org/node/1041632 – although the critical bit is that you have to set up a geocoding service before anything will work.
It’s pretty late right now, but I’ll try to go into a bit more detail about the process later.
