I would suggest having folks enter their city, geocoding it, and then saving that lat/long into the database so it can be visualized as a map later.

Here's some HTML/JS code for a form + map: http://pastebin.com/57nw4awx

And then you can follow this tutorial to create the map showing all the submissions: http://www.hackerlunch.com/