Someone is asking about some difficult MySQL mapping stuff, I don’t understand it, but I do know of a relatively easier way to get custom post types, such as those created by Pods, onto a map in WordPress. I built this for Live Work Oakland, so I remembered the steps, and I sat down and cranked this out in about 30 minutes: Pods + Geo Mashup.
The CPT is called Location, and has three additional meta fields added: Address, City, and Zip Code. The issue folks were having in the forum thread was how to show it on a map, and for that I used another (terrific) plugin, Geo Mashup. One of the settings for that plugin is this ingenious reverse geocoding feature, which will construct the address from an array of fields you designate. This screenshot shows how it is configured on the lab site:
The map page is just the map shortcode showing all posts with location data (the lab site is configured to only show the Location post type, but you can be creative with it). For LWO I built it into the theme, so it shows on individual listings automatically. Check the documentation, it is a pretty nifty plugin!
If you want to try it out, add a location! That bit is done with Gravity Forms and an add-on plugin that allows you to save it to custom post types. I only included a few address fields, so some locations may not show up correctly on the map, but this is only a demo. Also, you’d want to show the custom fields on the individual location posts, but that is a different tutorial. If you don’t want to mess with a lot of custom coding, these plugins can do the heavy lifting for ya. ^_^
Here is the Location custom post type export from Pods: location.pods (copy the contents of the file and import, or just add the three fields yerself!)