Plotting 500 US cities to a map
- by sqlman
I have 500 US cities in a MySQL table. I have the city name, state, longitude and latitude. I want to visually see these cities plotted on a map of the US.
How can I do this? Are they any free tools available? Google Maps or Google Earth maybe?
Obviously, it would take forever to plot each city individually. So I need a quick way of doing it, either through a program or by exporting the table as a spreadsheet and uploading it into some kind of generator that will do the plotting for me.
Please let me know your ideas. Thanks.