I'm using an events calendar plugin that allows me to create a bunch of venues for those events as a custom post type. I'm trying to figure out a way to map all of those venues on a Google Map and make that map filterable. What would be the best way of going about this?
I've found this: http://www.geocodezip.com/v3_MW_example_categories.html. But that's reading the data from an XML file with the Lat and the Long values already entered. I know about geocoding addresses (http://www.ulaskeles.com/blog/programming/geocoding-google-maps-api/) but I can't figure out how to get that to work with category filters, and for some reason my implementation of it only maps the first 11 addresses (http://www.eyestagedit.com/wtda/map/).
I know there are tools that will map all addresses in a Google spreadsheet, but that's less than ideal (unless someone knows how to inject data from a WP database into a Google spreadsheet) since I don't want the client to have to enter each venue twice. Any thoughts? I am pretty stumped here.