GeoCodes and Mapping

Posted in Capclave, Conventions on October 7th, 2009

I spent a good chunk of my time today working with a WordPress Plugin to try to get a map of all the restaurants in the vicinity of the Capclave convention hotel.

After hours of work, Hyperion and I managed to get the maps to show. The problem is that it was one map per restaurant. Not good… back to the drawing board. Searching …searching….searching…reading….searching…. you get the idea.

Anyway finally found another plugin that looks like it will easily do multiple items on one map but I’d have to enter all the data again and it has to already be geocoded when it’s entered because it doesn’t do it automatically like the first one did — which is why it was the first one I tried.

Okay, more fiddling and it looks like we can export the database to a file and then import to the new one once we know what it required and in what order — then I’m back in business.

The frustrating part is I have to enter the rest of the restaurant data into the program we’re not going to use to get the geocode for the one we are going to use. That’s another two pages single spaced of restaurants (names, addresses, telephone, number, types of cuisine, average cost of a meal).

I know I’m complaining but really this hasn’t been a wasted day. I’ve learned a lot about geo codes, maps, mapping plugins, and a couple of programming tips. I’m also thinking it’s about time I learned a bit more so I could actually change a program that ALMOST does what I want to doing EXACTLY what I want. (Yeah, I’ll add that to my TODO list somewhere around item 4,789,968,365. That’s it … I just have to live forever if I’m even going to make a dent in this list.)

Meanwhile, if any reader has tackled trying to do a map of multiple items to display on a WordPress page using your own list of places–especially with a roll-over that will list the restaurant when you are over the little marker — let me know what you used.

Hyperion and I only have like a couple of days to get this up and running on the website. Time is getting short and suggestions are welcome — though that doesn’t necessarily mean I’ll do more than listen and bang my head on the keyboard for a while for not thinking of whatever myself.