Awesome. I've probably used SQL even less than you, but I'm fortunate to work with several people who have used SQL a fair amount. I'll get to playing with it in the next few days, and I'll let you know what I come up with.
If I haven't mentioned before, I'll mention now: I think these mapping tools are probably one of the most powerful tools that we have. A problem I've run into a few times is that people don't know they exist. For example, here's an email I got this morning after asking a gal if she knew about the mapping:
I actually wasn't aware of this function.....If I can find a cincinnati pilot that can go from Cincinnati to NC that would be great.....I see them all on the map but not sure how I would email them.
Her response also hints that some simple howto information about the map might be useful. It's obvious to you and me how it works, but I use Google Maps a lot, so I forget that not everyone has an intuitive sense about how to use it.
One problem is that the link to the map page is only accessible from the main page, and not the forums. That'll be fixed when WP integration is eventually added. Every transport request has a map this request, but the requestor only sees that link if they go to their post, and they're only likely to do that if someone responds. I don't know what the answer is to this question, but here are some random ideas I've had:
- After a request is posted, the poster goes to a page that has their request mapped. No one would have any excuse to miss that
- A small sidebar in the forum that contains a GMap thumbnail. Folks would probably spot that pretty quickly I think.